/// <summary>
/// Set the default stored procedures names
/// </summary>
private void SetDefaultNames()
{
(var tableName, var trackingName) = OracleBuilder.GetParsers(this.TableDescription);
var schema = string.IsNullOrEmpty(tableName.SchemaName) ? "" : tableName.SchemaName + ".";
this.AddName(DbCommandType.SelectChanges, string.Format(selectChangesProcName, schema, tableName.ObjectName));
this.AddName(DbCommandType.SelectChangesWitFilters, string.Format(selectChangesProcNameWithFilters, schema, tableName.ObjectName, "{0}"));
this.AddName(DbCommandType.SelectRow, string.Format(selectRowProcName, schema, tableName.ObjectName));
this.AddName(DbCommandType.InsertRow, string.Format(insertProcName, schema, tableName.ObjectName));
this.AddName(DbCommandType.UpdateRow, string.Format(updateProcName, schema, tableName.ObjectName));
this.AddName(DbCommandType.DeleteRow, string.Format(deleteProcName, schema, tableName.ObjectName));
this.AddName(DbCommandType.InsertMetadata, string.Format(insertMetadataProcName, schema, tableName.ObjectName));
this.AddName(DbCommandType.UpdateMetadata, string.Format(updateMetadataProcName, schema, tableName.ObjectName));
this.AddName(DbCommandType.DeleteMetadata, string.Format(deleteMetadataProcName, schema, tableName.ObjectName));
this.AddName(DbCommandType.Reset, string.Format(resetMetadataProcName, schema, tableName.ObjectName));
this.AddName(DbCommandType.InsertTrigger, string.Format(insertTriggerName, schema, tableName.ObjectName));
this.AddName(DbCommandType.UpdateTrigger, string.Format(updateTriggerName, schema, tableName.ObjectName));
this.AddName(DbCommandType.DeleteTrigger, string.Format(deleteTriggerName, schema, tableName.ObjectName));
this.AddName(DbCommandType.BulkTableType, string.Format(bulkTableTypeName, schema, tableName.ObjectName));
this.AddName(DbCommandType.BulkTemporyTable, string.Format(bulkTemporyTableName, schema, tableName.ObjectName));
this.AddName(DbCommandType.BulkTable, string.Format(bulkTableName, schema, tableName.ObjectName));
this.AddName(DbCommandType.BulkInsertRows, string.Format(bulkInsertProcName, schema, tableName.ObjectName));
this.AddName(DbCommandType.BulkUpdateRows, string.Format(bulkUpdateProcName, schema, tableName.ObjectName));
this.AddName(DbCommandType.BulkDeleteRows, string.Format(bulkDeleteProcName, schema, tableName.ObjectName));
}
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 OracleBuilderTrackingTable(DmTable tableDescription, DbConnection connection, DbTransaction transaction)
{
this.tableDescription = tableDescription;
this.connection = connection as OracleConnection;
this.transaction = transaction as OracleTransaction;
(this.tableName, this.trackingName) = OracleBuilder.GetParsers(this.tableDescription);
this.oracleDbMetadata = new OracleDbMetadata();
}
public OracleBuilderTrigger(DmTable tableDescription, DbConnection connection, DbTransaction transaction)
{
this.tableDescription = tableDescription;
this.connection = connection as OracleConnection;
this.transaction = transaction as OracleTransaction;
(this.tableName, this.trackingName) = OracleBuilder.GetParsers(this.tableDescription);
this.oracleObjectNames = new OracleObjectNames(this.tableDescription);
}
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));
}