private static StatementContext compileStatement(
String query, Scan scan, List<Object> binds, Integer limit, Set<Expression> extractedNodes)
throws SQLException {
SQLParser parser = new SQLParser(query);
SelectStatement statement = parser.parseQuery();
statement = RHSLiteralStatementRewriter.normalizeWhereClause(statement);
PhoenixConnection pconn =
DriverManager.getConnection(getUrl(), TEST_PROPERTIES).unwrap(PhoenixConnection.class);
ColumnResolver resolver = FromCompiler.getResolver(statement, pconn);
StatementContext context =
new StatementContext(pconn, resolver, binds, statement.getBindCount(), scan);
Integer actualLimit = LimitCompiler.getLimit(context, statement.getLimit());
assertEquals(limit, actualLimit);
GroupBy groupBy = GroupByCompiler.getGroupBy(statement, context);
statement = HavingCompiler.moveToWhereClause(statement, context, groupBy);
WhereCompiler.compileWhereClause(
context, statement.getWhere(), extractedNodes, statement.getHint());
return context;
}
public static void main(String[] args) throws Exception {
try {
CatalogReader foo = new CatalogReader("Catalog.xml");
Map<String, TableData> catalog = foo.getCatalog();
// System.out.println (CatalogReader.printCatalog (res));
InputStreamReader converter = new InputStreamReader(System.in);
BufferedReader in = new BufferedReader(converter);
System.out.format("\nSQL>");
String soFar = in.readLine() + " ";
// loop forever, or until someone asks to quit
while (true) {
// keep on reading from standard in until we hit a ";"
while (soFar.indexOf(';') == -1) soFar += (in.readLine() + " ");
// split the string
String toParse = soFar.substring(0, soFar.indexOf(';') + 1);
soFar = soFar.substring(soFar.indexOf(';') + 1, soFar.length());
toParse = toParse.toLowerCase();
// parse it
ANTLRStringStream parserIn = new ANTLRStringStream(toParse);
SQLLexer lexer = new SQLLexer(parserIn);
CommonTokenStream tokens = new CommonTokenStream(lexer);
SQLParser parser = new SQLParser(tokens);
// if we got a quit
if (parser.parse() == false) break;
// print the results
System.out.println("RESULT OF PARSING");
System.out.println("Expressions in SELECT:");
ArrayList<Expression> mySelect = parser.getSELECT();
for (Expression e : mySelect) System.out.println("\t" + e);
System.out.println("Tables in FROM:");
Map<String, String> myFrom = parser.getFROM();
System.out.println("\t" + myFrom);
System.out.println("WHERE clause:");
Expression myWhere = parser.getWHERE();
if (myWhere != null) System.out.println("\t" + myWhere);
System.out.println("GROUPING att:");
String myGroup = parser.getGROUPBY();
if (myGroup != null) System.out.println("\t" + myGroup);
SemanticChecker sc = new SemanticChecker(mySelect, myFrom, myWhere, myGroup, catalog);
if (sc.execute() == true)
new Optimizer(mySelect, myFrom, myWhere, myGroup, catalog).execute();
else System.err.println("Semantic checking failed");
System.out.format("\nSQL>");
}
} catch (Exception e) {
System.err.println("Interpreter.main.73: error!");
}
}