« auto/share/dist/Zonemaster-Backend/patch/patch_db_schema_version_1.pl
↑ Summary
auto/share/dist/Zonemaster-Backend/patch/patch_db_zonemaster_backend_ver_9.0.0.pl »
| 1 | use strict; | ||
| 2 | use warnings; | ||
| 3 | |||
| 4 | use Zonemaster::Backend::Config; | ||
| 5 | use Zonemaster::Engine; | ||
| 6 | |||
| 7 | my $config = Zonemaster::Backend::Config->load_config(); | ||
| 8 | |||
| 9 | my $db_engine = $config->DB_engine; | ||
| 10 | print "Configured database engine: $db_engine\n"; | ||
| 11 | |||
| 12 | if ( $db_engine =~ /^(MySQL|PostgreSQL|SQLite)$/ ) { | ||
| 13 | print( "Starting database migration\n" ); | ||
| 14 | |||
| 15 | _update_result_entries( $config->new_DB()->dbh() ); | ||
| 16 | |||
| 17 | print( "\nMigration done\n" ); | ||
| 18 | } | ||
| 19 | else { | ||
| 20 | die "Unknown database engine configured: $db_engine\n"; | ||
| 21 | } | ||
| 22 | |||
| 23 | |||
| 24 | sub _update_result_entries { | ||
| 25 | my ( $dbh ) = @_; | ||
| 26 | |||
| 27 | $dbh->do(<<SQL) or die 'Migration failed'; | ||
| 28 | UPDATE result_entries | ||
| 29 | SET module = 'Backend' | ||
| 30 | WHERE upper(module) = 'BACKEND_TEST_AGENT'; | ||
| 31 | SQL | ||
| 32 | } |