private static Net.Vpc.Upa.Expressions.QueryStatement CreateViewQuery(string name, string[] tables, string updatableTableFieldName, System.Collections.Generic.IList <string> viewFields, string[][] fieldsMapping)
{
// StringBuilder sb=new StringBuilder("");
if (tables.Length < 2)
{
if (tables.Length == 0)
{
throw new System.ArgumentException("UnionTableUpdatableView must be over at least a couple of entities");
}
System.Console.Error.WriteLine("[WARNING] UnionTableUpdatableView must be over at least a couple of tables");
}
if (fieldsMapping != null && tables.Length != fieldsMapping.Length)
{
throw new System.ArgumentException("tables.length!=fieldsMapping.length");
}
Net.Vpc.Upa.Expressions.Union u = new Net.Vpc.Upa.Expressions.Union();
for (int i = 0; i < tables.Length; i++)
{
if (fieldsMapping != null && (viewFields).Count != fieldsMapping[i].Length)
{
throw new System.ArgumentException("UnionTableUpdatableView " + name + " requires " + (viewFields).Count + " fields but got " + fieldsMapping[i].Length + " for " + tables[i]);
}
Net.Vpc.Upa.Expressions.Select s = new Net.Vpc.Upa.Expressions.Select();
s.Field(new Net.Vpc.Upa.Expressions.Literal(tables[i]), updatableTableFieldName);
for (int j = 0; j < (viewFields).Count; j++)
{
string viewField = viewFields[j];
string varName = fieldsMapping == null ? viewField : fieldsMapping[i][j];
s.Field(new Net.Vpc.Upa.Expressions.Var(varName), viewField);
}
s.From(tables[i]);
u.Add(s);
}
return(u);
}
public virtual Net.Vpc.Upa.Impl.Persistence.QueryExecutor Execute() /* throws Net.Vpc.Upa.Exceptions.UPAException */
{
int c1 = 0;
int c2 = 0;
string oldAlias = baseExpression.GetEntityAlias();
if (oldAlias == null)
{
oldAlias = entity.GetName();
}
bool replaceThis = !"this".Equals(oldAlias);
if (baseExpression.CountFields() > 0)
{
if (replaceThis)
{
Net.Vpc.Upa.Impl.Uql.Util.UQLUtils.ReplaceThisVar(baseExpression, oldAlias, context.GetPersistenceUnit());
}
c1 = defaultPersistenceStore.CreateDefaultExecutor(baseExpression, parametersByName, parametersByIndex, updatable, defaultFieldFilter, context).Execute().GetResultCount();
}
if ((complexVals).Count > 0)
{
Net.Vpc.Upa.Expressions.Select q = new Net.Vpc.Upa.Expressions.Select();
foreach (Net.Vpc.Upa.Field primaryField in entity.GetPrimaryFields())
{
q.Field(primaryField.GetName());
}
foreach (Net.Vpc.Upa.Expressions.VarVal f in complexVals)
{
Net.Vpc.Upa.Expressions.Expression fieldExpression = f.GetVal();
if (replaceThis)
{
Net.Vpc.Upa.Impl.Uql.Util.UQLUtils.ReplaceThisVar(fieldExpression, oldAlias, context.GetPersistenceUnit());
}
q.Field(fieldExpression, f.GetVar().GetName());
}
q.From(entity.GetName(), oldAlias);
Net.Vpc.Upa.Expressions.Expression cond = baseExpression.GetCondition();
q.SetWhere(cond == null ? null : cond.Copy());
Net.Vpc.Upa.EntityBuilder eb = entity.GetBuilder();
foreach (Net.Vpc.Upa.Record record in entity.GetPersistenceUnit().CreateQuery(q).GetRecordList())
{
Net.Vpc.Upa.Expressions.Update u2 = new Net.Vpc.Upa.Expressions.Update();
u2.Entity(entityName);
foreach (Net.Vpc.Upa.Expressions.VarVal f in complexVals)
{
string fname = f.GetVar().GetName();
u2.Set(fname, record.GetObject <T>(fname));
}
Net.Vpc.Upa.Expressions.Expression exprId = eb.ObjectToIdExpression(record, oldAlias);
u2.Where(exprId);
c2 += defaultPersistenceStore.CreateDefaultExecutor(u2, parametersByName, parametersByIndex, updatable, defaultFieldFilter, context).Execute().GetResultCount();
}
}
resultCount = System.Math.Max(c1, c2);
return(this);
}
public DefaultQuery(Net.Vpc.Upa.Expressions.EntityStatement query, Net.Vpc.Upa.Entity defaultEntity, Net.Vpc.Upa.Persistence.EntityExecutionContext context)
{
this.query = query;
if (defaultEntity != null)
{
if (query is Net.Vpc.Upa.Expressions.Select)
{
Net.Vpc.Upa.Expressions.Select select = (Net.Vpc.Upa.Expressions.Select)query;
if (select.GetEntity() == null)
{
select.From(defaultEntity.GetName());
}
}
else if (query is Net.Vpc.Upa.Expressions.Insert)
{
if (((Net.Vpc.Upa.Expressions.Insert)query).GetEntity() == null)
{
((Net.Vpc.Upa.Expressions.Insert)query).Into(defaultEntity.GetName());
}
}
else if (query is Net.Vpc.Upa.Expressions.Update)
{
if (((Net.Vpc.Upa.Expressions.Update)query).GetEntity() == null)
{
((Net.Vpc.Upa.Expressions.Update)query).Entity(defaultEntity.GetName());
}
}
else if (query is Net.Vpc.Upa.Expressions.Delete)
{
if (((Net.Vpc.Upa.Expressions.Delete)query).GetEntity() == null)
{
((Net.Vpc.Upa.Expressions.Delete)query).From(defaultEntity.GetName());
}
}
}
this.context = context;
// this.cquery = (CompiledEntityStatement) query.copy();
// this.defaultEntity = defaultEntity;
store = (Net.Vpc.Upa.Impl.Persistence.DefaultPersistenceStore)context.GetPersistenceStore();
}
private object GetNavigateKey(Net.Vpc.Upa.Entity entity, object id, char @operator) /* throws Net.Vpc.Upa.Exceptions.UPAException */
{
System.Collections.Generic.IList <Net.Vpc.Upa.Field> pk = entity.GetPrimaryFields();
if ((pk).Count == 1)
{
Net.Vpc.Upa.Expressions.Select s = new Net.Vpc.Upa.Expressions.Select().From(entity.GetName());
s.From(entity.GetName());
string fieldName = pk[0].GetName();
if (id != null)
{
object[] @value = entity.GetBuilder().IdToKey(id).GetValue();
if (@operator == '<')
{
s.Field(new Net.Vpc.Upa.Expressions.Max(new Net.Vpc.Upa.Expressions.Var(fieldName)), "next");
s.SetWhere(new Net.Vpc.Upa.Expressions.LessThan(new Net.Vpc.Upa.Expressions.Var(fieldName), new Net.Vpc.Upa.Expressions.Param(null, @value[0])));
}
else if (@operator == '>')
{
s.Field(new Net.Vpc.Upa.Expressions.Min(new Net.Vpc.Upa.Expressions.Var(fieldName)), "next");
s.SetWhere(new Net.Vpc.Upa.Expressions.GreaterThan(new Net.Vpc.Upa.Expressions.Var(fieldName), new Net.Vpc.Upa.Expressions.Param(null, @value[0])));
}
else
{
throw new System.Exception("WouldNeverBeThrownException");
}
}
else
{
if (@operator == '<')
{
s.Field(new Net.Vpc.Upa.Expressions.Min(new Net.Vpc.Upa.Expressions.Var(fieldName)), "next");
}
else if (@operator == '>')
{
s.Field(new Net.Vpc.Upa.Expressions.Max(new Net.Vpc.Upa.Expressions.Var(fieldName)), "next");
}
else
{
throw new System.Exception("WouldNeverBeThrownException");
}
}
Net.Vpc.Upa.Record next = entity.GetPersistenceUnit().CreateQuery(s).GetRecord();
if (next != null)
{
object o = next.GetObject <T>("next");
if (o != null)
{
return(entity.CreateId(o));
}
}
return(null);
}
else
{
object[] v;
Net.Vpc.Upa.Expressions.Select sb = new Net.Vpc.Upa.Expressions.Select();
sb.Top(1);
foreach (Net.Vpc.Upa.Field aPk in pk)
{
sb.Field(new Net.Vpc.Upa.Expressions.Var(aPk.GetName()));
}
sb.From(entity.GetName());
if (id != null)
{
object[] @value = entity.GetBuilder().IdToKey(id).GetValue();
Net.Vpc.Upa.Expressions.Expression or = null;
for (int i = 0; i < (pk).Count; i++)
{
Net.Vpc.Upa.Field pki = pk[i];
Net.Vpc.Upa.Expressions.Expression a = null;
for (int j = 0; j < i; j++)
{
Net.Vpc.Upa.Field pkj = pk[j];
Net.Vpc.Upa.Expressions.Expression e = (new Net.Vpc.Upa.Expressions.Equals(new Net.Vpc.Upa.Expressions.Var(pkj.GetName()), (new Net.Vpc.Upa.Expressions.Param(null, @value[j]))));
a = (a == null) ? ((Net.Vpc.Upa.Expressions.Expression)(e)) : new Net.Vpc.Upa.Expressions.And(a, e);
}
Net.Vpc.Upa.Expressions.Expression e2 = new Net.Vpc.Upa.Expressions.LessThan(new Net.Vpc.Upa.Expressions.Var(pki.GetName()), new Net.Vpc.Upa.Expressions.Param(null, @value[i]));
a = (a == null) ? ((Net.Vpc.Upa.Expressions.Expression)(e2)) : new Net.Vpc.Upa.Expressions.And(a, e2);
or = or == null ? ((Net.Vpc.Upa.Expressions.Expression)(a)) : new Net.Vpc.Upa.Expressions.Or(or, a);
}
sb.SetWhere(or);
}
foreach (Net.Vpc.Upa.Field aPk in pk)
{
sb.OrderBy(new Net.Vpc.Upa.Expressions.Var(aPk.GetName()), @operator == '>');
}
Net.Vpc.Upa.Record r = entity.GetPersistenceUnit().CreateQuery(sb).GetRecord();
if (r != null)
{
object[] k = new object[(pk).Count];
for (int i = 0; i < k.Length; i++)
{
k[i] = r.GetObject <T>(pk[i].GetName());
}
return(entity.CreateId(k));
}
}
return(null);
}