private static void RecreateSchemaAndInstallObjects() { var provider = ConnectionUtils.GetConnectionProvider(); using (var connectionHolder = provider.AcquireConnection()) { var connection = connectionHolder.Connection; var databaseName = ConnectionUtils.GetDatabaseName(); var databaseExists = connection.ExecuteScalar <int>(@"select COUNT(*) from pg_database where datname = @databaseName;", new { databaseName = databaseName } ) > 0; if (!databaseExists) { connection.Execute(@"CREATE DATABASE @databaseName", new { databaseName = databaseName }); } } new DatabaseInitializer(ConnectionUtils.GetConnectionProvider(), ConnectionUtils.GetSchemaName()).Initialize(); using (var connectionHolder = provider.AcquireConnection()) { PostgreSqlTestObjectsInitializer.CleanTables(connectionHolder.Connection); } }
private static void CleanTables() { var provider = ConnectionUtils.GetConnectionProvider(); using (var connection = provider.AcquireConnection()) { PostgreSqlTestObjectsInitializer.CleanTables(connection.Connection); } }