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