public String getColumnAlias(Column col) { return _sel.getColumnAlias(col, _state.joins); }
public String getColumnAlias(String col, Table table) { return _sel.getColumnAlias(col, table, _state.joins); }
public String getColumnAlias(String col, Table table) { return _sel.getColumnAlias(col, table, _state.joins); }
public void appendIndex(SQLBuffer sql, Select sel, Joins joins) { sql.append(sel.getColumnAlias(field.getOrderColumn(), field.getName())); }
public void appendIsNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); for (int i = 0; i < _cols.length; i++) { if (i > 0) sql.append(" AND "); sql.append(sel.getColumnAlias(_cols[i], joins)).append(" IS "). appendValue(null, _cols[i]); } }
public void appendIsNotNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); sql.append(sel.getColumnAlias(field.getColumns()[0], joins)). append(" IS NOT ").appendValue(null, field.getColumns()[0]); }
public void appendIsNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); sql.append(sel.getColumnAlias(field.getColumns()[0], joins)). append(" IS ").appendValue(null, field.getColumns()[0]); }
public void appendTo(Select sel, ExpState state, SQLBuffer sql, Column col) { if (sel != null) sel.setSchemaAlias(_schemaAlias); // if select is null, it means we are not aliasing columns // (e.g., during a bulk update) if (sel == null) sql.append(col.getIdentifier()); else if (_type == XPATH) // if this is an xpath, append xpath string sql.append(getXPath()); else sql.append(sel.getColumnAlias(col, state.joins)); }
public void appendIsNotNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); sql.append(sel.getColumnAlias(field.getColumns()[0], joins)). append(" IS NOT ").appendValue(null, field.getColumns()[0]); }
public void appendIsNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); sql.append(sel.getColumnAlias(field.getColumns()[0], joins)). append(" IS ").appendValue(null, field.getColumns()[0]); }
public void appendIsNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); sql.append(sel.getColumnAlias(field.getColumns()[0], joins)). append(" IS ").appendValue(null, field.getColumns()[0]); }
public void appendIsNotNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); sql.append(sel.getColumnAlias(field.getColumns()[0], joins)). append(" IS NOT ").appendValue(null, field.getColumns()[0]); }
public void appendIsNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); for (int i = 0; i < _cols.length; i++) { if (i > 0) { sql.append(" AND "); } // Some databases do not allow IS NULL for every column type - let the DBDictionary decide. DBDictionary dict = sel.getDictionary(); sql.append(dict.getIsNullSQL(sel.getColumnAlias(_cols[i], joins), _cols[i].getType())); } }
public void appendIsNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); for (int i = 0; i < _cols.length; i++) { if (i > 0) { sql.append(" AND "); } // Some databases do not allow IS NULL for every column type - let the DBDictionary decide. DBDictionary dict = sel.getDictionary(); sql.append(dict.getIsNullSQL(sel.getColumnAlias(_cols[i], joins), _cols[i].getType())); } }
public void appendIsNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); sql.append(sel.getColumnAlias(field.getColumns()[0], joins)). append(" IS ").appendValue(null, field.getColumns()[0]); }
public void appendIsNotNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); sql.append(sel.getColumnAlias(field.getColumns()[0], joins)). append(" IS NOT ").appendValue(null, field.getColumns()[0]); }
public void appendIsNotNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); sql.append(sel.getColumnAlias(field.getColumns()[0], joins)). append(" IS NOT ").appendValue(null, field.getColumns()[0]); }
public void appendIsNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); sql.append(sel.getColumnAlias(field.getColumns()[0], joins)). append(" IS ").appendValue(null, field.getColumns()[0]); }
public void appendIsNotNull(SQLBuffer sql, Select sel, Joins joins) { joins = join(joins, false); sql.append(sel.getColumnAlias(field.getColumns()[0], joins)). append(" IS NOT ").appendValue(null, field.getColumns()[0]); }
/** * Create an IN clause limiting the results to the current page. */ private void inContains(Select sel, SQLBuffer buf, ClassMapping mapping, Column[] pks, int start, int end) { buf.append(sel.getColumnAlias(pks[0])).append(" IN ("); for (int i = start; i < end && _page[i] != null; i++) { if (i > start) buf.append(", "); buf.appendValue(mapping.toDataStoreValue(_page[i], pks, getStore()), pks[0]); } buf.append(")"); }