Exemplo n.º 1
0
        public void TestLexSampleSQL()
        {
            String[][] testcases =
            {
                new [] { "select * from A where a=b and c=d",                            "select * from A where 1=0 and a=b and c=d"                                                     },
                new [] { "select * from A where 1=0",                                    "select * from A where 1=0 and 1=0"                                                             },
                new [] { "select * from A",                                              "select * from A where 1=0"                                                                     },
                new [] { "select * from A group by x",                                   "select * from A where 1=0 group by x"                                                          },
                new [] { "select * from A having a>b",                                   "select * from A where 1=0 having a>b"                                                          },
                new [] { "select * from A order by d",                                   "select * from A where 1=0 order by d"                                                          },
                new [] { "select * from A group by a having b>c order by d",             "select * from A where 1=0 group by a having b>c order by d"                                    },
                new [] { "select * from A where (7<4) group by a having b>c order by d", "select * from A where 1=0 and (7<4) group by a having b>c order by d"                          },
                new [] { "select * from A union select * from B",                        "select * from A  where 1=0 union  select * from B where 1=0"                                   },
                new [] { "select * from A where a=2 union select * from B where 2=3",    "select * from A where 1=0 and a=2 union  select * from B where 1=0 and 2=3"                    },
                new [] { "select * from A union select * from B union select * from C",  "select * from A  where 1=0 union  select * from B  where 1=0 union  select * from C where 1=0" },
            };

            for (int i = 0; i < testcases.Length; i++)
            {
                String result = null;
                try
                {
                    result = DatabasePollingViewableFactory.LexSampleSQL(testcases[i][0]).Trim();
                }
                catch (Exception)
                {
                    Assert.Fail("failed case with exception:" + testcases[i][0]);
                }
                String expected = testcases[i][1].Trim();
                Assert.AreEqual(expected, result, "failed case " + i + " :" + testcases[i][0]);
            }
        }
Exemplo n.º 2
0
        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"));
        }
Exemplo n.º 3
0
        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"));
        }