public virtual void TestProperlyEnd() { var sql = "select * from tb1;"; var stmt = SqlParserDelegate.Parse(sql); Assert.AreEqual(typeof(DmlSelectStatement), stmt.GetType()); sql = "select * from tb1 ;;; "; stmt = SqlParserDelegate.Parse(sql); Assert.AreEqual(typeof(DmlSelectStatement), stmt.GetType()); sql = "select * from tb1 /***/ "; stmt = SqlParserDelegate.Parse(sql); Assert.AreEqual(typeof(DmlSelectStatement), stmt.GetType()); sql = "select * from tb1 , "; try { stmt = SqlParserDelegate.Parse(sql); Assert.Fail("should detect inproperly end"); } catch (SqlSyntaxErrorException) { } sql = "select * from tb1 ;, "; try { stmt = SqlParserDelegate.Parse(sql); Assert.Fail("should detect inproperly end"); } catch (SqlSyntaxErrorException) { } }
//[Test] //public virtual void TestMain() //{ // Main(null); // Assert.IsTrue(true); //} /// <exception cref="System.SqlSyntaxErrorException" /> public static void Performance() { var sql = "select id,member_id,gmt_create from offer where member_id in ('1','22','333','1124','4525')"; for (var i = 0; i < 1000000; i++) { SqlParserDelegate.Parse(sql); } }