private void visitWhere(SqlBuilder builder, boolean forSqlValidation) { if (criterions.isEmpty()) { return; } builder.sql.append(" WHERE "); builder.appendConcatenatedCompilables(criterions, " AND ", forSqlValidation); } }
private void visitWhere(SqlBuilder builder, boolean forSqlValidation) { if (criterions.isEmpty()) { return; } builder.sql.append(" WHERE "); builder.appendConcatenatedCompilables(criterions, " AND ", forSqlValidation); } }
private void visitWhen(SqlBuilder builder, boolean forSqlValidation) { if (criterions.isEmpty()) { return; } builder.sql.append("WHEN "); builder.appendConcatenatedCompilables(criterions, " AND ", forSqlValidation); builder.sql.append(" "); }
private void visitJoinClause(SqlBuilder builder, boolean forSqlValidation) { if (isEmpty(joins)) { return; } builder.sql.append(" "); builder.appendConcatenatedCompilables(joins, " ", forSqlValidation); }
private void visitCompoundSelectClauses(SqlBuilder builder, boolean forSqlValidation) { if (isEmpty(compoundSelects)) { return; } builder.sql.append(" "); builder.appendConcatenatedCompilables(compoundSelects, " ", forSqlValidation); }
private void visitOrderByClause(SqlBuilder builder, boolean forSqlValidation) { if (isEmpty(orders)) { return; } builder.sql.append(" ORDER BY "); builder.appendConcatenatedCompilables(orders, ", ", forSqlValidation); }
private void visitWhereClause(SqlBuilder builder, boolean forSqlValidation) { if (isEmpty(criterions)) { return; } builder.sql.append(" WHERE "); if (forSqlValidation) { builder.sql.append("("); } builder.appendConcatenatedCompilables(criterions, " AND ", forSqlValidation); if (forSqlValidation) { builder.sql.append(")"); } }
private void visitSelectClause(SqlBuilder builder, boolean forSqlValidation) { builder.sql.append("SELECT "); if (distinct) { builder.sql.append("DISTINCT "); } List<Field<?>> toSelect; if (isEmpty(fields)) { // SELECT * may yield unexpected column names, so we get the full list of fields to specify explicit aliases toSelect = getFields(); } else { toSelect = fields; } builder.appendConcatenatedCompilables(toSelect, ", ", forSqlValidation); }
private void visitGroupByClause(SqlBuilder builder, boolean forSqlValidation) { if (isEmpty(groupByFields)) { return; } builder.sql.append(" GROUP BY"); for (Field<?> groupBy : groupByFields) { builder.sql.append(" "); groupBy.appendQualifiedExpression(builder, forSqlValidation); builder.sql.append(","); } builder.sql.deleteCharAt(builder.sql.length() - 1); if (isEmpty(havings)) { return; } builder.sql.append(" HAVING "); builder.appendConcatenatedCompilables(havings, " AND ", forSqlValidation); }
private void visitWhere(SqlBuilder builder, boolean forSqlValidation) { if (criterions.isEmpty()) { return; } builder.sql.append(" WHERE "); builder.appendConcatenatedCompilables(criterions, " AND ", forSqlValidation); } }
private void visitWhere(SqlBuilder builder, boolean forSqlValidation) { if (criterions.isEmpty()) { return; } builder.sql.append(" WHERE "); builder.appendConcatenatedCompilables(criterions, " AND ", forSqlValidation); } }
private void visitWhen(SqlBuilder builder, boolean forSqlValidation) { if (criterions.isEmpty()) { return; } builder.sql.append("WHEN "); builder.appendConcatenatedCompilables(criterions, " AND ", forSqlValidation); builder.sql.append(" "); }
private void visitJoinClause(SqlBuilder builder, boolean forSqlValidation) { if (isEmpty(joins)) { return; } builder.sql.append(" "); builder.appendConcatenatedCompilables(joins, " ", forSqlValidation); }
private void visitCompoundSelectClauses(SqlBuilder builder, boolean forSqlValidation) { if (isEmpty(compoundSelects)) { return; } builder.sql.append(" "); builder.appendConcatenatedCompilables(compoundSelects, " ", forSqlValidation); }
private void visitOrderByClause(SqlBuilder builder, boolean forSqlValidation) { if (isEmpty(orders)) { return; } builder.sql.append(" ORDER BY "); builder.appendConcatenatedCompilables(orders, ", ", forSqlValidation); }
private void visitWhereClause(SqlBuilder builder, boolean forSqlValidation) { if (isEmpty(criterions)) { return; } builder.sql.append(" WHERE "); if (forSqlValidation) { builder.sql.append("("); } builder.appendConcatenatedCompilables(criterions, " AND ", forSqlValidation); if (forSqlValidation) { builder.sql.append(")"); } }
private void visitSelectClause(SqlBuilder builder, boolean forSqlValidation) { builder.sql.append("SELECT "); if (distinct) { builder.sql.append("DISTINCT "); } List<Field<?>> toSelect; if (isEmpty(fields)) { // SELECT * may yield unexpected column names, so we get the full list of fields to specify explicit aliases toSelect = getFields(); } else { toSelect = fields; } builder.appendConcatenatedCompilables(toSelect, ", ", forSqlValidation); }
private void visitGroupByClause(SqlBuilder builder, boolean forSqlValidation) { if (isEmpty(groupByFields)) { return; } builder.sql.append(" GROUP BY"); for (Field<?> groupBy : groupByFields) { builder.sql.append(" "); groupBy.appendQualifiedExpression(builder, forSqlValidation); builder.sql.append(","); } builder.sql.deleteCharAt(builder.sql.length() - 1); if (isEmpty(havings)) { return; } builder.sql.append(" HAVING "); builder.appendConcatenatedCompilables(havings, " AND ", forSqlValidation); }