auto/share/dist/Zonemaster-Backend/patch/patch_mysql_db_zonemaster_backend_ver_1.0.3.pl untested

filter: Statementstmt 0.0% 0 / 24 Branchbran 0.0% 0 / 2 Conditioncond n/a MC/DCmcdc n/a Subroutinesub 0.0% 0 / 6 Podpod 0.0% 0 / 1 totaltotal 0.0% 0 / 33 CC 1 SCAR 6.9
CC
1
Cov
0%
patch_db
2.0
BEGIN
2.0
BEGIN
2.0
CRAP 2.0
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();