public Query orderBy(Column column, Direction direction) { SelectItem selectItem = _selectClause.getSelectItem(column); if (selectItem == null) { selectItem = new SelectItem(column); } return orderBy(new OrderByItem(selectItem, direction)); }
private void buildParameterListInFromClause(List<QueryParameter> parameters, Query query) { List<FromItem> fromItems = query.getFromClause().getItems(); for (FromItem fromItem : fromItems) { Query subQuery = fromItem.getSubQuery(); if (subQuery != null) { buildParameterListInFromClause(parameters, subQuery); buildParameterListInWhereClause(parameters, subQuery); } } }
public Query having(Column column, OperatorType operatorType, Object operand) { SelectItem selectItem = _selectClause.getSelectItem(column); if (selectItem == null) { selectItem = new SelectItem(column); } return having(new FilterItem(selectItem, operatorType, operand)); }
public Query groupBy(Column... columns) { for (Column column : columns) { SelectItem selectItem = new SelectItem(column).setQuery(this); _groupByClause.addItem(new GroupByItem(selectItem)); } return this; }
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 SatisfiedOrderByBuilderImpl(Column column, Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); orderByitem = new OrderByItem(new SelectItem(column)); query.orderBy(orderByitem); }
public Query where(Column column, OperatorType operatorType, Object operand) { SelectItem selectItem = _selectClause.getSelectItem(column); if (selectItem == null) { selectItem = new SelectItem(column); } return where(selectItem, operatorType, operand); }
private void buildParameterListInWhereClause(List<QueryParameter> parameters, Query query) { List<FilterItem> items = query.getWhereClause().getItems(); for (FilterItem item : items) { buildParameterFromFilterItem(parameters, item); } }
public Query() { _selectClause = new SelectClause(this); _fromClause = new FromClause(this); _whereClause = new FilterClause(this, AbstractQueryClause.PREFIX_WHERE); _groupByClause = new GroupByClause(this); _havingClause = new FilterClause(this, AbstractQueryClause.PREFIX_HAVING); _orderByClause = new OrderByClause(this); }
public Query groupBy(GroupByItem... items) { for (GroupByItem item : items) { SelectItem selectItem = item.getSelectItem(); if (selectItem != null && selectItem.getQuery() == null) { selectItem.setQuery(this); } } _groupByClause.addItems(items); return this; }
@Override protected GroupByItem clone() { GroupByItem g = new GroupByItem(_selectItem.clone()); return g; }
public Query groupBy(List<Column> columns) { for (Column column : columns) { SelectItem selectItem = new SelectItem(column).setQuery(this); _groupByClause.addItem(new GroupByItem(selectItem)); } return this; }
public SatisfiedOrderByBuilderImpl(Column column, Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); orderByitem = new OrderByItem(new SelectItem(column)); query.orderBy(orderByitem); }
public Query where(Column column, OperatorType operatorType, Object operand) { SelectItem selectItem = _selectClause.getSelectItem(column); if (selectItem == null) { selectItem = new SelectItem(column); } return where(selectItem, operatorType, operand); }
public Query orderBy(Column column, Direction direction) { SelectItem selectItem = _selectClause.getSelectItem(column); if (selectItem == null) { selectItem = new SelectItem(column); } return orderBy(new OrderByItem(selectItem, direction)); }
private void buildParameterListInFromClause(List<QueryParameter> parameters, Query query) { List<FromItem> fromItems = query.getFromClause().getItems(); for (FromItem fromItem : fromItems) { Query subQuery = fromItem.getSubQuery(); if (subQuery != null) { buildParameterListInFromClause(parameters, subQuery); buildParameterListInWhereClause(parameters, subQuery); } } }
public Query() { _selectClause = new SelectClause(this); _fromClause = new FromClause(this); _whereClause = new FilterClause(this, AbstractQueryClause.PREFIX_WHERE); _groupByClause = new GroupByClause(this); _havingClause = new FilterClause(this, AbstractQueryClause.PREFIX_HAVING); _orderByClause = new OrderByClause(this); }
public Query groupBy(Column... columns) { for (Column column : columns) { SelectItem selectItem = new SelectItem(column).setQuery(this); _groupByClause.addItem(new GroupByItem(selectItem)); } return this; }
public SatisfiedOrderByBuilderImpl(FunctionType function, Column column, Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); orderByitem = new OrderByItem(new SelectItem(function, column)); query.orderBy(orderByitem); }
public Query groupBy(List<Column> columns) { for (Column column : columns) { SelectItem selectItem = new SelectItem(column).setQuery(this); _groupByClause.addItem(new GroupByItem(selectItem)); } return this; }