/** * Append a parameter value. */ public SQLBuffer appendValue(Object o) { return appendValue(o, null); }
/** * Append a parameter value. */ public SQLBuffer appendValue(Object o) { return appendValue(o, null); }
/** * Append a parameter value. */ public SQLBuffer appendValue(boolean b) { return appendValue(b, null); }
/** * Append a parameter value. */ public SQLBuffer appendValue(byte b) { return appendValue(b, null); }
/** * Append a parameter value. */ public SQLBuffer appendValue(char c) { return appendValue(c, null); }
/** * Append a parameter value. */ public SQLBuffer appendValue(float f) { return appendValue(f, null); }
@Override protected void appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect) { buf.append(" LIMIT ").appendValue(start).append(", "); if (end == Long.MAX_VALUE) buf.appendValue(Long.MAX_VALUE); else buf.appendValue(end - start); }
@Override protected void appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect) { if (end != Long.MAX_VALUE) buf.append(" LIMIT ").appendValue(end - start); if (start != 0) buf.append(" OFFSET ").appendValue(start); }
public void appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index) { ConstGetObjectIdExpState cstate = (ConstGetObjectIdExpState) state; if (cstate.otherLength > 1) sql.appendValue(((Object[]) cstate.sqlValue)[index], cstate.getColumn(index)); else sql.appendValue(cstate.sqlValue, cstate.getColumn(index)); }
public void appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index) { ConstPathExpState cstate = (ConstPathExpState) state; if (cstate.otherLength > 1) sql.appendValue(((Object[]) cstate.sqlValue)[index], cstate.getColumn(index)); else sql.appendValue(cstate.sqlValue, cstate.getColumn(index)); }
@Override protected void appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect) { if (end != Long.MAX_VALUE) buf.append(" LIMIT ").appendValue(end - start); if (start != 0) buf.append(" OFFSET ").appendValue(start); }
@Override protected void appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect) { if (end != Long.MAX_VALUE) buf.append(" LIMIT ").appendValue(end - start); if (start != 0) buf.append(" OFFSET ").appendValue(start); }
@Override protected void appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect) { if (end != Long.MAX_VALUE) buf.append(" LIMIT ").appendValue(end - start); if (start != 0) { if(end == Long.MAX_VALUE) buf.append(" LIMIT 0"); buf.append(" OFFSET ").appendValue(start); } }
public void appendIsNotNull(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql) { appendTo(sel, ctx, state, sql, 0); sql.append(" IS NOT ").appendValue(null); }
public void appendIsNull(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql) { appendTo(sel, ctx, state, sql, 0); sql.append(" IS ").appendValue(null); }
public void appendIsNull(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql) { appendTo(sel, ctx, state, sql, 0); sql.append(" IS ").appendValue(null); }
public void appendIsNotNull(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql) { appendTo(sel, ctx, state, sql, 0); sql.append(" IS NOT ").appendValue(null); }
public void appendTo(SQLBuffer buf, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store) { if (!args[0].isConstant()) throw new UserException(_loc.get("const-only", TAG)); Object val = args[0].getValue(); target.appendTo(buf); if (val == null) buf.append(" IS ").appendValue(null); else buf.append(" LIKE ").appendValue("%" + val + "%"); } }
public void appendTo(SQLBuffer buf, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store) { if (!args[0].isConstant()) throw new UserException(_loc.get("const-only", TAG)); Object val = args[0].getValue(); target.appendTo(buf); if (val == null) buf.append(" IS ").appendValue(null); else buf.append(" LIKE ").appendValue("%" + val + "%"); } }
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]); }