/// <summary>
/// 使用临时表形式，生成删除若干数据对象（多个主键）语句，
/// 要求数据库拥有<see cref="EDbCapable.TemporaryTable"/>
/// 和<see cref="EDbCapable.ModifyJoin"/>两个特性。
/// </summary>
/// <param name="context">生成上下文。</param>
/// <returns>语句片段。</returns>
protected virtual SqlFragment GenerateForInsertTempTable(GenerateContext context)
{
var data = (GenerateDataForInsert)context.Data;
var members = data.GetTables().SelectMany(a => a.Members);
var createtable = new CreateTempTableFragment(context, members);
var temptable = createtable.Table;
var insert = new InsertValueFragment(context, temptable, data.CommitObject, data.Items);
var mainunit = (CommitKeyUnit)data.MainUnit;
mainunit.Keys.ForEach(member => GenerateForInsertMembers(insert, member));
data.CommitObject.Parent = insert;
foreach (var unit in data.GetUnits())
{
unit.Members.ForEach(member => GenerateForInsertMembers(insert, member));
}
var block = new BlockFragment(context, createtable, insert);
InsertFragment mainInsert = null;
foreach (var unit in data.GetUnits().OfType <CommitKeyUnit>())
{
mainInsert = context.Insert(temptable, unit);
block.Add(mainInsert);
}
GenerateForInsertReturnStatement(context, block, mainInsert.Target, temptable);
return(block);
}
internal static InsertValueFragment InsertTemptable(this ContentBase data, TemporaryTableFragment temptable, IEnumerable <CommitMember> members)
{
var context = data.GenerateContext;
var insert = new InsertValueFragment(context, temptable, data.CommitObject, data.Items);
data.CommitObject.Parent = insert;
members.ForEach(member => SetCommitMember(insert, member));
return(insert);
}
internal static InsertValueFragment InsertUnit(this ContentBase data, CommitIdentityUnit unit, DbName name = null)
{
var context = data.GenerateContext;
var target = new TableFragment(context, unit.Table, name);
var insert = new InsertValueFragment(context, target, data.CommitObject, data.Items);
data.CommitObject.Parent = insert;
unit.Members.ForEach(member => SetCommitMember(insert, member));
return(insert);
}
/// <summary>
/// 生成添加若干复合关系对象语句。
/// </summary>
/// <param name="context">生成上下文。</param>
/// <returns>语句片段。</returns>
protected virtual SqlFragment GenerateForRelationInsert(GenerateContext context)
{
var data = (RelationContent)context.Data;
var metadata = (CompositeNavigateMetadata)data.Items.Navigate;
var target = new TableFragment(context, data.Table);
var insert = new InsertValueFragment(context, target, data.CommitObject, data.Items);
metadata.Pairs.ForEach(pair => insert.SetValue(pair.ForeignKey, data.CommitObject.GetMember(pair.PrincipalKey)));
metadata.CompositePairs.ForEach(pair => insert.SetValue(pair.ForeignKey, data.CommitObject.GetMember(pair.PrincipalKey)));
return(insert);
}
/// <summary>
/// 使用临时表形式，生成插入单个数据对象语句，对象的主键是标识列，
/// 要求数据库拥有<see cref="EDbCapable.TemporaryTable"/>
/// 和<see cref="EDbCapable.ModifyJoin"/>两个特性。
/// </summary>
/// <param name="context">生成上下文。</param>
/// <returns>语句片段。</returns>
protected virtual SqlFragment GenerateForInsertIdentityTempTable(GenerateContext context)
{
var data = (GenerateDataForInsert)context.Data;
var mainunit = (CommitIdentityUnit)data.MainUnit;
var members = data.GetTables().SelectMany(a => a.Members).ToList();
var rowindex = new ColumnMetadata(data.Table, SupportMembers.DbMembers.CustomRowIndex,
members.Select(a => a.Name).Unique("RowIndex"));
members.Add(rowindex);
var createtable = new CreateTempTableFragment(context, members);
var temptable = createtable.Table;
var insert = new InsertValueFragment(context, temptable, data.CommitObject, data.Items);
data.CommitObject.Parent = insert;
foreach (var unit in data.GetUnits())
{
unit.Members.ForEach(member => GenerateForInsertMembers(insert, member));
}
insert.SetValue(mainunit.Identity.Metadata, new SimpleFragment(context, "0"));
var rowindexfragment = new RowIndexFragment(context);
insert.SetValue(rowindex, rowindexfragment);
TableFragment whileTarget = null;
BlockFragment block = null;
if (context.Feature.HasCapable(EDbCapable.ExternalCompoundStatement))
{
var index = new CreateVariableFragment(context, typeof(int));
var whilefragment = GenerateForInsertIdentityMultipleWhile(context, mainunit, index,
rowindex, createtable.Table, rowindexfragment, out whileTarget);
block = new BlockFragment(context, index, createtable, insert,
context.Assign(index.Name, context.StatementString("1")), whilefragment);
}
else
{
var repeatfragment = GenerateForInsertIdentityMultipleRepeat(context, mainunit,
rowindex, createtable.Table, rowindexfragment, data, out whileTarget);
block = new BlockFragment(context, createtable, insert, repeatfragment);
}
if (data.SubUnits != null)
{
foreach (var unit in data.SubUnits)
{
block.Add(context.Insert(createtable.Table, unit));
}
}
GenerateForInsertReturnStatement(context, block, whileTarget, createtable.Table);
return(block);
}
private static void SetCommitMember(this InsertValueFragment insert, CommitMember member)
{
switch (member.ValueType)
{
case ECommitValueType.Constant:
insert.SetValue(member.Metadata);
break;
case ECommitValueType.Expression:
var exp = (CommitExpressionMember)member;
insert.SetValue(member.Metadata, insert.CreateExpression(exp.Expression));
break;
}
}
/// <summary>
/// 使用临时表形式，生成删除多个复合关系的语句，
/// 要求数据库拥有<see cref="EDbCapable.TemporaryTable"/>
/// 和<see cref="EDbCapable.ModifyJoin"/>两个特性。
/// </summary>
/// <param name="context">生成上下文。</param>
/// <returns>语句片段。</returns>
protected virtual SqlFragment GenerateForRelationDeleteTempTable(GenerateContext context)
{
var data = (RelationContent)context.Data;
var composite = (CompositeNavigateMetadata)data.Items.Navigate;
var createtemptable = new CreateTempTableFragment(context,
composite.Pairs.Select(a => a.ForeignKey).Concat(composite.CompositePairs.Select(a => a.ForeignKey)));
var insert = new InsertValueFragment(context, createtemptable.Table, data.CommitObject, data.Items);
composite.Pairs.ForEach(pair => insert.SetValue(pair.ForeignKey, data.CommitObject.GetMember(pair.PrincipalKey)));
composite.CompositePairs.ForEach(pair => insert.SetValue(pair.ForeignKey, data.CommitObject.GetMember(pair.PrincipalKey)));
var temptable = createtemptable.Table;
var target = new TableFragment(context, data.Table);
var delete = new DeleteFragment(context, target);
delete.AddSource(temptable);
target.Join(temptable, composite.Pairs.Select(a => a.ForeignKey).Concat(composite.CompositePairs.Select(a => a.ForeignKey)));
return(new BlockFragment(context, createtemptable, insert, delete));
}
/// <summary>
/// 生成插入若干数据对象语句。
/// </summary>
/// <param name="context">生成上下文。</param>
/// <returns>语句片段。</returns>
protected virtual SqlFragment GenerateForInsertSimple(GenerateContext context)
{
var data = (GenerateDataForInsert)context.Data;
var name = data.TargetName;
var block = new BlockFragment(context);
var mainunit = (CommitKeyUnit)data.MainUnit;
InsertValueFragment mainInsert = null;
foreach (var unit in data.GetUnits().OfType <CommitKeyUnit>())
{
var target = new TableFragment(context, unit.Table, name);
var insert = new InsertValueFragment(context, target, data.CommitObject, data.Items);
data.CommitObject.Parent = insert;
unit.Keys.Concat(unit.Members).ForEach(member => GenerateForInsertMembers(insert, member));
block.Add(insert);
mainInsert = insert;
}
GenerateForInsertReturnStatement(context, block, mainInsert.Target, null);
return(block);
}
/// <summary>
/// 使用临时表形式，生成更新关系语句，
/// 要求数据库拥有<see cref="EDbCapable.TemporaryTable"/>
/// 和<see cref="EDbCapable.ModifyJoin"/>两个特性。
/// </summary>
/// <param name="context">生成上下文。</param>
/// <returns>语句片段。</returns>
protected virtual SqlFragment GenerateForRelationUpdateTempTable(GenerateContext context)
{
var data = (RelationContent)context.Data;
var metadata = data.Items.Navigate;
var block = new BlockFragment(context);
var createtemptable = new CreateTempTableFragment(context,
data.IsAddRelation ? data.Source.Keys.Concat(metadata.Pairs.Select(a => a.ForeignKey)) : data.Source.Keys);
var insert = new InsertValueFragment(context, createtemptable.Table, data.CommitObject, data.Items);
data.Source.Keys.ForEach(key => insert.SetValue(key));
if (data.IsAddRelation)
{
metadata.Pairs.ForEach(
pair => insert.SetValue(pair.ForeignKey, data.CommitObject.GetMember(pair.PrincipalKey)));
}
var temptable = createtemptable.Table;
var update = new UpdateFragment(context, data.Table);
update.AddSource(update.Target, temptable);
if (data.IsAddRelation)
{
foreach (var pair in metadata.Pairs)
{
update.SetValue(pair.ForeignKey, temptable.GetMember(pair.ForeignKey));
}
}
else
{
var nullfargment = new SimpleFragment(context, "NULL");
foreach (var pair in metadata.Pairs)
{
update.SetValue(pair.ForeignKey, nullfargment);
}
}
update.Target.Join(temptable, data.Table.Keys);
return(new BlockFragment(context, createtemptable, insert, update));
}
/// <summary>
/// 生成插入单个数据对象语句，对象的主键是标识列。
/// </summary>
/// <param name="context">生成上下文。</param>
/// <returns>语句片段。</returns>
protected virtual SqlFragment GenerateForInsertIdentitySingle(GenerateContext context)
{
var getidentity = context.Translate(Expression.Call(null, SupportMembers.DbFunctions.GetIdentity));
var data = (GenerateDataForInsert)context.Data;
var identityunit = (CommitIdentityUnit)data.MainUnit;
var keyVars = new Dictionary <ColumnMetadata, VariableFragment>();
var identityCreate = new CreateVariableFragment(context, identityunit.Identity.Metadata.Member.PropertyType);
keyVars.Add(identityunit.Identity.Metadata, identityCreate.Name);
var block = new BlockFragment(context);
if (!context.Feature.HasCapable(EDbCapable.ImplicitDeclareVariable))
{
block.Add(identityCreate);
}
var name = data.TargetName;
var maintarget = new TableFragment(context, identityunit.Table, name);
{
var insert = new InsertValueFragment(context, maintarget, data.CommitObject, data.Items);
data.CommitObject.Parent = insert;
identityunit.Members.ForEach(member =>
{
if (member.Metadata.IsKey && member.ValueType == ECommitValueType.Expression)
{
var expMember = (CommitExpressionMember)member;
var exp = insert.CreateExpression(expMember.Expression);
var expVar = new CreateVariableFragment(context, member.Metadata.Member.PropertyType);
block.Add(expVar);
block.Add(context.Assign(expVar.Name, exp));
keyVars.Add(member.Metadata, expVar.Name);
}
else
{
GenerateForInsertMembers(insert, member);
}
});
block.Add(insert);
block.Add(context.Assign(identityCreate.Name, insert.CreateExpression(getidentity)));
}
if (data.SubUnits != null)
{
foreach (var unit in data.SubUnits)
{
var target = new TableFragment(context, unit.Table);
var insert = new InsertValueFragment(context, target, data.CommitObject, data.Items);
data.CommitObject.Parent = insert;
unit.Keys.ForEach(member =>
{
if (keyVars.TryGetValue(member.Metadata, out VariableFragment value))
{
insert.SetValue(member.Metadata, value);
}
else
{
GenerateForInsertMembers(insert, member);
}
});
unit.Members.ForEach(member => GenerateForInsertMembers(insert, member));
block.Add(insert);
}
}
if (data.ReturnMembers.Any())
{
ISourceFragment target = maintarget;
if (data.SubUnits != null)
{
target = new InheritFragment(context, data.Table);
}
var select = new SelectFragment(context, target);
select.Members.AddRange(data.ReturnMembers.Select(a => target.GetMember(a.Metadata)));
select.Where = data.Table.Keys.Select(key => context.Equal(target.GetMember(key),
keyVars.ContainsKey(key) ? (IExpressionFragment)keyVars[key] : data.CommitObject.GetMember(key))).Merge();
block.Add(select);
}
return(block);
}