public void ManualTypeMapped()
{
ConfigurationDBRef dbconfig = ConfigOracle;
dbconfig.ColumnChangeCase = ConfigurationDBRef.ColumnChangeCaseEnum.LOWERCASE;
dbconfig.AddSqlTypesBinding(2, "int");
Configuration configuration = GetConfig(dbconfig);
epService = EPServiceProviderManager.GetDefaultProvider(configuration);
epService.Initialize();
string sql = "select myint from " + TABLE_NAME + " where ${intPrimitive} = myint'" +
"metadatasql 'select myint from " + TABLE_NAME + "'";
string stmtText = "select myint from " +
" sql:MyDB ['" + sql + "] as s0," +
typeof(SupportBean).Name + "#length(100) as s1";
EPStatement statement = epService.EPAdministrator.CreateEPL(stmtText);
listener = new SupportUpdateListener();
statement.AddListener(listener);
Assert.AreEqual(typeof(int?), statement.EventType.GetPropertyType("myint"));
SendSupportBeanEvent(10);
Assert.AreEqual(10, listener.AssertOneGetNewAndReset().Get("myint"));
SendSupportBeanEvent(80);
Assert.AreEqual(80, listener.AssertOneGetNewAndReset().Get("myint"));
}
public void TestTypeMapped()
{
ConfigurationDBRef dbconfig = GetDBConfig();
dbconfig.ColumnChangeCase = ConfigurationDBRef.ColumnChangeCaseEnum.LOWERCASE;
dbconfig.AddSqlTypesBinding(java.sql.Types.INTEGER, "string");
Configuration configuration = GetConfig(dbconfig);
_epService = EPServiceProviderManager.GetDefaultProvider(configuration);
_epService.Initialize();
if (InstrumentationHelper.ENABLED)
{
InstrumentationHelper.StartTest(_epService, GetType(), GetType().FullName);
}
const string sql = "select myint from mytesttable where ${IntPrimitive} = myint'" +
"metadatasql 'select myint from mytesttable'";
string stmtText = "select myint from " +
" sql:MyDB ['" + sql + "] as s0," +
typeof(SupportBean).FullName + ".win:length(100) as s1";
EPStatement statement = _epService.EPAdministrator.CreateEPL(stmtText);
_listener = new SupportUpdateListener();
statement.Events += _listener.Update;
Assert.AreEqual(typeof(string), statement.EventType.GetPropertyType("myint"));
SendSupportBeanEvent(10);
Assert.AreEqual("10", _listener.AssertOneGetNewAndReset().Get("myint"));
SendSupportBeanEvent(80);
Assert.AreEqual("80", _listener.AssertOneGetNewAndReset().Get("myint"));
if (InstrumentationHelper.ENABLED)
{
InstrumentationHelper.EndTest();
}
}
