Ejemplo n.º 1
0
        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);
        }