public void ToSqlTextTest03()
{
string expected = string.Empty;
string actual = string.Empty;
SQLWhereTextBuilder target = new SQLWhereTextBuilder();
target.Set("aaa", SQLText.CompareOperation.Equal, DbType.Boolean, true);
SQLWhereTextBuilder target1 = new SQLWhereTextBuilder();
target1.Set("bbb", SQLText.CompareOperation.Equal, DbType.Double, 222);
SQLWhereTextBuilder target2 = new SQLWhereTextBuilder();
target2.Set("ccc", SQLText.CompareOperation.Equal, DbType.DateTime, DateTime.Parse("1999-9-9 9:9:9"));
SQLWhereTextBuilder target3 = new SQLWhereTextBuilder();
target3.Set("ddd", SQLText.CompareOperation.Equal, DbType.String, "DDD");
target.Add(SQLText.LogicOperation.And, target1);
target.Add(SQLText.LogicOperation.Or, target2);
target.Add(SQLText.LogicOperation.Or, target3);
expected = "(aaa = True AND bbb = 222 OR ccc = '1999-09-09 09:09:09.000' OR ddd = 'DDD')";
actual = target.ToSqlText();
Assert.AreEqual(expected, actual);
}
public void ToSqlTextTest02()
{
string expected = string.Empty;
string actual = string.Empty;
SQLWhereTextBuilder target = null;
target = new SQLWhereTextBuilder();
target.Set("aaa", SQLText.CompareOperation.MoreThan, DbType.Single, 22);
expected = "aaa > 22";
actual = target.ToSqlText();
Assert.AreEqual(expected, actual);
}
public void ToSqlTextTest01()
{
string expected = string.Empty;
string actual = string.Empty;
SQLWhereTextBuilder target = null;
target = new SQLWhereTextBuilder();
target.Set("aaa", SQLText.CompareOperation.Equal, DbType.Boolean, true);
expected = "aaa = True";
actual = target.ToSqlText();
Assert.AreEqual(expected, actual);
}
public void ToSqlTextTest01()
{
SQLWhereTextBuilder target = new SQLWhereTextBuilder();
SQLInTextBuilder inb = new SQLInTextBuilder();
inb.Set("a", "b", "c", "d");
target.Set("abcd", SQLText.CompareOperation.In, System.Data.DbType.String, inb);
string expected = "abcd IN ('a','b','c','d')";
string actual;
actual = target.ToSqlText();
Assert.AreEqual(expected, actual);
}
public void ToSqlTextTest02()
{
SQLTextBuilder stb = new SQLTextBuilder();
stb.Action = SQLText.Action.Select;
stb.Field.Set("field1");
stb.From.Set("DemoTable");
SQLWhereTextBuilder target = new SQLWhereTextBuilder();
SQLInTextBuilder inb = new SQLInTextBuilder();
inb.Set(stb);
target.Set("abcd", SQLText.CompareOperation.In, System.Data.DbType.String, inb);
string expected = "abcd IN (SELECT field1 FROM DemoTable)";
string actual;
actual = target.ToSqlText();
Assert.AreEqual(expected, actual);
}
internal static void Do()
{
SQLWhereTextBuilder ctb = new SQLWhereTextBuilder();
SQLWhereTextBuilder b1 = new SQLWhereTextBuilder();
b1.Set("name", SQLText.CompareOperation.Equal, DbType.String, "%kkp%");
SQLWhereTextBuilder b2 = new SQLWhereTextBuilder();
b2.Set("nickName", SQLText.CompareOperation.Like, DbType.String, "%'kkp'%");
SQLWhereTextBuilder b3 = new SQLWhereTextBuilder();
b3.Set("age", SQLText.CompareOperation.Equal, DbType.Date, DateTime.Now);
SQLWhereTextBuilder b4 = new SQLWhereTextBuilder();
b4.Set("signTime", SQLText.CompareOperation.Equal, DbType.DateTime, DateTime.Now);
SQLWhereTextBuilder b5 = new SQLWhereTextBuilder();
b5.Set("count", SQLText.CompareOperation.MoreThan, DbType.Int32, 88888);
SQLWhereTextBuilder b51 = new SQLWhereTextBuilder();
b51.Set("length", SQLText.CompareOperation.MoreThan, DbType.Decimal, 88888);
SQLWhereTextBuilder b52 = new SQLWhereTextBuilder();
b52.Set("price", SQLText.CompareOperation.MoreThan, DbType.Double, 888.88);
b1.Add(SQLText.LogicOperation.And, b2);
b2.Add(SQLText.LogicOperation.And, b3);
b3.Add(SQLText.LogicOperation.And, b4);
b4.Add(SQLText.LogicOperation.And, b5);
b5.Add(SQLText.LogicOperation.And, b51);
b5.Add(SQLText.LogicOperation.And, b52);
ctb.Add(SQLText.LogicOperation.Or, b1);
Console.WriteLine(ctb.ToSqlText());
Console.WriteLine();
Console.WriteLine(ctb.ToSqlTempletText());
Console.WriteLine();
DbParameter[] sqls = ctb.GetDbParameters();
foreach (var item in sqls)
{
Console.WriteLine(item.ToString());
}
Console.WriteLine("............................");
SQLFieldTextBuilder ftb = new SQLFieldTextBuilder();
ftb.Set("a", "b", "c", "d");
Console.WriteLine(ftb.ToSqlText());
ftb = new SQLFieldTextBuilder();
ftb.Set(
new Pair <string, string>("aaa", "AAA"),
new Pair <string, string>("bbb", "BBB"),
new Pair <string, string>("ccc", "CCC")
);
ftb.Set(
new Pair <string, string>("ddd", "DDD"),
new Pair <string, string>("eee", "EEE")
);
Console.WriteLine(ftb.ToSqlText());
}
internal static void Do()
{
SQLWhereTextBuilder ctb = new SQLWhereTextBuilder();
SQLWhereTextBuilder b1 = new SQLWhereTextBuilder();
b1.Set("name", SQLText.CompareOperation.Equal, DbType.String, "%kkp%");
SQLWhereTextBuilder b2 = new SQLWhereTextBuilder();
b2.Set("nickName", SQLText.CompareOperation.Like, DbType.String, "%'kkp'%");
SQLWhereTextBuilder b3 = new SQLWhereTextBuilder();
b3.Set("age", SQLText.CompareOperation.Equal, DbType.Date, DateTime.Now);
SQLWhereTextBuilder b4 = new SQLWhereTextBuilder();
b4.Set("signTime", SQLText.CompareOperation.Equal, DbType.DateTime, DateTime.Now);
SQLWhereTextBuilder b5 = new SQLWhereTextBuilder();
b5.Set("count", SQLText.CompareOperation.MoreThan, DbType.Int32, 88888);
SQLWhereTextBuilder b51 = new SQLWhereTextBuilder();
b51.Set("length", SQLText.CompareOperation.MoreThan, DbType.Decimal, 88888);
SQLWhereTextBuilder b52 = new SQLWhereTextBuilder();
b52.Set("price", SQLText.CompareOperation.MoreThan, DbType.Double, 888.88);
b1.Add(SQLText.LogicOperation.And, b2);
b2.Add(SQLText.LogicOperation.And, b3);
b3.Add(SQLText.LogicOperation.And, b4);
b4.Add(SQLText.LogicOperation.And, b5);
b5.Add(SQLText.LogicOperation.And, b51);
b5.Add(SQLText.LogicOperation.And, b52);
ctb.Add(SQLText.LogicOperation.Or, b1);
Console.WriteLine(ctb.ToSqlText());
Console.WriteLine();
Console.WriteLine(ctb.ToSqlTempletText());
Console.WriteLine();
DbParameter[] sqls = ctb.GetDbParameters();
foreach (var item in sqls)
{
Console.WriteLine(item.ToString());
}
Console.WriteLine("............................");
SQLFieldTextBuilder ftb = new SQLFieldTextBuilder();
ftb.Set("a", "b", "c", "d");
Console.WriteLine(ftb.ToSqlText());
ftb = new SQLFieldTextBuilder();
ftb.Set(
new Pair<string, string>("aaa", "AAA"),
new Pair<string, string>("bbb", "BBB"),
new Pair<string, string>("ccc", "CCC")
);
ftb.Set(
new Pair<string, string>("ddd", "DDD"),
new Pair<string, string>("eee", "EEE")
);
Console.WriteLine(ftb.ToSqlText());
}
