public async Task CreateDb_WithEncoding_Ok() { IDbProvider dbProvider = null; var random = new Random(); var dbName = $"temp_{random.Next(100)}"; try { var options = new PostgreDbProviderOptions( String.Format(ConfigProvider.GetConfig().ConnectionStringMask, dbName), template: "template0", databaseEncoding: "SQL_ASCII"); dbProvider = new PostgreDbProvider(options); await dbProvider.CreateDatabaseIfNotExistsAsync(); } finally { if (dbProvider != null) { try { await dbProvider.OpenConnectionAsync(); await dbProvider.ExecuteScriptAsync($"DROP TABLE IF EXISTS {dbName}"); await dbProvider.CloseConnectionAsync(); } catch (Exception) { // ignored } } } }
public PostgreSqlProviderDbTestFixture() { var random = new Random(); DbName = $"temp_{random.Next(100)}"; Options = new PostgreDbProviderOptions( String.Format(ConfigProvider.GetConfig().ConnectionStringMask, DbName), lcCollate: "C", lcCtype: "C", template: "template0", databaseEncoding: "SQL_ASCII"); DbProvider = new PostgreDbProvider(Options); }