public void setFrom(SQLSelectQueryBlock queryBlock, String alias) { if (queryBlock == null) { this.from = null; return; } this.setFrom(new SQLSelect(queryBlock), alias); }
public void setFrom(SQLSelect select, String alias) { if (select == null) { this.from = null; return; } SQLSubqueryTableSource from = new SQLSubqueryTableSource(select); from.setAlias(alias); this.setFrom(from); }
public void parseFrom(SQLSelectQueryBlock queryBlock) { if (lexer.token != Token.FROM) { return; } lexer.nextToken(); queryBlock.setFrom( parseTableSource()); }
public void setFrom(String tableName, String alias) { SQLExprTableSource from; if (tableName == null || tableName.length() == 0) { from = null; } else { from = new SQLExprTableSource(new SQLIdentifierExpr(tableName), alias); } this.setFrom(from); }
@Override public SQLSelectBuilderImpl from(String table, String alias) { SQLSelectQueryBlock queryBlock = getQueryBlock(); SQLExprTableSource from = new SQLExprTableSource(new SQLIdentifierExpr(table), alias); queryBlock.setFrom(from); return this; }
private static String createCountUseSubQuery(SQLSelect select, String dbType) { SQLSelectQueryBlock countSelectQuery = createQueryBlock(dbType); SQLSelectItem countItem = createCountItem(dbType); countSelectQuery.getSelectList().add(countItem); SQLSubqueryTableSource fromSubquery = new SQLSubqueryTableSource(select); fromSubquery.setAlias("ALIAS_COUNT"); countSelectQuery.setFrom(fromSubquery); SQLSelect countSelect = new SQLSelect(countSelectQuery); SQLSelectStatement countStmt = new SQLSelectStatement(countSelect, dbType); return SQLUtils.toSQLString(countStmt, dbType); }
public static SQLSelectQueryBlock transformOracleToPostgresql(SQLSelectQueryBlock x) { if (x instanceof OracleSelectQueryBlock) { OracleSelectQueryBlock xx = (OracleSelectQueryBlock) x; SQLSelectQueryBlock y = new SQLSelectQueryBlock(); xx.cloneTo(y); y.setFrom(transformOracleToPostgresql(y.getFrom())); y.setParent(x.getParent()); return y; } return x; } }
public boolean addWhere(SQLExpr where) { if (where == null) { return false; } if (query instanceof SQLSelectQueryBlock) { ((SQLSelectQueryBlock) query).addWhere(where); return true; } if (query instanceof SQLUnionQuery) { SQLSelectQueryBlock queryBlock = new SQLSelectQueryBlock(); queryBlock.setFrom(new SQLSelect(query), "u"); queryBlock.addSelectItem(new SQLAllColumnExpr()); queryBlock.setParent(queryBlock); query = queryBlock; return true; } return false; } }
public void parseFrom(SQLSelectQueryBlock queryBlock) { if (lexer.token() != Token.FROM) { return; } lexer.nextTokenIdent(); if (lexer.token() == Token.UPDATE) { // taobao returning to urgly syntax updateStmt = this.parseUpdateStatment(); List<SQLExpr> returnning = updateStmt.getReturning(); for (SQLSelectItem item : queryBlock.getSelectList()) { SQLExpr itemExpr = item.getExpr(); itemExpr.setParent(updateStmt); returnning.add(itemExpr); } returningFlag = true; return; } queryBlock.setFrom(parseTableSource()); }
public boolean visit(SQLSubqueryTableSource x) { String subViewName = generateSubViewName(); SQLObject parent = x.getParent(); if(parent instanceof SQLSelectQueryBlock) { SQLSelectQueryBlock queryBlock = (SQLSelectQueryBlock) parent; queryBlock.setFrom(subViewName, x.getAlias()); } else if(parent instanceof SQLJoinTableSource) { SQLJoinTableSource join = (SQLJoinTableSource) parent; if (join.getLeft() == x) { join.setLeft(subViewName, x.getAlias()); } else if (join.getRight() == x) { join.setRight(subViewName, x.getAlias()); } } SQLCreateViewStatement stmt = new SQLCreateViewStatement(); stmt.setName(generateSubViewName()); SQLSelect select = x.getSelect(); stmt.setSubQuery(select); targetList.add(0, stmt); stmt.accept(new FromSubqueryResolver(targetList, viewName)); return false; }
public void setFrom(SQLSelectQueryBlock queryBlock, String alias) { if (queryBlock == null) { this.from = null; return; } this.setFrom(new SQLSelect(queryBlock), alias); }
x.setFrom(from.clone());
public void setFrom(SQLSelect select, String alias) { if (select == null) { this.from = null; return; } SQLSubqueryTableSource from = new SQLSubqueryTableSource(select); from.setAlias(alias); this.setFrom(from); }
public void parseFrom(SQLSelectQueryBlock queryBlock) { if (lexer.token != Token.FROM) { return; } lexer.nextToken(); queryBlock.setFrom( parseTableSource()); }
public void setFrom(String tableName, String alias) { SQLExprTableSource from; if (tableName == null || tableName.length() == 0) { from = null; } else { from = new SQLExprTableSource(new SQLIdentifierExpr(tableName), alias); } this.setFrom(from); }
@Override public SQLSelectBuilderImpl from(String table, String alias) { SQLSelectQueryBlock queryBlock = getQueryBlock(); SQLExprTableSource from = new SQLExprTableSource(new SQLIdentifierExpr(table), alias); queryBlock.setFrom(from); return this; }
private static String createCountUseSubQuery(SQLSelect select, String dbType) { SQLSelectQueryBlock countSelectQuery = createQueryBlock(dbType); SQLSelectItem countItem = createCountItem(dbType); countSelectQuery.getSelectList().add(countItem); SQLSubqueryTableSource fromSubquery = new SQLSubqueryTableSource(select); fromSubquery.setAlias("ALIAS_COUNT"); countSelectQuery.setFrom(fromSubquery); SQLSelect countSelect = new SQLSelect(countSelectQuery); SQLSelectStatement countStmt = new SQLSelectStatement(countSelect, dbType); return SQLUtils.toSQLString(countStmt, dbType); }
public static SQLSelectQueryBlock transformOracleToPostgresql(SQLSelectQueryBlock x) { if (x instanceof OracleSelectQueryBlock) { OracleSelectQueryBlock xx = (OracleSelectQueryBlock) x; SQLSelectQueryBlock y = new SQLSelectQueryBlock(); xx.cloneTo(y); y.setFrom(transformOracleToPostgresql(y.getFrom())); y.setParent(x.getParent()); return y; } return x; } }
public boolean addWhere(SQLExpr where) { if (where == null) { return false; } if (query instanceof SQLSelectQueryBlock) { ((SQLSelectQueryBlock) query).addWhere(where); return true; } if (query instanceof SQLUnionQuery) { SQLSelectQueryBlock queryBlock = new SQLSelectQueryBlock(); queryBlock.setFrom(new SQLSelect(query), "u"); queryBlock.addSelectItem(new SQLAllColumnExpr()); queryBlock.setParent(queryBlock); query = queryBlock; return true; } return false; } }
public void parseFrom(SQLSelectQueryBlock queryBlock) { if (lexer.token() != Token.FROM) { return; } lexer.nextTokenIdent(); if (lexer.token() == Token.UPDATE) { // taobao returning to urgly syntax updateStmt = this.parseUpdateStatment(); List<SQLExpr> returnning = updateStmt.getReturning(); for (SQLSelectItem item : queryBlock.getSelectList()) { SQLExpr itemExpr = item.getExpr(); itemExpr.setParent(updateStmt); returnning.add(itemExpr); } returningFlag = true; return; } queryBlock.setFrom(parseTableSource()); }