pyrox.dev
1import ./../make-test-python.nix ({ pkgs, lib, ... }:
2
3{
4 name = "automysqlbackup";
5 meta.maintainers = [ lib.maintainers.aanderse ];
6
7 machine =
8 { pkgs, ... }:
9 {
10 services.mysql.enable = true;
11 services.mysql.package = pkgs.mariadb;
12 services.mysql.initialDatabases = [ { name = "testdb"; schema = ./testdb.sql; } ];
13
14 services.automysqlbackup.enable = true;
15 };
16
17 testScript = ''
18 start_all()
19
20 # Need to have mysql started so that it can be populated with data.
21 machine.wait_for_unit("mysql.service")
22
23 with subtest("Wait for testdb to be fully populated (5 rows)."):
24 machine.wait_until_succeeds(
25 "mysql -u root -D testdb -N -B -e 'select count(id) from tests' | grep -q 5"
26 )
27
28 with subtest("Do a backup and wait for it to start"):
29 machine.start_job("automysqlbackup.service")
30 machine.wait_for_job("automysqlbackup.service")
31
32 with subtest("wait for backup file and check that data appears in backup"):
33 machine.wait_for_file("/var/backup/mysql/daily/testdb")
34 machine.succeed(
35 "${pkgs.gzip}/bin/zcat /var/backup/mysql/daily/testdb/daily_testdb_*.sql.gz | grep hello"
36 )
37 '';
38})