public void ConfigTerminal(Replica replica, Table table, List<Insert> valuesToInsert)
{
MysqlDatabaseDA sqlDatabaseAccess = new MysqlDatabaseDA(replica.StrTerminalUser, replica.StrTerminalPassword, replica.StrTerminalIPAddress, replica.IntTerminalPort.ToString(), replica.StrTerminalDatabase);
sqlDatabaseAccess.CreateReplicaLogs();
sqlDatabaseAccess.createTable(table);
sqlDatabaseAccess.ExecuteMultipleInsert(valuesToInsert);
sqlDatabaseAccess.CreateTriggerDelete(table);
sqlDatabaseAccess.CreateTriggerInsert(table);
sqlDatabaseAccess.CreateTriggerUpdate(table);
}
public Table ConfigSource(Replica replica)
{
MysqlDatabaseDA sqlDatabaseAccess = new MysqlDatabaseDA(replica.StrSourceUser, replica.StrSourcePassword, replica.StrSourceIPAddress, replica.IntSourcePort.ToString(), replica.StrSourceDatabase);
sqlDatabaseAccess.CreateReplicaLogs();
Table table = sqlDatabaseAccess.getTableStructure(replica.StrSourceDatabase, replica.StrSourceTable);
sqlDatabaseAccess.CreateTriggerDelete(table);
sqlDatabaseAccess.CreateTriggerInsert(table);
sqlDatabaseAccess.CreateTriggerUpdate(table);
return table;
}
