blib/lib/MySQL/Backup.pm

filter: Statementstmt 2.5% 8 / 314 Branchbran 0.0% 0 / 174 Conditioncond 0.0% 0 / 29 MC/DCmcdc 0.0% 0 / 17 Subroutinesub 15.3% 2 / 13 Podpod 0.0% 0 / 11 totaltotal 1.7% 10 / 558 CC 111 SCAR 78.3
CC
111
Cov
2%
run_upgrade_script
4556.0
table_desc
132.0
data_backup
132.0
CRAP 2512.8
↑ Summary
1 package MySQL::Backup;
2
3 1 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
4
5 1 ▶use DBI;
Subroutine BEGIN: called CC=1 SCAR=0.0
6 1 our $VERSION = '0.04';
7
8 0 ▶sub new{ #standart constructor
Subroutine new: not called CC=2 SCAR=17.9
Pod undocumented
9 0 my ($pkg, $dbname, $dbhost, $dbuser, $dbpass, $param) = @_;
10
11 0 my $self = {};
12 0 my $dbh = DBI->connect("DBI:mysql:$dbname:$dbhost", $dbuser, $dbpass, {RaiseError=>1});
13 0 $self->{'DBH_OBJ'} = $dbh;
14 0 $self->{'param'} = {};
15
16 0 foreach my $key(keys %{$param}){
17 0 $self->{'param'}->{$key} = $param->{$key};
18 }
19
20 0 bless($self, $pkg);
21 0 return $self;
22 }
23
24 0 ▶sub new_from_DBH{ #if you have already DBI connection, you can use this
Subroutine new_from_DBH: not called CC=2 SCAR=17.9
Pod undocumented
25 0 my ($pkg, $dbh, $param) = @_;
26
27 0 my $self = {};
28 0 $self->{'DBH_OBJ'} = $dbh;
29 0 $self->{'param'} = {};
30
31 0 foreach my $key(keys %{$param}){
32 0 $self->{'param'}->{$key} = $param->{$key};
33 }
34
35 0 bless($self, $pkg);
36 0 return $self;
37 }
38
39 0 ▶sub run_sql{
Subroutine run_sql: not called CC=4 SCAR=30.0
Pod undocumented
40 0 my ($self, $sql) = @_;
41 0 my $dbh = $self->{'DBH_OBJ'};
42 #die $dbh->prepare($sql);
43
44 0 ▶ my $sth = $dbh->prepare($sql) || die $self->caller();
Condition0%0/2
$dbh->prepare($sql) || die($self->caller)
l!l
00
MC/DC0%0/1
$dbh->prepare($sql) || die($self->caller)
$dbh->prepare($sql)
Truth table0%0/2
A
A= $dbh->prepare($sql)
Aresult
11
00
45
46 0 ▶ if (not $sth){
Branch: 1 branch
BranchTrueFalseTotal
unless ($sth) 0 0 0
47 0 die $DBI::errstr;
48 }
49
50 0 my $res = $sth->execute;
51 0 ▶ if (not $res){
Branch: 1 branch
BranchTrueFalseTotal
unless ($res) 0 0 0
52 0 return undef;
53 }
54 0 return $sth;
55 }
56
57 0 ▶sub arr_hash{
Subroutine arr_hash: not called CC=3 SCAR=24.8
Pod undocumented
58 0 my ($self, $sql) = @_;
59 0 my @res;
60 0 ▶ if (my $sth = $self->run_sql($sql)){
Branch: 1 branch
BranchTrueFalseTotal
if (my $sth = $self->run_sql($sql)) 0 0 0
61 0 ▶ while (my $ref = $sth->fetchrow_hashref){
Branch: 1 branch
BranchTrueFalseTotal
if (my $ref = $sth->fetchrow_hashref) 0 0 0
62 0 push @res, $ref;
63 }
64 }
65 0 return @res;
66 }
67
68 0 ▶sub param{
Subroutine param: not called CC=5 SCAR=34.0
Pod undocumented
69 0 my ($self, $ref) = @_;
70 0 ▶ if(ref $ref eq 'HASH'){
Branch: 2 branches
BranchTrueFalseTotal
if (ref $ref eq 'HASH') { } 0 0 0
elsif (ref $ref eq 'SCALAR') { } 0 0 0
71 0 foreach my $key(keys %{$ref}){
72 0 $self->{'param'}->{$key} = $ref->{$key};
73 }
74 }
75 elsif(ref $ref eq 'SCALAR'){
76 0 ▶ if(defined $self->{'param'}->{$ref}){
Branch: 1 branch
BranchTrueFalseTotal
if (defined $self->{'param'}{$ref}) { } 0 0 0
77 0 return $self->{'param'}->{$ref};
78 }
79 else{
80 0 $self->{'error'} = 'can\'t return this param: please check if name of it is right. Also, this param can be undefined';
81 0 return undef;
82 }
83 }
84 }
85
86 0 ▶sub table_desc{ #creates a structure of the inputed table
Subroutine table_desc: not called CC=11 SCAR=48.8
Pod undocumented
87
88 0 my ($self, $table) = @_;
89 0 my @temp = $self->arr_hash("SHOW COLUMNS FROM $table");
90 0 my @temp2;
91
92 0 foreach my $ref(@temp){
93 0 ▶ my $null = 'NOT NULL' if ($ref->{'Null'} !~ m/YES/i);
Branch: 1 branch
BranchTrueFalseTotal
unless $ref->{"Null"} =~ /YES/i 0 0 0
94 0 my $default;
95 0 ▶ if($ref->{'default'}){
Branch: 1 branch
BranchTrueFalseTotal
if ($ref->{'default'}) { } 0 0 0
96 0 $default .= $null.' default '."'".$ref->{'Default'}."'";
97 }
98 else{
99 0 ▶ if (($ref->{'Null'} =~ m/YES/i)and(!($ref->{'Type'} =~ m/timestamp/i))){
Branch: 1 branch
BranchTrueFalseTotal
if ($ref->{'Null'} =~ /YES/i and not $ref->{'Type'} =~ /timestamp/i) { } 0 0 0
Condition0%0/3
$ref->{"Null"} =~ /YES/i and not $ref->{"Type"} =~ /timestamp/i
!ll&&!rl&&r
000
MC/DC0%0/2
$ref->{"Null"} =~ /YES/i and not $ref->{"Type"} =~ /timestamp/i
$ref->{"Null"} =~ /YES/i not $ref->{"Type"} =~ /timestamp/i
Truth table0%0/3
A and not(B)
A= $ref->{"Null"} =~ /YES/iB= not $ref->{"Type"} =~ /timestamp/i
ABresult
0X0
100
111
100 0 $default .= 'default '.'NULL';
101 }
102 else{
103 0 $default .= $null;
104 }
105 }
106 0 chomp $default;
107 0 ▶ push @temp2, join(' ', '`'.$ref->{'Field'}.'`', $ref->{'Type'}, $default.($ref->{'Extra'}?' '.$ref->{'Extra'}:''));
Branch: 1 branch
BranchTrueFalseTotal
$ref->{'Extra'} ? : 0 0 0
108 }
109
110 0 my $columns = join(', ', @temp2);
111
112 0 @temp = $self->arr_hash("SHOW KEYS FROM $table");
113 0 foreach my $ref(@temp){
114 0 ▶ if ($ref->{'Key_name'} =~ m/PRIMARY/i){
Branch: 3 branches
BranchTrueFalseTotal
if ($ref->{'Key_name'} =~ /PRIMARY/i) { } 0 0 0
elsif ($ref->{'Non_unique'} =~ /0/i) { } 0 0 0
elsif ($ref->{'Index_type'} =~ /FULLTEXT/i) { } 0 0 0
115 0 $columns .= ", PRIMARY KEY (`".$ref->{'Column_name'}."`)";
116 }
117 elsif ($ref->{'Non_unique'} =~ m/0/i){
118 0 $columns .= ", UNIQUE INDEX (`".$ref->{'Column_name'}."`)";
119 }
120 elsif ($ref->{'Index_type'} =~ m/FULLTEXT/i){
121 0 $columns .= ", FULLTEXT INDEX (`".$ref->{'Column_name'}."`)";
122 }
123 else{
124 0 $columns .= ", INDEX (`".$ref->{'Column_name'}."`)";
125 }
126 }
127 0 my $sql = "CREATE TABLE `$table` ($columns);";
128
129 0 return $sql;
130 }
131
132 0 ▶sub create_structure{ #creates a structure of the current DB
Subroutine create_structure: not called CC=5 SCAR=34.0
Pod undocumented
133 0 my $self = shift;
134 0 my @arr;
135 my $sql;
136
137 0 ▶ unless($self->{'param'}->{'tables'}){
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'param'}{'tables'}) { } 0 0 0
138 0 my $sth = $self->run_sql("SHOW TABLES");
139 0 ▶ while(my @temp = $sth->fetchrow_array()){
Branch: 1 branch
BranchTrueFalseTotal
if (my(@temp) = $sth->fetchrow_array) 0 0 0
140 0 push @arr, $temp[0];
141 }
142
143 0 foreach my $temp(@arr){
144 0 $sql .= $self->table_desc($temp)."\n";
145 }
146 }
147 else{
148 0 @arr = @{$self->{'param'}->{'tables'}};
149 0 foreach my $temp(@arr){
150 0 $sql .= $self->table_desc($temp)."\n";
151 }
152 }
153
154 0 return $sql;
155 }
156
157 0 ▶sub get_table_data{
Subroutine get_table_data: not called CC=4 SCAR=30.0
Pod undocumented
158
159 0 my ($self, $table) = @_;
160 0 my $data;
161 0 my @temp = $self->arr_hash("SELECT * FROM $table WHERE 1");
162
163 0 foreach my $ref (@temp){
164 0 my @keys = keys %$ref;
165 0 my $key_list = '`'.join('`, `', @keys).'`';
166 0 my @values;
167 0 ▶ for(my $i=0; $i<=$#keys; $i++){
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#keys) 0 0 0
168 0 push @values, $self->{'DBH_OBJ'}->quote($ref->{$keys[$i]});
169 }
170 0 my $value_list = join(', ', @values);
171 0 ▶ if($self->{'param'}->{'USE_REPLACE'}){
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'param'}{'USE_REPLACE'}) { } 0 0 0
172 0 $data .= "REPLACE INTO `$table` ($key_list) VALUES ($value_list);\n";
173 }
174 else{
175 0 $data .= "INSERT INTO `$table` ($key_list) VALUES ($value_list);\n";
176 }
177 }
178
179 0 return $data;
180 }
181
182 0 ▶sub data_backup{ #get all data from current database
Subroutine data_backup: not called CC=11 SCAR=48.8
Pod undocumented
183
184 0 my $self = shift;
185 #my $sth = $self->run_sql("SHOW TABLES");
186 #my (@tables, @tables_for_lock);
187 #while(my $temp = $sth->fetchrow_array()){
188 # push @tables, "$temp";
189 # push @tables_for_lock, "$temp WRITE";
190 #}
191 #$self->run_sql("LOCK TABLES ".join(', ', @tables_for_lock));
192 0 my @arr;
193 0 my $sql = '';
194 #foreach my $temp(@tables){
195 # $sql .= $self->get_table_data($temp);
196 #}
197
198 0 ▶ unless($self->{'param'}->{'tables'}){
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'param'}{'tables'}) { } 0 0 0
199 0 my $sth = $self->run_sql("SHOW TABLES");
200 0 ▶ while(my @temp = $sth->fetchrow_array()){
Branch: 1 branch
BranchTrueFalseTotal
if (my(@temp) = $sth->fetchrow_array) 0 0 0
201 0 push @arr, $temp[0];
202 }
203
204 0 foreach my $temp(@arr){
205 0 my $table_data = $self->get_table_data($temp);
206 0 ▶ $sql .= "/* $temp */\n" if (($self->{'param'}->{'SHOW_TABLE_NAMES'})and($table_data));
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"param"}{"SHOW_TABLE_NAMES"} and $table_data 0 0 0
Condition0%0/3
$self->{"param"}{"SHOW_TABLE_NAMES"} and $table_data
!ll&&!rl&&r
000
MC/DC0%0/2
$self->{"param"}{"SHOW_TABLE_NAMES"} and $table_data
$self->{"param"}{"SHOW_TABLE_NAMES"} $table_data
Truth table0%0/3
A and B
A= $self->{"param"}{"SHOW_TABLE_NAMES"}B= $table_data
ABresult
0X0
100
111
207 0 ▶ $sql .= $table_data if $table_data;
Branch: 1 branch
BranchTrueFalseTotal
if $table_data 0 0 0
208 }
209 }
210 else{
211 0 foreach my $temp(@{$self->{'param'}->{'tables'}}){
212 0 my $table_data = $self->get_table_data($temp);
213 0 ▶ $sql .= "/* $temp */\n" if (($self->{'param'}->{'SHOW_TABLE_NAMES'})and($table_data));
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"param"}{"SHOW_TABLE_NAMES"} and $table_data 0 0 0
Condition0%0/3
$self->{"param"}{"SHOW_TABLE_NAMES"} and $table_data
!ll&&!rl&&r
000
MC/DC0%0/2
$self->{"param"}{"SHOW_TABLE_NAMES"} and $table_data
$self->{"param"}{"SHOW_TABLE_NAMES"} $table_data
Truth table0%0/3
A and B
A= $self->{"param"}{"SHOW_TABLE_NAMES"}B= $table_data
ABresult
0X0
100
111
214 0 ▶ $sql .= $table_data if $table_data;
Branch: 1 branch
BranchTrueFalseTotal
if $table_data 0 0 0
215 }
216 }
217
218 #$self->run_sql("UNLOCK TABLES");
219 0 return $sql;
220 }
221
222 0 ▶sub run_restore_script{
Subroutine run_restore_script: not called CC=7 SCAR=40.3
Pod undocumented
223 0 my ($self, $file) = @_;
224 0 my $sth = $self->run_sql("SHOW TABLES");
225 0 my $dbh = $self->{'DBH_OBJ'};
226 0 my (@tables, @tables_for_lock);
227 0 ▶ while(my $temp = $sth->fetchrow_array()){
Branch: 1 branch
BranchTrueFalseTotal
if (my $temp = $sth->fetchrow_array) 0 0 0
228 0 push @tables, "$temp";
229 0 push @tables_for_lock, "$temp WRITE";
230 }
231 #$self->run_sql("LOCK TABLES ".join(', ', @tables_for_lock));
232 #$sth = run_sql("FLUSH TABLES");
233 0 foreach my $temp(@tables){
234 0 $dbh->do("DROP TABLE IF EXISTS `$temp`");
235 }
236
237 0 open(FILE, $file);
238 0 my $fline = readline(FILE);
239 0 ▶ if ($fline =~ m/\r\n/){
Branch: 3 branches
BranchTrueFalseTotal
if ($fline =~ /\r\n/) { } 0 0 0
elsif ($fline =~ /\n\r/) { } 0 0 0
elsif ($fline =~ /\r/) { } 0 0 0
240 0 $/ = ";\r\n";
241 }
242 elsif($fline =~ m/\n\r/){
243 0 $/ = ";\n\r";
244 }
245 elsif($fline =~ m/\r/){
246 0 $/ = ";\r";
247 }
248 else{
249 0 $/ = ";\n";
250 }
251 0 my @sql = <FILE>;
252 0 unshift @sql, $fline;
253 0 $/= "\n";
254 0 close(FILE);
255
256 0 foreach my $sql(@sql){
257 0 chomp $sql;
258 0 $self->run_sql($sql);
259 }
260
261 #$dbh->do("RESET MASTER");
262 #$self->run_sql("UNLOCK TABLES");
263 0 return \@sql;
264 }
265
266 0 ▶sub run_upgrade_script{
Subroutine run_upgrade_script: not called CC=67 SCAR=84.2
Pod undocumented
267 0 my $self =shift;
268 0 my $file = shift;
269 0 my $db_vers;
270 0 my $dbh = $self->{'DBH_OBJ'};
271 0 my $sth = $self->run_sql("SHOW TABLES");
272 0 my (@tables, @tables_for_lock, $table_list);
273 0 ▶ while(my $temp = $sth->fetchrow_array()){
Branch: 1 branch
BranchTrueFalseTotal
if (my $temp = $sth->fetchrow_array) 0 0 0
274 0 push @tables, "`$temp`";
275 0 push @tables_for_lock, "`$temp` WRITE";
276 }
277 #run_sql("LOCK TABLES ".join(', ', @tables_for_lock));
278 #$sth = run_sql("FLUSH TABLES");
279
280 0 open(FILE, $file);
281 0 my $fline = readline(FILE);
282 0 ▶ if ($fline =~ m/\r\n/){
Branch: 2 branches
BranchTrueFalseTotal
if ($fline =~ /\r\n/) { } 0 0 0
elsif ($fline =~ /\n\r/) { } 0 0 0
283 0 $/ = ";\r\n";
284 }
285 elsif($fline =~ m/\n\r/){
286 0 $/ = ";\n\r";
287 }
288 else{
289 0 $/ = ";\n";
290 }
291
292 0 my @sql = <FILE>;
293 0 unshift @sql, $fline;
294 0 $/= "\n";
295 0 close(FILE);
296
297 0 foreach my $sql(@sql){
298 0 chomp $sql;
299 0 ▶ if($sql =~ /^CREATE TABLE ([`\w]+) \((.*)\)/i){
Branch: 3 branches
BranchTrueFalseTotal
if ($sql =~ /^CREATE TABLE ([`\w]+) \((.*)\)/i) { } 0 0 0
elsif ($sql =~ /^ALTER TABLE (.*) DROP INDEX (.*);/i) { } 0 0 0
elsif ($sql =~ /^INSERT/i or $sql =~ /^REPLACE/i) { } 0 0 0
300 0 ▶ for(my $i=0; $i<=$#tables; $i++){
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#tables) 0 0 0
301 #die "lc($tables[$i]) eq lc($1)";
302 0 ▶ if(($tables[$i] eq $1)or(lc($tables[$i]) eq lc($1))){
Branch: 1 branch
BranchTrueFalseTotal
if ($tables[$i] eq $1 or lc $tables[$i] eq lc $1) 0 0 0
Condition0%0/3
$tables[$i] eq $1 or lc $tables[$i] eq lc $1
l!l&&r!l&&!r
000
MC/DC0%0/2
$tables[$i] eq $1 or lc $tables[$i] eq lc $1
$tables[$i] eq $1 lc $tables[$i] eq lc $1
Truth table0%0/3
A or B
A= $tables[$i] eq $1B= lc $tables[$i] eq lc $1
ABresult
1X1
011
000
303 0 my $temp_2_1 = $2;
304 0 my @columns_desc = split /, /, $temp_2_1;
305 0 my $real_table = $self->table_desc($tables[$i]);
306 #die $real_table
307 #die $real_table."<br>".$sql if $tables[$i] eq 'perldesk_kb_ratings';
308 0 $real_table =~ /^CREATE TABLE ([`\w]+) \((.*)\)/i;
309 0 my $temp_2_2 = $2;
310 0 my @real_columns_desc = split /, /, $temp_2_2;
311
312
313
314 0 my (@columns, @real_columns);
315 0 $#columns = $#columns_desc;
316 0 $#real_columns = $#real_columns_desc;
317 0 ▶ for(my $j=0; $j<=$#columns_desc; $j++){
Branch: 1 branch
BranchTrueFalseTotal
if ($j <= $#columns_desc) 0 0 0
318 0 $columns_desc[$j] =~ s/^\s*(.*?)\s*$/$1/gi;
319 0 ▶ if($columns_desc[$j] =~ m/^([`\w]+) /){
Branch: 1 branch
BranchTrueFalseTotal
if ($columns_desc[$j] =~ /^([`\w]+) /) 0 0 0
320 0 $columns[$j] = $1;
321 }
322 }
323
324 0 ▶ for(my $j=0; $j<=$#real_columns_desc; $j++){
Branch: 1 branch
BranchTrueFalseTotal
if ($j <= $#real_columns_desc) 0 0 0
325 0 $real_columns_desc[$j] =~ s/^\s*(.*?)\s*$/$1/gi;
326 0 ▶ if($real_columns_desc[$j] =~ m/^([`\w]+) /){
Branch: 1 branch
BranchTrueFalseTotal
if ($real_columns_desc[$j] =~ /^([`\w]+) /) 0 0 0
327 0 $real_columns[$j] = $1;
328 }
329 }
330
331 0 my $bool = 0;
332 0 ▶ for(my $j=0; $j<=$#columns; $j++){ #checking for existing of columns
Branch: 1 branch
BranchTrueFalseTotal
if ($j <= $#columns) 0 0 0
333 0 ▶ for(my $k=0; $k<=$#real_columns; $k++){
Branch: 1 branch
BranchTrueFalseTotal
if ($k <= $#real_columns) 0 0 0
334 0 $bool = 0;
335 0 ▶ if ($columns_desc[$j] =~ /^PRIMARY KEY \(([`\w]+)\)/){ #checking if it's Primary key
Branch: 6 branches
BranchTrueFalseTotal
if ($columns_desc[$j] =~ /^PRIMARY KEY \(([`\w]+)\)/) { } 0 0 0
elsif ($columns_desc[$j] =~ /^KEY(.*)\(([`\w]+)\)/) { } 0 0 0
elsif ($columns_desc[$j] =~ /^INDEX(.*)\(([`\w]+)\)/) { } 0 0 0
elsif ($columns_desc[$j] =~ /^UNIQUE INDEX(.*)\(([`\w]+)\)/) { } 0 0 0
elsif ($columns_desc[$j] =~ /^FULLTEXT INDEX(.*)\(([`\w]+)\)/) { } 0 0 0
elsif (lc $columns[$j] eq lc $real_columns[$k]) { } 0 0 0
336 0 my $column_name = $1;
337 #die $tables[$i];
338 0 $sth = $self->run_sql("SHOW KEYS FROM $tables[$i]");
339
340 0 ▶ while(my $temp = $sth->fetchrow_hashref()){
Branch: 1 branch
BranchTrueFalseTotal
if (my $temp = $sth->fetchrow_hashref) 0 0 0
341 # die $temp->{'Column_name'}.' '.$column_name;
342 0 ▶ if((($temp->{'Key_name'} eq 'PRIMARY')or($temp->{'Key_name'} eq 'primary'))and(('`'.$temp->{'Column_name'}.'`' eq $column_name)or('`'.lc($temp->{'Column_name'}).'`' eq lc($column_name)))){
Branch: 1 branch
BranchTrueFalseTotal
if ($temp->{"Key_name"} eq "PRIMARY" || $temp->{"Key_name"} eq "primary" and '`' . $temp->{"Column_name"} . '`' eq $column_name || '`' . lc($temp->{"Column_name"}) . '`' eq lc $column_name) 0 0 0
Condition0%0/9
$temp->{"Key_name"} eq "PRIMARY" || $temp->{"Key_name"} eq "primary" and '`' . $temp->{"Column_name"} . '`' eq $column_name || '`' . lc($temp->{"Column_name"}) . '`' eq lc $column_name
!ll&&!rl&&r
000
$temp->{"Key_name"} eq "PRIMARY" or $temp->{"Key_name"} eq "primary"
l!l&&r!l&&!r
000
'`' . $temp->{"Column_name"} . '`' eq $column_name or '`' . lc($temp->{"Column_name"}) . '`' eq lc $column_name
l!l&&r!l&&!r
000
MC/DC0%0/4
$temp->{"Key_name"} eq "PRIMARY" || $temp->{"Key_name"} eq "primary" and '`' . $temp->{"Column_name"} . '`' eq $column_name || '`' . lc($temp->{"Column_name"}) . '`' eq lc $column_name
$temp->{"Key_name"} eq "PRIMARY" $temp->{"Key_name"} eq "primary" '`' . $temp->{"Column_name"} . '`' eq $column_name '`' . lc($temp->{"Column_name"}) . '`' eq lc $column_name
Truth table0%0/7
A or B and C or D
A= $temp->{"Key_name"} eq "PRIMARY"B= $temp->{"Key_name"} eq "primary"C= '`' . $temp->{"Column_name"} . '`' eq $column_nameD= '`' . lc($temp->{"Column_name"}) . '`' eq lc $column_name
ABCDresult
00XX0
1X000
01000
1X1X1
1X011
011X1
01011
343 0 $bool= 1;
344 #die $bool;
345 0 last;
346 }
347 }
348 }
349
350
351 elsif ($columns_desc[$j] =~ /^KEY(.*)\(([`\w]+)\)/){ #checking if it's key
352 #for(my $l=0; $l<$#real_columns; $l++){
353 0 ▶ if($columns_desc[$j] eq $real_columns_desc[$k]){
Branch: 1 branch
BranchTrueFalseTotal
if ($columns_desc[$j] eq $real_columns_desc[$k]) 0 0 0
354
355 0 $bool = 1;
356 0 last;
357 }
358 #}
359 0 ▶ if($bool){last;}
Branch: 1 branch
BranchTrueFalseTotal
if ($bool) 0 0 0
360 }
361 # elsif ($columns_desc[$j] =~ /^INDEX/){
362
363 # }
364 elsif ($columns_desc[$j] =~ /^INDEX(.*)\(([`\w]+)\)/){ #checking if it's key
365 #for(my $l=0; $l<$#real_columns; $l++){
366 0 ▶ if($columns_desc[$j] eq $real_columns_desc[$k]){
Branch: 1 branch
BranchTrueFalseTotal
if ($columns_desc[$j] eq $real_columns_desc[$k]) 0 0 0
367 #die $real_columns_desc[$k];
368 0 $bool = 1;
369 #die $columns_desc[$j]." ".$real_columns_desc[$k];
370 #die $bool;
371 0 last;
372 }
373 #}
374 0 ▶ if($bool){last;}
Branch: 1 branch
BranchTrueFalseTotal
if ($bool) 0 0 0
375 }
376 elsif ($columns_desc[$j] =~ /^UNIQUE INDEX(.*)\(([`\w]+)\)/){ #checking if it's key UNIQUE
377
378 #for(my $l=0; $l<$#real_columns; $l++){
379 0 ▶ if($columns_desc[$j] eq $real_columns_desc[$k]){
Branch: 1 branch
BranchTrueFalseTotal
if ($columns_desc[$j] eq $real_columns_desc[$k]) 0 0 0
380 0 $bool = 1;
381 #die $columns_desc[$j];
382 0 last;
383 }
384 #}
385 0 ▶ if($bool){last;}
Branch: 1 branch
BranchTrueFalseTotal
if ($bool) 0 0 0
386 }
387
388 elsif ($columns_desc[$j] =~ /^FULLTEXT INDEX(.*)\(([`\w]+)\)/){ #checking if it's key FULLTEXT
389 #die $columns_desc[$j];
390 #for(my $l=0; $l<$#real_columns; $l++){
391 0 ▶ if($columns_desc[$j] eq $real_columns_desc[$k]){
Branch: 1 branch
BranchTrueFalseTotal
if ($columns_desc[$j] eq $real_columns_desc[$k]) 0 0 0
392 0 $bool = 1;
393 0 last;
394 }
395 #}
396 0 ▶ if($bool){last;}
Branch: 1 branch
BranchTrueFalseTotal
if ($bool) 0 0 0
397 }
398
399 elsif(lc($columns[$j]) eq lc($real_columns[$k])){ #checking for existence of column
400 0 ▶ if(lc($columns_desc[$j]) eq lc($real_columns_desc[$k])){
Branch: 1 branch
BranchTrueFalseTotal
if (lc $columns_desc[$j] eq lc $real_columns_desc[$k]) { } 0 0 0
401 0 $bool = 1;
402 0 last;
403 }
404 else{
405 #die "lc($columns[$j]) eq lc($real_columns[$k])";
406 # die "$columns_desc[$j] eq $real_columns_desc[$k]";
407 0 $bool = 2;
408 0 last;
409 }
410 }
411 }
412 0 my $key;
413 0 ▶ unless($bool){ #the column or Key doesn't exist
Branch: 2 branches
BranchTrueFalseTotal
if ($bool) { } 0 0 0
if (do { $bool == 2 }) 0 0 0
414 #chomp $columns_desc[$j];
415
416 0 ▶ if($columns_desc[$j] =~ /^PRIMARY KEY \(([`\w]+)\)/){
Branch: 1 branch
BranchTrueFalseTotal
if ($columns_desc[$j] =~ /^PRIMARY KEY \(([`\w]+)\)/) 0 0 0
417
418 0 my $column_name = $1; #die $column_name;
419 0 $key = "PRIMARY KEY ($column_name)";
420 #killimg duplicates
421 0 my $sth = $self->run_sql("SELECT * FROM $tables[$i] WHERE 1");
422 0 ▶ while(my $temp = $sth->fetchrow_hashref()){
Branch: 1 branch
BranchTrueFalseTotal
if (my $temp = $sth->fetchrow_hashref) 0 0 0
423 0 my $th = $self->run_sql("SELECT * FROM $tables[$i] WHERE $column_name = ".$dbh->quote($temp->{$column_name}));
424 0 my $rows = $th->rows;
425 0 ▶ if($rows > 1){
Branch: 1 branch
BranchTrueFalseTotal
if ($rows > 1) 0 0 0
426 0 $self->run_sql("DELETE FROM $tables[$i] WHERE $column_name = ".$dbh->quote($temp->{$column_name})." LIMIT 1");
427 0 $table_list.="DELETE FROM $tables[$i] WHERE $column_name = ".$dbh->quote($temp->{$column_name})." LIMIT 1\n";
428 }
429 }
430 }
431 0 my $key_name;
432 0 ▶ unless ($key){
Branch: 1 branch
BranchTrueFalseTotal
unless ($key) 0 0 0
433 0 ▶ if($columns_desc[$j] =~ /^KEY (.*) \((.*)\)/){
Branch: 8 branches
BranchTrueFalseTotal
if ($columns_desc[$j] =~ /^KEY (.*) \((.*)\)/) { } 0 0 0
elsif ($columns_desc[$j] =~ /^KEY(.*)\((.*)\)/) { } 0 0 0
elsif ($columns_desc[$j] =~ /^INDEX (.*) \((.*)\)/) { } 0 0 0
elsif ($columns_desc[$j] =~ /^INDEX(.*)\((.*)\)/) { } 0 0 0
elsif ($columns_desc[$j] =~ /^UNIQUE INDEX (.*) \((.*)\)/) { } 0 0 0
elsif ($columns_desc[$j] =~ /^UNIQUE INDEX(.*)\((.*)\)/) { } 0 0 0
elsif ($columns_desc[$j] =~ /^FULLTEXT INDEX (.*) \((.*)\)/) { } 0 0 0
elsif ($columns_desc[$j] =~ /^FULLTEXT INDEX(.*)\((.*)\)/) { } 0 0 0
434 0 $key = "INDEX $1 ($2)";
435 0 $key_name = $1;
436 }
437 elsif($columns_desc[$j] =~ /^KEY(.*)\((.*)\)/){
438 0 $key = "INDEX ($2)";
439 0 $key_name = $2;
440 }
441 elsif($columns_desc[$j] =~ /^INDEX (.*) \((.*)\)/){
442 0 $key = "INDEX $1 ($2)";
443 0 $key_name = $1;
444 }
445 elsif($columns_desc[$j] =~ /^INDEX(.*)\((.*)\)/){
446 0 $key = "INDEX ($2)";
447 0 $key_name = $2;
448 }
449 elsif($columns_desc[$j] =~ /^UNIQUE INDEX (.*) \((.*)\)/){
450 0 $key = "UNIQUE INDEX $1 ($2)";
451 0 $key_name = $1;
452 }
453 elsif($columns_desc[$j] =~ /^UNIQUE INDEX(.*)\((.*)\)/){
454 0 $key = "UNIQUE INDEX ($2)";
455 0 $key_name = $2;
456 }
457 elsif($columns_desc[$j] =~ /^FULLTEXT INDEX (.*) \((.*)\)/){
458 0 $key = "FULLTEXT INDEX $1 ($2)";
459 0 $key_name = $1;
460 }
461 elsif($columns_desc[$j] =~ /^FULLTEXT INDEX(.*)\((.*)\)/){
462 0 $key = "FULLTEXT INDEX ($2)";
463 0 $key_name = $2;
464 }
465
466 }
467
468 0 ▶ unless($key){
Branch: 1 branch
BranchTrueFalseTotal
if ($key) { } 0 0 0
469 0 my $add;
470 0 ▶ if($columns_desc[$j] =~ m/auto_increment/i){$add=' PRIMARY KEY';}
Branch: 1 branch
BranchTrueFalseTotal
if ($columns_desc[$j] =~ /auto_increment/i) 0 0 0
471 0 my $sql2 = "ALTER TABLE $tables[$i] ADD COLUMN ".$columns_desc[$j].$add;
472 0 ▶ eval{$dbh->do($sql2)} or die $self->errstr("Couldn't execute statement: $sql2 $DBI::errstr: stopped");
Branch: 1 branch
BranchTrueFalseTotal
eval { do { $dbh->do($sql2) } } or die $self->errstr("Couldn't execute statement: $sql2 $DBI::errstr: stopped") 0 0 0
473 0 $table_list .= $sql2."\n";
474 }
475 else{
476
477 0 my $sql2 = "SHOW KEYS FROM $tables[$i]";
478 #die $sql2;
479 0 my $sth = $self->run_sql($sql2);
480 0 $table_list .= $sql2."\n";
481 0 my $key_exists;
482 0 ▶ while(my $ref = $sth->fetchrow_hashref()){
Branch: 1 branch
BranchTrueFalseTotal
if (my $ref = $sth->fetchrow_hashref) 0 0 0
483 0 die $ref->{'Key_name'}.' ? '.$key_name;
484 0 ▶ if('`'.$ref->{'Key_name'}.'`' eq $key_name){
Branch: 1 branch
BranchTrueFalseTotal
if ('`' . $ref->{"Key_name"} . '`' eq $key_name) 0 0 0
485 0 $key_exists = 1;
486 0 last;
487 }
488 }
489 0 ▶ unless($key_exists){
Branch: 1 branch
BranchTrueFalseTotal
unless ($key_exists) 0 0 0
490 0 $sql2 = "ALTER TABLE $tables[$i] ADD $key";
491 0 die $sql2;
492 0 $self->run_sql($sql2);
493 0 $table_list .= $sql2."\n";
494 }
495 }
496
497 #$bool =1;
498 }
499 0 elsif($bool == 2){
500 0 my $add;
501 #if($columns_desc[$j] =~ m/auto_increment/i){$add=' PRIMARY KEY';}
502 0 my $sql2 = "ALTER TABLE $tables[$i] MODIFY COLUMN ".$columns_desc[$j].$add;
503 0 ▶ eval{$dbh->do($sql2)} or die $self->errstr("Couldn't execute statement: $sql2 $DBI::errstr: stopped");
Branch: 1 branch
BranchTrueFalseTotal
eval { do { $dbh->do($sql2) } } or die $self->errstr("Couldn't execute statement: $sql2 $DBI::errstr: stopped") 0 0 0
504 0 $table_list .= $sql2."\n";
505 }
506 }
507
508 0 $table_list .= "Log: ".$tables[$i]." ".$2."\n";
509 0 last;
510 }
511 0 ▶ if($i == $#tables){ #table doesn't exist
Branch: 1 branch
BranchTrueFalseTotal
if ($i == $#tables) 0 0 0
512 0 $dbh->do($sql);
513 0 $table_list .= $sql."\n";
514 }
515 }
516 }
517 elsif($sql =~ /^ALTER TABLE (.*) DROP INDEX (.*);/i){
518 0 $sth = $self->run_sql("SHOW KEYS FROM $1");
519 0 my $bool = 0;
520 0 ▶ while(my $temp = $sth->fetchrow_hashref()){
Branch: 1 branch
BranchTrueFalseTotal
if (my $temp = $sth->fetchrow_hashref) 0 0 0
521 0 ▶ if(lc($temp->{'Key_name'}) eq lc($2)){
Branch: 1 branch
BranchTrueFalseTotal
if (lc $temp->{"Key_name"} eq lc $2) 0 0 0
522 0 $bool= 1;
523 0 last;
524 }
525 }
526 0 ▶ if ($bool){
Branch: 1 branch
BranchTrueFalseTotal
if ($bool) 0 0 0
527 0 $table_list .= $sql."\n";
528 0 $dbh->do($sql);
529 }
530 }
531 ▶ elsif(($sql =~ /^INSERT/i)or($sql =~ /^REPLACE/i)){
Condition0%0/3
$sql =~ /^INSERT/i or $sql =~ /^REPLACE/i
l!l&&r!l&&!r
000
MC/DC0%0/2
$sql =~ /^INSERT/i or $sql =~ /^REPLACE/i
$sql =~ /^INSERT/i $sql =~ /^REPLACE/i
Truth table0%0/3
A or B
A= $sql =~ /^INSERT/iB= $sql =~ /^REPLACE/i
ABresult
1X1
011
000
532 0 $sql =~ s/^INSERT/REPLACE/i;
533 0 $sql =~ m/INTO (\w+)/i;
534 0 my $table = $1;
535 0 ▶ if(($table eq 'perlDesk_settings')and($sql !~ /^ALTER/i)){
Branch: 1 branch
BranchTrueFalseTotal
if ($table eq 'perlDesk_settings' and not $sql =~ /^ALTER/i) { } 0 0 0
Condition0%0/3
$table eq "perlDesk_settings" and not $sql =~ /^ALTER/i
!ll&&!rl&&r
000
MC/DC0%0/2
$table eq "perlDesk_settings" and not $sql =~ /^ALTER/i
$table eq "perlDesk_settings" not $sql =~ /^ALTER/i
Truth table0%0/3
A and not(B)
A= $table eq "perlDesk_settings"B= not $sql =~ /^ALTER/i
ABresult
0X0
100
111
536 0 ▶ if($sql =~ m/\(value, setting\) VALUES \('(.*)', 'db_version'\);$/i){
Branch: 1 branch
BranchTrueFalseTotal
if ($sql =~ /\(value, setting\) VALUES \('(.*)', 'db_version'\);$/i) { } 0 0 0
537 0 $db_vers = $1;
538 0 $table_list .= $sql."\n";
539 0 $self->run_sql($sql);
540 }
541 else{
542 0 $sql =~ m/\(value, setting\) VALUES \('(.*)', '(.*)'\);$/i;
543 0 my ($value, $setting) = ($1, $2);
544 0 my $sth = $self->run_sql("SELECT * FROM perlDesk_settings WHERE setting=".$dbh->quote($setting));
545 0 ▶ unless($sth->rows){
Branch: 1 branch
BranchTrueFalseTotal
unless ($sth->rows) 0 0 0
546 0 $table_list .= $sql."\n";
547 0 $self->run_sql($sql);
548 }
549 }
550 }
551 else{
552 0 $table_list .= $sql."\n";
553 0 my $rt = $dbh->prepare($sql);
554 0 $rt->execute;
555 }
556 }
557 else{
558 0 $table_list .= $sql."\n";
559 0 my $rt = $dbh->prepare($sql);
560 0 $rt->execute;
561 }
562 }
563
564
565
566
567 0 $self->run_sql("UNLOCK TABLES");
568 0 return $db_vers;
569 }
570
571 1 1;
572
573 __END__
↑ Summary