import ./make-test.nix {
  name = "prosody";

  machine = { pkgs, ... }: {
    services.prosody = {
      enable = true;
      # TODO: use a self-signed certificate
      c2sRequireEncryption = false;
      extraConfig = ''
        storage = "sql"
        sql = {
          driver = "MySQL";
          database = "prosody";
          host = "localhost";
          port = 3306;
          username = "prosody";
          password = "password123";
        };
      '';
      virtualHosts.test = {
        domain = "example.com";
        enabled = true;
      };
    };
    services.mysql.enable = true;
    services.mysql.initialScript = pkgs.writeText "mysql_init.sql" ''
      CREATE DATABASE prosody;
      CREATE USER 'prosody'@'localhost' IDENTIFIED BY 'password123';
      GRANT ALL PRIVILEGES ON prosody.* TO 'prosody'@'localhost';
      FLUSH PRIVILEGES;
    '';
    services.mysql.package = pkgs.mariadb;

    environment.systemPackages = [
      (pkgs.callPackage ./xmpp-sendmessage.nix {})
    ];
  };

  testScript = ''
    $machine->waitForUnit('mysql.service');
    $machine->waitForUnit('prosody.service');
    $machine->succeed('prosodyctl status') =~ /Prosody is running/;

    # set password to 'nothunter2' (it's asked twice)
    $machine->succeed('yes nothunter2 | prosodyctl adduser cthon98@example.com');
    # set password to 'y'
    $machine->succeed('yes | prosodyctl adduser azurediamond@example.com');
    # correct password to 'hunter2'
    $machine->succeed('yes hunter2 | prosodyctl passwd azurediamond@example.com');

    $machine->succeed("send-message");

    $machine->succeed('prosodyctl deluser cthon98@example.com');
    $machine->succeed('prosodyctl deluser azurediamond@example.com');
  '';
}

machine: output: sql error Error in SQL transaction: ...brg0sgx91k1d-lua5.2-luadbi-0.7.2-1/share/lua/5.2/DBI.lua:53: Cannot load driver MySQL. Available drivers are: (None)
example.com:storage_sql error Unable to read from database accounts store for cthon98: ...brg0sgx91k1d-lua5.2-luadbi-0.7.2-1/share/lua/5.2/DBI.lua:53: Cannot load driver MySQL. Available drivers are: (None)