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 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());
}
