| line |
true |
false |
branch |
|
179
|
0 |
0 |
unless $self->{'connect'}{'schema'} |
|
183
|
0 |
0 |
if $self->{'connect'}{'host'} |
|
184
|
0 |
0 |
if $self->{'connect'}{'port'} |
|
206
|
0 |
0 |
if ($self->{'exclude_tables'}) |
|
208
|
0 |
0 |
if $name eq $t |
|
211
|
0 |
0 |
unless $t =~ /%/ |
|
220
|
0 |
0 |
if $name =~ /$re/ |
|
225
|
0 |
0 |
unless @{$self->{'tables'};} |
|
229
|
0 |
0 |
if $name eq $t |
|
232
|
0 |
0 |
unless $t =~ /%/ |
|
241
|
0 |
0 |
if $name =~ /$re/ |
|
257
|
0 |
0 |
if ($self->{'exclude_views'}) |
|
259
|
0 |
0 |
if $name eq $v |
|
262
|
0 |
0 |
unless $v =~ /%/ |
|
271
|
0 |
0 |
if $name =~ /$re/ |
|
276
|
0 |
0 |
unless @{$self->{'views'};} |
|
280
|
0 |
0 |
if $name eq $v |
|
283
|
0 |
0 |
unless $v =~ /%/ |
|
292
|
0 |
0 |
if $name =~ /$re/ |
|
344
|
0 |
0 |
unless my($name) = $table_sql =~ /^(.*)\.sql$/ |
|
368
|
0 |
0 |
unless shift(@create_sql) =~ /CREATE TABLE `(.*)`/ |
|
380
|
0 |
0 |
unless $table_options =~ s/ENGINE=(\S+)\s*// |
|
391
|
0 |
0 |
if ($table_options =~ s/\s*COMMENT='(([^']|'')*)'//) |
|
412
|
0 |
0 |
if ($line =~ /^\s*`([^`]+)`\s*(.*)/) { } |
|
|
0 |
0 |
elsif ($line =~ /^\s*PRIMARY KEY \(`(.*)`\)/) { } |
|
|
0 |
0 |
elsif ($line =~ /^\s*((UNIQUE )?KEY `([^`]+)`.*)/) { } |
|
|
0 |
0 |
elsif ($line =~ /^\s*
CONSTRAINT\s+`(.*)`\s+
FOREIGN\s+KEY\s+\(`(.*)`\)\s+
REFERENCES\s+`(.*)`\s+\(`(.*)`\)\s+(.*)
/x) { } |
|
496
|
0 |
0 |
if $@ |
|
499
|
0 |
0 |
unless $name eq $desc->{'name'} |
|
522
|
0 |
0 |
if $name =~ /$archive_name_regexp/ |
|
526
|
0 |
0 |
if $table->{'column_definition'}{$self->{'colname'}{'revision'}} |
|
545
|
0 |
0 |
unless @{$table->{'primary_key'};} |
|
550
|
0 |
0 |
unless $coldef = $table->{'column_definition'}{$col} |
|
552
|
0 |
0 |
unless $coldef =~ /\b(int|bigint)\b/ |
|
556
|
0 |
0 |
if ($table->{'col_definition'}{$col}) |
|
557
|
0 |
0 |
unless $coldef =~ /\b(varchar)\b/ |
|
562
|
0 |
0 |
unless my $col = $self->{'colname'}{$timecol} |
|
563
|
0 |
0 |
unless $coldef = $table->{'column_definition'}{$col} |
|
565
|
0 |
0 |
unless $coldef =~ /\b(timestamp|datetime)\b/ |
|
574
|
0 |
0 |
if $table->{'column_definition'}{$col} |
|
580
|
0 |
0 |
unless $table->{'engine'} eq 'InnoDB' |
|
596
|
0 |
0 |
unless @{$current->{'primary_key'};} |
|
600
|
0 |
0 |
unless $current_pkstr eq $desired_pkstr |
|
610
|
0 |
0 |
unless $cdef |
|
623
|
0 |
0 |
if ($ddef =~ /$num_type/) { } |
|
|
0 |
0 |
elsif ($ddef =~ /$datetime_type/) { } |
|
|
0 |
0 |
elsif ($ddef =~ /$string_type/) { } |
|
624
|
0 |
0 |
unless $cdef =~ /$num_type/ |
|
627
|
0 |
0 |
unless $cdef =~ /$datetime_type/ |
|
630
|
0 |
0 |
unless $cdef =~ /$string_type/ |
|
637
|
0 |
0 |
unless $current->{'engine'} eq $desired->{'engine'} |
|
689
|
0 |
0 |
if ($def =~ /^timestamp\b/) { } |
|
|
0 |
0 |
elsif (not grep({$col eq $_;} @{$archive_table{'primary_key'};})) { } |
|
707
|
0 |
0 |
if $table->{'column_definition'}{$colname} |
|
745
|
0 |
0 |
unless -d "$self->{'dir'}/table" |
|
827
|
0 |
0 |
unless -d "$self->{'dir'}/trigger" |
|
850
|
0 |
0 |
unless -d "$self->{'dir'}/trigger" |
|
866
|
0 |
0 |
if $colname->{'ctime'} and $table->{'column_definition'}{$colname->{'ctime'}} |
|
868
|
0 |
0 |
if $colname->{'mtime'} and $table->{'column_definition'}{$colname->{'mtime'}} |
|
870
|
0 |
0 |
if $table->{'column_definition'}{$colname->{'updid'}} |
|
880
|
0 |
0 |
if $colname->{'ctime'} and $table->{'column_definition'}{$colname->{'ctime'}} |
|
882
|
0 |
0 |
if $colname->{'mtime'} and $table->{'column_definition'}{$colname->{'mtime'}} |
|
884
|
0 |
0 |
if $table->{'column_definition'}{$colname->{'updid'}} |
|
893
|
0 |
0 |
$colname->{$_} ? : |
|
900
|
0 |
0 |
if ($colname->{'ctime'} and not $table->{'column_definition'}{$colname->{'ctime'}}) |
|
922
|
0 |
0 |
$_ eq 'stmt' ? : |
|
|
0 |
0 |
$_ eq 'dbuser' ? : |
|
|
0 |
0 |
$_ eq 'updid' ? : |
|
|
0 |
0 |
$_ eq 'action' ? : |
|
|
0 |
0 |
/^(ctime|mtime|revision)$/ ? : |
|
935
|
0 |
0 |
$_ eq 'stmt' ? : |
|
|
0 |
0 |
$_ eq 'dbuser' ? : |
|
|
0 |
0 |
$_ eq 'updid' ? : |
|
|
0 |
0 |
$_ eq 'action' ? : |
|
|
0 |
0 |
/^(ctime|mtime|revision)$/ ? : |
|
947
|
0 |
0 |
$_ eq 'stmt' ? : |
|
|
0 |
0 |
$_ eq 'revision' ? : |
|
|
0 |
0 |
$_ eq 'mtime' ? : |
|
|
0 |
0 |
$_ eq 'dbuser' ? : |
|
|
0 |
0 |
$_ eq 'ctime' ? : |
|
|
0 |
0 |
$_ eq 'updid' ? : |
|
|
0 |
0 |
$_ eq 'action' ? : |
|
983
|
0 |
0 |
if $VERBOSE |
|
1008
|
0 |
0 |
unless -d "$self->{'dir'}/table" |
|
1016
|
0 |
0 |
if $self->__ignore_table($name) |
|
1022
|
0 |
0 |
if ($self->{'remove'}{'table'}) |
|
1024
|
0 |
0 |
if $self->__ignore_table($name) |
|
1027
|
0 |
0 |
if $db_table{$name} |
|
1072
|
0 |
0 |
unless ($opt->{'no_constraints'}) |
|
1082
|
0 |
0 |
if ($table->{'comment'}) |
|
1105
|
0 |
0 |
$constraint->{'cascade_opt'} ? : |
|
1156
|
0 |
0 |
if ($current->{'column_definition'}{$col}) { } |
|
1157
|
0 |
0 |
unless ($current->{'column_definition'}{$col} eq $new->{'column_definition'}{$col}) |
|
1173
|
0 |
0 |
$i == 0 ? : |
|
1180
|
0 |
0 |
if ($self->{'drop_columns'}) |
|
1182
|
0 |
0 |
if $new->{'column_definition'}{$col} |
|
1195
|
0 |
0 |
if ($current_keydef) { } |
|
1196
|
0 |
0 |
unless ($current_keydef eq $new_keydef) |
|
1215
|
0 |
0 |
if (not $current->{'constraint_definition'}{$constraint} or freeze($current->{'constraint_definition'}{$constraint}) ne freeze($new->{'constraint_definition'}{$constraint})) |
|
1220
|
0 |
0 |
if $current->{'constraint_definition'}{$constraint} |
|
1225
|
0 |
0 |
if $new->{'constraint_definition'}{$constraint} |
|
1248
|
0 |
0 |
if ($current) { } |
|
1268
|
0 |
0 |
if $self->__ignore_table($name) |
|
1273
|
0 |
0 |
if ($self->{'remove'}{'table'}) |
|
1276
|
0 |
0 |
if $self->__ignore_table($name) |
|
1279
|
0 |
0 |
if grep {$name eq $_;} @tables |
|
1315
|
0 |
0 |
unless -d $viewdir |
|
1320
|
0 |
0 |
unless my($name) = $view_sql =~ /^(.*)\.sql$/ |
|
1366
|
0 |
0 |
unless -d "$self->{'dir'}/view" |
|
1436
|
0 |
0 |
if $VERBOSE |
|
1497
|
0 |
0 |
if ($current_sql and $current_sql ne $new_sql) |
|
1516
|
0 |
0 |
if $self->__ignore_view($name) |
|
1521
|
0 |
0 |
if ($self->{'remove'}{'view'}) |
|
1524
|
0 |
0 |
if $self->__ignore_view($name) |
|
1527
|
0 |
0 |
if grep {$name eq $_;} @views |
|
1558
|
0 |
0 |
unless -d "$self->{'dir'}/view" |
|
1566
|
0 |
0 |
if $self->__ignore_view($name) |
|
1572
|
0 |
0 |
if ($self->{'remove'}{'view'}) |
|
1574
|
0 |
0 |
if $self->__ignore_view($name) |
|
1577
|
0 |
0 |
if $db_view{$name} |
|
1597
|
0 |
0 |
unless -d $dir |
|
1603
|
0 |
0 |
unless my($name, $time, $action, $table) = $file =~ /^
(.+)\.(before|after)\.(insert|update|delete)\.(.+)\.sql$
/x |
|
1676
|
0 |
0 |
if $self->__ignore_table($table) |
|
1687
|
0 |
0 |
if (not $current) { } |
|
|
0 |
0 |
elsif ($current->{'sql'} ne $new) { } |
|
1707
|
0 |
0 |
if ($self->{'remove'}{'trigger'}) |
|
1710
|
0 |
0 |
if $self->__ignore_table($table) |
|
1716
|
0 |
0 |
if $triggers{$table}{$action}{$time} |
|
1745
|
0 |
0 |
if $self->__ignore_table($table) |
|
1778
|
0 |
0 |
if $self->__ignore_table($table) |
|
1797
|
0 |
0 |
if ($trigger_sql) |
|
1798
|
0 |
0 |
if ($self->{'init_trigger_name'}) { } |
|
1815
|
0 |
0 |
if ($self->{'remove'}{'trigger'}) |
|
1819
|
0 |
0 |
if $found_fragments{$table}{$action}{$time}{$name} |
|
1836
|
0 |
0 |
unless -d "$self->{'dir'}/procedure" |
|
1840
|
0 |
0 |
unless my($name) = $sql =~ /^(.*)\.sql$/ |
|
1883
|
0 |
0 |
if ($current_sql) { } |
|
1884
|
0 |
0 |
if ($new_sql ne $current_sql) |
|
1936
|
0 |
0 |
if ($self->{'remove'}{'procedure'}) |
|
1938
|
0 |
0 |
if grep {$_ eq $name;} @procedures |
|
1989
|
0 |
0 |
unless $sql =~ /\n$/ |
|
2013
|
0 |
0 |
if ($self->{'remove'}{'procedure'}) |
|
2015
|
0 |
0 |
if $found_procedure{$procedure} |
|
2032
|
0 |
0 |
unless -d "$self->{'dir'}/procedure" |
|
2052
|
0 |
0 |
unless $self->{'dbh'} and $self->{'dbh'}->ping |
|
2070
|
0 |
0 |
unless $self->{'dbh'} and $self->{'dbh'}->ping |
|
2095
|
0 |
0 |
unless $QUIET |
|
2096
|
0 |
0 |
if $VERBOSE or $DRYRUN |
|
2098
|
0 |
0 |
unless $DRYRUN |
|
2100
|
0 |
0 |
if $@ |
|
2120
|
0 |
0 |
if (@{$self->{'tables'};}) { } |
|
2146
|
0 |
0 |
if ($current_archive_table) { } |
|
2148
|
0 |
0 |
if $VERBOSE |
|
2161
|
0 |
0 |
if $VERBOSE |