X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/3eb3d1b144adb92e62de08e67dc6ff3d39bf7483..d7fddb8d59bdcb8ec6bb31572d392fa29a858947:/scripts/rose_auto_create_model.pl?ds=sidebyside diff --git a/scripts/rose_auto_create_model.pl b/scripts/rose_auto_create_model.pl index 42af25a5b..fb589c610 100755 --- a/scripts/rose_auto_create_model.pl +++ b/scripts/rose_auto_create_model.pl @@ -13,8 +13,10 @@ use Data::Dumper; use Digest::MD5 qw(md5_hex); use English qw( -no_match_vars ); use Getopt::Long; -use List::MoreUtils qw(any); +use List::MoreUtils qw(none); +use List::UtilsBy qw(partition_by); use Pod::Usage; +use Rose::DB::Object 0.809; use Term::ANSIColor; use SL::Auth; @@ -40,20 +42,24 @@ $script =~ s:.*/::; $OUTPUT_AUTOFLUSH = 1; $Data::Dumper::Sortkeys = 1; -our $meta_path = "SL/DB/MetaSetup"; +our $meta_path = "SL/DB/MetaSetup"; +our $manager_path = "SL/DB/Manager"; my %config; -our %foreign_key_name_map = ( - oe => { payment => 'payment_terms', }, - ar => { payment => 'payment_terms', }, - ap => { payment => 'payment_terms', }, +our %foreign_key_name_map = ( + KIVITENDO => { + 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' }, + orderitems => { parts => 'part', trans => 'order', }, + delivery_order_items => { parts => 'part' }, + invoice => { parts => 'part' }, + follow_ups => { 'employee_obj' => 'created_for' }, - periodic_invoices_configs => { oe => 'order' }, + periodic_invoices_configs => { oe => 'order' }, + }, ); sub setup { @@ -78,17 +84,19 @@ sub setup { usage(); } - mkdir $meta_path unless -d $meta_path; + foreach (($meta_path, $manager_path)) { + mkdir $_ unless -d; + } } sub process_table { - my @spec = split(/=/, shift, 2); - my $table = $spec[0]; + my ($domain, $table, $package) = @_; my $schema = ''; ($schema, $table) = split(m/\./, $table) if $table =~ m/\./; - my $package = ucfirst($spec[1] || $spec[0]); + $package = ucfirst($package || $table); $package =~ s/_+(.)/uc($1)/ge; my $meta_file = "${meta_path}/${package}.pm"; + my $mngr_file = "${manager_path}/${package}.pm"; my $file = "SL/DB/${package}.pm"; my $schema_str = $schema ? <{ALL}, $foreign_key_name_map{$domain}->{$table}); + while (my ($auto_generated_name, $desired_name) = each %changes) { $foreign_key_definition =~ s/^ \s \s ${auto_generated_name} \b/ ${desired_name}/msx; } @@ -166,12 +175,10 @@ package SL::DB::${package}; use strict; use SL::DB::MetaSetup::${package}; +use SL::DB::Manager::${package}; __PACKAGE__->meta->initialize; -# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. -__PACKAGE__->meta->make_manager_class; - 1; CODE @@ -182,7 +189,7 @@ CODE my $old_md5 = md5_hex($orig_file); my $new_size = length $full_definition; my $new_md5 = md5_hex($full_definition); - if ($old_size == $new_size && $old_md5 == $new_md5) { + if ($old_size == $new_size && $old_md5 eq $new_md5) { notice("No changes in $meta_file, skipping.") unless $config{quiet}; return; } @@ -197,14 +204,39 @@ CODE notice("File '$meta_file' " . ($file_exists ? 'updated' : 'created') . " for table '$table'"); - if (! -f $file) { - if (!$config{nocommit}) { - open my $out, ">", $file || die; - print $out $meta_definition; - } + return if -f $file; + + if (!$config{nocommit}) { + open my $out, ">", $file || die; + print $out $meta_definition; + } + + notice("File '$file' created as well."); + + return if -f $mngr_file; - notice("File '$file' created as well."); + if (!$config{nocommit}) { + open my $out, ">", $mngr_file || die; + print $out <make_manager_methods; + +1; +EOT } + + notice("File '$mngr_file' created as well."); } sub parse_args { @@ -212,6 +244,7 @@ sub parse_args { GetOptions( 'client=s' => \ my $client, all => \ my $all, + 'db=s' => \ my $db, 'no-commit|dry-run' => \ my $nocommit, help => sub { pod2usage(verbose => 99, sections => 'NAME|SYNOPSIS|OPTIONS') }, quiet => \ my $quiet, @@ -220,6 +253,7 @@ sub parse_args { $options->{client} = $client; $options->{all} = $all; + $options->{db} = $db; $options->{nocommit} = $nocommit; $options->{quiet} = $quiet; $options->{color} = -t STDOUT ? 1 : 0; @@ -257,21 +291,32 @@ sub usage { } sub make_tables { - my @tables; + my %tables_by_domain; if ($config{all}) { - my $db = SL::DB::create(undef, 'KIVITENDO'); - @tables = - map { $package_names{KIVITENDO}->{$_} ? "$_=" . $package_names{KIVITENDO}->{$_} : $_ } - grep { my $table = $_; !any { $_ eq $table } @{ $blacklist{KIVITENDO} } } - $db->list_tables; + my @domains = $config{db} ? (uc $config{db}) : sort keys %package_names; + + foreach my $domain (@domains) { + my $db = SL::DB::create(undef, $domain); + $tables_by_domain{$domain} = [ grep { my $table = $_; none { $_ eq $table } @{ $blacklist{$domain} } } $db->list_tables ]; + $db->disconnect; + } + } elsif (@ARGV) { - @tables = @ARGV; + %tables_by_domain = partition_by { + my ($domain, $table) = split m{:}; + $table ? uc($domain) : 'KIVITENDO'; + } @ARGV; + + foreach my $tables (values %tables_by_domain) { + s{.*:}{} for @{ $tables }; + } + } else { error("You specified neither --all nor any specific tables."); usage(); } - @tables; + return %tables_by_domain; } sub error { @@ -282,15 +327,31 @@ sub notice { print @_, $/; } +sub check_errors_in_package_names { + foreach my $domain (sort keys %package_names) { + my @both = grep { $package_names{$domain}->{$_} } @{ $blacklist{$domain} || [] }; + next unless @both; + + print "Error: domain '$domain': The following table names are present in both the black list and the package name hash: ", join(' ', sort @both), "\n"; + exit 1; + } +} + parse_args(\%config); setup(); -my @tables = make_tables(); +check_errors_in_package_names(); -for my $table (@tables) { - # add default model name unless model name is given or no defaults exists - $table .= '=' . $package_names{KIVITENDO}->{lc $table} if $table !~ /=/ && $package_names{KIVITENDO}->{lc $table}; +my %tables_by_domain = make_tables(); - process_table($table); +foreach my $domain (keys %tables_by_domain) { + my @tables = @{ $tables_by_domain{$domain} }; + my @unknown_tables = grep { !$package_names{$domain}->{$_} } @tables; + if (@unknown_tables) { + error("The following tables do not have entries in \%SL::DB::Helper::Mappings::${domain}_package_names: " . join(' ', sort @unknown_tables)); + exit 1; + } + + process_table($domain, $_, $package_names{$domain}->{$_}) for @tables; } 1; @@ -305,20 +366,20 @@ rose_auto_create_model - mana Rose::DB::Object classes for kivitendo =head1 SYNOPSIS - scripts/rose_create_model.pl --client name-or-id table1[=package1] [table2[=package2] ...] - scripts/rose_create_model.pl --client name-or-id [--all|-a] + scripts/rose_auto_create_model.pl --client name-or-id [db1:]table1 [[db2:]table2 ...] + scripts/rose_auto_create_model.pl --client name-or-id [--all|-a] # updates all models - scripts/rose_create_model.pl --client name-or-id --all + scripts/rose_auto_create_model.pl --client name-or-id --all [--db db] # updates only customer table, login taken from config - scripts/rose_create_model.pl customer + scripts/rose_auto_create_model.pl customer # updates only parts table, package will be Part - scripts/rose_create_model.pl parts=Part + scripts/rose_auto_create_model.pl parts=Part # try to update parts, but don't do it. tell what would happen in detail - scripts/rose_create_model.pl --no-commit parts + scripts/rose_auto_create_model.pl --no-commit parts =head1 DESCRIPTION @@ -355,10 +416,22 @@ In the most basic version, just give it a login and a table name, and it will load the schema information for this table and create the appropriate class files, or update them if already present. -Each table has two associated files. A C class, which is -a perl version of the schema definition, and a C class file. The -first one will be updated if the schema changes, the second one will only be -created if it does not exist. +Each table has three associated files. A C +class, which is a perl version of the schema definition, a +C class file and a C manager class +file. The first one will be updated if the schema changes, the second +and third ones will only be created if it they do not exist. + +=head1 DATABASE NAMES AND TABLES + +If you want to generate the data for specific tables only then you +have to list them on the command line. The format is +C. The part C is optional and defaults +to C – which means the tables in the default kivitendo +database. + +Valid database names are keys in the hash returned by +L. =head1 OPTIONS @@ -377,6 +450,11 @@ Note that C can be either a database ID or a client's name. Process all tables from the database. Only those that are blacklistes in L are excluded. +=item C<--db db> + +In combination with C<--all> causes all tables in the specific +database to be processed, not in all databases. + =item C<--no-commit, -n> =item C<--dry-run> @@ -406,6 +484,7 @@ None yet. =head1 AUTHOR +Moritz Bunkus Em.bunkus@linet-services.deE, Sven Schöling Es.schoeling@linet-services.deE =cut