nixpkgs/nixos/tests/pgmanage.nix

{ pkgs, ... }:
let
  role = "test";
  password = "secret";
  conn = "local";
in
{
  name = "pgmanage";
  meta = with pkgs.lib.maintainers; {
    maintainers = [ basvandijk ];
  };
  nodes = {
    one =
      { config, pkgs, ... }:
      {
        services = {
          postgresql = {
            enable = true;
            initialScript = pkgs.writeText "pg-init-script" ''
              CREATE ROLE ${role} SUPERUSER LOGIN PASSWORD '${password}';
            '';
          };
          pgmanage = {
            enable = true;
            connections = {
              ${conn} =
                "hostaddr=127.0.0.1 port=${toString config.services.postgresql.settings.port} dbname=postgres";
            };
          };
        };
      };
  };

  testScript = ''
    start_all()
    one.wait_for_unit("default.target")
    one.require_unit_state("pgmanage.service", "active")

    # Test if we can log in.
    one.wait_until_succeeds(
        "curl 'http://localhost:8080/pgmanage/auth' --data 'action=login&connname=${conn}&username=${role}&password=${password}' --fail"
    )
  '';
}