X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB.pm;h=861fe6a52835bf8882e4e1185d6c4617c79878c0;hb=dc3f6120f9bbacaa028e554d7fa71e481d4497b4;hp=f90a9c6371a72710287499afbbe3c12384d2abd6;hpb=89c9ff022d3f13e27ba6bda085df15707fcfb0eb;p=kivitendo-erp.git diff --git a/SL/DB.pm b/SL/DB.pm index f90a9c637..861fe6a52 100644 --- a/SL/DB.pm +++ b/SL/DB.pm @@ -4,11 +4,14 @@ use strict; use Carp; use Data::Dumper; +use SL::DBConnect; use English qw(-no_match_vars); use Rose::DB; +use Rose::DBx::Cache::Anywhere; use base qw(Rose::DB); +__PACKAGE__->db_cache_class('Rose::DBx::Cache::Anywhere'); __PACKAGE__->use_private_registry; my (%_db_registered, %_initial_sql_executed); @@ -16,24 +19,14 @@ my (%_db_registered, %_initial_sql_executed); sub dbi_connect { shift; - return DBI->connect(@_) unless $::lx_office_conf{debug} && $::lx_office_conf{debug}->{dbix_log4perl}; - - require Log::Log4perl; - require DBIx::Log4perl; - - my $filename = $LXDebug::file_name; - my $config = $::lx_office_conf{debug}->{dbix_log4perl_config}; - $config =~ s/LXDEBUGFILE/${filename}/g; - - Log::Log4perl->init(\$config); - return DBIx::Log4perl->connect(@_); + return SL::DBConnect->connect(@_); } sub create { my $domain = shift || SL::DB->default_domain; my $type = shift || SL::DB->default_type; - my ($domain, $type) = _register_db($domain, $type); + ($domain, $type) = _register_db($domain, $type); my $db = __PACKAGE__->new_or_cached(domain => $domain, type => $type); @@ -65,7 +58,7 @@ sub _register_db { } elsif ($type eq 'LXOFFICE_AUTH') { %connect_settings = ( driver => $::myconfig{dbdriver} || 'Pg', database => $::auth->{DB_config}->{db}, - host => $::auth->{DB_config}->{host}, + host => $::auth->{DB_config}->{host} || 'localhost', port => $::auth->{DB_config}->{port} || 5432, username => $::auth->{DB_config}->{user}, password => $::auth->{DB_config}->{password}, @@ -74,12 +67,13 @@ sub _register_db { } else { my $european_dates = 0; if ($::myconfig{dateformat}) { - $european_dates = 1 if $_dateformats{ $::myconfig{dateformat} } =~ m/european/i; + $european_dates = 1 if $_dateformats{ $::myconfig{dateformat} } + && $_dateformats{ $::myconfig{dateformat} } =~ m/european/i; } %connect_settings = ( driver => $::myconfig{dbdriver} || 'Pg', database => $::myconfig{dbname}, - host => $::myconfig{dbhost}, + host => $::myconfig{dbhost} || 'localhost', port => $::myconfig{dbport} || 5432, username => $::myconfig{dbuser}, password => $::myconfig{dbpasswd}, @@ -91,7 +85,7 @@ sub _register_db { my %flattened_settings = _flatten_settings(%connect_settings); $domain = 'LXOFFICE' if $type =~ m/^LXOFFICE/; - $type .= join($SUBSCRIPT_SEPARATOR, map { ($_, $flattened_settings{$_}) } sort keys %flattened_settings); + $type .= join($SUBSCRIPT_SEPARATOR, map { ($_, $flattened_settings{$_} || '') } sort keys %flattened_settings); my $idx = "${domain}::${type}"; if (!$_db_registered{$idx}) {