« auto/share/dist/Zonemaster-Backend/patch/patch_db_zonemaster_backend_ver_9.0.0.pl
↑ Summary
auto/share/dist/Zonemaster-Backend/patch/patch_mysql_db_zonemaster_backend_ver_5.0.0.pl »
| 1 | use strict; | ||
| 2 | use warnings; | ||
| 3 | |||
| 4 | use DBI qw(:utils); | ||
| 5 | |||
| 6 | use Zonemaster::Backend::Config; | ||
| 7 | use Zonemaster::Backend::DB::MySQL; | ||
| 8 | |||
| 9 | my $config = Zonemaster::Backend::Config->load_config(); | ||
| 10 | if ( $config->DB_engine ne 'MySQL' ) { | ||
| 11 | die "The configuration file does not contain the MySQL backend"; | ||
| 12 | } | ||
| 13 | my $dbh = Zonemaster::Backend::DB::MySQL->from_config( $config )->dbh; | ||
| 14 | |||
| 15 | sub patch_db { | ||
| 16 | |||
| 17 | #################################################################### | ||
| 18 | # TEST RESULTS | ||
| 19 | #################################################################### | ||
| 20 | $dbh->do( 'ALTER TABLE test_results ADD COLUMN hash_id VARCHAR(16) NULL' ); | ||
| 21 | |||
| 22 | $dbh->do( 'UPDATE test_results SET hash_id = (SELECT SUBSTRING(MD5(CONCAT(RAND(), UUID())) from 1 for 16))' ); | ||
| 23 | |||
| 24 | $dbh->do( 'ALTER TABLE test_results MODIFY hash_id VARCHAR(16) DEFAULT NULL NOT NULL' ); | ||
| 25 | |||
| 26 | $dbh->do( | ||
| 27 | 'CREATE TRIGGER before_insert_test_results | ||
| 28 | BEFORE INSERT ON test_results | ||
| 29 | FOR EACH ROW | ||
| 30 | BEGIN | ||
| 31 | IF new.hash_id IS NULL OR new.hash_id=\'\' | ||
| 32 | THEN | ||
| 33 | SET new.hash_id = SUBSTRING(MD5(CONCAT(RAND(), UUID())) from 1 for 16); | ||
| 34 | END IF; | ||
| 35 | END; | ||
| 36 | ' | ||
| 37 | ); | ||
| 38 | } | ||
| 39 | |||
| 40 | patch_db(); |