1 package C4::Database; #assumes C4/Database
3 #requires DBI.pm to be installed
6 # Copyright 2000-2002 Katipo Communications
8 # This file is part of Koha.
10 # Koha is free software; you can redistribute it and/or modify it under the
11 # terms of the GNU General Public License as published by the Free Software
12 # Foundation; either version 2 of the License, or (at your option) any later
15 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
16 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
17 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
19 # You should have received a copy of the GNU General Public License along with
20 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
21 # Suite 330, Boston, MA 02111-1307 USA
24 # C4::Database::C4Connect has been superseded by C4::Context->dbh;
27 # If C4::Biblio::OLD_MAY_BE_DELETED_newcompletebiblioitem can, in
28 # fact, be deleted, then it should be. Then C4::Biblio::getoraddbiblio
29 # won't be used anywhere, and it can be deleted too. That'll make two
30 # fewer functions that use C4::Database::requireDBI.
35 use vars qw($VERSION @ISA @EXPORT);
41 &C4Connect &requireDBI
46 my ($database,$hostname,$user,$pass,%configfile);
47 open (KC, "/etc/koha.conf");
51 if (/(.*)\s*=\s*(.*)/) {
54 # Clean up white space at beginning and end
59 $configfile{$variable}=$value;
62 $database=$configfile{'database'};
63 $hostname=$configfile{'hostname'};
64 $user=$configfile{'user'};
65 $pass=$configfile{'pass'};
67 my $dbh=DBI->connect("DBI:mysql:$database:$hostname",$user,$pass);
73 &requireDBI($dbh, $functionnname);
75 Verifies that C<$dbh> is a valid DBI::db database handle (presumably
76 to the Koha database). If it isn't, the function dies.
78 C<$functionname> is the name of the calling function, which will be
79 used in error messages.
84 # Helper subroutine to make sure database handle was passed properly
88 $subrname, # name of calling subroutine
89 # FIXME - Ought to get this with 'caller',
90 # instead of requiring developers to always
91 # get it right. Plus, it'd give the line
95 unless ( ref($dbh) =~ /DBI::db/ ) {
96 print "<pre>\nERROR: Subroutine $subrname called without proper DBI handle.\n" .
97 "Please contact system administrator.\n</pre>\n";
98 die "ERROR: Subroutine $subrname called without proper DBI handle.\n";