protected internal virtual void AppendFields(Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect o, System.Text.StringBuilder sb, Net.Vpc.Upa.Persistence.EntityExecutionContext context, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { sb.Append(" "); string aliasString = null; string valueString = null; bool started = false; if (o.CountFields() == 0) { sb.Append("..."); } else { // PersistenceStore persistenceStore = context.getPersistenceStore(); for (int i = 0; i < o.CountFields(); i++) { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledQueryField fi = o.GetField(i); Net.Vpc.Upa.Impl.Uql.Compiledexpression.DefaultCompiledExpression e = fi.GetExpression(); bool fieldIsSelect = e is Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect; valueString = sqlManager.GetSQL(e, context, declarations); if (fieldIsSelect) { valueString = "(" + valueString + ")"; } aliasString = fi.GetAlias(); if (started) { sb.Append(","); } else { started = true; } if (aliasString == null) { sb.Append(valueString); } else { sb.Append(valueString); sb.Append(" "); sb.Append(sqlManager.GetSQL(new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar(aliasString), context, declarations)); } } } }
public virtual string GetSQL(object oo, Net.Vpc.Upa.Persistence.EntityExecutionContext qlContext, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) /* throws Net.Vpc.Upa.Exceptions.UPAException */ { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledQLFunctionExpression o = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledQLFunctionExpression)oo; int argumentsCount = o.GetArgumentsCount(); object[] args = new object[argumentsCount]; for (int i = 0; i < args.Length; i++) { args[i] = Eval(o.GetArgument(i), qlContext); } return(sqlManager.GetMarshallManager().FormatSqlValue(o.GetHandler().Eval(new Net.Vpc.Upa.EvalContext(o.GetName(), args, qlContext.GetPersistenceUnit())))); }
public virtual string GetSQL(object o, Net.Vpc.Upa.Persistence.EntityExecutionContext qlContext, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) /* throws Net.Vpc.Upa.Exceptions.UPAException */ { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledFunction cc = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledFunction)o; return(Simplify(qlContext, sqlManager, declarations, cc.GetArguments())); }
protected internal virtual Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledDateDiff CompileDateDiff(Net.Vpc.Upa.Expressions.DateDiff v, Net.Vpc.Upa.Impl.Uql.ExpressionTranslationManager manager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { if (v == null) { return(null); } Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledDateDiff s = new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledDateDiff(v.GetDatePartType(), manager.TranslateAny(v.GetStart(), declarations), manager.TranslateAny(v.GetEnd(), declarations)); // s.setDeclarationList(declarations); return(s); }
public virtual Net.Vpc.Upa.Impl.Uql.Compiledexpression.DefaultCompiledExpression TranslateExpression(object o, Net.Vpc.Upa.Impl.Uql.ExpressionTranslationManager manager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { return(CompileURShift((Net.Vpc.Upa.Expressions.URShift)o, manager, declarations)); }
public override string GetSQL(object oo, Net.Vpc.Upa.Persistence.EntityExecutionContext qlContext, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) /* throws Net.Vpc.Upa.Exceptions.UPAException */ { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledInSelection o = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledInSelection)oo; Net.Vpc.Upa.Impl.Uql.Compiledexpression.DefaultCompiledExpression[] left = o.GetLeft(); Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect query = o.GetSelection(); if (left.Length == 1) { string q = sqlManager.GetSQL(left[0], qlContext, declarations) + " in (" + sqlManager.GetSQL(query, qlContext, declarations) + ")"; return('(' + q + ')'); } Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledUplet uplet = new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledUplet(left); System.Text.StringBuilder stringBuffer = new System.Text.StringBuilder(sqlManager.GetSQL(uplet, qlContext, declarations)); stringBuffer.Append(" In ("); stringBuffer.Append(sqlManager.GetSQL(query, qlContext, declarations)); stringBuffer.Append(")"); return('(' + stringBuffer.ToString() + ')'); }
public override string GetSQL(object oo, Net.Vpc.Upa.Persistence.EntityExecutionContext context, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) /* throws Net.Vpc.Upa.Exceptions.UPAException */ { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledInsert o = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledInsert)oo; // PersistenceUnitManager persistenceManager = context.getPersistenceStore(); Net.Vpc.Upa.Entity entity = context.GetPersistenceUnit().GetEntity(o.GetEntity().GetName()); string n = context.GetPersistenceStore().GetValidIdentifier(context.GetPersistenceStore().GetPersistenceName(entity)); System.Text.StringBuilder sb = new System.Text.StringBuilder("Insert Into " + n); sb.Append("("); System.Text.StringBuilder sbVals = new System.Text.StringBuilder(); bool isFirst = true; int max = o.CountFields(); for (int i = 0; i < max; i++) { if (isFirst) { isFirst = false; } else { sb.Append(", "); sbVals.Append(", "); } sb.Append(sqlManager.GetSQL(o.GetField(i), context, declarations)); sbVals.Append(sqlManager.GetSQL(o.GetFieldValue(i), context, declarations)); } return(sb.Append(") Values (").Append(sbVals).Append(")").ToString()); }
protected internal virtual void AppendFrom(Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect o, System.Text.StringBuilder sb, Net.Vpc.Upa.Persistence.EntityExecutionContext context, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledNameOrSelect entity = o.GetEntity(); if (entity == null) { string fns = GetFromNullString(); if (fns != null) { sb.Append(" "); sb.Append(fns); } } else { sb.Append(" From "); if (entity is Net.Vpc.Upa.Expressions.Select) { sb.Append(sqlManager.GetSQL(entity, context, declarations)); } else { Net.Vpc.Upa.Persistence.PersistenceStore persistenceStore = context.GetPersistenceStore(); Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledEntityName entityName = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledEntityName)entity; Net.Vpc.Upa.Entity e = context.GetPersistenceUnit().GetEntity(entityName.GetName()); if (entityName.IsUseView() && e.NeedsView() && persistenceStore.IsViewSupported()) { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledEntityName v = new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledEntityName(e.GetName(), true); sb.Append(sqlManager.GetSQL(v, context, declarations)); } else { sb.Append(sqlManager.GetSQL(entityName, context, declarations)); } } } if (o.GetEntityAlias() != null) { Net.Vpc.Upa.Persistence.PersistenceStore store = context.GetPersistenceStore(); sb.Append(" ").Append(sqlManager.GetSQL(new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar(o.GetEntityAlias()), context, declarations)); } }
protected internal virtual void AppendJoins(Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect o, System.Text.StringBuilder sb, Net.Vpc.Upa.Persistence.EntityExecutionContext context, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { for (int i = 0; i < o.CountJoins(); i++) { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledJoinCriteria e = o.GetJoin(i); // String _valueString = sqlManager.getSQL(e.getEntity(), context, declarations); string _aliasString = e.GetEntityAlias(); string _joinKey = "Inner Join"; switch (e.GetJoinType()) { case Net.Vpc.Upa.Expressions.JoinType.INNER_JOIN: _joinKey = "Inner Join"; break; case Net.Vpc.Upa.Expressions.JoinType.FULL_JOIN: _joinKey = "Full Join"; break; case Net.Vpc.Upa.Expressions.JoinType.LEFT_JOIN: _joinKey = "Left Join"; break; case Net.Vpc.Upa.Expressions.JoinType.RIGHT_JOIN: _joinKey = "Right Join"; break; case Net.Vpc.Upa.Expressions.JoinType.CROSS_JOIN: _joinKey = "Cross Join"; break; } sb.Append(" ").Append(_joinKey).Append(" ").Append(sqlManager.GetSQL(e.GetEntity(), context, declarations)); if (_aliasString != null) { Net.Vpc.Upa.Persistence.PersistenceStore store = context.GetPersistenceStore(); // String goodAlias = store.getPersistenceName(, PersistenceNameType.ALIAS); sb.Append(" ").Append(sqlManager.GetSQL(new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar(_aliasString), context, declarations)); } if (e.GetCondition() != null && e.GetCondition().IsValid()) { sb.Append(" On ").Append(sqlManager.GetSQL(e.GetCondition(), context, declarations)); } } }
protected internal virtual void AppendOrderBy(Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect o, System.Text.StringBuilder sb, Net.Vpc.Upa.Persistence.EntityExecutionContext context, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { int max = o.CountOrderByItems(); if (max > 0) { sb.Append(" "); sb.Append("Order By "); for (int i = 0; i < max; i++) { if (i > 0) { sb.Append(", "); } sb.Append(sqlManager.GetSQL(o.GetOrderBy(i), context, declarations)); if (o.IsOrderAscending(i)) { sb.Append(" Asc "); } else { sb.Append(" Desc "); } } } }
public override string GetSQL(object oo, Net.Vpc.Upa.Persistence.EntityExecutionContext context, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) /* throws Net.Vpc.Upa.Exceptions.UPAException */ { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect o = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect)oo; System.Text.StringBuilder sb = new System.Text.StringBuilder("Select "); AppendDistinct(o, sb, context, sqlManager, declarations); AppendFields(o, sb, context, sqlManager, declarations); AppendFrom(o, sb, context, sqlManager, declarations); AppendJoins(o, sb, context, sqlManager, declarations); AppendWhere(o, sb, context, sqlManager, declarations); AppendGroupBy(o, sb, context, sqlManager, declarations); AppendHaving(o, sb, context, sqlManager, declarations); AppendOrderBy(o, sb, context, sqlManager, declarations); return(sb.ToString()); }
protected internal virtual void AppendHaving(Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect o, System.Text.StringBuilder sb, Net.Vpc.Upa.Persistence.EntityExecutionContext context, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { Net.Vpc.Upa.Impl.Uql.Compiledexpression.DefaultCompiledExpression hav = o.GetHaving(); if (hav != null && hav.IsValid()) { sb.Append(" Having ").Append(sqlManager.GetSQL(hav, context, declarations)); } }
protected internal virtual void AppendWhere(Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect o, System.Text.StringBuilder sb, Net.Vpc.Upa.Persistence.EntityExecutionContext context, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { AppendWhere(o.GetWhere(), sb, context, sqlManager, declarations); }
protected internal virtual void AppendWhere(Net.Vpc.Upa.Impl.Uql.Compiledexpression.DefaultCompiledExpression cond, System.Text.StringBuilder sb, Net.Vpc.Upa.Persistence.EntityExecutionContext context, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { if (cond != null && cond.IsValid()) { sb.Append(" Where ").Append(sqlManager.GetSQL(cond, context, declarations)); } }
public override string GetSQL(object oo, Net.Vpc.Upa.Persistence.EntityExecutionContext qlContext, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledTypeName o = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledTypeName)oo; return(GetSqlTypeName(o.GetTypeTransform().GetTargetType())); }
public override string GetSQL(object oo, Net.Vpc.Upa.Persistence.EntityExecutionContext qlContext, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) /* throws Net.Vpc.Upa.Exceptions.UPAException */ { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledBinaryOperatorExpression o = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledBinaryOperatorExpression)oo; string leftValue = o.GetLeft() != null?sqlManager.GetSQL(o.GetLeft(), qlContext, declarations) : "NULL"; string rightValue = o.GetRight() != null?sqlManager.GetSQL(o.GetRight(), qlContext, declarations) : "NULL"; string s = null; switch (o.GetOperator()) { case Net.Vpc.Upa.Expressions.BinaryOperator.AND: { s = leftValue + " And " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.OR: { s = leftValue + " Or " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.BIT_AND: { s = leftValue + " & " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.LSHIFT: { s = leftValue + " << " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.BIT_OR: { s = leftValue + " | " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.RSHIFT: { s = leftValue + " >> " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.URSHIFT: { s = leftValue + " >>> " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.XOR: { s = leftValue + " ^ " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.DIFF: { if ("NULL".Equals(rightValue, System.StringComparison.InvariantCultureIgnoreCase)) { s = leftValue + " IS NOT " + rightValue; } else { s = leftValue + " <> " + rightValue; } break; } case Net.Vpc.Upa.Expressions.BinaryOperator.EQ: { if ("NULL".Equals(rightValue, System.StringComparison.InvariantCultureIgnoreCase)) { s = leftValue + " IS " + rightValue; } else { s = leftValue + " = " + rightValue; } break; } case Net.Vpc.Upa.Expressions.BinaryOperator.GT: { s = leftValue + " > " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.GE: { s = leftValue + " >= " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.LT: { s = leftValue + " < " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.LE: { s = leftValue + " < " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.PLUS: { s = leftValue + " + " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.MINUS: { s = leftValue + " - " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.MUL: { s = leftValue + " * " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.DIV: { s = leftValue + " - " + rightValue; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.REM: { s = "{fn mod(" + leftValue + "," + rightValue + " )}"; break; } case Net.Vpc.Upa.Expressions.BinaryOperator.LIKE: { //escape seems to be not supported with '*' wildcard //s=leftValue+" Like "+rightValue+" {escape '*'} "; s = leftValue + " Like " + rightValue + " "; break; } default: { throw new System.ArgumentException("Not Supported Yet"); } } return("(" + s + ")"); }
protected internal virtual Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledDelete CompileDelete(Net.Vpc.Upa.Expressions.Delete v, Net.Vpc.Upa.Impl.Uql.ExpressionTranslationManager manager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { if (v == null) { return(null); } Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledDelete s = new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledDelete(); s.From(v.GetEntity().GetName()); s.Where(manager.TranslateAny(v.GetCondition(), declarations)); return(s); }
protected internal virtual Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledCoalesce CompileCoalesce(Net.Vpc.Upa.Expressions.Coalesce v, Net.Vpc.Upa.Impl.Uql.ExpressionTranslationManager manager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { if (v == null) { return(null); } Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledCoalesce s = new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledCoalesce(manager.TranslateArray(v.GetArguments(), declarations)); // s.setDeclarationList(declarations); return(s); }
protected internal virtual Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledParam CompileVal(Net.Vpc.Upa.Expressions.Param v, Net.Vpc.Upa.Impl.Uql.ExpressionTranslationManager manager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { if (v == null) { return(null); } Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledParam s = new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledParam(v.IsUnspecified() ? null : v.GetValue(), v.GetName(), null, v.IsUnspecified()); // s.setDeclarationList(declarations); return(s); }
protected internal virtual Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledInsertSelection CompileInsertSelection(Net.Vpc.Upa.Expressions.InsertSelection v, Net.Vpc.Upa.Impl.Uql.ExpressionTranslationManager manager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { if (v == null) { return(null); } Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledInsertSelection s = new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledInsertSelection(); s.Into(v.GetEntity().GetName()); for (int i = 0; i < v.CountFields(); i++) { Net.Vpc.Upa.Expressions.Var fvar = v.GetField(i); s.Field(fvar.GetName()); } s.From((Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledQueryStatement)manager.TranslateAny(v.GetSelection(), declarations)); return(s); }
public virtual string GetSQL(Net.Vpc.Upa.Impl.Uql.Compiledexpression.DefaultCompiledExpression expression, Net.Vpc.Upa.Persistence.EntityExecutionContext context, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) /* throws Net.Vpc.Upa.Exceptions.UPAException */ { // if (context == null) { // context = createContext(ContextOperation.FIND); // } if (expression != null) { Net.Vpc.Upa.Impl.Persistence.SQLProvider p = sqlProviders.Get(expression.GetType()); if (p != null) { return(p.GetSQL(expression, context, this, declarations)); } } throw new System.Exception(System.Convert.ToString(expression)); }
public override string GetSQL(object oo, Net.Vpc.Upa.Persistence.EntityExecutionContext qlContext, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) /* throws Net.Vpc.Upa.Exceptions.UPAException */ { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledBetween o = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledBetween)oo; string s = sqlManager.GetSQL(o.GetLeft(), qlContext, declarations) + " Between " + sqlManager.GetSQL(o.GetMin(), qlContext, declarations) + " And " + sqlManager.GetSQL(o.GetMax(), qlContext, declarations); return("(" + s + ")"); }
public virtual Net.Vpc.Upa.Impl.Uql.Compiledexpression.DefaultCompiledExpression TranslateExpression(object o, Net.Vpc.Upa.Impl.Uql.ExpressionTranslationManager manager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { Net.Vpc.Upa.Expressions.Negative v = (Net.Vpc.Upa.Expressions.Negative)o; if (v == null) { return(null); } return(new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledNegative(manager.TranslateAny(v.GetExpression(), declarations))); }
protected internal virtual Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar CompileVar(Net.Vpc.Upa.Expressions.Var v, Net.Vpc.Upa.Impl.Uql.ExpressionTranslationManager manager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { if (v == null) { return(null); } Net.Vpc.Upa.Expressions.CompiledExpression p = null; if (v.GetApplier() != null) { p = manager.TranslateAny(v.GetApplier(), declarations); } if (p == null) { return(new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar(v.GetName())); } else { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar r = new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar(v.GetName()); if (p is Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar) { ((Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar)((Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar)p).GetFinest()).SetChild(r); return((Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar)p); } else { throw new Net.Vpc.Upa.Exceptions.UPAException("Unsupported"); } } }
protected internal virtual Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledURShift CompileURShift(Net.Vpc.Upa.Expressions.URShift v, Net.Vpc.Upa.Impl.Uql.ExpressionTranslationManager manager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { if (v == null) { return(null); } Net.Vpc.Upa.Impl.Uql.Compiledexpression.DefaultCompiledExpression left = manager.TranslateAny(v.GetLeft(), declarations); Net.Vpc.Upa.Impl.Uql.Compiledexpression.DefaultCompiledExpression right = manager.TranslateAny(v.GetRight(), declarations); Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledURShift s = new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledURShift(left, right); // s.setDeclarationList(new ExpressionDeclarationList(declarations)); return(s); }
protected internal virtual Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledCurrentDate CompileCurrentDate(Net.Vpc.Upa.Expressions.CurrentDate v, Net.Vpc.Upa.Impl.Uql.ExpressionTranslationManager manager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { if (v == null) { return(null); } Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledCurrentDate s = new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledCurrentDate(); // s.setDeclarationList(declarations); return(s); }
public override string GetSQL(object oo, Net.Vpc.Upa.Persistence.EntityExecutionContext context, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) /* throws Net.Vpc.Upa.Exceptions.UPAException */ { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledUpdate o = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledUpdate)oo; Net.Vpc.Upa.Persistence.PersistenceStore persistenceStore = context.GetPersistenceStore(); Net.Vpc.Upa.PersistenceUnit pu = context.GetPersistenceUnit(); Net.Vpc.Upa.Entity entity = pu.GetEntity(o.GetEntity().GetName()); // String persistenceName = persistenceStore.getPersistenceName(entity); System.Text.StringBuilder sb = new System.Text.StringBuilder("Update " + sqlManager.GetSQL(new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledEntityName(entity.GetName()), context, declarations)); string tableAlias = o.GetEntityAlias(); if (tableAlias != null) { sb.Append(" "); sb.Append(sqlManager.GetSQL(new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar(tableAlias), context, declarations)); } sb.Append(" Set "); bool isFirst = true; int max = o.CountFields(); for (int i = 0; i < max; i++) { Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar vv = o.GetField(i); Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar ev = null; Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar fv = null; if (vv.GetChild() == null) { ev = null; fv = vv; } else { ev = vv; fv = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar)vv.GetChild(); } Net.Vpc.Upa.Impl.Uql.Compiledexpression.DefaultCompiledExpression fieldValue = o.GetFieldValue(i); // Object referrer = vv.getReferrer(); Net.Vpc.Upa.Field f = ((Net.Vpc.Upa.Field)fv.GetReferrer()); Net.Vpc.Upa.Entity entityManager = f.GetEntity(); System.Collections.Generic.IList <Net.Vpc.Upa.PrimitiveField> primFields = entityManager.ToPrimitiveFields <Net.Vpc.Upa.EntityPart>(new System.Collections.Generic.List <Net.Vpc.Upa.EntityPart>(new[] { (Net.Vpc.Upa.EntityPart)f })); foreach (Net.Vpc.Upa.PrimitiveField primField in primFields) { if (isFirst) { isFirst = false; } else { sb.Append(", "); } if (ev != null) { sb.Append(sqlManager.GetSQL(new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar(ev.GetName()), context, declarations)).Append("."); } sb.Append(sqlManager.GetSQL(new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar(primField), context, declarations)); sb.Append("=").Append("(").Append(sqlManager.GetSQL(fieldValue, context, declarations)).Append(")"); } } if (o.GetCondition() != null && o.GetCondition().IsValid()) { sb.Append(" Where ").Append(sqlManager.GetSQL(o.GetCondition(), context, declarations)); } if (persistenceStore.IsViewSupported() && entity.NeedsView() && o.GetEntity().IsUseView()) { string implicitTableAlias = persistenceStore.GetPersistenceName("IT_" + entity.GetName(), Net.Vpc.Upa.Persistence.PersistenceNameType.ALIAS); sb.Append(" "); sb.Append(sqlManager.GetSQL(new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledEntityName(entity.GetName()), context, declarations)).Append(" ").Append(implicitTableAlias).Append(",").Append(sqlManager.GetSQL(new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledEntityName(entity.GetName(), true), context, declarations)).Append(" ").Append(sqlManager.GetSQL(new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledVar(tableAlias), context, declarations)); } // if (extraFrom != null) return(sb.ToString()); }
protected internal virtual Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledMax CompileMax(Net.Vpc.Upa.Expressions.Max v, Net.Vpc.Upa.Impl.Uql.ExpressionTranslationManager manager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { if (v == null) { return(null); } Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledMax s = new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledMax(manager.TranslateAny(v.GetArgument(0), declarations)); // s.setDeclarationList(declarations); return(s); }
public virtual string Simplify(Net.Vpc.Upa.Persistence.EntityExecutionContext ctx, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations, params Net.Vpc.Upa.Impl.Uql.Compiledexpression.DefaultCompiledExpression [] @params) /* throws Net.Vpc.Upa.Exceptions.UPAException */ { string[] p = new string[@params.Length]; for (int i = 0; i < p.Length; i++) { p[i] = sqlManager.GetSQL(@params[i], ctx, declarations); } return(Simplify((GetExpressionType()).Name, p, null)); }
protected internal virtual void AppendDistinct(Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect o, System.Text.StringBuilder sb, Net.Vpc.Upa.Persistence.EntityExecutionContext context, Net.Vpc.Upa.Impl.Persistence.SQLManager sqlManager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations) { if (o.IsDistinct()) { sb.Append(" DISTINCT"); } }