public virtual void TestShowVersion()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Version, ManagerParseShow.Parse(
"show @@version", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Version, ManagerParseShow.Parse(
"SHOW @@VERSION", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Version, ManagerParseShow.Parse(
"show @@VERSION", 5));
}
public virtual void TestShowTimeCurrent()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.TimeCurrent, ManagerParseShow.Parse
("show @@time.current", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.TimeCurrent, ManagerParseShow.Parse
("SHOW @@TIME.CURRENT", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.TimeCurrent, ManagerParseShow.Parse
("show @@TIME.current", 5));
}
public virtual void TestShowCommand()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Command, ManagerParseShow.Parse(
"show @@command", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Command, ManagerParseShow.Parse(
"SHOW @@COMMAND", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Command, ManagerParseShow.Parse(
"show @@COMMAND", 5));
}
public virtual void TestShowThreadPool()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Threadpool, ManagerParseShow.Parse
("show @@threadPool", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Threadpool, ManagerParseShow.Parse
("SHOW @@THREADPOOL", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Threadpool, ManagerParseShow.Parse
("show @@THREADPOOL", 5));
}
public virtual void TestShowBackend()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Backend, ManagerParseShow.Parse(
"show @@backend", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Backend, ManagerParseShow.Parse(
"SHOW @@BACkend;", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Backend, ManagerParseShow.Parse(
"show @@BACKEND ", 5));
}
public virtual void TestShowRouter()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Router, ManagerParseShow.Parse("show @@router"
, 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Router, ManagerParseShow.Parse("SHOW @@ROUTER"
, 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Router, ManagerParseShow.Parse("show @@ROUTER"
, 5));
}
public virtual void TestShowServer()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Server, ManagerParseShow.Parse("show @@server"
, 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Server, ManagerParseShow.Parse("SHOW @@SERVER"
, 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Server, ManagerParseShow.Parse("show @@SERVER"
, 5));
}
public virtual void TestShowProcessor()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Processor, ManagerParseShow.Parse
("show @@processor", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Processor, ManagerParseShow.Parse
("SHOW @@PROCESSOR", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Processor, ManagerParseShow.Parse
("show @@PROCESSOR", 5));
}
public virtual void TestShowHeartbeat()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Heartbeat, ManagerParseShow.Parse
("show @@heartbeat", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Heartbeat, ManagerParseShow.Parse
("SHOW @@hearTBeat ", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Heartbeat, ManagerParseShow.Parse
(" show @@HEARTBEAT ", 6));
}
public virtual void TestShowHelp()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Help, ManagerParseShow.Parse("show @@help"
, 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Help, ManagerParseShow.Parse("SHOW @@HELP"
, 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Help, ManagerParseShow.Parse("show @@HELP"
, 5));
}
public virtual void TestShowConnectionSQL()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.ConnectionSql, ManagerParseShow.
Parse("show @@connection.sql", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.ConnectionSql, ManagerParseShow.
Parse("SHOW @@CONNECTION.SQL", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.ConnectionSql, ManagerParseShow.
Parse("show @@CONNECTION.Sql", 5));
}
public virtual void TestShowTimeStartUp()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.TimeStartup, ManagerParseShow.Parse
("show @@time.startup", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.TimeStartup, ManagerParseShow.Parse
("SHOW @@TIME.STARTUP", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.TimeStartup, ManagerParseShow.Parse
("show @@TIME.startup", 5));
}
public virtual void TestGetWhere()
{
NUnit.Framework.Assert.AreEqual("123", ManagerParseShow.GetWhereParameter("where id = 123"
));
NUnit.Framework.Assert.AreEqual("datanode", ManagerParseShow.GetWhereParameter("where datanode = datanode"
));
NUnit.Framework.Assert.AreEqual("schema", ManagerParseShow.GetWhereParameter("where schema =schema "
));
}
public virtual void TestShowWhitComment()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Variables, ManagerParseShow.Parse
(" /** 111**/show variables", " /** 111**/show".Length));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Variables, ManagerParseShow.Parse
(" /**111**/ SHOW VARIABLES", " /** 111**/show".Length));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Variables, ManagerParseShow.Parse
(" /**111**/ SHOW variables", " /** 111**/show".Length));
}
public virtual void TestShowDatabase()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Database, ManagerParseShow.Parse
("show @@database", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Database, ManagerParseShow.Parse
("SHOW @@DATABASE", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Database, ManagerParseShow.Parse
("show @@DATABASE", 5));
}
public virtual void TestShowCollation()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Collation, ManagerParseShow.Parse
("show collation", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Collation, ManagerParseShow.Parse
("SHOW COLLATION", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Collation, ManagerParseShow.Parse
("show COLLATION", 5));
}
public virtual void TestShowVariables()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Variables, ManagerParseShow.Parse
("show variables", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Variables, ManagerParseShow.Parse
("SHOW VARIABLES", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Variables, ManagerParseShow.Parse
("show VARIABLES", 5));
}
public virtual void TestShowSQLSlow()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SqlSlow, ManagerParseShow.Parse(
"show @@sql.slow", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SqlSlow, ManagerParseShow.Parse(
"SHOW @@SQL.SLOW", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SqlSlow, ManagerParseShow.Parse(
"SHOW @@sql.slow", 5));
}
public virtual void TestShowSQLExecute()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SqlExecute, ManagerParseShow.Parse
("show @@sql.execute", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SqlExecute, ManagerParseShow.Parse
("SHOW @@SQL.EXECUTE", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SqlExecute, ManagerParseShow.Parse
("show @@SQL.EXECUTE", 5));
}
public virtual void TestShowSQLDetail()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SqlDetail, ManagerParseShow.Parse
("show @@sql.detail where id = -1079800749", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SqlDetail, ManagerParseShow.Parse
("SHOW @@SQL.DETAIL WHERE ID = -1079800749", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SqlDetail, ManagerParseShow.Parse
("show @@SQL.DETAIL WHERE ID = -1079800749", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SqlDetail, ManagerParseShow.Parse
("show @@sql.detail where id=1079800749 ", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SqlDetail, ManagerParseShow.Parse
("show @@sql.detail where id= -1079800749", 5));
}
public virtual void TestShowSQL()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Sql, ManagerParseShow.Parse("show @@sql where id = -1079800749"
, 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Sql, ManagerParseShow.Parse("SHOW @@SQL WHERE ID = -1079800749"
, 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Sql, ManagerParseShow.Parse("show @@Sql WHERE ID = -1079800749"
, 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Sql, ManagerParseShow.Parse("show @@sql where id=-1079800749"
, 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Sql, ManagerParseShow.Parse("show @@sql where id =-1079800749 "
, 5));
}
public virtual void TestShowDataNode()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Datanode, ManagerParseShow.Parse
("show @@datanode", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Datanode, ManagerParseShow.Parse
("SHOW @@DATANODE", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Datanode, ManagerParseShow.Parse
("show @@DATANODE", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Datanode, ManagerParseShow.Parse
("show @@DATANODE ", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.DatanodeWhere, unchecked ((int)(0xff
)) & ManagerParseShow.Parse("show @@DATANODE WHERE SCHEMA=1", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.DatanodeWhere, unchecked ((int)(0xff
)) & ManagerParseShow.Parse("show @@DATANODE WHERE schema =1", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.DatanodeWhere, unchecked ((int)(0xff
)) & ManagerParseShow.Parse("show @@DATANODE WHERE SCHEMA= 1", 5));
}
public virtual void TestShowDataSource()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Datasource, ManagerParseShow.Parse
("show @@datasource", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Datasource, ManagerParseShow.Parse
("SHOW @@DATASOURCE", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Datasource, ManagerParseShow.Parse
(" show @@DATASOURCE ", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.Datasource, ManagerParseShow.Parse
(" show @@DATASOURCE ", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.DatasourceWhere, unchecked ((int)
(0xff)) & ManagerParseShow.Parse(" show @@DATASOURCE where datanode = 1", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.DatasourceWhere, unchecked ((int)
(0xff)) & ManagerParseShow.Parse(" show @@DATASOURCE where datanode=1", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.DatasourceWhere, unchecked ((int)
(0xff)) & ManagerParseShow.Parse(" show @@DATASOURCE WHERE datanode = 1", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.DatasourceWhere, unchecked ((int)
(0xff)) & ManagerParseShow.Parse(" show @@DATASOURCE where DATAnode= 1 ", 5));
}
public virtual void TestShowSlowSchema()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SlowSchema, unchecked ((int)(0xff
)) & ManagerParseShow.Parse("show @@slow where schema=a", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SlowSchema, unchecked ((int)(0xff
)) & ManagerParseShow.Parse(" SHOW @@SLOW WHERE SCHEMA=B", 6));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SlowSchema, unchecked ((int)(0xff
)) & ManagerParseShow.Parse(" show @@slow WHERE SCHEMA = a ", 5));
}
public virtual void TestShowSlowDataNode()
{
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SlowDatanode, unchecked ((int)(0xff
)) & ManagerParseShow.Parse("show @@slow where datanode= a", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SlowDatanode, unchecked ((int)(0xff
)) & ManagerParseShow.Parse("SHOW @@SLOW WHERE DATANODE= A", 5));
NUnit.Framework.Assert.AreEqual(ManagerParseShow.SlowDatanode, unchecked ((int)(0xff
)) & ManagerParseShow.Parse(" show @@SLOW where DATANODE= b ", 5));
}
