public Query where(FilterItem... items) { _whereClause.addItems(items); return this; }
public Query where(Iterable<FilterItem> items) { _whereClause.addItems(items); return this; }
public Query where(FilterItem... items) { _whereClause.addItems(items); return this; }
public Query having(FilterItem... items) { _havingClause.addItems(items); return this; }
public Query where(Iterable<FilterItem> items) { _whereClause.addItems(items); return this; }
public Query having(FilterItem... items) { _havingClause.addItems(items); return this; }
@Override public String toSql() { return "DELETE FROM " + _table.getQualifiedLabel() + new FilterClause(null, " WHERE ").addItems(_whereItems); } }
@Override public String toSql() { return "DELETE FROM " + _table.getQualifiedLabel() + new FilterClause(null, " WHERE ").addItems(_whereItems); } }
@Override public String toSql() { StringBuilder sb = new StringBuilder(); sb.append("UPDATE "); sb.append(_table.getQualifiedLabel()); sb.append(" SET "); Column[] columns = getColumns(); Object[] values = getValues(); for (int i = 0; i < columns.length; i++) { if (i != 0) { sb.append(','); } sb.append(columns[i].getName()); sb.append('='); sb.append(values[i] == null ? "NULL" : values[i].toString()); } List<FilterItem> whereItems = getWhereItems(); String whereClause = new FilterClause(null, " WHERE ").addItems(whereItems).toSql(); sb.append(whereClause); return sb.toString(); }
@Override public String toSql() { StringBuilder sb = new StringBuilder(); sb.append("UPDATE "); sb.append(_table.getQualifiedLabel()); sb.append(" SET "); Column[] columns = getColumns(); Object[] values = getValues(); for (int i = 0; i < columns.length; i++) { if (i != 0) { sb.append(','); } sb.append(columns[i].getName()); sb.append('='); sb.append(values[i] == null ? "NULL" : values[i].toString()); } List<FilterItem> whereItems = getWhereItems(); String whereClause = new FilterClause(null, " WHERE ").addItems(whereItems).toSql(); sb.append(whereClause); return sb.toString(); }