public void MySqlSourceConstructorTest_Subquery()
{
MySqlSource source = new MySqlSource("Table");
ISqlSelectStatement statement = new MySqlSelectStatement();
statement.SelectClause.AddExpressions(new SqlAllField(source));
statement.FromClause.Source = source;
MySqlSource target = new MySqlSource(statement, "Source");
Assert.AreEqual <string>(string.Format("`{0}`", target.Name), target.Fullname);
Assert.AreEqual <string>(string.Format("({0}) AS `{1}`", statement.SqlString, target.Name), target.SqlString);
}
public void CountTest()
{
ISqlObject source = new MySqlSource("Table");
ISqlObject field = new MySqlField(source, "ID");
MySqlSelectStatement target = new MySqlSelectStatement();
target.SelectClause.AddExpressions(field);
target.FromClause.SetSource(source);
target.Count = 13;
Assert.AreEqual <string>(string.Format("{0} {1} {2}", target.SelectClause.SqlString, target.FromClause.SqlString, target.LimitClause.SqlString),
target.SqlString);
}
