public void ToSqlTextTest()
{
string expected = string.Empty;
string actual = string.Empty;
SQLFieldTextBuilder target = null;
target = new SQLFieldTextBuilder();
target.Set("a", "b", "c", "d");
expected = "a, b, c, d";
actual = target.ToSqlText();
Assert.AreEqual(expected, actual);
target = new SQLFieldTextBuilder();
target.Set(
new Pair <string, string>("aaa", "AAA"),
new Pair <string, string>("bbb", "BBB"),
new Pair <string, string>("ccc", "CCC")
);
target.Set(
new Pair <string, string>("ddd", "DDD"),
new Pair <string, string>("eee", "EEE")
);
expected = "aaa AS \"AAA\", bbb AS \"BBB\", ccc AS \"CCC\", ddd AS \"DDD\", eee AS \"EEE\"";
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());
}
