public static PlainSelect parseSqlQuery(String selectStatement) throws IOException { CCJSqlParserManager pm = new CCJSqlParserManager(); Reader reader = new StringReader(selectStatement); Statement statement; try { statement = pm.parse(reader); } catch (Exception e) { throw new DataSourceException( "parsing select statement: " + e.getCause().getMessage(), e); } if (!(statement instanceof Select)) { // either PlainSelect or Union throw new IllegalArgumentException("expected select or union statement: " + statement); } SelectBody selectBody = ((Select) statement).getSelectBody(); if (selectBody instanceof Union) { // dataStore.registerView(typeName, (Union) selectBody); throw new UnsupportedOperationException( "ArcSDEDataStore does not supports registering Union queries"); } else if (selectBody instanceof PlainSelect) { return (PlainSelect) selectBody; } else { throw new IllegalStateException(selectBody.getClass().getName()); } } }
public static PlainSelect parseQuery(CCJSqlParserManager parserManager, String query) throws JSQLParserException { PlainSelect parsedQueryString; if(!query.toLowerCase().trim().startsWith("select")) { query = FAKE_SELECT_PREFIX + query; } parsedQueryString = (PlainSelect) ((Select) parserManager.parse(new StringReader(query))) .getSelectBody(); return parsedQueryString; }
CCJSqlParserManager pm = new CCJSqlParserManager();
public static PlainSelect parseQuery(CCJSqlParserManager parserManager, String query) throws JSQLParserException { PlainSelect parsedQueryString; if(!query.toLowerCase().trim().startsWith("select")) { query = FAKE_SELECT_PREFIX + query; } parsedQueryString = (PlainSelect) ((Select) parserManager.parse(new StringReader(query))) .getSelectBody(); return parsedQueryString; }
CCJSqlParserManager pm = new CCJSqlParserManager();
/** * Parse a SQL/ADQL string using JSqlParser, return the result Statement. * * @param query * @return * @throws JSQLParserException SQL syntax error */ public static Statement receiveQuery(String query) throws JSQLParserException { log.debug(query); Statement statement = null; StringReader sr = new StringReader(query); CCJSqlParserManager sqlParser = new CCJSqlParserManager(); statement = sqlParser.parse(sr); return statement; }
public Statement testFullURISingle(String sqlcmd) throws Exception { Statement statement = parser.parse(new StringReader(sqlcmd)); TableNameReplacer tableNameReplacer = new TableNameReplacer(manager); return null; // return tableNameReplacer.run(statement); }
@BeforeClass public static void startServer() throws Exception { Thread.sleep(1000); // LOG = LoggerFactory.getLogger(BaseTest.class); // manager = DDFManager.get("spark"); /* manager = DDFManager.get("jdbc", new JDBCDataSourceDescriptor(new DataSourceURI("jdbc:mysql://localhost/testdb"), new JDBCDataSourceDescriptor.JDBCDataSourceCredentials("pauser", "papwd"), null)); DataSourceDescriptor ds = manager.getDataSourceDescriptor(); if (ds instanceof JDBCDataSourceDescriptor) { System.out.println("hello"); } DDF ret = manager.sql2ddf("select * from testtable", "jdbc");*/ // Add 2 test ddfs. manager = DDFManager.get(DDFManager.EngineType.SPARK); parser = new CCJSqlParserManager(); }
public static String name_select_where(String sql) throws JSQLParserException { CCJSqlParserManager parserManager = new CCJSqlParserManager(); Select select = (Select) parserManager.parse(new StringReader(sql)); PlainSelect plain = (PlainSelect) select.getSelectBody(); Expression where_expression = plain.getWhere(); if (where_expression == null) return ""; String str = where_expression.toString(); return str; }
@Test public void testAlias() { TableNameReplacer tableNameReplacer = new TableNameReplacer(manager); String sqlcmd = "select T0.id from (select tmp.id from ddf://adatao/a" + " " + "tmp) T0"; try { Statement statement = parser.parse(new StringReader(sqlcmd)); // statement = tableNameReplacer.run(statement); // System.out.println(statement.toString()); } catch (JSQLParserException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } }
Object[] parameters = hqlFormat.evaluateOgnlExpressions(rootObject); CCJSqlParserManager parserManager = new CCJSqlParserManager(); PlainSelect parsedQueryString; PlainSelect parsedCriteriaQuery;
public static SelectBody parse(String selectStatement)throws IOException{ CCJSqlParserManager pm = new CCJSqlParserManager(); Reader reader = new StringReader(selectStatement); Statement statement; try { statement = pm.parse(reader); } catch (Exception e) { throw new DataSourceException("parsing select statement: " + e.getCause().getMessage(), e); } if(!(statement instanceof Select)){ //either PlainSelect or Union throw new IllegalArgumentException("expected select or union statement: " + statement); } SelectBody selectBody = ((Select)statement).getSelectBody(); return selectBody; } }
@Test public void testUnion() { TableNameReplacer tableNameReplacer = new TableNameReplacer(manager); String sqlcmd = "select * from ddf://adatao/a union select * from " + "ddf://adatao/b"; try { Statement statement = parser.parse(new StringReader(sqlcmd)); // System.out.println(statement.toString()); int a = 2; } catch (JSQLParserException e) { e.printStackTrace(); } }
Object[] parameters = hqlFormat.evaluateOgnlExpressions(rootObject); CCJSqlParserManager parserManager = new CCJSqlParserManager(); PlainSelect parsedQueryString; PlainSelect parsedCriteriaQuery;
public static PlainSelect parseSqlQuery(String selectStatement) throws IOException { CCJSqlParserManager pm = new CCJSqlParserManager(); Reader reader = new StringReader(selectStatement); Statement statement; try { statement = pm.parse(reader); } catch (Exception e) { throw new DataSourceException("parsing select statement: " + e.getCause().getMessage(), e); } if (!(statement instanceof Select)) { // either PlainSelect or Union throw new IllegalArgumentException("expected select or union statement: " + statement); } SelectBody selectBody = ((Select) statement).getSelectBody(); if (selectBody instanceof Union) { // dataStore.registerView(typeName, (Union) selectBody); throw new UnsupportedOperationException( "ArcSDEDataStore does not supports registering Union queries"); } else if (selectBody instanceof PlainSelect) { return (PlainSelect) selectBody; } else { throw new IllegalStateException(selectBody.getClass().getName()); } } }
System.arraycopy(ognlParameters, 0, parameters, 0, p); try { PlainSelect parsedQuery = parseQuery(new CCJSqlParserManager(), formatString); if(parsedQuery.getWhere() == null) { return getObjectByPk(persistence, database, entityName, pk);
import java.io.StringReader; import net.sf.jsqlparser.JSQLParserException; import net.sf.jsqlparser.expression.Function; import net.sf.jsqlparser.parser.CCJSqlParserManager; import net.sf.jsqlparser.statement.select.PlainSelect; import net.sf.jsqlparser.statement.select.Select; import net.sf.jsqlparser.statement.select.SelectExpressionItem; public class MySQLParser { CCJSqlParserManager parserManager = new CCJSqlParserManager(); public MySQLParser() throws JSQLParserException { String statement = "SELECT COUNT(*) FROM db.table1"; PlainSelect plainSelect = (PlainSelect) ((Select) parserManager.parse(new StringReader(statement))).getSelectBody(); System.out.format("%s is function call? %s", plainSelect.getSelectItems().get(0), ((Function)((SelectExpressionItem) plainSelect.getSelectItems().get(0)).getExpression()).isAllColumns()); } public static void main(String[] args) throws JSQLParserException { new MySQLParser(); } }
System.arraycopy(ognlParameters, 0, parameters, 0, p); try { PlainSelect parsedQuery = parseQuery(new CCJSqlParserManager(), formatString); if(parsedQuery.getWhere() == null) { return getObjectByPk(persistence, database, entityName, pk);