CCJSqlParserManager pm = new CCJSqlParserManager();
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()); } } }
/** * 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 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; }
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; } }
CCJSqlParserManager pm = new CCJSqlParserManager();
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()); } } }
CCJSqlParserManager pm = new CCJSqlParserManager(); List<String> columnNames = new ArrayList<String>();
/** * @param aQuery * @return True if query is select query. * @throws Exception */ public boolean putTableFieldsMetadata(SqlQuery aQuery) throws Exception { CCJSqlParserManager parserManager = new CCJSqlParserManager(); try { Statement parsedQuery = parserManager.parse(new StringReader(aQuery.getSqlText())); if (parsedQuery instanceof Select) { Select select = (Select) parsedQuery; resolveOutputFieldsFromTables(aQuery, select.getSelectBody()); return true; } } catch (JSQLParserException ex) { if (aQuery.isProcedure()) { Logger.getLogger(StoredQueryFactory.class.getName()).log(Level.WARNING, ex.getMessage()); } else { throw ex; } } return false; }
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(); } }
@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(); }
protected String generateCountQuery(String queryString) throws JSQLParserException { CCJSqlParserManager parserManager = new CCJSqlParserManager(); try { PlainSelect plainSelect = (PlainSelect) ((Select) parserManager.parse(new StringReader(queryString))).getSelectBody(); logger.debug("Query string {} contains select"); List items = plainSelect.getSelectItems(); if(items.size() != 1) { logger.error("I don't know how to generate a count query for {}", queryString); return null; } SelectExpressionItem item = (SelectExpressionItem) items.get(0); Function function = new Function(); function.setName("count"); function.setParameters(new ExpressionList(Arrays.asList(item.getExpression()))); item.setExpression(function); plainSelect.setOrderByElements(null); return plainSelect.toString(); } catch(Exception e) { logger.debug("Query string {} does not contain select", e); queryString = "SELECT count(*) " + queryString; PlainSelect plainSelect = (PlainSelect) ((Select) parserManager.parse(new StringReader(queryString))).getSelectBody(); plainSelect.setOrderByElements(null); return plainSelect.toString(); } }
protected String generateCountQuery(String queryString) throws JSQLParserException { CCJSqlParserManager parserManager = new CCJSqlParserManager(); try { PlainSelect plainSelect = (PlainSelect) ((Select) parserManager.parse(new StringReader(queryString))).getSelectBody(); logger.debug("Query string {} contains select"); List items = plainSelect.getSelectItems(); if(items.size() != 1) { logger.error("I don't know how to generate a count query for {}", queryString); return null; } SelectExpressionItem item = (SelectExpressionItem) items.get(0); Function function = new Function(); function.setName("count"); function.setParameters(new ExpressionList(Arrays.asList(item.getExpression()))); item.setExpression(function); plainSelect.setOrderByElements(null); return plainSelect.toString(); } catch(Exception e) { logger.debug("Query string {} does not contain select", e); queryString = "SELECT count(*) " + queryString; PlainSelect plainSelect = (PlainSelect) ((Select) parserManager.parse(new StringReader(queryString))).getSelectBody(); plainSelect.setOrderByElements(null); return plainSelect.toString(); } }
CCJSqlParserManager parserManager = new CCJSqlParserManager(); StringReader reader = new StringReader(command); try {
CCJSqlParserManager pm = new CCJSqlParserManager(); net.sf.jsqlparser.statement.Statement statement = pm.parse(new StringReader(sqlWithCTEs)); if (statement instanceof Select) {
CCJSqlParserManager parserManager = new CCJSqlParserManager(); StringReader reader = new StringReader(sqlcmd); try {
Object[] parameters = hqlFormat.evaluateOgnlExpressions(rootObject); CCJSqlParserManager parserManager = new CCJSqlParserManager(); PlainSelect parsedQueryString; PlainSelect parsedCriteriaQuery;
Object[] parameters = hqlFormat.evaluateOgnlExpressions(rootObject); CCJSqlParserManager parserManager = new CCJSqlParserManager(); PlainSelect parsedQueryString; PlainSelect parsedCriteriaQuery;
System.arraycopy(ognlParameters, 0, parameters, 0, p); try { PlainSelect parsedQuery = parseQuery(new CCJSqlParserManager(), formatString); if(parsedQuery.getWhere() == null) { return getObjectByPk(persistence, database, entityName, pk);
System.arraycopy(ognlParameters, 0, parameters, 0, p); try { PlainSelect parsedQuery = parseQuery(new CCJSqlParserManager(), formatString); if(parsedQuery.getWhere() == null) { return getObjectByPk(persistence, database, entityName, pk);