public virtual void TestPerformanceWhere()
{
for (int i = 0; i < 500000; i++)
{
ManagerParse.Parse(" show @@datasource where datanode = 1");
ManagerParse.Parse(" show @@datanode where schema = 1");
}
}
public virtual void TestIsSet()
{
NUnit.Framework.Assert.AreEqual(ManagerParse.Set, ManagerParse.Parse("set names utf8"
));
NUnit.Framework.Assert.AreEqual(ManagerParse.Set, ManagerParse.Parse("SET NAMES UTF8"
));
NUnit.Framework.Assert.AreEqual(ManagerParse.Set, ManagerParse.Parse("set NAMES utf8"
));
}
public virtual void TestPerformance()
{
for (int i = 0; i < 250000; i++)
{
ManagerParse.Parse("show databases");
ManagerParse.Parse("set autocommit=1");
ManagerParse.Parse(" show @@datasource ");
ManagerParse.Parse("select id,name,value from t");
}
}
public virtual void TestOnOff()
{
NUnit.Framework.Assert.AreEqual(ManagerParse.Online, ManagerParse.Parse("online "
));
NUnit.Framework.Assert.AreEqual(ManagerParse.Online, ManagerParse.Parse(" Online"
));
NUnit.Framework.Assert.AreEqual(ManagerParse.Other, ManagerParse.Parse(" Online2"
));
NUnit.Framework.Assert.AreEqual(ManagerParse.Other, ManagerParse.Parse("Online2 "
));
NUnit.Framework.Assert.AreEqual(ManagerParse.Offline, ManagerParse.Parse(" Offline"
));
NUnit.Framework.Assert.AreEqual(ManagerParse.Offline, ManagerParse.Parse("offLine\t"
));
NUnit.Framework.Assert.AreEqual(ManagerParse.Other, ManagerParse.Parse("onLin"));
NUnit.Framework.Assert.AreEqual(ManagerParse.Other, ManagerParse.Parse(" onlin"));
}
public virtual void TestIsShow()
{
NUnit.Framework.Assert.AreEqual(ManagerParse.Show, unchecked ((int)(0xff)) & ManagerParse
.Parse("show databases"));
NUnit.Framework.Assert.AreEqual(ManagerParse.Show, unchecked ((int)(0xff)) & ManagerParse
.Parse("SHOW DATABASES"));
NUnit.Framework.Assert.AreEqual(ManagerParse.Show, unchecked ((int)(0xff)) & ManagerParse
.Parse("SHOW databases"));
}
public virtual void TestRollback()
{
NUnit.Framework.Assert.AreEqual(ManagerParse.Rollback, unchecked ((int)(0xff)) & ManagerParse
.Parse("rollback @@"));
NUnit.Framework.Assert.AreEqual(ManagerParse.Rollback, unchecked ((int)(0xff)) & ManagerParse
.Parse(" ROLLBACK "));
}
public virtual void TestReload()
{
NUnit.Framework.Assert.AreEqual(ManagerParse.Reload, unchecked ((int)(0xff)) & ManagerParse
.Parse("reload @@"));
NUnit.Framework.Assert.AreEqual(ManagerParse.Reload, unchecked ((int)(0xff)) & ManagerParse
.Parse(" RELOAD "));
}
public virtual void TestStop()
{
NUnit.Framework.Assert.AreEqual(ManagerParse.Stop, unchecked ((int)(0xff)) & ManagerParse
.Parse("stop @@"));
NUnit.Framework.Assert.AreEqual(ManagerParse.Stop, unchecked ((int)(0xff)) & ManagerParse
.Parse(" STOP "));
}
public virtual void TestComment()
{
NUnit.Framework.Assert.AreEqual(ManagerParse.Switch, unchecked ((int)(0xff)) & ManagerParse
.Parse("/* abc */switch @@pool offer2$0-2"));
NUnit.Framework.Assert.AreEqual(ManagerParse.Show, unchecked ((int)(0xff)) & ManagerParse
.Parse(" /** 111**/Show @@help"));
NUnit.Framework.Assert.AreEqual(ManagerParse.Select, unchecked ((int)(0xff)) & ManagerParse
.Parse(" /***/ select * from t "));
}
public virtual void TestSwitchPool()
{
NUnit.Framework.Assert.AreEqual(ManagerParse.Switch, unchecked ((int)(0xff)) & ManagerParse
.Parse("switch @@pool offer2$0-2"));
NUnit.Framework.Assert.AreEqual(ManagerParse.Switch, unchecked ((int)(0xff)) & ManagerParse
.Parse("SWITCH @@POOL offer2$0-2"));
NUnit.Framework.Assert.AreEqual(ManagerParse.Switch, unchecked ((int)(0xff)) & ManagerParse
.Parse("switch @@pool offer2$0-2 :2"));
}
public virtual void TestIsSelect()
{
NUnit.Framework.Assert.AreEqual(ManagerParse.Select, unchecked ((int)(0xff)) & ManagerParse
.Parse("select * from offer limit 1"));
NUnit.Framework.Assert.AreEqual(ManagerParse.Select, unchecked ((int)(0xff)) & ManagerParse
.Parse("SELECT * FROM OFFER LIMIT 1"));
NUnit.Framework.Assert.AreEqual(ManagerParse.Select, unchecked ((int)(0xff)) & ManagerParse
.Parse("SELECT * FROM OFFER limit 1"));
}
