public SQLSubqueryTableSource(SQLSelectQuery query){ this(new SQLSelect(query)); }
protected SQLSelect createSelect() { return new SQLSelect(); }
public void setFrom(SQLSelectQueryBlock queryBlock, String alias) { if (queryBlock == null) { this.from = null; return; } this.setFrom(new SQLSelect(queryBlock), alias); }
public void setQuery(SQLSelectQuery query) { this.setQuery(new SQLSelect(query)); }
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 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 SQLSelect clone() { SQLSelect x = new SQLSelect();
public void parseStatementList(List<SQLStatement> statementList, int max, SQLObject parent) { if ("select @@session.tx_read_only".equals(lexer.text) && lexer.token == Token.SELECT) { SQLSelect select = new SQLSelect(); MySqlSelectQueryBlock queryBlock = new MySqlSelectQueryBlock(); queryBlock.addSelectItem(new SQLPropertyExpr(new SQLVariantRefExpr("@@session"), "tx_read_only"));
public SQLSelect select() { SQLSelect select = new SQLSelect(); if (lexer.token == Token.WITH) { SQLWithSubqueryClause with = this.parseWith(); select.setWithSubQuery(with); } SQLSelectQuery query = query(); select.setQuery(query); SQLOrderBy orderBy = this.parseOrderBy(); if (query instanceof SQLSelectQueryBlock) { SQLSelectQueryBlock queryBlock = (SQLSelectQueryBlock) query; if (queryBlock.getOrderBy() == null) { queryBlock.setOrderBy(orderBy); } else { select.setOrderBy(orderBy); } if (orderBy != null) { parseFetchClause(queryBlock); } } else { select.setOrderBy(orderBy); } while (lexer.token == Token.HINT) { this.exprParser.parseHints(select.getHints()); } return select; }
public SQLSubqueryTableSource(SQLSelectQuery query){ this(new SQLSelect(query)); }
protected SQLSelect createSelect() { return new SQLSelect(); }
offsetQueryBlock.setFrom(new SQLSubqueryTableSource(new SQLSelect(countQueryBlock), "XXX")); offsetQueryBlock.setWhere(pageCondition);
offsetQueryBlock.setFrom(new SQLSubqueryTableSource(new SQLSelect(countQueryBlock), "XXX")); offsetQueryBlock.setWhere(new SQLBinaryOpExpr(new SQLIdentifierExpr("RN"), //
offsetQueryBlock.setFrom(new SQLSubqueryTableSource(new SQLSelect(countQueryBlock), "XXX")); offsetQueryBlock.setWhere(pageCondition);
public void setFrom(SQLSelectQueryBlock queryBlock, String alias) { if (queryBlock == null) { this.from = null; return; } this.setFrom(new SQLSelect(queryBlock), alias); }
public void setQuery(SQLSelectQuery query) { this.setQuery(new SQLSelect(query)); }
public SQLSelect select() { SQLSelect select = new SQLSelect();
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 SQLSelect select() { SQLSelect select = new SQLSelect();
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; } }