private string CreateProcedureCommandScriptText <T>(Func <T, MySqlCommand> BuildCommand, string procName, T t, DbConnection connection, DbTransaction transaction)
{
var str1 = $"Command {procName} for table {tableName.Quoted().ToString()}";
var str = CreateProcedureCommandText(BuildCommand(t), procName);
return(MyTableSqlBuilder.WrapScriptTextWithComments(str, str1));
}
private string CreateProcedureCommandScriptText <T>(Func <T, MySqlCommand> BuildCommand, string procName, T t)
{
bool alreadyOpened = connection.State == ConnectionState.Open;
try
{
if (!alreadyOpened)
{
connection.Open();
}
var str1 = $"Command {procName} for table {tableName.Quoted().ToString()}";
var str = CreateProcedureCommandText(BuildCommand(t), procName);
return(MyTableSqlBuilder.WrapScriptTextWithComments(str, str1));
}
catch (Exception ex)
{
Debug.WriteLine($"Error during CreateProcedureCommand : {ex}");
throw;
}
finally
{
if (!alreadyOpened && connection.State != ConnectionState.Closed)
{
connection.Close();
}
}
}
private string CreateProcedureCommandScriptText(Func <MySqlCommand> BuildCommand, string procName)
{
var str1 = $"Command {procName} for table {tableName.Quoted().ToString()}";
var str = CreateProcedureCommandText(BuildCommand(), procName);
return(MyTableSqlBuilder.WrapScriptTextWithComments(str, str1));
}
public MySqlBuilderTrackingTable(SyncTable tableDescription, DbConnection connection, DbTransaction transaction = null)
{
this.connection = connection as MySqlConnection;
this.transaction = transaction as MySqlTransaction;
this.tableDescription = tableDescription;
(this.tableName, this.trackingName) = MyTableSqlBuilder.GetParsers(this.tableDescription);
this.mySqlDbMetadata = new MySqlDbMetadata();
}
public override DbTableBuilder GetTableBuilder(SyncTable tableDescription, SyncSetup setup)
{
var(tableName, trackingName) = GetParsers(tableDescription, setup);
var tableBuilder = new MyTableSqlBuilder(tableDescription, tableName, trackingName, setup);
return(tableBuilder);
}
