require Koha::Schema;
- my $context = C4::Context->new();
-
- my $db_driver = $context->{db_driver};
-
- my $db_name = $context->config("database");
- my $db_host = $context->config("hostname");
- my $db_port = $context->config("port") || '';
- my $db_user = $context->config("user");
- my $db_passwd = $context->config("pass");
- my $tls = $context->config("tls");
+ my $db_driver = C4::Context::db_scheme2dbi(C4::Context->config('db_scheme'));;
+
+ my $db_name = C4::Context->config("database");
+ my $db_host = C4::Context->config("hostname");
+ my $db_port = C4::Context->config("port") || '';
+ my $db_user = C4::Context->config("user");
+ my $db_passwd = C4::Context->config("pass");
+ my $tls = C4::Context->config("tls");
my $tls_options;
if( $tls && $tls eq 'yes' ) {
- my $ca = $context->config('ca');
- my $cert = $context->config('cert');
- my $key = $context->config('key');
+ my $ca = C4::Context->config('ca');
+ my $cert = C4::Context->config('cert');
+ my $key = C4::Context->config('key');
$tls_options = ";mysql_ssl=1;mysql_ssl_client_key=".$key.";mysql_ssl_client_cert=".$cert.";mysql_ssl_ca_file=".$ca;
}
$tz_query = qq(SET TIME ZONE = "$tz") if $tz;
}
- my $RaiseError = (
- $ENV{DEBUG}
- || $ENV{KOHA_TESTING}
- || exists $ENV{_} && $ENV{_} =~ m|prove|
- ) ? 1 : 0;
my $schema = Koha::Schema->connect(
{
dsn => "dbi:$db_driver:database=$db_name;host=$db_host;port=$db_port".($tls_options? $tls_options : ""),
user => $db_user,
password => $db_passwd,
%encoding_attr,
- RaiseError => $RaiseError,
+ RaiseError => 1,
PrintError => 1,
- unsafe => 1,
quote_names => 1,
+ auto_savepoint => 1,
on_connect_do => [
$encoding_query || (),
$tz_query || (),
my $dbh = $schema->storage->dbh;
eval {
- $dbh->{RaiseError} = 1;
+ my $HandleError = $dbh->{HandleError};
if ( $ENV{KOHA_DB_DO_NOT_RAISE_OR_PRINT_ERROR} ) {
- $dbh->{RaiseError} = 0;
- $dbh->{PrintError} = 0;
+ $dbh->{HandleError} = sub { return 1 };
}
$dbh->do(q|
SELECT * FROM systempreferences WHERE 1 = 0 |
);
- $dbh->{RaiseError} = $RaiseError
+ $dbh->{HandleError} = $HandleError;
};
- $dbh->{RaiseError} = 0 if $@;
+
+ if ( $@ ) {
+ $dbh->{HandleError} = sub { warn $_[0]; return 1 };
+ }
return $schema;
}