1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
|
#!/usr/bin/perl -w
#
# rhrdlibs
#
# Copyright (C) 2015 Christian Pointner <equinox@helsinki.at>
#
# This file is part of rhrdlibs.
#
# rhrdlibs is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# any later version.
#
# rhrdlibs is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU Affero General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with rhrdlibs. If not, see <http://www.gnu.org/licenses/>.
#
use strict;
use lib "../lib/";
use RHRD::rddb;
my ($dbh, undef, $errorstring) = RHRD::rddb::opendb();
if(defined $dbh) {
print "Shows:\n";
my ($low_cart, $high_cart, $chunk_size) = RHRD::rddb::get_shows_cart_range($dbh);
if(!$low_cart) {
print "$high_cart: $chunk_size\n";
} else {
print "Range: " . $low_cart . " - " . $high_cart . ", chunk size: " . $chunk_size . "\n";
}
my ($slot_low_cart, $slot_high_cart, $err) = RHRD::rddb::get_shows_next_free_slot($dbh);
if(!$slot_low_cart) {
print "$slot_high_cart: $err\n";
} else {
print " Next Free: " . $slot_low_cart . " - " . $slot_high_cart . "\n";
}
print "\nMusic Pools:\n";
($low_cart, $high_cart, $chunk_size) = RHRD::rddb::get_musicpools_cart_range($dbh);
if(!$low_cart) {
print "$high_cart: $chunk_size\n";
} else {
print "Range: " . $low_cart . " - " . $high_cart . ", chunk size: " . $chunk_size . "\n";
}
($slot_low_cart, $slot_high_cart, $err) = RHRD::rddb::get_musicpools_next_free_slot($dbh);
if(!$slot_low_cart) {
print "$slot_high_cart: $err\n";
} else {
print " Next Free: " . $slot_low_cart . " - " . $slot_high_cart . "\n";
}
print "\nJingles:\n";
($low_cart, $high_cart, $chunk_size) = RHRD::rddb::get_jingles_cart_range($dbh);
if(!$low_cart) {
print "$high_cart: $chunk_size\n";
} else {
print "Range: " . $low_cart . " - " . $high_cart . ", chunk size: " . $chunk_size . "\n";
}
($slot_low_cart, $slot_high_cart, $err) = RHRD::rddb::get_jingles_next_free_slot($dbh);
if(!$slot_low_cart) {
print "$slot_high_cart: $err\n";
} else {
print " Next Free: " . $slot_low_cart . " - " . $slot_high_cart . "\n";
}
RHRD::rddb::closedb($dbh);
} else {
print "$errorstring\n";
exit 1;
}
exit 0
|
