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);
}
public void ToSqlTextTest02()
{
string expected = "SELECT CustomerID, CompanyName, ContactTitle, City FROM Customers WHERE CustomerID IN (SELECT CustomerID FROM Orders)";
SQLTextBuilder target = new SQLTextBuilder();
target.Action = SQLText.Action.Select;
target.Field.Set("CustomerID", "CompanyName", "ContactTitle", "City");
target.From.Set("Customers");
SQLTextBuilder ta = new SQLTextBuilder();
ta.Action = SQLText.Action.Select;
ta.Field.Set("CustomerID");
ta.From.Set("Orders");
SQLInTextBuilder inb = new SQLInTextBuilder();
inb.Set(ta);
target.Where.Set("CustomerID", SQLText.CompareOperation.In, DbType.String, inb);
Assert.AreEqual(expected, target.ToSqlText());
}