void addSnapshotPkFilter(long snapshotPk) { selectBuilder.and(SNAPSHOT_PK, snapshotPk); }
void addSnapshotPkFilter(long snapshotPk) { selectBuilder.and(SNAPSHOT_PK, snapshotPk); }
public SelectBuilder and(String columnName, String value) { return and(columnName, "=", stringParam(value)); }
public SelectBuilder and(String columnName, BigDecimal value) { return and(columnName, "=", Parameter.bigDecimalParam(value)); }
public SelectBuilder and(String columnName, Long value) { return and(columnName, "=", longParam(value)); }
public SelectBuilder and(String columnName, BigDecimal value) { return and(columnName, "=", Parameter.bigDecimalParam(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<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))); } }
void addManagedTypesFilter(Set<String> managedTypeNames) { String basePredicate = SNAPSHOT_MANAGED_TYPE + " in (" + ToStringBuilder.join(managedTypeNames) + ")"; if (!queryParams.isAggregate()) { selectBuilder.and(basePredicate); } else { selectBuilder.and( "( " + basePredicate + " OR g.owner_id_fk in ( "+ " select g1." + GLOBAL_ID_PK + " from " + snapshotTableName() + " s1 "+ " INNER JOIN " + globalIdTableName() + " g1 ON g1." + GLOBAL_ID_PK + "= s1."+ SNAPSHOT_GLOBAL_ID_FK + " and s1." + basePredicate + ")"+ ")"); } }
void addManagedTypesFilter(Set<String> managedTypeNames) { String basePredicate = SNAPSHOT_MANAGED_TYPE + " in (" + ToStringBuilder.join(managedTypeNames) + ")"; if (!queryParams.isAggregate()) { selectBuilder.and(basePredicate); } else { selectBuilder.and( "( " + basePredicate + " OR g.owner_id_fk in ( "+ " select g1." + GLOBAL_ID_PK + " from " + snapshotTableName() + " s1 "+ " INNER JOIN " + globalIdTableName() + " g1 ON g1." + GLOBAL_ID_PK + "= s1."+ SNAPSHOT_GLOBAL_ID_FK + " and s1." + basePredicate + ")"+ ")"); } }
private Optional<Long> selectMaxSnapshotPrimaryKey(long globalIdPk, Session session) { Optional<Long> maxPrimaryKey = session .select("MAX(" + SNAPSHOT_PK + ")") .from(tableNameProvider.getSnapshotTableNameWithSchema()) .and(SNAPSHOT_GLOBAL_ID_FK, globalIdPk) .queryName("select max snapshot's PK") .queryForOptionalLong(); if (maxPrimaryKey.isPresent() && maxPrimaryKey.get() == 0){ return Optional.empty(); } return maxPrimaryKey; }
private Optional<Long> selectMaxSnapshotPrimaryKey(long globalIdPk, Session session) { Optional<Long> maxPrimaryKey = session .select("MAX(" + SNAPSHOT_PK + ")") .from(tableNameProvider.getSnapshotTableNameWithSchema()) .and(SNAPSHOT_GLOBAL_ID_FK, globalIdPk) .queryName("select max snapshot's PK") .queryForOptionalLong(); if (maxPrimaryKey.isPresent() && maxPrimaryKey.get() == 0){ return Optional.empty(); } return maxPrimaryKey; }
private void addCommitPropertyFilter(SelectBuilder selectBuilder, String propertyName, String propertyValue) { selectBuilder.and("EXISTS (" + " SELECT * FROM " + commitPropertyTableName() + " WHERE " + COMMIT_PROPERTY_COMMIT_FK + " = " + COMMIT_PK + " AND " + COMMIT_PROPERTY_NAME + " = ?" + " AND " + COMMIT_PROPERTY_VALUE + " = ?)", stringParam(propertyName), stringParam(propertyValue)); }
private void addCommitPropertyFilter(SelectBuilder selectBuilder, String propertyName, String propertyValue) { selectBuilder.and("EXISTS (" + " SELECT * FROM " + commitPropertyTableName() + " WHERE " + COMMIT_PROPERTY_COMMIT_FK + " = " + COMMIT_PK + " AND " + COMMIT_PROPERTY_NAME + " = ?" + " AND " + COMMIT_PROPERTY_VALUE + " = ?)", stringParam(propertyName), stringParam(propertyValue)); }
boolean isCommitPersisted(CommitId commitId, Session session) { long count = session.select("count(*)") .from(getCommitTableNameWithSchema()) .and(COMMIT_COMMIT_ID, commitId.valueAsNumber()) .queryForLong("isCommitPersisted"); return count > 0; }
boolean isCommitPersisted(CommitId commitId, Session session) { long count = session.select("count(*)") .from(getCommitTableNameWithSchema()) .and(COMMIT_COMMIT_ID, commitId.valueAsNumber()) .queryForLong("isCommitPersisted"); return count > 0; }