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());
}
public virtual Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledInsert AddQuery(Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledInsert other)
{
if (other == null)
{
return(this);
}
if (other.entity != null)
{
entity = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledEntityName)other.entity.Copy();
ExportDeclaration(null, Net.Vpc.Upa.Impl.Uql.DecObjectType.ENTITY, entity.GetName(), null);
PrepareChildren(entity);
}
for (int i = 0; i < (other.fields).Count; i++)
{
Set(other.GetField(i).GetName(), other.GetFieldValue(i).Copy());
}
return(this);
}
