private static void ParseSetPerf()
{
// ServerParse.parse("show databases");
// ServerParseSet.parse("set autocommit=1");
// ServerParseSet.parse("set names=1");
ServerParseSet.Parse("SET character_set_results = NULL", 4);
}
public virtual void TestTxSerializable()
{
NUnit.Framework.Assert.AreEqual(ServerParseSet.TxSerializable, ServerParseSet.Parse
(" SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE ", " SET".Length));
NUnit.Framework.Assert.AreEqual(ServerParseSet.TxSerializable, ServerParseSet.Parse
(" set session transaction isolation level serializable ", " SET".Length));
NUnit.Framework.Assert.AreEqual(ServerParseSet.TxSerializable, ServerParseSet.Parse
(" set session transaction isOLATION LEVEL SERIAlizable ", " SET".Length));
}
public virtual void TestTxReadCommitted()
{
NUnit.Framework.Assert.AreEqual(ServerParseSet.TxReadCommitted, ServerParseSet.Parse
(" SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED ", " SET".Length));
NUnit.Framework.Assert.AreEqual(ServerParseSet.TxReadCommitted, ServerParseSet.Parse
(" set session transaction isolation level read committed ", " SET".Length));
NUnit.Framework.Assert.AreEqual(ServerParseSet.TxReadCommitted, ServerParseSet.Parse
(" set session transaCTION ISOLATION LEVel read committed ", " SET".Length));
}
public virtual void TestIsSetOther()
{
NUnit.Framework.Assert.AreEqual(ServerParseSet.Other, ServerParseSet.Parse("set ..."
, 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.Other, ServerParseSet.Parse("SET ..."
, 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.Other, ServerParseSet.Parse("sEt ..."
, 3));
}
public virtual void TestTxRepeatedRead()
{
NUnit.Framework.Assert.AreEqual(ServerParseSet.TxRepeatedRead, ServerParseSet.Parse
(" SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ ", " SET".Length
));
NUnit.Framework.Assert.AreEqual(ServerParseSet.TxRepeatedRead, ServerParseSet.Parse
(" set session transaction isolation level repeatable read ", " SET".Length));
NUnit.Framework.Assert.AreEqual(ServerParseSet.TxRepeatedRead, ServerParseSet.Parse
(" set session transaction isOLATION LEVEL REPEatable read ", " SET".Length));
}
public virtual void TestIsSetAutocommitOff()
{
NUnit.Framework.Assert.AreEqual(ServerParseSet.AutocommitOff, ServerParseSet.Parse
("set autocommit=0", 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.AutocommitOff, ServerParseSet.Parse
("SET AUTOCOMMIT= 0", 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.AutocommitOff, ServerParseSet.Parse
("set autoCOMMIT =OFF", 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.AutocommitOff, ServerParseSet.Parse
("set autoCOMMIT = off", 3));
}
public virtual void TestIsSetAutocommitOn()
{
NUnit.Framework.Assert.AreEqual(ServerParseSet.AutocommitOn, ServerParseSet.Parse
("set autocommit=1", 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.AutocommitOn, ServerParseSet.Parse
("set autoCOMMIT = 1", 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.AutocommitOn, ServerParseSet.Parse
("SET AUTOCOMMIT=on", 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.AutocommitOn, ServerParseSet.Parse
("set autoCOMMIT = ON", 3));
}
public virtual void TestIsCharacterSetResults()
{
NUnit.Framework.Assert.AreEqual(ServerParseSet.CharacterSetResults, unchecked ((int
)(0xff)) & ServerParseSet.Parse("SET character_set_results = NULL", 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.CharacterSetResults, unchecked ((int
)(0xff)) & ServerParseSet.Parse("SET CHARACTER_SET_RESULTS= NULL", 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.CharacterSetResults, unchecked ((int
)(0xff)) & ServerParseSet.Parse("Set chARActer_SET_RESults = NULL", 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.CharacterSetConnection, unchecked (
(int)(0xff)) & ServerParseSet.Parse("Set chARActer_SET_Connection = NULL", 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.CharacterSetClient, unchecked ((int
)(0xff)) & ServerParseSet.Parse("Set chARActer_SET_client = NULL", 3));
}
public virtual void TestIsSetNames()
{
NUnit.Framework.Assert.AreEqual(ServerParseSet.Names, unchecked ((int)(0xff)) & ServerParseSet
.Parse("set names utf8", 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.Names, unchecked ((int)(0xff)) & ServerParseSet
.Parse("SET NAMES UTF8", 3));
NUnit.Framework.Assert.AreEqual(ServerParseSet.Names, unchecked ((int)(0xff)) & ServerParseSet
.Parse("set NAMES utf8", 3));
}
