public string ScriptAddFilterColumn(DmColumn filterColumn)
{
var quotedColumnName = new ObjectNameParser(filterColumn.ColumnName, "[", "]");
string str = string.Concat("Add new filter column, ", quotedColumnName.UnquotedString, ", to Tracking Table ", trackingName.QuotedString);
return(OracleBuilder.WrapScriptTextWithComments(this.AddFilterColumnCommandText(filterColumn), str));
}
public string DropUpdateTriggerScriptText()
{
var triggerName = this.oracleObjectNames.GetCommandName(DbCommandType.UpdateTrigger);
var trigger = $"DELETE TRIGGER {triggerName};";
var str = $"Drop Update Trigger for table {tableName.QuotedString}";
return(OracleBuilder.WrapScriptTextWithComments(trigger, str));
}
public string DropTableScriptText()
{
StringBuilder stringBuilder = new StringBuilder();
var tableNameScript = $"Drop Table {tableName.QuotedString}";
var tableScript = BuildTableCommand().CommandText;
stringBuilder.Append(OracleBuilder.WrapScriptTextWithComments(tableScript, tableNameScript));
stringBuilder.AppendLine();
return(stringBuilder.ToString());
}
public string CreatePrimaryKeyScriptText()
{
StringBuilder stringBuilder = new StringBuilder();
var pkName = $"Create primary keys for table {tableName.QuotedString}";
var pkScript = BuildPkCommand().CommandText;
stringBuilder.Append(OracleBuilder.WrapScriptTextWithComments(pkScript, pkName));
stringBuilder.AppendLine();
return(stringBuilder.ToString());
}
public string CreateUpdateTriggerScriptText()
{
var updTriggerName = this.oracleObjectNames.GetCommandName(DbCommandType.UpdateTrigger);
StringBuilder createTrigger = new StringBuilder($"CREATE TRIGGER {updTriggerName} ON {tableName.QuotedString} FOR EACH ROW ");
createTrigger.AppendLine();
createTrigger.AppendLine(this.UpdateTriggerBodyText());
string str = $"Update Trigger for table {tableName.QuotedString}";
return(OracleBuilder.WrapScriptTextWithComments(createTrigger.ToString(), str));
}
public string AlterInsertTriggerScriptText()
{
var insTriggerName = this.oracleObjectNames.GetCommandName(DbCommandType.InsertTrigger);
StringBuilder createTrigger = new StringBuilder($"ALTER TRIGGER {insTriggerName} AFTER INSERT ON {tableName.QuotedString} FOR EACH ROW ");
createTrigger.AppendLine();
createTrigger.AppendLine(this.InsertTriggerBodyText());
string str = $"ALTER Trigger Insert for table {tableName.QuotedString}";
return(OracleBuilder.WrapScriptTextWithComments(createTrigger.ToString(), str));
}
public string AlterDeleteTriggerScriptText()
{
(var tableName, var trackingName) = OracleBuilder.GetParsers(this.tableDescription);
var delTriggerName = this.oracleObjectNames.GetCommandName(DbCommandType.DeleteTrigger);
StringBuilder createTrigger = new StringBuilder($"CREATE OR REPLACE TRIGGER {delTriggerName} AFTER DELETE ON {tableName.QuotedString} FOR EACH ROW ");
createTrigger.AppendLine();
createTrigger.AppendLine(this.InsertTriggerBodyText());
string str = $"ALTER Trigger Delete for table {tableName.QuotedString}";
return(OracleBuilder.WrapScriptTextWithComments(createTrigger.ToString(), str));
}
public string CreateSchemaScriptText()
{
if (String.IsNullOrEmpty(this.tableDescription.Schema))
{
return(null);
}
StringBuilder stringBuilder = new StringBuilder();
var schemaNameScript = $"Create Schema {tableName.SchemaName}";
var schemaScript = $"Create Schema {tableName.SchemaName}";
stringBuilder.Append(OracleBuilder.WrapScriptTextWithComments(schemaScript, schemaNameScript));
stringBuilder.AppendLine();
return(stringBuilder.ToString());
}
public string CreateForeignKeyConstraintsScriptText(DmRelation constraint)
{
StringBuilder stringBuilder = new StringBuilder();
var constraintName =
$"Create Constraint {constraint.RelationName} " +
$"between parent {constraint.ParentTable.TableName} " +
$"and child {constraint.ChildTable.TableName}";
var constraintScript = BuildForeignKeyConstraintsCommand(constraint).CommandText;
stringBuilder.Append(OracleBuilder.WrapScriptTextWithComments(constraintScript, constraintName));
stringBuilder.AppendLine();
return(stringBuilder.ToString());
}
public string CreatePopulateFromBaseTableScriptText()
{
string str = string.Concat("Populate tracking table ", trackingName.QuotedString, " for existing data in table ", tableName.QuotedString);
return(OracleBuilder.WrapScriptTextWithComments(this.CreatePopulateFromBaseTableCommandText(), str));
}
public string DropTableScriptText()
{
string str = string.Concat("Droping Tracking Table ", trackingName.QuotedString);
return(OracleBuilder.WrapScriptTextWithComments(this.CreateTableCommandText(), str));
}
public string CreatePkScriptText()
{
string str = string.Concat("Create Primary Key on Tracking Table ", trackingName.QuotedString);
return(OracleBuilder.WrapScriptTextWithComments(this.CreatePkCommandText(), str));
}