public void BuildExpression_ANSIJoin()
{
MySQLBuilder sqlBuilder = new MySQLBuilder();
sqlBuilder.AddSelectClause("id");
sqlBuilder.AddFromClause("foo");
sqlBuilder.AddJoinClause("LEFT JOIN", "bar", "bar.id = foo.id");
StringBuilder stringBuilder = new StringBuilder();
sqlBuilder.BuildExpression(stringBuilder);
Assert.AreEqual("SELECT DISTINCT id FROM foo LEFT JOIN bar ON bar.id = foo.id;", stringBuilder.ToString());
}
public void BuildExpression_Limit()
{
MySQLBuilder sqlBuilder = new MySQLBuilder();
sqlBuilder.AddSelectClause("id");
sqlBuilder.AddFromClause("employees");
sqlBuilder.SkipResults(100);
sqlBuilder.TakeResults(10);
StringBuilder stringBuilder = new StringBuilder();
sqlBuilder.BuildExpression(stringBuilder);
Assert.AreEqual("SELECT DISTINCT id FROM employees LIMIT 100, 10;", stringBuilder.ToString());
}
public void BuildExpression_Count()
{
MySQLBuilder sqlBuilder = new MySQLBuilder();
sqlBuilder.AddSelectClause("id");
sqlBuilder.AddSelectClause("name");
sqlBuilder.AddFromClause("employees");
sqlBuilder.AddCountClause(typeof(Employee));
StringBuilder stringBuilder = new StringBuilder();
sqlBuilder.BuildExpression(stringBuilder);
Assert.AreEqual("SELECT COUNT(*) AS numrows FROM employees;", stringBuilder.ToString());
}
public void BuildExpression_OrderBy()
{
MySQLBuilder sqlBuilder = new MySQLBuilder();
sqlBuilder.AddSelectClause("id");
sqlBuilder.AddFromClause("employees");
sqlBuilder.AddOrderByClause("name", SortDirection.Descending);
StringBuilder stringBuilder = new StringBuilder();
sqlBuilder.BuildExpression(stringBuilder);
Assert.AreEqual("SELECT DISTINCT id FROM employees ORDER BY name DESC;", stringBuilder.ToString());
}
public void Clone_SimpleTest()
{
SQLBuilder sqlBuilder = new MySQLBuilder();
sqlBuilder.AddSelectClause("name");
sqlBuilder.AddFromClause("employees");
sqlBuilder.AddWhereClause("id=42", ExpressionType.And);
SQLBuilder clonedBuilder = (SQLBuilder) sqlBuilder.Clone();
sqlBuilder.AddCountClause(typeof(Employee));
StringBuilder stringBuilder = new StringBuilder();
sqlBuilder.BuildExpression(stringBuilder);
Assert.AreEqual("SELECT COUNT(*) AS numrows FROM employees WHERE id=42 ;", stringBuilder.ToString());
stringBuilder = new StringBuilder();
clonedBuilder.BuildExpression(stringBuilder);
Assert.AreEqual("SELECT DISTINCT name FROM employees WHERE id=42 ;", stringBuilder.ToString());
}
public void BuildExpression_TypeSelect()
{
MySQLBuilder sqlBuilder = new MySQLBuilder();
sqlBuilder.AddSelectTypeClause("employees", typeof(Employee));
sqlBuilder.AddFromClause("employees");
StringBuilder stringBuilder = new StringBuilder();
sqlBuilder.BuildExpression(stringBuilder);
Assert.AreEqual("SELECT DISTINCT employees.id AS employee_id, employees.name AS employee_name FROM employees;", stringBuilder.ToString());
}
public void BuildExpression_SelectFromWhere()
{
MySQLBuilder sqlBuilder = new MySQLBuilder();
sqlBuilder.AddSelectClause("name");
sqlBuilder.AddFromClause("employees");
sqlBuilder.AddWhereClause("id=42", ExpressionType.And);
StringBuilder stringBuilder = new StringBuilder();
sqlBuilder.BuildExpression(stringBuilder);
Assert.AreEqual("SELECT DISTINCT name FROM employees WHERE id=42 ;", stringBuilder.ToString());
}