auto/share/dist/Zonemaster-Backend/patch/patch_db_schema_version_1.pl untested

filter: Statementstmt 0.0% 0 / 33 Branchbran 0.0% 0 / 4 Conditioncond n/a MC/DCmcdc n/a Subroutinesub 0.0% 0 / 5 Podpod n/a totaltotal 0.0% 0 / 42 CC 1 SCAR 6.9
CC
1
Cov
0%
BEGIN
2.0
BEGIN
2.0
BEGIN
2.0
CRAP 2.0
1 use 5.14.2;
2 use strict;
3 use warnings;
4  
5 use Readonly;
6 use Zonemaster::Backend::Config;
7  
8 Readonly my $TARGET_SCHEMA_VERSION => 1;
9 Readonly my $EXPECTED_SCHEMA_VERSION => $TARGET_SCHEMA_VERSION - 1;
10  
11 my $config = Zonemaster::Backend::Config->load_config();
12 say "Configured database engine: ", $config->DB_engine;
13  
14 my $db = $config->new_DB();
15 my $detected_version = $db->get_schema_version();
16 say "Target database schema version: ", $TARGET_SCHEMA_VERSION;
17 say "Expected pre-migration schema version: ", $EXPECTED_SCHEMA_VERSION;
18 say "Detected database schema version: ", $detected_version;
19  
20 if ( $detected_version eq $TARGET_SCHEMA_VERSION ) {
21 say "Schema already at target version.";
22 exit 0;
23 }
24 elsif ( $detected_version ne $EXPECTED_SCHEMA_VERSION ) {
25 say "Schema version requirement not met!";
26 exit 2;
27 }
28  
29 say "Starting database migration";
30  
31 $db->dbh->do(
32 "CREATE TABLE IF NOT EXISTS schema_version (
33 id INTEGER PRIMARY KEY,
34 version INTEGER NOT NULL,
35 CHECK (id = 1),
36 CHECK (version >= 1)
37 )"
38 );
39 $db->dbh->do( "INSERT INTO schema_version (id, version) VALUES (1, ?)", {}, $TARGET_SCHEMA_VERSION );
40  
41 say "Migration done";