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