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