SelectQuery q = factory.selectQuery(); q.addSelect(Table1.TABLE1.fields()); q.addSelect(Table1.ID.count().as("IdCount")); q.addFrom(Table1.TABLE1);
Factory create = new Factory(connection, dialect); SelectQuery query = create.selectQuery(); query.addFrom(AUTHOR); // Join books only under certain circumstances if (join) { query.addJoin(BOOK, BOOK.AUTHOR_ID.equal(AUTHOR.ID)); } Result<?> result = query.fetch();
SelectQuery select = DSL.using(configuration).selectQuery(); select.addFrom(CAR);
@Override public final SelectImpl from(Collection<? extends TableLike<?>> tables) { getQuery().addFrom(tables); return this; }
@Override public final SelectImpl from(Collection<? extends TableLike<?>> tables) { getQuery().addFrom(tables); return this; }
@Override public final SelectImpl from(TableLike<?> table) { getQuery().addFrom(table); return this; }
@Override public final SelectImpl from(TableLike<?>... tables) { getQuery().addFrom(tables); return this; }
@Override public final SelectImpl from(TableLike<?>... tables) { getQuery().addFrom(tables); return this; }
SelectQuery selectQuery = create.selectQuery(); selectQuery.addSelect(selectFields); selectQuery.addFrom(leftTable); selectQuery.addJoin(rightTable, joinCondition);
/** * Create Select statement * @param table to select from * @param fields optional fields and aggregates * @return select step */ public SelectQuery createSelectFrom(Table table, Field ... fields) { // get Postgres context DSLContext context = PostgresDSL.using(SQL_DIALECT); // create select query and optionally add specified fields SelectQuery<?> select = context.selectQuery(); if (fields.length > 0) select.addSelect(fields); // from table select.addFrom(table); return select; }
/** * Create Select statement * @param table to select from * @param fields optional fields and aggregates * @return select step */ public SelectQuery createSelectFrom(Table table, Field ... fields) { // get Postgres context DSLContext context = PostgresDSL.using(SQL_DIALECT); // create select query and optionally add specified fields SelectQuery<?> select = context.selectQuery(); if (fields.length > 0) select.addSelect(fields); // from table select.addFrom(table); return select; }
/** * Create Select statement * @param table to select from * @param fields optional fields and aggregates * @return select step */ public SelectQuery createSelectFrom(Table table, Field ... fields) { // get Postgres context DSLContext context = PostgresDSL.using(SQL_DIALECT); // create select query and optionally add specified fields SelectQuery<?> select = context.selectQuery(); if (fields.length > 0) select.addSelect(fields); // from table select.addFrom(table); return select; }
protected MultiTableMapper addTables(SchemaFactory schemaFactory, SelectQuery<?> query, String type, Table<?> table, Map<Object, Object> criteria, Include include, Pagination pagination, Map<Table<?>, Condition> joins) { if ((joins == null || joins.size() == 0) && (include == null || include.getLinks().size() == 0)) { query.addFrom(table); return null; query.addFrom(table); return tableMapper; query.addFrom(table);
query.addFrom(ACCOUNT); query.addJoin(PROJECT_MEMBER, PROJECT_MEMBER.PROJECT_ID.equal(ACCOUNT.ID)); query.addConditions(allMembers);
@Override public final void refresh(final Field<?>... refreshFields) { SelectQuery<Record> select = create().selectQuery(); select.addSelect(refreshFields); select.addFrom(getTable()); Tools.addConditions(select, this, getPrimaryKey().getFieldsArray()); if (select.execute() == 1) { final AbstractRecord source = (AbstractRecord) select.getResult().get(0); delegate(configuration(), (Record) this, REFRESH) .operate(new RecordOperation<Record, RuntimeException>() { @Override public Record operate(Record record) throws RuntimeException { setValues(refreshFields, source); return record; } }); } else { throw new NoDataFoundException("Exactly one row expected for refresh. Record does not exist in database."); } }
@Override public final void refresh(final Field<?>... f) { SelectQuery<Record> select = create().selectQuery(); select.addSelect(f); select.addFrom(getTable()); Utils.addConditions(select, this, getPrimaryKey().getFieldsArray()); if (select.execute() == 1) { final AbstractRecord source = (AbstractRecord) select.getResult().get(0); delegate(configuration(), (Record) this, REFRESH) .operate(new RecordOperation<Record, RuntimeException>() { @Override public Record operate(Record record) throws RuntimeException { setValues(f, source); return record; } }); } else { throw new InvalidResultException("Exactly one row expected for refresh. Record does not exist in database."); } }
@Override public List<? extends ProjectMember> getProjectMembersByIdentity(long projectId, Set<Identity> identities) { Condition allMembers = DSL.falseCondition(); for (Identity identity : identities) { allMembers = allMembers.or(PROJECT_MEMBER.EXTERNAL_ID.eq(identity.getExternalId()) .and(PROJECT_MEMBER.EXTERNAL_ID_TYPE.eq(identity.getExternalIdType())) .and(PROJECT_MEMBER.REMOVED.isNull()) .and(PROJECT_MEMBER.STATE.eq(CommonStatesConstants.ACTIVE)) .and(PROJECT_MEMBER.PROJECT_ID.eq(projectId))); } SelectQuery<Record> query = create().selectQuery(); query.addFrom(PROJECT_MEMBER); query.addConditions(allMembers); query.setDistinct(true); return query.fetchInto(PROJECT_MEMBER); }
@SuppressWarnings("unchecked") @Override protected <T> List<T> getListByRelationshipMap(Object obj, MapRelationship rel) { Class<UpdatableRecord<?>> typeClass = JooqUtils.getRecordClass(schemaFactory, rel.getObjectType()); String mappingType = schemaFactory.getSchemaName(rel.getMappingType()); String fromType = schemaFactory.getSchemaName(rel.getObjectType()); TableField<?, Object> fieldFrom = JooqUtils.getTableField(getMetaDataManager(), fromType, ObjectMetaDataManager.ID_FIELD); TableField<?, Object> mappingTo = JooqUtils.getTableField(getMetaDataManager(), mappingType, rel.getOtherRelationship().getPropertyName()); TableField<?, Object> mappingOther = JooqUtils.getTableField(getMetaDataManager(), mappingType, rel.getPropertyName()); TableField<?, Object> mappingRemoved = JooqUtils.getTableField(getMetaDataManager(), mappingType, ObjectMetaDataManager.REMOVED_FIELD); Table<?> table = JooqUtils.getTable(schemaFactory, typeClass); Table<?> mapTable = JooqUtils.getTable(schemaFactory, rel.getMappingType()); SelectQuery<?> query = create().selectQuery(); query.addFrom(table); query.addSelect(table.fields()); query.addJoin(mapTable, fieldFrom.eq(mappingTo).and(mappingRemoved == null ? DSL.trueCondition() : mappingRemoved.isNull()).and( mappingOther.eq(ObjectUtils.getId(obj)))); return (List<T>) query.fetchInto(typeClass); }
private SelectQuery<Record> buildSelect(DSLContext tx, Set<ProcessDataInclude> includes) { SelectQuery<Record> query = tx.selectQuery(); query.addSelect(PROCESS_QUEUE.fields()); query.addFrom(PROCESS_QUEUE);