/** * Adds a selection to this query. * * @param expression * @return */ public Query select(String expression) { return select(expression, false); }
/** * Adds a selection to this query. * * @param expression * @return */ public Query select(String expression) { return select(expression, false); }
@Override public SatisfiedSelectBuilder<GroupedQueryBuilder> select(Column... columns) { if (columns == null) { throw new IllegalArgumentException("column cannot be null"); } _query.select(columns); return new SatisfiedSelectBuilderImpl(this); }
public FunctionSelectBuilderImpl(FunctionType functionType, Column column, Object[] functionParameters, Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); this.selectItem = new SelectItem(functionType, functionParameters, column); query.select(selectItem); }
public CountSelectBuilderImpl(Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); this.selectItem = SelectItem.getCountAllItem(); query.select(selectItem); }
public FunctionSelectBuilderImpl(FunctionType functionType, Column column, Object[] functionParameters, Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); this.selectItem = new SelectItem(functionType, functionParameters, column); query.select(selectItem); }
public ColumnSelectBuilderImpl(Column column, Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); this.selectItem = new SelectItem(column); query.select(selectItem); }
public CountSelectBuilderImpl(Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); this.selectItem = SelectItem.getCountAllItem(); query.select(selectItem); }
@Override public SatisfiedSelectBuilder<GroupedQueryBuilder> select(Column... columns) { if (columns == null) { throw new IllegalArgumentException("column cannot be null"); } _query.select(columns); return new SatisfiedSelectBuilderImpl(this); }
public ColumnSelectBuilderImpl(Column column, Query query, GroupedQueryBuilder queryBuilder) { super(queryBuilder); this.selectItem = new SelectItem(column); query.select(selectItem); }
public Query select(Column column, FromItem fromItem) { SelectItem selectItem = new SelectItem(column, fromItem); return select(selectItem); }
@Override public SatisfiedSelectBuilder<?> select(Column... columns) { if (columns == null) { throw new IllegalArgumentException("columns cannot be null"); } query.select(columns); GroupedQueryBuilder queryBuilder = new GroupedQueryBuilderImpl(dataContext, query); return new SatisfiedSelectBuilderImpl(queryBuilder); }
@Override public SatisfiedSelectBuilder<?> select(String selectExpression, boolean allowExpressionBasedSelectItem) { if (selectExpression == null) { throw new IllegalArgumentException("selectExpression cannot be null"); } query.select(selectExpression, allowExpressionBasedSelectItem); final GroupedQueryBuilder queryBuilder = new GroupedQueryBuilderImpl(dataContext, query); return new SatisfiedSelectBuilderImpl(queryBuilder); }
@Override public SatisfiedSelectBuilder<?> select(Column... columns) { if (columns == null) { throw new IllegalArgumentException("columns cannot be null"); } query.select(columns); GroupedQueryBuilder queryBuilder = new GroupedQueryBuilderImpl(dataContext, query); return new SatisfiedSelectBuilderImpl(queryBuilder); }
@Override public SatisfiedSelectBuilder<?> select(String selectExpression, boolean allowExpressionBasedSelectItem) { if (selectExpression == null) { throw new IllegalArgumentException("selectExpression cannot be null"); } query.select(selectExpression, allowExpressionBasedSelectItem); final GroupedQueryBuilder queryBuilder = new GroupedQueryBuilderImpl(dataContext, query); return new SatisfiedSelectBuilderImpl(queryBuilder); }
@Override protected DataSet materializeMainSchemaTable(Table table, List<Column> columns, int maxRows) { // find the appropriate datacontext to execute a simple // table materialization query final DataContext dc = _dataContextRetrievalFunction.apply(table); final Query q = new Query().select(columns).from(table); if (maxRows >= 0) { q.setMaxRows(maxRows); } return dc.executeQuery(q); }
@Override protected DataSet materializeMainSchemaTable(Table table, List<Column> columns, int maxRows) { // find the appropriate datacontext to execute a simple // table materialization query final DataContext dc = _dataContextRetrievalFunction.apply(table); final Query q = new Query().select(columns).from(table); if (maxRows >= 0) { q.setMaxRows(maxRows); } return dc.executeQuery(q); }
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(); }
@Override protected RowProcessingQueryOptimizer getQueryOptimizer() { final Table table = getStream().getTable(); final Query q = new Query().from(table).select(table.getColumns()); return new NoopRowProcessingQueryOptimizer(q, getConsumersSorted()); } }