public void runSqlParser()
{
string sql =
"SELECT DISTINCT\n" +
" idsostype, descriptive, soscategory, soscategory.sosbusinessarea,\n" +
" webcompany, webperson, web, department, name\n" +
"FROM sostype\n" +
"WHERE active='1':numeric AND\n" +
" soscategory.sosbusinessarea != 2701 AND\n" +
" web=1 AND (webperson=1 OR webcompany=1)\n" +
"ORDER BY descriptive, soscategory DESC\n" +
"LIMIT 100";
Node query = Parser.ParseSQL(sql);
My.Write("Query: " + query.ToHumanReadableString());
}
public void runTestBuilder()
{
Node table = Builder.Table("mytable");
My.Write("Table: " + table);
}