test.nix

let nixpkgs = import <nixpkgs> {};
    nixos-lib = import (<nixpkgs> + "/nixos/lib") {};
in
nixos-lib.runTest {
  nodes.db = { lib, ... }: {
    config = {
      services.postgresql = {
        enable = true;
        settings.log_statement = "all";
        authentication = ''
          local mydb myuser peer
        '';
        ensureDatabases = [ "mydb" ];
        ensureUsers = [{
          name = "myuser";
          ensurePermissions = {
            "ALL TABLES IN SCHEMA public" = "ALL PRIVILEGES";
          };
        }];
      };

      users.groups."mygroup" = {};
      users.users."myuser".isNormalUser = true;
      users.users."myuser".group = "mygroup";
    };
  };

  name = "Test if database works";

  hostPkgs = nixpkgs;

  testScript = ''
    db.wait_for_unit("postgresql.service")
    db.succeed("sudo -u myuser psql -d mydb -c \"SELECT VERSION()\"")
  '';
}