« auto/share/dist/Zonemaster-Backend/create_db.pl
↑ Summary
auto/share/dist/Zonemaster-Backend/patch/patch_db_zonemaster_backend_ver_11.2.0.pl »
| 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"; |