public override void Run(EPServiceProvider epService)
{
var configDB = SupportDatabaseService.CreateDefaultConfig();
configDB.ConnectionLifecycle = ConnectionLifecycleEnum.RETAIN;
var configuration = SupportConfigFactory.GetConfiguration();
configuration.AddDatabaseReference("MyDB", configDB);
var epServiceRetained = EPServiceProviderManager.GetProvider(
SupportContainer.Instance, "TestDatabaseJoinRetained", configuration);
epServiceRetained.Initialize();
configDB = SupportDatabaseService.CreateDefaultConfig();
configDB.ConnectionLifecycle = ConnectionLifecycleEnum.POOLED;
configuration = SupportConfigFactory.GetConfiguration();
configuration.AddDatabaseReference("MyDB", configDB);
var epServicePooled = EPServiceProviderManager.GetProvider(
SupportContainer.Instance, "TestDatabaseJoinPooled", configuration);
epServicePooled.Initialize();
RunAssertion100EventsRetained(epServiceRetained);
RunAssertion100EventsPooled(epServicePooled);
RunAssertionSelectRStream(epServiceRetained);
RunAssertionSelectIStream(epServiceRetained);
RunAssertionWhereClauseNoIndexNoCache(epServiceRetained);
epServicePooled.Dispose();
epServiceRetained.Dispose();
}
private static IContainer CreateContainer()
{
var baseDirectory = AppDomain.CurrentDomain.BaseDirectory;
var container = ContainerExtensions.CreateDefaultContainer(false);
container.Register <IResourceManager>(
xx => new DefaultResourceManager(
true,
Path.GetFullPath(Path.Combine(baseDirectory, "..", "..", "..", "etc")),
Path.GetFullPath(Path.Combine(baseDirectory, "..", "..", "..", "..", "etc")),
Path.GetFullPath(Path.Combine(baseDirectory, "..", "..", "..", "..", "..", "etc"))),
Lifespan.Singleton);
SupportEventTypeFactory.RegisterSingleton(container);
SupportExprNodeFactory.RegisterSingleton(container);
SupportDatabaseService.RegisterSingleton(container);
SupportJoinResultNodeFactory.RegisterSingleton(container);
container
.InitializeDefaultServices()
.InitializeDatabaseDrivers()
.RegisterDatabaseDriver(typeof(DbDriverPgSQL));
return(container);
}
private ConfigurationDBRef GetDefaultConfig()
{
var configDB = SupportDatabaseService.CreateDefaultConfig();
configDB.ConnectionLifecycle = ConnectionLifecycleEnum.RETAIN;
return(configDB);
}
public void SetUp()
{
const string sql = "select myvarchar from mytesttable where mynumeric = ? order by mybigint asc";
var databaseConnectionFactory = SupportDatabaseService.MakeService().GetConnectionFactory("mydb");
var connectionCache = new ConnectionNoCacheImpl(databaseConnectionFactory, sql, null);
var resultProperties = new Dictionary <String, Object>();
resultProperties["myvarchar"] = typeof(string);
var resultEventType = SupportEventAdapterService.Service.CreateAnonymousMapType("test", resultProperties);
IDictionary <String, DBOutputTypeDesc> propertiesOut = new Dictionary <String, DBOutputTypeDesc>();
propertiesOut["myvarchar"] = new DBOutputTypeDesc("TIME", typeof(string), null);
_dbPollExecStrategy = new PollExecStrategyDBQuery(
SupportEventAdapterService.Service,
resultEventType,
connectionCache,
sql,
propertiesOut,
null,
null);
}
public override void Configure(Configuration configuration)
{
var configDB = SupportDatabaseService.CreateDefaultConfig();
configuration.AddDatabaseReference("MyDB", configDB);
configuration.AddEventType <SupportBean>("SupportBean");
configuration.AddEventType <SupportBean_S0>("SupportBean_S0");
configuration.AddEventType <SupportBean_S1>("SupportBean_S1");
}
public override void Configure(Configuration configuration)
{
var configDB = SupportDatabaseService.CreateDefaultConfig();
configDB.ConnectionLifecycle = ConnectionLifecycleEnum.RETAIN;
configDB.ConnectionCatalog = "test";
configDB.ConnectionTransactionIsolation = IsolationLevel.Serializable;
configuration.AddDatabaseReference("MyDB", configDB);
}
public override void Configure(Configuration configuration)
{
var configDB = SupportDatabaseService.CreateDefaultConfig();
configDB.ConnectionLifecycle = ConnectionLifecycleEnum.RETAIN;
configDB.LRUCache = 100000;
configDB.ConnectionCatalog = "test";
configuration.AddDatabaseReference("MyDB", configDB);
}
public override void Configure(Configuration configuration)
{
configuration.EngineDefaults.Logging.IsEnableADO = true;
configuration.EngineDefaults.Threading.IsListenerDispatchPreserveOrder = false;
var configDB = SupportDatabaseService.CreateDefaultConfig();
configDB.ConnectionLifecycle = ConnectionLifecycleEnum.RETAIN;
configuration.AddDatabaseReference("MyDB", configDB);
}
internal static ConfigurationDBRef GetDBConfig()
{
var configDB = SupportDatabaseService.CreateDefaultConfig();
configDB.ConnectionLifecycle = ConnectionLifecycleEnum.RETAIN;
configDB.ConnectionCatalog = "test";
configDB.ConnectionTransactionIsolation = IsolationLevel.Serializable;
configDB.ConnectionAutoCommit = true;
return(configDB);
}
public override void Configure(Configuration configuration)
{
var configDB = SupportDatabaseService.CreateDefaultConfig();
configDB.ConnectionCatalog = "test";
configDB.SetExpiryTimeCache(60, 120);
configuration.EngineDefaults.Logging.IsEnableQueryPlan = true;
configuration.AddDatabaseReference("MyDB", configDB);
}
public override void Configure(Configuration configuration)
{
var configDB = SupportDatabaseService.CreateDefaultConfig();
configDB.ConnectionLifecycle = ConnectionLifecycleEnum.RETAIN;
// Turn this cache setting off to turn off indexing since without cache there is no point in indexing.
configDB.LRUCache = (100000);
configuration.EngineDefaults.Logging.IsEnableQueryPlan = (true);
configuration.AddDatabaseReference("MyDB", configDB);
}
public virtual void SetUpCommon()
{
container = SupportContainer.Reset();
supportEventTypeFactorySupplier = Suppliers.Memoize(() =>
SupportEventTypeFactory.GetInstance(container));
supportExprNodeFactorySupplier = Suppliers.Memoize(() =>
SupportExprNodeFactory.GetInstance(container));
supportDatabaseServiceSupplier = Suppliers.Memoize(() =>
SupportDatabaseService.GetInstance(container));
supportJoinResultNodeFactorySupplier = Suppliers.Memoize(() =>
SupportJoinResultNodeFactory.GetInstance(container));
}
public override void Configure(Configuration configuration)
{
var configDB = SupportDatabaseService.CreateDefaultConfig();
configDB.ConnectionLifecycle = ConnectionLifecycleEnum.RETAIN;
configDB.ConnectionCatalog = "test";
//configDB.ConnectionReadOnly = true;
configDB.ConnectionTransactionIsolation = IsolationLevel.Serializable;
configDB.ConnectionAutoCommit = true;
configuration.AddDatabaseReference("MyDB", configDB);
configuration.EngineDefaults.Logging.IsEnableADO = true;
}
public void TestDBStatementViewFactory()
{
DBStatementStreamSpec spec = new DBStatementStreamSpec("s0", ViewSpec.EMPTY_VIEWSPEC_ARRAY,
"mydb", "select * from mytesttable where mybigint=${idnum}", null);
EventCollection eventCollection = DatabasePollingViewableFactory.CreateDBStatementView(
"id", 1, spec,
SupportDatabaseService.MakeService(),
SupportEventAdapterService.Service, null, null, null, null, true);
Assert.AreEqual(typeof(long?), eventCollection.EventType.GetPropertyType("mybigint"));
Assert.AreEqual(typeof(string), eventCollection.EventType.GetPropertyType("myvarchar"));
Assert.AreEqual(typeof(bool?), eventCollection.EventType.GetPropertyType("mybool"));
Assert.AreEqual(typeof(decimal?), eventCollection.EventType.GetPropertyType("mynumeric"));
Assert.AreEqual(typeof(decimal?), eventCollection.EventType.GetPropertyType("mydecimal"));
}
public void TestDBStatementViewFactory()
{
var container = SupportContainer.Instance;
var spec = new DBStatementStreamSpec("s0", ViewSpec.EMPTY_VIEWSPEC_ARRAY,
"mydb", "select * from mytesttable where mybigint=${idnum}", null);
EventCollection eventCollection = DatabasePollingViewableFactory.CreateDBStatementView(
1, 1, spec,
SupportDatabaseService.MakeService(),
container.Resolve <EventAdapterService>(),
null, null, null, null, true, new DataCacheFactory(),
SupportStatementContextFactory.MakeContext(container));
Assert.AreEqual(typeof(long?), eventCollection.EventType.GetPropertyType("mybigint"));
Assert.AreEqual(typeof(string), eventCollection.EventType.GetPropertyType("myvarchar"));
Assert.AreEqual(typeof(bool?), eventCollection.EventType.GetPropertyType("mybool"));
Assert.AreEqual(typeof(decimal?), eventCollection.EventType.GetPropertyType("mynumeric"));
Assert.AreEqual(typeof(decimal?), eventCollection.EventType.GetPropertyType("mydecimal"));
}
public void RunAssertionGetConnection()
{
TryAndCloseConnectionWithFactory(
() =>
{
var properties = SupportDatabaseService.DefaultProperties;
var config = SupportDatabaseService.CreateDefaultConfig(properties);
config.ConnectionCatalog = "test";
config.ConnectionAutoCommit = false; // not supported yet
config.ConnectionTransactionIsolation = IsolationLevel.Unspecified;
return(new DatabaseDriverConnFactory((DbDriverFactoryConnection)config.ConnectionFactoryDesc, config.ConnectionSettings));
});
TryAndCloseConnection(SupportDatabaseService.DbDriverFactoryDefault);
#if X64
// ODBC drivers are sensitive to which platform they are installed on; we only test them when performing
// tests with X64 since we usually do not install the 32-bit drivers.
TryAndCloseConnection(SupportDatabaseService.DbDriverFactoryODBC);
#endif
}
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
}
