List<CommitPropertyDTO> findCommitPropertiesOfSnaphots(Collection<Long> commitPKs, Session session) { if (commitPKs.isEmpty()) { return Collections.emptyList(); } return session.select(COMMIT_PROPERTY_COMMIT_FK + ", " + COMMIT_PROPERTY_NAME + ", " + COMMIT_PROPERTY_VALUE) .from(tableNameProvider.getCommitPropertyTableNameWithSchema()) .queryName("commit properties") .and(COMMIT_PROPERTY_COMMIT_FK + " in (" + Joiner.on(",").join(commitPKs) + ")") .executeQuery(resultSet -> new CommitPropertyDTO( resultSet.getLong(COMMIT_PROPERTY_COMMIT_FK), resultSet.getString(COMMIT_PROPERTY_NAME), resultSet.getString(COMMIT_PROPERTY_VALUE))); } }
List<CommitPropertyDTO> findCommitPropertiesOfSnaphots(Collection<Long> commitPKs, Session session) { if (commitPKs.isEmpty()) { return Collections.emptyList(); } return session.select(COMMIT_PROPERTY_COMMIT_FK + ", " + COMMIT_PROPERTY_NAME + ", " + COMMIT_PROPERTY_VALUE) .from(tableNameProvider.getCommitPropertyTableNameWithSchema()) .queryName("commit properties") .and(COMMIT_PROPERTY_COMMIT_FK + " in (" + Joiner.on(",").join(commitPKs) + ")") .executeQuery(resultSet -> new CommitPropertyDTO( resultSet.getLong(COMMIT_PROPERTY_COMMIT_FK), resultSet.getString(COMMIT_PROPERTY_NAME), resultSet.getString(COMMIT_PROPERTY_VALUE))); } }
List<CdoSnapshotSerialized> run() { selectBuilder.orderByDesc(SNAPSHOT_PK); selectBuilder.limit(queryParams.limit(), queryParams.skip()); return selectBuilder.executeQuery(cdoSnapshotMapper); }
List<CdoSnapshotSerialized> run() { selectBuilder.orderByDesc(SNAPSHOT_PK); selectBuilder.limit(queryParams.limit(), queryParams.skip()); return selectBuilder.executeQuery(cdoSnapshotMapper); }