public Value trim(Value str, Value trimChar, Boolean where) { return new Trim((Val) str, (Val) trimChar, where); }
public void orderBy(Select sel, ExpContext ctx, ExpState state, boolean asc) { sel.orderBy(newSQLBuffer(sel, ctx, state), asc, false, getSelectAs()); }
private Object handleTrimVal(Object value, Object ob, Object[] params, OpenJPAStateManager sm) { org.apache.openjpa.jdbc.kernel.exps.Trim trimVal = (org.apache.openjpa.jdbc.kernel.exps.Trim) value; Val val = trimVal.getVal(); String valStr = (String) getValue(val, ob, params, sm); Val trimChar = trimVal.getTrimChar(); char trimCharObj = ((String) getValue(trimChar, ob, params, sm)). charAt(0); Boolean where = trimVal.getWhere(); if (where == null) { //trim both return trimLeading(trimTrailing(valStr, trimCharObj), trimCharObj); } else if (where.booleanValue()) { // trim leading return trimLeading(valStr, trimCharObj); } else { // trim trailing return trimTrailing(valStr, trimCharObj); } }
private SQLBuffer newSQLBuffer(Select sel, ExpContext ctx, ExpState state) { calculateValue(sel, ctx, state, null, null); SQLBuffer buf = new SQLBuffer(ctx.store.getDBDictionary()); appendTo(sel, ctx, state, buf, 0); return buf; }
public void select(Select sel, ExpContext ctx, ExpState state, boolean pks) { sel.select(newSQLBuffer(sel, ctx, state), this); }
public Object load(ExpContext ctx, ExpState state, Result res) throws SQLException { return Filters.convert(res.getObject(this, JavaSQLTypes.JDBC_DEFAULT, null), getType()); }
private Object handleTrimVal(Object value, Object ob, Object[] params, OpenJPAStateManager sm) { org.apache.openjpa.jdbc.kernel.exps.Trim trimVal = (org.apache.openjpa.jdbc.kernel.exps.Trim) value; Val val = trimVal.getVal(); String valStr = (String) getValue(val, ob, params, sm); Val trimChar = trimVal.getTrimChar(); char trimCharObj = ((String) getValue(trimChar, ob, params, sm)). charAt(0); Boolean where = trimVal.getWhere(); if (where == null) { //trim both return trimLeading(trimTrailing(valStr, trimCharObj), trimCharObj); } else if (where.booleanValue()) { // trim leading return trimLeading(valStr, trimCharObj); } else { // trim trailing return trimTrailing(valStr, trimCharObj); } }
private SQLBuffer newSQLBuffer(Select sel, ExpContext ctx, ExpState state) { calculateValue(sel, ctx, state, null, null); SQLBuffer buf = new SQLBuffer(ctx.store.getDBDictionary()); appendTo(sel, ctx, state, buf, 0); return buf; }
public void select(Select sel, ExpContext ctx, ExpState state, boolean pks) { sel.select(newSQLBuffer(sel, ctx, state), this); }
public Object load(ExpContext ctx, ExpState state, Result res) throws SQLException { return Filters.convert(res.getObject(this, JavaSQLTypes.JDBC_DEFAULT, null), getType()); }
private Object handleTrimVal(Object value, Object ob, Object[] params, OpenJPAStateManager sm) { org.apache.openjpa.jdbc.kernel.exps.Trim trimVal = (org.apache.openjpa.jdbc.kernel.exps.Trim) value; Val val = trimVal.getVal(); String valStr = (String) getValue(val, ob, params, sm); Val trimChar = trimVal.getTrimChar(); char trimCharObj = ((String) getValue(trimChar, ob, params, sm)). charAt(0); Boolean where = trimVal.getWhere(); if (where == null) { //trim both return trimLeading(trimTrailing(valStr, trimCharObj), trimCharObj); } else if (where.booleanValue()) { // trim leading return trimLeading(valStr, trimCharObj); } else { // trim trailing return trimTrailing(valStr, trimCharObj); } }
private SQLBuffer newSQLBuffer(Select sel, ExpContext ctx, ExpState state) { calculateValue(sel, ctx, state, null, null); SQLBuffer buf = new SQLBuffer(ctx.store.getDBDictionary()); appendTo(sel, ctx, state, buf, 0); return buf; }
public void orderBy(Select sel, ExpContext ctx, ExpState state, boolean asc) { sel.orderBy(newSQLBuffer(sel, ctx, state), asc, false, getSelectAs()); }
public void groupBy(Select sel, ExpContext ctx, ExpState state) { sel.groupBy(newSQLBuffer(sel, ctx, state)); }
public Value trim(Value str, Value trimChar, Boolean where) { return new Trim((Val) str, (Val) trimChar, where); }
public Object load(ExpContext ctx, ExpState state, Result res) throws SQLException { return Filters.convert(res.getObject(this, JavaSQLTypes.JDBC_DEFAULT, null), getType()); }
private Object handleTrimVal(Object value, Object ob, Object[] params, OpenJPAStateManager sm) { org.apache.openjpa.jdbc.kernel.exps.Trim trimVal = (org.apache.openjpa.jdbc.kernel.exps.Trim) value; Val val = trimVal.getVal(); String valStr = (String) getValue(val, ob, params, sm); Val trimChar = trimVal.getTrimChar(); char trimCharObj = ((String) getValue(trimChar, ob, params, sm)). charAt(0); Boolean where = trimVal.getWhere(); if (where == null) { //trim both return trimLeading(trimTrailing(valStr, trimCharObj), trimCharObj); } else if (where.booleanValue()) { // trim leading return trimLeading(valStr, trimCharObj); } else { // trim trailing return trimTrailing(valStr, trimCharObj); } }
private SQLBuffer newSQLBuffer(Select sel, ExpContext ctx, ExpState state) { calculateValue(sel, ctx, state, null, null); SQLBuffer buf = new SQLBuffer(ctx.store.getDBDictionary()); appendTo(sel, ctx, state, buf, 0); return buf; }
public void orderBy(Select sel, ExpContext ctx, ExpState state, boolean asc) { sel.orderBy(newSQLBuffer(sel, ctx, state), asc, false, getSelectAs()); }
public void groupBy(Select sel, ExpContext ctx, ExpState state) { sel.groupBy(newSQLBuffer(sel, ctx, state)); }