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)); }
public SelectBuilder and(String columnName, String value) { return and(columnName, "=", stringParam(value)); }
void addVoOwnerEntityFilter(String ownerTypeName, String fragment) { selectBuilder.and("o." + GLOBAL_ID_TYPE_NAME + " = ?", Parameter.stringParam(ownerTypeName)) .and("g." + GLOBAL_ID_FRAGMENT + " = ?", Parameter.stringParam(fragment)); }
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)); }
void addVoOwnerEntityFilter(String ownerTypeName, String fragment) { selectBuilder.and("o." + GLOBAL_ID_TYPE_NAME + " = ?", Parameter.stringParam(ownerTypeName)) .and("g." + GLOBAL_ID_FRAGMENT + " = ?", Parameter.stringParam(fragment)); }
public SelectBuilder and(String columnName, String value) { return and(columnName, "=", stringParam(value)); }
private void applyQueryParams() { queryParams.changedProperty().ifPresent(changedProperty -> { selectBuilder.and(SNAPSHOT_CHANGED, "like", stringParam("%\"" + queryParams.changedProperty().get() +"\"%")); }); queryParams.from().ifPresent(from -> { selectBuilder.and(COMMIT_COMMIT_DATE, ">=", localDateTimeParam(from)); }); queryParams.to().ifPresent(to -> { selectBuilder.and(COMMIT_COMMIT_DATE, "<=", localDateTimeParam(to)); }); queryParams.toCommitId().ifPresent(commitId -> { selectBuilder.and(COMMIT_COMMIT_ID, "<=", bigDecimalParam(commitId.valueAsNumber())); }); if (queryParams.commitIds().size() > 0) { selectBuilder.and(COMMIT_COMMIT_ID + " IN (" + ToStringBuilder.join( queryParams.commitIds().stream().map(c -> c.valueAsNumber()).collect(toList())) + ")"); } queryParams.version().ifPresent(ver -> selectBuilder.and(SNAPSHOT_VERSION, ver)); queryParams.author().ifPresent(author -> selectBuilder.and(COMMIT_AUTHOR, author)); if (queryParams.commitProperties().size() > 0) { for (Map.Entry<String, String> commitProperty : queryParams.commitProperties().entrySet()) { addCommitPropertyFilter(selectBuilder, commitProperty.getKey(), commitProperty.getValue()); } } queryParams.snapshotType().ifPresent(snapshotType -> selectBuilder.and(SNAPSHOT_TYPE, snapshotType.name())); }
private void applyQueryParams() { queryParams.changedProperty().ifPresent(changedProperty -> { selectBuilder.and(SNAPSHOT_CHANGED, "like", stringParam("%\"" + queryParams.changedProperty().get() +"\"%")); }); queryParams.from().ifPresent(from -> { selectBuilder.and(COMMIT_COMMIT_DATE, ">=", localDateTimeParam(from)); }); queryParams.to().ifPresent(to -> { selectBuilder.and(COMMIT_COMMIT_DATE, "<=", localDateTimeParam(to)); }); queryParams.toCommitId().ifPresent(commitId -> { selectBuilder.and(COMMIT_COMMIT_ID, "<=", bigDecimalParam(commitId.valueAsNumber())); }); if (queryParams.commitIds().size() > 0) { selectBuilder.and(COMMIT_COMMIT_ID + " IN (" + ToStringBuilder.join( queryParams.commitIds().stream().map(c -> c.valueAsNumber()).collect(toList())) + ")"); } queryParams.version().ifPresent(ver -> selectBuilder.and(SNAPSHOT_VERSION, ver)); queryParams.author().ifPresent(author -> selectBuilder.and(COMMIT_AUTHOR, author)); if (queryParams.commitProperties().size() > 0) { for (Map.Entry<String, String> commitProperty : queryParams.commitProperties().entrySet()) { addCommitPropertyFilter(selectBuilder, commitProperty.getKey(), commitProperty.getValue()); } } queryParams.snapshotType().ifPresent(snapshotType -> selectBuilder.and(SNAPSHOT_TYPE, snapshotType.name())); }