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