@Override protected void appendFunctionExpression(SqlBuilder builder, boolean forSqlValidation) { builder.addValueToSql(query, forSqlValidation); } }
@Override protected void populate(SqlBuilder builder, boolean forSqlValidation) { builder.addValueToSql(value, forSqlValidation); } };
protected void afterPopulateOperator(SqlBuilder builder, boolean forSqlValidation) { builder.addValueToSql(value, forSqlValidation); }
@Override protected void afterPopulateOperator(SqlBuilder builder, boolean forSqlValidation) { builder.addValueToSql(lower, forSqlValidation); builder.sql.append(" AND "); builder.addValueToSql(upper, forSqlValidation); }
@Override protected void appendArgumentList(SqlBuilder builder, Object[] arguments, boolean forSqlValidation) { builder.addValueToSql(field, forSqlValidation); builder.sql.append(" AS ").append(newType); } };
protected void visitValues(SqlBuilder builder, boolean forSqlValidation) { boolean appendComma = false; for (String column : valuesToUpdate.keySet()) { if (appendComma) { builder.sql.append(","); } appendComma = true; builder.sql.append(column).append(" = "); Object value = valuesToUpdate.get(column); builder.addValueToSql(value, forSqlValidation); } }
@Override protected void appendFunctionExpression(SqlBuilder builder, boolean forSqlValidation) { builder.sql.append("(CASE"); if (baseExpression != null) { builder.sql.append(' '); builder.addValueToSql(baseExpression, forSqlValidation); } int size = whens.size(); for (int i = 0; i < size; i++) { builder.sql.append(" WHEN "); builder.addValueToSql(whens.get(i), forSqlValidation); builder.sql.append(" THEN "); builder.addValueToSql(thens.get(i), forSqlValidation); } if (elseValue != null) { builder.sql.append(" ELSE "); builder.addValueToSql(elseValue, forSqlValidation); } builder.sql.append(" END)"); } };
protected void appendArgumentList(SqlBuilder builder, Object[] arguments, boolean forSqlValidation) { for (int i = 0; i < arguments.length; i++) { if (i > 0) { builder.sql.append(separator()); } builder.addValueToSql(arguments[i], forSqlValidation); } }
@Override void appendToSqlBuilder(SqlBuilder builder, boolean forSqlValidation) { if (orderType == OrderType.RAW) { builder.sql.append(expression); } else { builder.addValueToSql(expression, forSqlValidation); builder.sql.append(" ").append(orderType.toString()); } }
private void visitValues(SqlBuilder builder, boolean forSqlValidation) { if (builder.compileContext.getVersionCode().isLessThan(SQLITE_VERSION_MULTI_ROW_INSERT) && valuesToInsert.size() > 1) { throw new UnsupportedOperationException("Can't insert with multiple sets of values below " + "SQLite version 3.7.11"); } builder.sql.append("VALUES "); for (List<Object> valuesList : valuesToInsert) { if (valuesList.isEmpty()) { continue; } builder.sql.append("("); for (Object value : valuesList) { builder.addValueToSql(value, forSqlValidation); builder.sql.append(","); } builder.sql.deleteCharAt(builder.sql.length() - 1); builder.sql.append("),"); } builder.sql.deleteCharAt(builder.sql.length() - 1); } }
@Override protected void appendFunctionExpression(SqlBuilder builder, boolean forSqlValidation) { if (!builder.compileContext.getVersionCode().isAtLeast(minVersion)) { throw new UnsupportedOperationException("The function " + functionName + " is not supported on SQLite " + "version " + builder.compileContext.getVersionCode() + " - requires version " + minVersion + " or higher"); } builder.sql.append(functionName).append("("); boolean needsSeparator = false; if (jsonArg != null) { builder.addValueToSql(jsonArg, forSqlValidation); needsSeparator = true; } if (additionalArgs != null && additionalArgs.length > 0) { for (Object additionalArg : additionalArgs) { if (needsSeparator) { builder.sql.append(", "); } builder.addValueToSql(additionalArg, forSqlValidation); needsSeparator = true; } } builder.sql.append(")"); } }
@Override protected void populate(SqlBuilder builder, boolean forSqlValidation) { builder.addValueToSql(value, forSqlValidation); } };
@Override protected void appendFunctionExpression(SqlBuilder builder, boolean forSqlValidation) { builder.addValueToSql(query, forSqlValidation); } }
protected void afterPopulateOperator(SqlBuilder builder, boolean forSqlValidation) { builder.addValueToSql(value, forSqlValidation); }
@Override protected void afterPopulateOperator(SqlBuilder builder, boolean forSqlValidation) { builder.addValueToSql(lower, forSqlValidation); builder.sql.append(" AND "); builder.addValueToSql(upper, forSqlValidation); }
@Override protected void appendArgumentList(SqlBuilder builder, Object[] arguments, boolean forSqlValidation) { builder.addValueToSql(field, forSqlValidation); builder.sql.append(" AS ").append(newType); } };
protected void visitValues(SqlBuilder builder, boolean forSqlValidation) { boolean appendComma = false; for (String column : valuesToUpdate.keySet()) { if (appendComma) { builder.sql.append(","); } appendComma = true; builder.sql.append(column).append(" = "); Object value = valuesToUpdate.get(column); builder.addValueToSql(value, forSqlValidation); } }
@Override protected void appendFunctionExpression(SqlBuilder builder, boolean forSqlValidation) { builder.sql.append("(CASE"); if (baseExpression != null) { builder.sql.append(' '); builder.addValueToSql(baseExpression, forSqlValidation); } int size = whens.size(); for (int i = 0; i < size; i++) { builder.sql.append(" WHEN "); builder.addValueToSql(whens.get(i), forSqlValidation); builder.sql.append(" THEN "); builder.addValueToSql(thens.get(i), forSqlValidation); } if (elseValue != null) { builder.sql.append(" ELSE "); builder.addValueToSql(elseValue, forSqlValidation); } builder.sql.append(" END)"); } };
@Override void appendToSqlBuilder(SqlBuilder builder, boolean forSqlValidation) { if (orderType == OrderType.RAW) { builder.sql.append(expression); } else { builder.addValueToSql(expression, forSqlValidation); builder.sql.append(" ").append(orderType.toString()); } }
protected void appendArgumentList(SqlBuilder builder, Object[] arguments, boolean forSqlValidation) { for (int i = 0; i < arguments.length; i++) { if (i > 0) { builder.sql.append(separator()); } builder.addValueToSql(arguments[i], forSqlValidation); } }