public void PutDropMaterialized(SqlScriptCompiler cmp) { if (_materializedName == null) return; cmp.Dumper.DropTable(new TableInfo(null) { FullName = _materializedName }, false); cmp.EndCommand(); }
private void RunCoreRound1(SqlScriptCompiler cmp) { if (_dbsh.LifetimeHandler.CreateMarkRelived) { var update = CompileMarkRelived(); if (update != null) { cmp.StartTimeMeasure("OP"); cmp.PutSmallTitleComment("MARK RELIVED"); cmp.GenCommandSql(update); cmp.EndCommand(); cmp.PutLogMessage(this, LogOperationType.MarkRelived, "@rows rows marked as relived", "OP"); } } if (_dbsh.LifetimeHandler.CreateMarkDeleted) { var update = CompileMarkDeleted(); if (update != null) { cmp.StartTimeMeasure("OP"); cmp.PutSmallTitleComment("MARK DELETED"); cmp.GenCommandSql(update); cmp.PutLogMessage(this, LogOperationType.MarkDeleted, "@rows rows marked as deleted", "OP"); } } if (_dbsh.LifetimeHandler.CreateMarkUpdated) { var update = CompileMarkUpdated(); if (update != null) { cmp.StartTimeMeasure("OP"); cmp.PutSmallTitleComment("MARK UPDATED"); cmp.GenCommandSql(update); cmp.PutLogMessage(this, LogOperationType.MarkUpdated, "@rows rows marked as updated", "OP"); } } if (_dbsh.LifetimeHandler.CreateInsert) { var insert = CompileInsert(); if (insert != null) { cmp.StartTimeMeasure("OP"); cmp.PutSmallTitleComment("INSERT"); bool isIdentity = Structure != null && Structure.Columns.Any(x => x.AutoIncrement && insert.TargetColumns.Contains(x.Name)); if (isIdentity) cmp.GenCommandSql(dmp => dmp.AllowIdentityInsert(insert.TargetTable, true)); cmp.GenCommandSql(insert); cmp.PutLogMessage(this, LogOperationType.Insert, "@rows rows inserted", "OP"); if (isIdentity) cmp.GenCommandSql(dmp => dmp.AllowIdentityInsert(insert.TargetTable, false)); } } if (_dbsh.LifetimeHandler.CreateUpdate) { var update = CompileUpdate(); if (update != null) { cmp.StartTimeMeasure("OP"); cmp.PutSmallTitleComment("UPDATE"); cmp.GenCommandSql(update); cmp.PutLogMessage(this, LogOperationType.Update, "@rows rows updated", "OP"); } } }