/** * Create the outer join operator for this platform */ protected ExpressionOperator operatorOuterJoin() { ExpressionOperator result = new ExpressionOperator(); result.setSelector(ExpressionOperator.EqualOuterJoin); Vector v = new Vector(2); v.addElement(" (+) = "); result.printsAs(v); result.bePostfix(); result.setNodeClass(RelationExpression.class); return result; }
/** * INTERNAL: * Create the outer join operator for this platform */ protected ExpressionOperator operatorOuterJoin() { ExpressionOperator result = new ExpressionOperator(); result.setSelector(ExpressionOperator.EqualOuterJoin); Vector v = new Vector(2); v.addElement(" (+) = "); result.printsAs(v); result.bePostfix(); result.setNodeClass(RelationExpression.class); return result; }
/** * INTERNAL: * Override the default MOD operator. */ public ExpressionOperator modOperator() { ExpressionOperator result = new ExpressionOperator(); result.setSelector(ExpressionOperator.Mod); Vector v = new Vector(); v.addElement(" % "); result.printsAs(v); result.bePostfix(); result.setNodeClass(oracle.toplink.essentials.internal.expressions.FunctionExpression.class); return result; }
/** * INTERNAL: * Override the default MOD operator. */ public ExpressionOperator modOperator() { ExpressionOperator result = new ExpressionOperator(); result.setSelector(ExpressionOperator.Mod); Vector v = new Vector(); v.addElement(" % "); result.printsAs(v); result.bePostfix(); result.setNodeClass(oracle.toplink.essentials.internal.expressions.FunctionExpression.class); return result; }
/** * INTERNAL: * Create the outer join operator for this platform. */ protected ExpressionOperator operatorOuterJoin() { ExpressionOperator result = new ExpressionOperator(); result.setSelector(ExpressionOperator.EqualOuterJoin); Vector v = new Vector(); v.addElement(" =* "); result.printsAs(v); result.bePostfix(); result.setNodeClass(RelationExpression.class); return result; }
/** * INTERNAL: * Create the outer join operator for this platform */ protected ExpressionOperator operatorOuterJoin() { ExpressionOperator result = new ExpressionOperator(); result.setSelector(ExpressionOperator.EqualOuterJoin); Vector v = new Vector(); v.addElement(" =* "); result.printsAs(v); result.bePostfix(); result.setNodeClass(RelationExpression.class); return result; }
/** * INTERNAL: * Create the NOTIN operator. */ public static ExpressionOperator notIn() { ExpressionOperator result = new ExpressionOperator(); result.setType(ExpressionOperator.FunctionOperator); result.setSelector(NotIn); Vector v = new Vector(2); v.addElement(" NOT IN ("); v.addElement(")"); result.printsAs(v); result.bePostfix(); result.setNodeClass(ClassConstants.FunctionExpression_Class); return result; }
/** * INTERNAL: * Create the IN operator. */ public static ExpressionOperator in() { ExpressionOperator result = new ExpressionOperator(); result.setType(ExpressionOperator.FunctionOperator); result.setSelector(In); Vector v = new Vector(2); v.addElement(" IN ("); v.addElement(")"); result.printsAs(v); result.bePostfix(); result.setNodeClass(ClassConstants.FunctionExpression_Class); return result; }
public static ExpressionOperator getNumberVal() { ExpressionOperator result = new ExpressionOperator(); Vector v = oracle.toplink.essentials.internal.helper.NonSynchronizedVector.newInstance(); v.addElement(".getNumberVal()"); result.printsAs(v); result.bePostfix(); result.setSelector(GetNumberVal); result.setNodeClass(ClassConstants.FunctionExpression_Class); return result; }
public static ExpressionOperator getStringVal() { ExpressionOperator result = new ExpressionOperator(); Vector v = oracle.toplink.essentials.internal.helper.NonSynchronizedVector.newInstance(); v.addElement(".getStringVal()"); result.printsAs(v); result.bePostfix(); result.setSelector(GetStringVal); result.setNodeClass(ClassConstants.FunctionExpression_Class); return result; }
public static ExpressionOperator isFragment() { ExpressionOperator result = new ExpressionOperator(); Vector v = oracle.toplink.essentials.internal.helper.NonSynchronizedVector.newInstance(); v.addElement(".isFragment()"); result.printsAs(v); result.bePostfix(); result.setSelector(IsFragment); result.setNodeClass(ClassConstants.FunctionExpression_Class); return result; }
/** * INTERNAL: * Create the IN operator taking a subquery. * Note, the subquery itself comes with parenethesis, so the IN operator * should not add any parenethesis. */ public static ExpressionOperator inSubQuery() { ExpressionOperator result = new ExpressionOperator(); result.setType(ExpressionOperator.FunctionOperator); result.setSelector(InSubQuery); Vector v = new Vector(1); v.addElement(" IN "); result.printsAs(v); result.bePostfix(); result.setNodeClass(ClassConstants.FunctionExpression_Class); return result; }
/** * INTERNAL: * Create the NOTIN operator taking a subQuery. * Note, the subquery itself comes with parenethesis, so the IN operator * should not add any parenethesis. */ public static ExpressionOperator notInSubQuery() { ExpressionOperator result = new ExpressionOperator(); result.setType(ExpressionOperator.FunctionOperator); result.setSelector(NotInSubQuery); Vector v = new Vector(1); v.addElement(" NOT IN "); result.printsAs(v); result.bePostfix(); result.setNodeClass(ClassConstants.FunctionExpression_Class); return result; }
/** * INTERNAL: * Create an operator for a simple logical given a Java name and a single * String for the database (parentheses will be added automatically). */ public static ExpressionOperator simpleLogical(int selector, String databaseName, String javaName) { ExpressionOperator exOperator = new ExpressionOperator(); exOperator.setType(LogicalOperator); exOperator.setSelector(selector); exOperator.printsAs(" " + databaseName + " "); exOperator.bePostfix(); Vector v = oracle.toplink.essentials.internal.helper.NonSynchronizedVector.newInstance(2); v.addElement("." + javaName + "("); v.addElement(")"); exOperator.printsJavaAs(v); exOperator.setNodeClass(ClassConstants.LogicalExpression_Class); return exOperator; }
/** * INTERNAL: * Create the SOME operator. */ public static ExpressionOperator some() { ExpressionOperator exOperator = new ExpressionOperator(); exOperator.setType(FunctionOperator); exOperator.setSelector(Some); exOperator.printsAs("SOME"); exOperator.bePostfix(); exOperator.setNodeClass(ClassConstants.FunctionExpression_Class); return exOperator; }
/** * ADVANCED: * Inserts the SQL as is directly into the expression. * The sql will be printed immediately after (postfixed to) the sql for * <b>this</b>. */ public Expression postfixSQL(String sqlString) { ExpressionOperator anOperator = new ExpressionOperator(); anOperator.setType(ExpressionOperator.FunctionOperator); Vector v = oracle.toplink.essentials.internal.helper.NonSynchronizedVector.newInstance(1); v.addElement(sqlString); anOperator.printsAs(v); anOperator.bePostfix(); anOperator.setNodeClass(ClassConstants.FunctionExpression_Class); return anOperator.expressionFor(this); }
/** * INTERNAL: * Create the ALL operator. */ public static ExpressionOperator all() { ExpressionOperator exOperator = new ExpressionOperator(); exOperator.setType(FunctionOperator); exOperator.setSelector(All); exOperator.printsAs("ALL"); exOperator.bePostfix(); exOperator.setNodeClass(ClassConstants.FunctionExpression_Class); return exOperator; }
/** * INTERNAL: * Create the ANY operator. */ public static ExpressionOperator any() { ExpressionOperator exOperator = new ExpressionOperator(); exOperator.setType(FunctionOperator); exOperator.setSelector(Any); exOperator.printsAs("ANY"); exOperator.bePostfix(); exOperator.setNodeClass(ClassConstants.FunctionExpression_Class); return exOperator; }
/** * INTERNAL: * Create an operator for a simple relation given a Java name and a single * String for the database (parentheses will be added automatically). */ public static ExpressionOperator simpleRelation(int selector, String databaseName) { ExpressionOperator exOperator = new ExpressionOperator(); exOperator.setType(ComparisonOperator); exOperator.setSelector(selector); exOperator.printsAs(" " + databaseName + " "); exOperator.bePostfix(); exOperator.setNodeClass(ClassConstants.RelationExpression_Class); return exOperator; }
/** * INTERNAL: * Create an operator for a simple ordering given a Java name and a single * String for the database (parentheses will be added automatically). */ public static ExpressionOperator simpleOrdering(int selector, String databaseName, String javaName) { ExpressionOperator exOperator = new ExpressionOperator(); exOperator.setType(OrderOperator); exOperator.setSelector(selector); exOperator.printsAs(" " + databaseName); exOperator.bePostfix(); exOperator.printsJavaAs("." + javaName + "()"); exOperator.setNodeClass(ClassConstants.FunctionExpression_Class); return exOperator; }