public ConfigurationCommonDBRef CreateDefaultConfig(Properties properties = null)
{
var configDB = new ConfigurationCommonDBRef();
configDB.SetDatabaseDriver(DriverConnectionFactoryDefault.Merge(properties));
return(configDB);
}
private ConfigurationCommonDBRef GetDefaultConfig(IContainer container)
{
var configDB = new ConfigurationCommonDBRef();
configDB.SetDatabaseDriver(
SupportDatabaseService.DRIVER,
SupportDatabaseService.DefaultProperties);
configDB.ConnectionLifecycleEnum = ConnectionLifecycleEnum.RETAIN;
return configDB;
}
public void TestTypeMapping()
{
TryInvalid(
typeof(Console),
"Unsupported type 'System.Console' when expecting any of: [BOOLEAN, BYTE, BYTE_ARRAY, DECIMAL, DOUBLE, FLOAT, INT32, INT64, INT16, STRING, TIMESTAMP]");
var config = new ConfigurationCommonDBRef();
config.AddTypeBinding(typeof(long), typeof(int));
}
internal static ConfigurationCommonDBRef GetDBConfig(IContainer container)
{
var configDB = new ConfigurationCommonDBRef();
configDB.SetDatabaseDriver(
SupportDatabaseService.DRIVER,
SupportDatabaseService.DefaultProperties);
configDB.ConnectionLifecycleEnum = ConnectionLifecycleEnum.RETAIN;
configDB.ConnectionCatalog = "test";
configDB.ConnectionReadOnly = true;
configDB.ConnectionAutoCommit = true;
return configDB;
}
private void TryAndCloseConnection(ConnectionFactoryDesc connectionFactoryDesc)
{
var config = new ConfigurationCommonDBRef {
ConnectionFactoryDesc = connectionFactoryDesc
};
var connectionFactory = new DatabaseDriverConnFactory(
container,
(DriverConnectionFactoryDesc)config.ConnectionFactoryDesc,
config.ConnectionSettings);
var connection = connectionFactory.Driver.CreateConnection();
TryAndCloseConnection(connection);
}
public void Configure(Configuration configuration)
{
configuration.Common.AddEventType(typeof(SupportBean));
configuration.Common.Logging.IsEnableADO = true;
configuration.Runtime.Threading.IsListenerDispatchPreserveOrder = false;
var configDB = new ConfigurationCommonDBRef();
configDB.SetDatabaseDriver(
SupportDatabaseService.DRIVER,
SupportDatabaseService.DefaultProperties);
configDB.ConnectionLifecycleEnum = ConnectionLifecycleEnum.RETAIN;
configuration.Common.AddDatabaseReference("MyDB", configDB);
}
private void TryInvalid(
Type type,
string text)
{
try
{
var config = new ConfigurationCommonDBRef();
config.AddTypeBinding(typeof(int), type);
}
catch (ConfigurationException ex)
{
Assert.AreEqual(text, ex.Message);
}
}
private static void Configure(Configuration configuration)
{
foreach (var clazz in new[] {
typeof(SupportBean),
typeof(SupportMarketDataBean),
typeof(SupportByteArrEventLongId),
typeof(SupportBean_A),
typeof(SupportBean_S0),
typeof(SupportBean_S1),
typeof(SupportCollection),
typeof(MultithreadStmtNamedWindowJoinUniqueView.MyEventA),
typeof(MultithreadStmtNamedWindowJoinUniqueView.MyEventB),
typeof(MultithreadStmtNamedWindowMultiple.OrderEvent),
typeof(MultithreadStmtNamedWindowMultiple.OrderCancelEvent),
typeof(SentenceEvent),
typeof(SupportTradeEvent)
}) {
configuration.Common.AddEventType(clazz);
}
var configDB = new ConfigurationCommonDBRef();
configDB.SetDatabaseDriver(
SupportDatabaseService.DRIVER,
SupportDatabaseService.DefaultProperties);
configDB.ConnectionLifecycleEnum = ConnectionLifecycleEnum.RETAIN;
configDB.ConnectionCatalog = "test";
configDB.ConnectionReadOnly = true;
configDB.ConnectionTransactionIsolation = IsolationLevel.ReadCommitted;
configDB.ConnectionAutoCommit = true;
configuration.Common.AddDatabaseReference("MyDB", configDB);
var common = configuration.Common;
common.AddVariable("var1", typeof(long?), 0);
common.AddVariable("var2", typeof(long?), 0);
common.AddVariable("var3", typeof(long?), 0);
configuration.Compiler.AddPlugInAggregationFunctionForge(
"intListAgg",
typeof(SupportIntListAggregationForge));
}
public void SetUp()
{
ImportService engineImportService = SupportClasspathImport.GetInstance(container);
// driver-manager config 1
var config = new ConfigurationCommonDBRef();
config.SetDatabaseDriver(SupportDatabaseService.GetInstance(container).DriverConnectionFactoryNative);
config.ConnectionAutoCommit = true;
config.ConnectionCatalog = "test";
config.ConnectionTransactionIsolation = IsolationLevel.Serializable;
config.ConnectionReadOnly = true;
#if false
_databaseDmConnConnectionFactoryOne = new DriverConnectionFactoryDesc(
(ConfigurationCommonDBRef.DriverManagerConnection)config.ConnectionFactoryDesc,
config.ConnectionSettings, engineImportService);
// driver-manager config 2
config = new ConfigurationCommonDBRef();
config.SetDriverManagerConnection(SupportDatabaseURL.DRIVER, SupportDatabaseURL.PARTURL, SupportDatabaseURL.DBUSER, SupportDatabaseURL.DBPWD);
_databaseDmConnConnectionFactoryTwo = new DriverConnectionFactoryDesc(
(ConfigurationCommonDBRef.DriverManagerConnection)config.ConnectionFactoryDesc,
config.ConnectionSettings, engineImportService);
// driver-manager config 3
config = new ConfigurationCommonDBRef();
Properties properties = new Properties();
properties["user"] = SupportDatabaseURL.DBUSER;
properties["password"] = SupportDatabaseURL.DBPWD;
config.SetDriverManagerConnection(SupportDatabaseURL.DRIVER, SupportDatabaseURL.PARTURL, properties);
_databaseDmConnConnectionFactoryThree = new DatabaseDMConnFactory(
(ConfigurationCommonDBRef.DriverManagerConnection)config.ConnectionFactoryDesc,
config.ConnectionSettings, engineImportService);
#endif
}
private SupportDatabaseService(IContainer container)
{
_container = container;
var configurationPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ESPER_REGRESSION_CONFIG_FILE);
var configurationFile = new FileInfo(configurationPath);
var configuration = new ConfigurationCommon();
var configurationDocument = new XmlDocument();
configurationDocument.Load(configurationFile.FullName);
ConfigurationCommonParser.DoConfigure(configuration, configurationDocument.DocumentElement);
var dbTable = configuration.DatabaseReferences;
DriverConnectionFactoryDefault = dbTable["db1"].ConnectionFactoryDesc as DriverConnectionFactoryDesc;
DbConfigReferenceNative = dbTable["db1"];
DbConfigReferenceODBC = dbTable["db2"];
DriverConnectionFactoryNative = DbConfigReferenceNative
.ConnectionFactoryDesc as DriverConnectionFactoryDesc;
DriverConnectionFactoryOdbc = DbConfigReferenceODBC
.ConnectionFactoryDesc as DriverConnectionFactoryDesc;
}
private static void Configure(Configuration configuration)
{
foreach (var clazz in new[] {
typeof(SupportBean),
typeof(SupportBeanTwo),
typeof(SupportBean_A),
typeof(SupportBeanRange),
typeof(SupportBean_S0),
typeof(SupportBeanComplexProps)
}) {
configuration.Common.AddEventType(clazz);
}
var common = configuration.Common;
common.AddVariable("myvariableOCC", typeof(int), 10);
common.AddVariable("myvariableIPC", typeof(string), "x10");
common.AddVariable("myvariableORC", typeof(int), 10);
var configDBWithRetain = new ConfigurationCommonDBRef();
configDBWithRetain.SetDatabaseDriver(
SupportDatabaseService.DRIVER,
SupportDatabaseService.DefaultProperties);
configDBWithRetain.ConnectionLifecycleEnum = ConnectionLifecycleEnum.RETAIN;
configuration.Common.AddDatabaseReference("MyDBWithRetain", configDBWithRetain);
var configDBWithPooledWithLRU100 = new ConfigurationCommonDBRef();
configDBWithPooledWithLRU100.SetDatabaseDriver(
SupportDatabaseService.DRIVER,
SupportDatabaseService.DefaultProperties);
configDBWithPooledWithLRU100.ConnectionLifecycleEnum = ConnectionLifecycleEnum.POOLED;
configDBWithPooledWithLRU100.SetLRUCache(100);
configuration.Common.AddDatabaseReference("MyDBWithPooledWithLRU100", configDBWithPooledWithLRU100);
var configDBWithTxnIso1WithReadOnly = new ConfigurationCommonDBRef();
configDBWithTxnIso1WithReadOnly.SetDatabaseDriver(
SupportDatabaseService.DRIVER,
SupportDatabaseService.DefaultProperties);
configDBWithTxnIso1WithReadOnly.ConnectionLifecycleEnum = ConnectionLifecycleEnum.RETAIN;
configDBWithTxnIso1WithReadOnly.ConnectionCatalog = "test";
configDBWithTxnIso1WithReadOnly.ConnectionReadOnly = true;
configDBWithTxnIso1WithReadOnly.ConnectionTransactionIsolation = IsolationLevel.ReadCommitted;
configDBWithTxnIso1WithReadOnly.ConnectionAutoCommit = true;
configuration.Common.AddDatabaseReference("MyDBWithTxnIso1WithReadOnly", configDBWithTxnIso1WithReadOnly);
var dbconfigLowerCase = GetDBConfig(configuration.Container);
dbconfigLowerCase.ColumnChangeCase = ColumnChangeCaseEnum.LOWERCASE;
dbconfigLowerCase.AddTypeBinding(typeof(int), typeof(string));
configuration.Common.AddDatabaseReference("MyDBLowerCase", dbconfigLowerCase);
var dbconfigUpperCase = GetDBConfig(configuration.Container);
dbconfigUpperCase.ColumnChangeCase = ColumnChangeCaseEnum.UPPERCASE;
configuration.Common.AddDatabaseReference("MyDBUpperCase", dbconfigUpperCase);
var dbconfigPlain = GetDBConfig(configuration.Container);
configuration.Common.AddDatabaseReference("MyDBPlain", dbconfigPlain);
var configDBPooled = new ConfigurationCommonDBRef();
configDBPooled.SetDatabaseDriver(
SupportDatabaseService.DRIVER,
SupportDatabaseService.DefaultProperties);
configDBPooled.ConnectionLifecycleEnum = ConnectionLifecycleEnum.POOLED;
configuration.Common.AddDatabaseReference("MyDBPooled", configDBPooled);
var configDBWithLRU100000 = new ConfigurationCommonDBRef();
configDBWithLRU100000.SetDatabaseDriver(
SupportDatabaseService.DRIVER,
SupportDatabaseService.DefaultProperties);
configDBWithLRU100000.ConnectionLifecycleEnum = ConnectionLifecycleEnum.RETAIN;
configDBWithLRU100000.SetLRUCache(100000);
configuration.Common.AddDatabaseReference("MyDBWithLRU100000", configDBWithLRU100000);
var configDBWithExpiryTime = new ConfigurationCommonDBRef();
configDBWithExpiryTime.SetDatabaseDriver(
SupportDatabaseService.DRIVER,
SupportDatabaseService.DefaultProperties);
configDBWithExpiryTime.ConnectionCatalog = "test";
configDBWithExpiryTime.SetExpiryTimeCache(60, 120);
configuration.Common.AddDatabaseReference("MyDBWithExpiryTime", configDBWithExpiryTime);
configuration.Common.Logging.IsEnableQueryPlan = true;
configuration.Common.Logging.IsEnableADO = true;
}
private static void Configure(Configuration configuration)
{
foreach (var clazz in new[] {
typeof(SupportBean),
typeof(SupportBean_S0),
typeof(SupportBean_S1),
typeof(SupportBean_S2),
typeof(SupportBean_S3),
typeof(ISupportBaseAB),
typeof(ISupportA),
typeof(SupportWebEvent),
typeof(ISupportAImpl),
typeof(SupportGroupSubgroupEvent),
typeof(SupportEventWithIntArray)
}) {
configuration.Common.AddEventType(clazz.Name, clazz);
}
configuration.Common.AddEventType(typeof(ContextDocExamples.BankTxn));
configuration.Common.AddEventType(typeof(ContextDocExamples.LoginEvent));
configuration.Common.AddEventType(typeof(ContextDocExamples.LogoutEvent));
configuration.Common.AddEventType(typeof(ContextDocExamples.SecurityEvent));
configuration.Common.AddEventType(typeof(ContextDocExamples.SensorEvent));
configuration.Common.AddEventType(typeof(ContextDocExamples.TrafficEvent));
configuration.Common.AddEventType(typeof(ContextDocExamples.TrainEnterEvent));
configuration.Common.AddEventType(typeof(ContextDocExamples.TrainLeaveEvent));
configuration.Common.AddEventType(typeof(ContextDocExamples.CumulativePrice));
configuration.Common.AddEventType(typeof(ContextDocExamples.PassengerScanEvent));
configuration.Common.AddEventType(typeof(ContextDocExamples.MyStartEvent));
configuration.Common.AddEventType(typeof(ContextDocExamples.MyEndEvent));
configuration.Common.AddEventType(typeof(ContextDocExamples.MyInitEvent));
configuration.Common.AddEventType(typeof(ContextDocExamples.MyTermEvent));
configuration.Common.AddEventType(typeof(ContextDocExamples.MyEvent));
configuration.Common.AddEventType("StartEventOne", typeof(ContextDocExamples.MyStartEvent));
configuration.Common.AddEventType("StartEventTwo", typeof(ContextDocExamples.MyStartEvent));
configuration.Common.AddEventType("MyOtherEvent", typeof(ContextDocExamples.MyStartEvent));
configuration.Common.AddEventType("EndEventOne", typeof(ContextDocExamples.MyEndEvent));
configuration.Common.AddEventType("EndEventTwo", typeof(ContextDocExamples.MyEndEvent));
configuration.Common.AddEventType(typeof(ContextDocExamples.MyTwoKeyInit));
configuration.Common.AddEventType(typeof(ContextDocExamples.MyTwoKeyTerm));
configuration.Compiler.AddPlugInSingleRowFunction("myHash", typeof(ContextHashSegmented), "MyHashFunc");
configuration.Compiler.AddPlugInSingleRowFunction("mySecond", typeof(ContextHashSegmented), "MySecondFunc");
configuration.Compiler.AddPlugInSingleRowFunction(
"makeBean",
typeof(ContextInitTermTemporalFixed),
"SingleRowPluginMakeBean");
configuration.Compiler.AddPlugInSingleRowFunction(
"toArray",
typeof(ContextKeySegmentedAggregate),
"ToArray");
configuration.Compiler.AddPlugInSingleRowFunction(
"customEnabled",
typeof(ContextNested),
"CustomMatch",
ConfigurationCompilerPlugInSingleRowFunction.FilterOptimizableEnum.ENABLED);
configuration.Compiler.AddPlugInSingleRowFunction(
"customDisabled",
typeof(ContextNested),
"CustomMatch",
ConfigurationCompilerPlugInSingleRowFunction.FilterOptimizableEnum.DISABLED);
configuration.Compiler.AddPlugInSingleRowFunction(
"stringContainsX",
typeof(ContextKeySegmented),
"StringContainsX");
configuration.Common.AddImportType(typeof(ContextHashSegmented));
var configDB = new ConfigurationCommonDBRef();
configDB.SetDatabaseDriver(
SupportDatabaseService.DRIVER,
SupportDatabaseService.DefaultProperties);
configuration.Common.AddDatabaseReference("MyDB", configDB);
configuration.Compiler.ByteCode.AllowSubscriber = true;
configuration.Compiler.AddPlugInVirtualDataWindow(
"test",
"vdw",
typeof(SupportVirtualDWForge),
SupportVirtualDW.ITERATE); // configure with iteration
}
