my %package_names = SL::DB::Helper::Mappings->get_package_names;
our $form;
-our $cgi;
our $auth;
our %lx_office_conf;
my %config;
+our %foreign_key_name_map = (
+ oe => { payment => 'payment_terms', },
+ ar => { payment => 'payment_terms', },
+ ap => { payment => 'payment_terms', },
+
+ orderitems => { parts => 'part', trans => 'order', },
+ delivery_order_items => { parts => 'part' },
+ invoice => { parts => 'part' },
+
+ periodic_invoices_configs => { oe => 'order' },
+);
+
sub setup {
SL::LxOfficeConf->read;
$::lxdebug = LXDebug->new();
$::locale = Locale->new("de");
$::form = new Form;
- $::cgi = new CGI('');
$::auth = SL::Auth->new();
- $::user = User->new($login);
- %::myconfig = $auth->read_user($login);
- $::request = { };
+ $::user = User->new(login => $login);
+ %::myconfig = $auth->read_user(login => $login);
+ $::request = { cgi => CGI->new({}) };
$form->{script} = 'rose_meta_data.pl';
$form->{login} = $login;
}
$definition =~ s/::AUTO::/::/g;
+
+ while (my ($auto_generated_name, $desired_name) = each %{ $foreign_key_name_map{$table} || {} }) {
+ $definition =~ s/( foreign_keys \s*=> \s*\[ .* ^\s+ ) ${auto_generated_name} \b/${1}${desired_name}/msx;
+ }
+
my $full_definition = <<CODE;
# This file has been auto-generated. Do not modify it; it will be overwritten
# by $::script automatically.
GetOptions(
'login|user=s' => \ my $login,
all => \ my $all,
- sugar => \ my $sugar,
'no-commit|dry-run' => \ my $nocommit,
help => sub { pod2usage(verbose => 99, sections => 'NAME|SYNOPSIS|OPTIONS') },
verbose => \ my $verbose,
);
$options->{login} = $login if $login;
- $options->{sugar} = $sugar;
$options->{all} = $all;
$options->{nocommit} = $nocommit;
$options->{verbose} = $verbose;
sub make_tables {
my @tables;
- if ($config{all} || $config{sugar}) {
- my ($type, $prefix) = $config{sugar} ? ('SUGAR', 'sugar_') : ('LXOFFICE', '');
- my $db = SL::DB::create(undef, $type);
- @tables =
- map { $package_names{$type}->{$_} ? "$_=" . $package_names{$type}->{$_} : $prefix ? "$_=$prefix$_" : $_ }
- grep { my $table = $_; !any { $_ eq $table } @{ $blacklist{$type} } }
+ if ($config{all}) {
+ my $db = SL::DB::create(undef, 'LXOFFICE');
+ @tables =
+ map { $package_names{LXOFFICE}->{$_} ? "$_=" . $package_names{LXOFFICE}->{$_} : $_ }
+ grep { my $table = $_; !any { $_ eq $table } @{ $blacklist{LXOFFICE} } }
$db->list_tables;
} elsif (@ARGV) {
@tables = @ARGV;
} else {
- error("You specified neither --sugar nor --all nor any specific tables.");
+ error("You specified neither --all nor any specific tables.");
usage();
}
=head1 NAME
-rose_auto_create_model - mana Rose::DB::Object classes for Lx-Office
+rose_auto_create_model - mana Rose::DB::Object classes for kivitendo
=head1 SYNOPSIS
scripts/rose_create_model.pl --login login table1[=package1] [table2[=package2] ...]
- scripts/rose_create_model.pl --login login [--all|-a] [--sugar|-s]
+ scripts/rose_create_model.pl --login login [--all|-a]
# updates all models
scripts/rose_create_model.pl --login login --all
Process all tables from the database. Only those that are blacklistes in
L<SL::DB::Helper::Mappings> are excluded.
-=item C<--sugar, -s>
-
-Process tables in sugar schema instead of standard schema. Rarely useful unless
-you debug schema awareness of the RDBO layer.
-
=item C<--no-commit, -n>
+
=item C<--dry-run>
Do not write back generated files. This will do everything as usual but not