nixos/tests/pgmanage.nix


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44

{ 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"
    )
  '';
}