public JoinFromBuilderImpl(Query query, FromItem leftItem, Table rightTable, JoinType joinType, DataContext dataContext) { super(query, dataContext); this.joinType = joinType; this.leftItem = leftItem; this.rightItem = new FromItem(rightTable); }
public JoinFromBuilderImpl(Query query, FromItem leftItem, Table rightTable, JoinType joinType, DataContext dataContext) { super(query, dataContext); this.joinType = joinType; this.leftItem = leftItem; this.rightItem = new FromItem(rightTable); }
public Query from(Table leftTable, Table rightTable, JoinType joinType, Column leftOnColumn, Column rightOnColumn) { SelectItem[] leftOn = new SelectItem[] { new SelectItem(leftOnColumn) }; SelectItem[] rightOn = new SelectItem[] { new SelectItem(rightOnColumn) }; FromItem fromItem = new FromItem(joinType, new FromItem(leftTable), new FromItem(rightTable), leftOn, rightOn); return from(fromItem); }
public Query from(Table leftTable, Table rightTable, JoinType joinType, Column leftOnColumn, Column rightOnColumn) { SelectItem[] leftOn = new SelectItem[] { new SelectItem(leftOnColumn) }; SelectItem[] rightOn = new SelectItem[] { new SelectItem(rightOnColumn) }; FromItem fromItem = new FromItem(joinType, new FromItem(leftTable), new FromItem(rightTable), leftOn, rightOn); return from(fromItem); }
public TableFromBuilderImpl(Table table, Query query, DataContext dataContext) { super(query, dataContext); fromItem = new FromItem(table); query.from(fromItem); }
public TableFromBuilderImpl(Table table, Query query, DataContext dataContext) { super(query, dataContext); fromItem = new FromItem(table); query.from(fromItem); }
public Query from(String expression) { return from(new FromItem(expression)); }
public Query from(String expression) { return from(new FromItem(expression)); }
public Query from(Table table) { return from(new FromItem(table)); }
public Query from(Table table) { return from(new FromItem(table)); }
protected String createSqlStatement() { StringBuilder sb = new StringBuilder(); sb.append("DELETE FROM "); sb.append(_queryRewriter.rewriteFromItem(new FromItem(getTable()))); sb.append(JdbcUtils.createWhereClause(getWhereItems(), _queryRewriter, _inlineValues)); return sb.toString(); }
protected String createSqlStatement() { StringBuilder sb = new StringBuilder(); sb.append("DELETE FROM "); sb.append(_queryRewriter.rewriteFromItem(new FromItem(getTable()))); sb.append(JdbcUtils.createWhereClause(getWhereItems(), _queryRewriter, _inlineValues)); return sb.toString(); }
protected String createSqlStatement() { FromItem fromItem = new FromItem(getTable()); String tableLabel = _queryRewriter.rewriteFromItem(fromItem); return "DROP TABLE " + tableLabel; }
protected String createSqlStatement() { FromItem fromItem = new FromItem(getTable()); String tableLabel = _queryRewriter.rewriteFromItem(fromItem); return "DROP TABLE " + tableLabel; }
public Query from(Table table, String alias) { return from(new FromItem(table).setAlias(alias)); }
public Query from(Table table, String alias) { return from(new FromItem(table).setAlias(alias)); }
@Override public SatisfiedFromBuilder on(Column left, Column right) throws IllegalArgumentException { if (left == null) { throw new IllegalArgumentException("left cannot be null"); } if (right == null) { throw new IllegalArgumentException("right cannot be null"); } getQuery().getFromClause().removeItem(leftItem); SelectItem[] leftOn = new SelectItem[] { new SelectItem(left) }; SelectItem[] rightOn = new SelectItem[] { new SelectItem(right) }; FromItem fromItem = new FromItem(joinType, leftItem, rightItem, leftOn, rightOn); getQuery().from(fromItem); return this; }
private long getRowCount(Query q) { q = q.clone(); SelectItem countAllItem = SelectItem.getCountAllItem(); if (q.getGroupByClause().getItemCount() > 0) { q = new Query().from(new FromItem(q).setAlias("sq")).select(countAllItem); } else { q.getSelectClause().removeItems(); q.select(countAllItem); } Row row = MetaModelHelper.executeSingleRowQuery(_dataContext, q); Number count = (Number) row.getValue(countAllItem); return count.longValue(); }
private long getRowCount(Query q) { q = q.clone(); SelectItem countAllItem = SelectItem.getCountAllItem(); if (q.getGroupByClause().getItemCount() > 0) { q = new Query().from(new FromItem(q).setAlias("sq")).select(countAllItem); } else { q.getSelectClause().removeItems(); q.select(countAllItem); } Row row = MetaModelHelper.executeSingleRowQuery(_dataContext, q); Number count = (Number) row.getValue(countAllItem); return count.longValue(); }
private void replaceParametersInFromClause(Object[] values, AtomicInteger parameterIndex, Query originalQuery, Query newQuery) { final List<FromItem> fromItems = originalQuery.getFromClause().getItems(); int i = 0; for (FromItem fromItem : fromItems) { final Query subQuery = fromItem.getSubQuery(); if (subQuery != null) { final Query newSubQuery = newQuery.getFromClause().getItem(i).getSubQuery(); replaceParametersInQuery(values, parameterIndex, subQuery, newSubQuery); newQuery.getFromClause().removeItem(i); newQuery.getFromClause().addItem(i, new FromItem(newSubQuery).setAlias(fromItem.getAlias())); } i++; } }