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(); } }