public SyncSimpleFixture() { // create databases helperDb.CreateDatabase(serverDbName); helperDb.CreateDatabase(client1DbName); // create table helperDb.ExecuteScript(serverDbName, createTableScript); // insert table helperDb.ExecuteScript(serverDbName, datas); }
public SyncReinitializeTestsHttpFixture() { // create databases helperDb.CreateDatabase(serverDbName); helperDb.CreateDatabase(client1DbName); // create table helperDb.ExecuteScript(serverDbName, createTableScript); // insert table helperDb.ExecuteScript(serverDbName, datas); }
public SyncPreffixAndSuffixWithSchemaFixture() { // create databases helperDb.CreateDatabase(serverDbName); helperDb.CreateDatabase(client1DbName); // create table helperDb.ExecuteScript(serverDbName, createSchemaScript); helperDb.ExecuteScript(serverDbName, createTableScript); // insert table helperDb.ExecuteScript(serverDbName, datas); }
public SqliteSyncAllColumnsFixture() { var builder = new SqliteConnectionStringBuilder { DataSource = ClientSqliteFilePath }; this.ClientSqliteConnectionString = builder.ConnectionString; GC.Collect(); GC.WaitForPendingFinalizers(); if (File.Exists(ClientSqliteFilePath)) File.Delete(ClientSqliteFilePath); // create databases helperDb.CreateDatabase(serverDbName); // create table helperDb.ExecuteScript(serverDbName, createTableScript); // insert table helperDb.ExecuteScript(serverDbName, datas); var serverProvider = new SqlSyncProvider(ServerConnectionString); var clientProvider = new SqliteSyncProvider(ClientSqliteFilePath); var simpleConfiguration = new SyncConfiguration(new[] { "AllColumns" }); Agent = new SyncAgent(clientProvider, serverProvider, simpleConfiguration); }
public SQLiteSyncSimpleFixture() { var builder = new SQLiteConnectionStringBuilder { DataSource = ClientSQLiteFilePath }; this.ClientSQLiteConnectionString = builder.ConnectionString; if (File.Exists(ClientSQLiteFilePath)) { File.Delete(ClientSQLiteFilePath); } // create databases helperDb.CreateDatabase(serverDbName); // create table helperDb.ExecuteScript(serverDbName, createTableScript); // insert table helperDb.ExecuteScript(serverDbName, datas); var serverProvider = new SqlSyncProvider(ServerConnectionString); var clientProvider = new SQLiteSyncProvider(ClientSQLiteFilePath); var simpleConfiguration = new SyncConfiguration(Tables); Agent = new SyncAgent(clientProvider, serverProvider, simpleConfiguration); }
public MySqlAllColumnsFixture() { // create databases helperDb.CreateDatabase(serverDbName); helperDb.CreateMySqlDatabase(client1DbName); // create table helperDb.ExecuteScript(serverDbName, createTableScript); }
public SyncAllColumnsFixture() { // create databases HelperDB.CreateDatabase(ProviderType.Sql, serverDbName); HelperDB.CreateDatabase(ProviderType.Sql, client1DbName); // create table HelperDB.ExecuteSqlScript(serverDbName, createTableScript); // insert table HelperDB.ExecuteSqlScript(serverDbName, datas); }
public MySqlSyncIdentityColumnNotPkFixture() { // create databases helperDb.CreateDatabase(serverDbName); helperDb.CreateMySqlDatabase(client1DbName); // create table helperDb.ExecuteScript(serverDbName, createTableScript); // insert table helperDb.ExecuteScript(serverDbName, datas); }
public MySqlSyncOneTableOneFieldFixture() { // create databases helperDb.CreateDatabase(serverDbName); helperDb.CreateMySqlDatabase(client1DbName); // create table helperDb.ExecuteScript(serverDbName, createTableScript); // insert table helperDb.ExecuteScript(serverDbName, datas); }
public SqliteSyncSimpleFixture() { var builder = new SqliteConnectionStringBuilder { DataSource = ClientSqliteFilePath }; this.ClientSqliteConnectionString = builder.ConnectionString; if (File.Exists(ClientSqliteFilePath)) { File.Delete(ClientSqliteFilePath); } // create databases helperDb.CreateDatabase(serverDbName); // create table helperDb.ExecuteScript(serverDbName, createTableScript); // insert table helperDb.ExecuteScript(serverDbName, datas); var serverProvider = new SqlSyncProvider(ServerConnectionString); SqliteConnection c = new SqliteConnection($"Data Source=fabrikamde.db"); c.StateChange += (_, e) => { if (e.CurrentState == ConnectionState.Open) { var cmd = c.CreateCommand(); cmd.CommandText = "PRAGMA journal_mode=WAL;"; var i = cmd.ExecuteScalar(); } }; c.Open(); c.Close(); var clientProvider = new SqliteSyncProvider(ClientSqliteFilePath); var totoClientProvider = new SqliteSyncProvider( @"Data Source=D:\database\myData.db;Journal Mode=WAL;Page Size=8192"); SqliteConnectionStringBuilder sqliteConnectionStringBuilder = new SqliteConnectionStringBuilder(); var simpleConfiguration = new SyncConfiguration(Tables); Agent = new SyncAgent(clientProvider, serverProvider, simpleConfiguration); }
public MySqlSyncSimpleFixture() { // create databases helperDb.CreateDatabase(serverDbName); // create table helperDb.ExecuteScript(serverDbName, createTableScript); // insert table helperDb.ExecuteScript(serverDbName, datas); helperDb.CreateMySqlDatabase(clientDbName); var serverProvider = new SqlSyncProvider(ServerConnectionString); var clientProvider = new MySqlSyncProvider(ClientMySqlConnectionString); Agent = new SyncAgent(clientProvider, serverProvider, Tables); }
public SQLiteTwoTablesFixture() { //var builder = new SQLiteConnectionStringBuilder { DataSource = ClientSQLiteFilePath }; GC.Collect(); GC.WaitForPendingFinalizers(); if (File.Exists(ClientSQLiteFilePath)) { File.Delete(ClientSQLiteFilePath); } // create databases helperDb.CreateDatabase(serverDbName); // create table helperDb.ExecuteScript(serverDbName, createTableScript); // insert table helperDb.ExecuteScript(serverDbName, datas); }
public SqliteSyncHttpFixture() { var builder = new SqliteConnectionStringBuilder { DataSource = ClientSqliteFilePath }; this.ClientSqliteConnectionString = builder.ConnectionString; if (File.Exists(ClientSqliteFilePath)) { File.Delete(ClientSqliteFilePath); } // create databases helperDb.CreateDatabase(serverDbName); // create table helperDb.ExecuteScript(serverDbName, createTableScript); // insert table helperDb.ExecuteScript(serverDbName, datas); }
internal virtual void ClientDatabasesEnsureCreated() { // foreach server provider to test, there is a list of client / network foreach (var serverKey in this.lstClientsType) { // get the the network we want to use var networkType = serverKey.Key; // create all the client databases based in the flags we set foreach (var cpt in serverKey.Value.GetFlags()) { // cast (wait for C# 7.3 to be able to set an extension method where a generic T can be marked as Enum compliant :) var clientProviderType = (ProviderType)cpt; // check if we have the fixture provider to be able to create a client provider if (!registeredProviders.ContainsKey(clientProviderType)) { continue; } // generate a new database name var dbName = GetRandomDatabaseName(); Console.WriteLine("Create client database called " + dbName + " for provider " + clientProviderType); // get the connection string var connectionString = HelperDB.GetConnectionString(clientProviderType, dbName); // create the database on the client provider HelperDB.CreateDatabase(clientProviderType, dbName); // generate the client provider var clientProvider = registeredProviders[clientProviderType].NewServerProvider(connectionString); // then add the run this.ClientRuns.Add(new ProviderRun(dbName, clientProvider, clientProviderType, networkType)); } } }