1
package GenTest::Reporter::BackupAndRestore;
4
@ISA = qw(GenTest::Reporter);
9
use GenTest::Constants;
12
my $file = '/tmp/rqg_backup';
17
return STATUS_OK if $count > 0;
19
my $dsn = $reporter->dsn();
21
my $dbh = DBI->connect($dsn);
23
unlink('/tmp/rqg_backup');
24
say("Executing BACKUP DATABASE.");
25
$dbh->do("BACKUP DATABASE test TO '/tmp/rqg_backup'");
28
if (defined $dbh->err()) {
29
return STATUS_DATABASE_CORRUPTION;
38
my $dsn = $reporter->dsn();
40
my $dbh = DBI->connect($dsn);
42
say("Executing RESTORE FROM.");
43
$dbh->do("RESTORE FROM '/tmp/rqg_backup' OVERWRITE");
45
if (defined $dbh->err()) {
46
return STATUS_DATABASE_CORRUPTION;
53
return REPORTER_TYPE_PERIODIC | REPORTER_TYPE_SUCCESS;