public void ParseTestsAncCheckCount(string command, int outputCount, int conditionCount, int orderByCount)
{
DefaultSelectParser parser = new DefaultSelectParser();
SelectInfo info = parser.Parse(command);
Assert.AreEqual(outputCount, info.Fields.Count, "count of output");
Assert.AreEqual(conditionCount, info.Conditions.Count, "count of condition");
Assert.AreEqual(orderByCount, info.Orders.Count, "count of orderby");
}
public void ParseCommand_NameByIdIsMyid()
{
DefaultSelectParser parser = new DefaultSelectParser();
SelectInfo info = parser.Parse("NameByIdIsMyid");
Assert.AreEqual("Name", info.Fields[0]);
Assert.AreEqual("Id", info.Conditions[0].Field);
Assert.AreEqual("Is", info.Conditions[0].Operators);
Assert.AreEqual(ConditionJoiners.Null, info.Conditions[0].JoinerToNext);
Assert.AreEqual("Myid", info.Conditions[0].Parameter);
}
public void ParseTest_NameById()
{
string command = "NameById";
DefaultSelectParser parser = new DefaultSelectParser();
SelectInfo info = parser.Parse(command);
Assert.AreEqual(1, info.Fields.Count, "count of field should be 1");
Assert.AreEqual("Name", info.Fields[0]);
Assert.AreEqual(1, info.Conditions.Count, "count of condition should be 1");
Assert.AreEqual("Id", info.Conditions[0].Field);
Assert.AreEqual("", info.Conditions[0].Operators);
Assert.AreEqual(0, info.Orders.Count);
}
public void ParseCommand_NameByIdIsMyidAndAgeGtMyageOrderbyId()
{
DefaultSelectParser parser = new DefaultSelectParser();
SelectInfo info = parser.Parse("NameByIdIsMyidAndAgeGtMyageOrderbyId");
Assert.AreEqual("Name", info.Fields[0]);
Assert.AreEqual("Id", info.Conditions[0].Field);
Assert.AreEqual("Is", info.Conditions[0].Operators);
Assert.AreEqual(ConditionJoiners.And, info.Conditions[0].JoinerToNext);
Assert.AreEqual("Myid", info.Conditions[0].Parameter);
Assert.AreEqual("Age", info.Conditions[1].Field);
Assert.AreEqual("Gt", info.Conditions[1].Operators);
Assert.AreEqual(ConditionJoiners.Null, info.Conditions[1].JoinerToNext);
Assert.AreEqual("Myage", info.Conditions[1].Parameter);
Assert.AreEqual("Id", info.Orders[0].Field);
Assert.AreEqual(OrderTypes.Asc, info.Orders[0].Type);
}
public void ParseCommand_NameAndIconByRegstertimeAndStateOrderbyRegtertimeDescId()
{
DefaultSelectParser parser = new DefaultSelectParser();
SelectInfo info = parser.Parse("NameAndIconByRegstertimeAndStateOrderbyRegtertimeDescId");
Assert.AreEqual("Name", info.Fields[0]);
Assert.AreEqual("Icon", info.Fields[1]);
Assert.AreEqual("Regstertime", info.Conditions[0].Field);
Assert.AreEqual("", info.Conditions[0].Operators);
Assert.AreEqual(ConditionJoiners.And, info.Conditions[0].JoinerToNext);
Assert.AreEqual("State", info.Conditions[1].Field);
Assert.AreEqual("", info.Conditions[1].Operators);
Assert.AreEqual(ConditionJoiners.Null, info.Conditions[1].JoinerToNext);
Assert.AreEqual("Regtertime", info.Orders[0].Field);
Assert.AreEqual(OrderTypes.Desc, info.Orders[0].Type);
Assert.AreEqual("Id", info.Orders[1].Field);
Assert.AreEqual(OrderTypes.Asc, info.Orders[1].Type);
}
private SelectInfo GetInfoByCommand(string command)
{
DefaultSelectParser parser = new DefaultSelectParser();
return(parser.Parse(command));
}
