using Npgsql; namespace Backend.Tests; /// /// A throwaway database on the PostgreSQL server the PG* variables name (PGHOST, PGPORT, PGUSER, PGPASSWORD), created for a /// test and dropped after it. is null when no server is configured; the tests then skip. /// public sealed class PostgresTestDatabase : IDisposable { private readonly string admin; private PostgresTestDatabase(string admin, string name) { this.admin = admin; Name = name; ConnectionString = new NpgsqlConnectionStringBuilder(admin) { Database = name, Pooling = false }.ConnectionString; Execute(admin, $"CREATE DATABASE \"{name}\""); } public const string SkipReason = "No PostgreSQL to test against (PGHOST, PGUSER, PGPASSWORD)."; public string Name { get; } /// The database's connection string, password included. public string ConnectionString { get; } /// The server's connection, for the server's own database. public static string? AdminConnectionString() { var host = Environment.GetEnvironmentVariable("PGHOST"); var user = Environment.GetEnvironmentVariable("PGUSER"); var password = Environment.GetEnvironmentVariable("PGPASSWORD"); if (string.IsNullOrEmpty(host) || string.IsNullOrEmpty(user) || password is null) { return null; } return new NpgsqlConnectionStringBuilder { Host = host, Port = int.TryParse(Environment.GetEnvironmentVariable("PGPORT"), out var port) ? port : 5432, Username = user, Password = password, Database = "postgres", Pooling = false, }.ConnectionString; } public static PostgresTestDatabase? TryCreate(string prefix) => AdminConnectionString() is { } admin ? new PostgresTestDatabase(admin, $"{prefix}_{Guid.NewGuid():N}"[..40]) : null; /// Another throwaway database on the same server (a restore target). public PostgresTestDatabase Sibling(string prefix) => new(admin, $"{prefix}_{Guid.NewGuid():N}"[..40]); public long Scalar(string sql) { using var connection = new NpgsqlConnection(ConnectionString); connection.Open(); using var command = new NpgsqlCommand(sql, connection); return Convert.ToInt64(command.ExecuteScalar(), System.Globalization.CultureInfo.InvariantCulture); } private static void Execute(string connectionString, string sql) { using var connection = new NpgsqlConnection(connectionString); connection.Open(); using var command = new NpgsqlCommand(sql, connection); command.ExecuteNonQuery(); } public void Dispose() { NpgsqlConnection.ClearAllPools(); Execute(admin, $"DROP DATABASE IF EXISTS \"{Name}\" WITH (FORCE)"); } } /// The backend on a throwaway Postgres database (SQLite when no server is configured: the tests skip then). public sealed class PostgresBackendFixture : BackendTestFixture { public PostgresBackendFixture() { Database = PostgresTestDatabase.TryCreate("executer_backend_tests"); if (Database is not null) { Settings["DATABASE_PROVIDER"] = "postgres"; Settings["DATABASE_CONNECTION_STRING"] = Database.ConnectionString; } } public PostgresTestDatabase? Database { get; } protected override void Dispose(bool disposing) { base.Dispose(disposing); if (disposing) { Database?.Dispose(); } } }