public void GetDeleteCommands(DmlfBatch res, DatabaseInfo db, ChangeSetModel model) { var table = db.FindTable(TargetTable); if (table == null) { return; } if (IsDuplicatingIdentity(db, model)) { var del = new DmlfDelete(); del.DeleteTarget = new DmlfSource { TableOrView = table.FullName, Alias = "basetbl", }; del.SingleFrom = new DmlfFromItem { Source = del.DeleteTarget }; GetConditions(del, this, Conditions, db); res.Commands.Add(del); } }
public void GetCommands(DmlfBatch res, DatabaseInfo db, ChangeSetModel model, bool allowCascade = true) { if (allowCascade && (DeleteReferencesCascade || model.DeleteReferencesCascade)) { var refs = GenerateCascadeDeletions(db); foreach (var item in refs) { item.GetCommands(res, db, model, false); } } if (model.DeleteReferencesCascade && model.DeleteSkipList != null && model.DeleteSkipList.Contains(TargetTable)) { return; } var cmd = new DmlfDelete(); cmd.DeleteTarget = new DmlfSource { TableOrView = TargetTable, LinkedInfo = LinkedInfo, Alias = "basetbl", }; cmd.From.Add(new DmlfFromItem { Source = cmd.DeleteTarget, }); if (!GetConditions(cmd, this, Conditions, db)) { return; } res.Commands.Add(cmd); }
public bool IsDuplicatingIdentity(DatabaseInfo db, ChangeSetModel model) { if (!UpdateReferences && !model.UpdateReferences) return false; if (!IsUpdatingPk(db)) return false; var table = db.FindTable(TargetTable); if (table == null) return false; var autoinc = table.FindAutoIncrementColumn(); return autoinc != null && Values.Any(x => x.Column == autoinc.Name); }
public static ChangeSetModel LoadFromFile(string fileName) { var doc = new XmlDocument(); doc.LoadXml(File.ReadAllText(fileName)); var res = new ChangeSetModel(); res.LoadProperties(doc.DocumentElement); return(res); }
public void GetInsertCommands(DmlfBatch res, DatabaseInfo db, ChangeSetModel model, IDialectDataAdapter dda, ICdlValueConvertor converter) { var table = db.FindTable(TargetTable); if (table == null) { return; } if (IsDuplicatingIdentity(db, model)) { res.AllowIdentityInsert(table.FullName, true); var insert = new DmlfInsertSelect { TargetTable = table.FullName, }; insert.Select = new DmlfSelect(); insert.Select.SingleFrom = new DmlfFromItem { Source = new DmlfSource { TableOrView = table.FullName, Alias = "basetbl", } }; GetConditions(insert.Select, this, Conditions, db); foreach (var col in table.Columns) { var valcol = Values.FirstOrDefault(x => x.Column == col.Name); insert.TargetColumns.Add(col.Name); if (valcol == null) { insert.Select.Columns.Add(DmlfResultField.BuildFromColumn(col.Name, insert.Select.SingleFrom.Source)); } else { insert.Select.Columns.Add(new DmlfResultField { Expr = new DmlfLiteralExpression { Value = valcol.Value, } }); } } res.Commands.Add(insert); res.AllowIdentityInsert(table.FullName, false); } }
public bool IsDuplicatingIdentity(DatabaseInfo db, ChangeSetModel model) { if (!UpdateReferences && !model.UpdateReferences) { return(false); } if (!IsUpdatingPk(db)) { return(false); } var table = db.FindTable(TargetTable); if (table == null) { return(false); } var autoinc = table.FindAutoIncrementColumn(); return(autoinc != null && Values.Any(x => x.Column == autoinc.Name)); }
public void GetCommands(DmlfBatch res, DatabaseInfo db, ChangeSetModel model, IDialectDataAdapter dda, ICdlValueConvertor converter) { var table = db.FindTable(TargetTable); if (table == null) { return; } if ((UpdateReferences || model.UpdateReferences) && IsUpdatingPk(db)) { var refs = GenerateCascadeUpdates(db); foreach (var item in refs) { item.GetCommands(res, db, model, dda, converter); } } if (!IsDuplicatingIdentity(db, model)) { var cmd = new DmlfUpdate(); cmd.UpdateTarget = new DmlfSource { TableOrView = TargetTable, LinkedInfo = LinkedInfo, Alias = "basetbl", }; cmd.From.Add(new DmlfFromItem { Source = cmd.UpdateTarget, }); if (GetConditions(cmd, this, Conditions, db)) { GetValues(cmd.Columns, Values, table, dda, converter); res.Commands.Add(cmd); } } }
public void GetCommands(DmlfBatch res, DatabaseInfo db, ChangeSetModel model, bool allowCascade = true) { if (allowCascade && (DeleteReferencesCascade || model.DeleteReferencesCascade)) { var refs = GenerateCascadeDeletions(db); foreach (var item in refs) { item.GetCommands(res, db, model, false); } } if (model.DeleteReferencesCascade && model.DeleteSkipList != null && model.DeleteSkipList.Contains(TargetTable)) return; var cmd = new DmlfDelete(); cmd.DeleteTarget = new DmlfSource { TableOrView = TargetTable, LinkedInfo = LinkedInfo, Alias = "basetbl", }; cmd.From.Add(new DmlfFromItem { Source = cmd.DeleteTarget, }); if (!GetConditions(cmd, this, Conditions, db)) return; res.Commands.Add(cmd); }
public void GetInsertCommands(DmlfBatch res, DatabaseInfo db, ChangeSetModel model, IDialectDataAdapter dda, ICdlValueConvertor converter) { var table = db.FindTable(TargetTable); if (table == null) return; if (IsDuplicatingIdentity(db, model)) { res.AllowIdentityInsert(table.FullName, true); var insert = new DmlfInsertSelect { TargetTable = table.FullName, }; insert.Select = new DmlfSelect(); insert.Select.SingleFrom = new DmlfFromItem { Source = new DmlfSource { TableOrView = table.FullName, Alias = "basetbl", } }; GetConditions(insert.Select, this, Conditions, db); foreach (var col in table.Columns) { var valcol = Values.FirstOrDefault(x => x.Column == col.Name); insert.TargetColumns.Add(col.Name); if (valcol == null) { insert.Select.Columns.Add(DmlfResultField.BuildFromColumn(col.Name, insert.Select.SingleFrom.Source)); } else { insert.Select.Columns.Add(new DmlfResultField { Expr = new DmlfLiteralExpression { Value = valcol.Value, } }); } } res.Commands.Add(insert); res.AllowIdentityInsert(table.FullName, false); } }
public void GetCommands(DmlfBatch res, DatabaseInfo db, ChangeSetModel model, IDialectDataAdapter dda, ICdlValueConvertor converter) { var table = db.FindTable(TargetTable); if (table == null) return; if ((UpdateReferences || model.UpdateReferences) && IsUpdatingPk(db)) { var refs = GenerateCascadeUpdates(db); foreach (var item in refs) { item.GetCommands(res, db, model, dda, converter); } } if (!IsDuplicatingIdentity(db, model)) { var cmd = new DmlfUpdate(); cmd.UpdateTarget = new DmlfSource { TableOrView = TargetTable, LinkedInfo = LinkedInfo, Alias = "basetbl", }; cmd.From.Add(new DmlfFromItem { Source = cmd.UpdateTarget, }); if (GetConditions(cmd, this, Conditions, db)) { GetValues(cmd.Columns, Values, table, dda, converter); res.Commands.Add(cmd); } } }
public void GetDeleteCommands(DmlfBatch res, DatabaseInfo db, ChangeSetModel model) { var table = db.FindTable(TargetTable); if (table == null) return; if (IsDuplicatingIdentity(db, model)) { var del = new DmlfDelete(); del.DeleteTarget = new DmlfSource { TableOrView = table.FullName, Alias = "basetbl", }; del.SingleFrom = new DmlfFromItem { Source = del.DeleteTarget }; GetConditions(del, this, Conditions, db); res.Commands.Add(del); } }
public static ChangeSetModel LoadFromFile(string fileName) { var doc = new XmlDocument(); doc.LoadXml(File.ReadAllText(fileName)); var res = new ChangeSetModel(); res.LoadProperties(doc.DocumentElement); return res; }