X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/46135cc6988f5ce2d8d1be1627651e5da28d64ae..0b34e29fb04ad9ac9912f67b767f9f401700ca97:/t/000setup_database.t?ds=inline diff --git a/t/000setup_database.t b/t/000setup_database.t index 5cf6a2892..3d5ca6c7a 100755 --- a/t/000setup_database.t +++ b/t/000setup_database.t @@ -14,6 +14,7 @@ use SL::InstanceConfiguration; use SL::LXDebug; use SL::Layout::None; use SL::LxOfficeConf; +use XML::LibXML; our ($db_cfg, $dbh); @@ -117,12 +118,17 @@ sub create_initial_schema { $dbh = SL::DBConnect->connect(@dbi_options) || BAIL_OUT("Database connection failed: " . $DBI::errstr); $::auth->{dbh} = $dbh; my $dbupdater = SL::DBUpgrade2->new(form => $::form, return_on_error => 1, silent => 1); - my $coa = 'Germany-DATEV-SKR03EU'; + my $defaults = SL::DefaultManager->new($::lx_office_conf{system}->{default_manager}); + my $coa = $defaults->chart_of_accounts( 'Germany-DATEV-SKR03EU' ); + my $am = $defaults->accounting_method( 'cash' ); + my $pd = $defaults->profit_determination( 'balance' ); + my $is = $defaults->inventory_system( 'periodic' ); + my $curr = $defaults->currency( 'EUR' ); apply_dbupgrade($dbupdater, "sql/lx-office.sql"); apply_dbupgrade($dbupdater, "sql/${coa}-chart.sql"); - dbh_do($dbh, qq|UPDATE defaults SET coa = '${coa}', accounting_method = 'cash', profit_determination = 'income', inventory_system = 'periodic', curr = 'EUR'|); + dbh_do($dbh, qq|UPDATE defaults SET coa = '${coa}', accounting_method = '${am}', profit_determination = '${pd}', inventory_system = '${is}', curr = '${curr}'|); dbh_do($dbh, qq|CREATE TABLE schema_info (tag TEXT, login TEXT, itime TIMESTAMP DEFAULT now(), PRIMARY KEY (tag))|); }