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;
}
static void Main(string[] args)
{
//SqlDatabaseDA prueba = new SqlDatabaseDA("", "", "", "");
//Table tabla = new Table();
//tabla.StrName = "MiTabla";
//Column column = new Column();
//column.StrName = "Prueba";
//tabla.ListColumns.Add(column);
//column = new Column();
//column.StrName = "Prueba2";
//tabla.ListColumns.Add(column);
//column = new Column();
//column.StrName = "Prueba3";
//tabla.ListColumns.Add(column);
//column = new Column();
//column.StrName = "Prueba4";
//tabla.ListColumns.Add(column);
//prueba.CreateTrigger(tabla);
// ######################################## MYSQL ########################################
MysqlDatabaseDA pruebaBD = new MysqlDatabaseDA("root", "123456", "localhost", "3306", "world");
string ConnectionString = "server=localhost" + ";user= root" + ";database=world" + ";port=3306" + ";password=123456;";
MySqlConnection _oConnection = new MySqlConnection(ConnectionString);
_oConnection.Open();
string strQuery = "SELECT * FROM COUNTRY";
MySqlCommand cmdComando = new MySqlCommand(strQuery, _oConnection);
cmdComando.ExecuteNonQuery();
}
public Boolean TableSyncTerminal(Replica replica, ReplicaLog replicaLog)
{
MysqlDatabaseDA sqlDatabaseAccess = new MysqlDatabaseDA(replica.StrTerminalUser, replica.StrTerminalPassword, replica.StrTerminalIPAddress, replica.IntTerminalPort.ToString(), replica.StrTerminalDatabase);
return sqlDatabaseAccess.TableSync(replica.StrSourceTable, replicaLog.StrReplicaTransaction);
}
public Boolean SetReplicaTerminalLogSync(Replica replica, ReplicaLog oreplicaLog)
{
MysqlDatabaseDA sqlDatabaseAccess = new MysqlDatabaseDA(replica.StrTerminalUser, replica.StrTerminalPassword, replica.StrTerminalIPAddress, replica.IntTerminalPort.ToString(), replica.StrTerminalDatabase);
return sqlDatabaseAccess.SetReplicaLogSync(oreplicaLog);
}
public Boolean SetReplicaSourceLogSync(Replica replica, ReplicaLog oreplicaLog)
{
MysqlDatabaseDA sqlDatabaseAccess = new MysqlDatabaseDA(replica.StrSourceUser, replica.StrSourcePassword, replica.StrSourceIPAddress, replica.IntSourcePort.ToString(), replica.StrSourceDatabase);
return sqlDatabaseAccess.SetReplicaLogSync(oreplicaLog);
}
/// <summary>
/// MySql Method to obtain Tables on DB
/// </summary>
/// <param name="user"></param>
/// <param name="password"></param>
/// <param name="server"></param>
/// <param name="port"></param>
/// <returns></returns>
public List<Table> GetTables(string user, string password, string server, string port, string database)
{
MysqlDatabaseDA sqlDatabaseDA = new MysqlDatabaseDA(user, password, server, port, database);
return sqlDatabaseDA.GetAllTables(database);
}
public List<ReplicaLog> GetReplicaLogsTerminalUnsynchronized(Replica replica)
{
MysqlDatabaseDA sqlDatabaseAccess = new MysqlDatabaseDA(replica.StrTerminalUser, replica.StrTerminalPassword, replica.StrTerminalIPAddress, replica.IntTerminalPort.ToString(), replica.StrTerminalDatabase);
return sqlDatabaseAccess.GetReplicaLogsUnsynchronized(replica.StrSourceTable);
}
public List<Database> GetDatabases(string user, string password, string server, string port)
{
MysqlDatabaseDA sqlDatabaseDA = new MysqlDatabaseDA(user, password, server, port);
return sqlDatabaseDA.GetAllDatabases();
}
public List<Insert> GetConfigValues(Replica replica,Table table)
{
MysqlDatabaseDA sqlDatabaseAccess = new MysqlDatabaseDA(replica.StrSourceUser, replica.StrSourcePassword, replica.StrSourceIPAddress, replica.IntSourcePort.ToString(), replica.StrSourceDatabase);
return sqlDatabaseAccess.GetCurrentRows(table);
}
