public void SelectAllFrom()
{
var expected = "SELECT * FROM Products";
var query = SQLSelectBuilder
.SelectAllFrom("Products")
.Build();
AssertTrue(query, expected);
}
public void SelectAllFromApplyingWhere()
{
var expected = "SELECT * FROM EMPLOYEES WHERE ANNUAL_SALARY > 24000";
var query = SQLSelectBuilder
.SelectAllFrom("EMPLOYEES")
.Where("ANNUAL_SALARY", new MajorThan(24000))
.Build();
AssertTrue(query, expected);
}
public void SelectAllFromApplyingWhereWithAnd()
{
var expected = "SELECT * FROM EMPLOYEES WHERE ANNUAL_SALARY > 24000 AND HIRED_ON > 1990/01/01";
var query = SQLSelectBuilder
.SelectAllFrom("EMPLOYEES")
.Where("ANNUAL_SALARY", new MajorThan(24000))
.And("HIRED_ON", new AfterThan(new DateTime(1990, 1, 1), "yyyy/MM/dd"))
.Build();
AssertTrue(query, expected);
}
