X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB.pm;h=861fe6a52835bf8882e4e1185d6c4617c79878c0;hb=b498a3939d86fd9fd7c83e5174103250d8662ca7;hp=b48a49e70bb4a708775a35487f4fe4da28ff42d3;hpb=ea502a0bc9fddc65bd56bd49255b28cf36050796;p=kivitendo-erp.git diff --git a/SL/DB.pm b/SL/DB.pm index b48a49e70..861fe6a52 100644 --- a/SL/DB.pm +++ b/SL/DB.pm @@ -4,20 +4,29 @@ 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); +sub dbi_connect { + shift; + + 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); @@ -49,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}, @@ -58,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}, @@ -75,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}) {