Lines 204-210
sub _add_exception {
Link Here
|
204 |
$schema->storage->txn_rollback; |
204 |
$schema->storage->txn_rollback; |
205 |
|
205 |
|
206 |
subtest 'copy_to_branch' => sub { |
206 |
subtest 'copy_to_branch' => sub { |
207 |
|
207 |
|
208 |
plan tests => 8; |
208 |
plan tests => 8; |
209 |
|
209 |
|
210 |
$schema->storage->txn_begin; |
210 |
$schema->storage->txn_begin; |
Lines 281-292
subtest 'copy_to_branch' => sub {
Link Here
|
281 |
|
281 |
|
282 |
#Select all rows with same values from database |
282 |
#Select all rows with same values from database |
283 |
my $dbh = C4::Context->dbh; |
283 |
my $dbh = C4::Context->dbh; |
284 |
my $get_repeatable_holidays = "SELECT a.* FROM repeatable_holidays a |
284 |
my $get_repeatable_holidays = "SELECT a.* FROM repeatable_holidays a |
285 |
JOIN (SELECT branchcode, weekday, day, month, COUNT(*) |
285 |
JOIN (SELECT branchcode, weekday, day, month, COUNT(*) |
286 |
FROM repeatable_holidays |
286 |
FROM repeatable_holidays |
287 |
GROUP BY branchcode, weekday, day, month HAVING count(*) > 1) b |
287 |
GROUP BY branchcode, weekday, day, month HAVING count(*) > 1) b |
288 |
ON a.branchcode = b.branchcode |
288 |
ON a.branchcode = b.branchcode |
289 |
AND ( a.weekday = b.weekday OR (a.day = b.day AND a.month = b.month)) |
289 |
AND ( a.weekday = b.weekday OR (a.day = b.day AND a.month = b.month)) |
290 |
ORDER BY a.branchcode;"; |
290 |
ORDER BY a.branchcode;"; |
291 |
my $sth = $dbh->prepare($get_repeatable_holidays); |
291 |
my $sth = $dbh->prepare($get_repeatable_holidays); |
292 |
$sth->execute; |
292 |
$sth->execute; |
Lines 295-308
subtest 'copy_to_branch' => sub {
Link Here
|
295 |
while(my $row = $sth->fetchrow_hashref){ |
295 |
while(my $row = $sth->fetchrow_hashref){ |
296 |
push @repeatable_holidays, $row |
296 |
push @repeatable_holidays, $row |
297 |
} |
297 |
} |
298 |
|
298 |
|
299 |
is( scalar(@repeatable_holidays), 0, "None of the repeatable holidays were doubled"); |
299 |
is( scalar(@repeatable_holidays), 0, "None of the repeatable holidays were doubled"); |
300 |
|
300 |
|
301 |
my $get_special_holidays = "SELECT a.* FROM special_holidays a |
301 |
my $get_special_holidays = "SELECT a.* FROM special_holidays a |
302 |
JOIN (SELECT branchcode, day, month, year, isexception, COUNT(*) |
302 |
JOIN (SELECT branchcode, day, month, year, isexception, COUNT(*) |
303 |
FROM special_holidays |
303 |
FROM special_holidays |
304 |
GROUP BY branchcode, day, month, year, isexception HAVING count(*) > 1) b |
304 |
GROUP BY branchcode, day, month, year, isexception HAVING count(*) > 1) b |
305 |
ON a.branchcode = b.branchcode |
305 |
ON a.branchcode = b.branchcode |
306 |
AND a.day = b.day AND a.month = b.month AND a.year = b.year AND a.isexception = b.isexception |
306 |
AND a.day = b.day AND a.month = b.month AND a.year = b.year AND a.isexception = b.isexception |
307 |
ORDER BY a.branchcode;"; |
307 |
ORDER BY a.branchcode;"; |
308 |
$sth = $dbh->prepare($get_special_holidays); |
308 |
$sth = $dbh->prepare($get_special_holidays); |
Lines 317-320
subtest 'copy_to_branch' => sub {
Link Here
|
317 |
|
317 |
|
318 |
$schema->storage->txn_rollback; |
318 |
$schema->storage->txn_rollback; |
319 |
|
319 |
|
320 |
} |
320 |
}; |
321 |
- |
|
|