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); }