From 7dce1e6b79376cb9fd7966051210b0e099f97c9c Mon Sep 17 00:00:00 2001 From: =?utf8?q?Sven=20Sch=C3=B6ling?= Date: Tue, 27 Sep 2011 16:05:01 +0200 Subject: [PATCH] =?utf8?q?rose=5Fauto=5Fcreate=5Fmodel.pl=20=C3=BCberarbei?= =?utf8?q?tet.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit - nocommit option - farbige ausgabe - verbose - login aus config laden - bessere doku --- scripts/rose_auto_create_model.pl | 238 +++++++++++++++++++++++++----- 1 file changed, 201 insertions(+), 37 deletions(-) diff --git a/scripts/rose_auto_create_model.pl b/scripts/rose_auto_create_model.pl index bfb3e3d6a..6b6db0a8c 100755 --- a/scripts/rose_auto_create_model.pl +++ b/scripts/rose_auto_create_model.pl @@ -10,8 +10,12 @@ BEGIN { use CGI qw( -no_xhtml); use Config::Std; use Data::Dumper; +use Digest::MD5 qw(md5_hex); use English qw( -no_match_vars ); +use Getopt::Long; use List::MoreUtils qw(any); +use Pod::Usage; +use Term::ANSIColor; use SL::Auth; use SL::DBUtils; @@ -23,6 +27,9 @@ use SL::LxOfficeConf; use SL::DB::Helper::ALL; use SL::DB::Helper::Mappings; +my %blacklist = SL::DB::Helper::Mappings->get_blacklist; +my %package_names = SL::DB::Helper::Mappings->get_package_names; + our $form; our $cgi; our $auth; @@ -36,27 +43,25 @@ $Data::Dumper::Sortkeys = 1; our $meta_path = "SL/DB/MetaSetup"; +my %config; + sub setup { - if (@ARGV < 2) { - print "Usage: $PROGRAM_NAME login table1[=package1] [table2[=package2] ...]\n"; - print " or $PROGRAM_NAME login [--all|-a] [--sugar|-s]\n"; - exit 1; - } SL::LxOfficeConf->read; - my $login = shift @ARGV; + my $login = $config{login} || $::lx_office_conf{devel}{login}; - $::lxdebug = LXDebug->new(); + if (!$login) { + error("No login found in config. Please provide a login:"); + usage(); + } - # locale messages + $::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); $form->{script} = 'rose_meta_data.pl'; $form->{login} = $login; @@ -93,27 +98,19 @@ $schema CODE if ($EVAL_ERROR) { - print STDERR "Error in execution for table '$table': $EVAL_ERROR"; + error("Error in execution for table '$table'"); + error("'$EVAL_ERROR'") if $config{verbose}; return; } $definition =~ s/::AUTO::/::/g; - - my $file_exists = -f $meta_file; - - open(OUT, ">$meta_file") || die; - print OUT <$file") || die; - print OUT <meta->make_manager_class; 1; CODE - close OUT; - print "File '$file' created as well.\n"; + my $file_exists = -f $meta_file; + if ($file_exists) { + my $old_size = -s $meta_file; + my $old_md5 = md5_hex(do { local(@ARGV, $/) = ($meta_file); <> }); + my $new_size = length $full_definition; + my $new_md5 = md5_hex($full_definition); + if ($old_size == $new_size && $old_md5 == $new_md5) { + notice("No changes in $meta_file, skipping.") if $config{verbose}; + return; + } + } + + if (!$config{nocommit}) { + open my $out, ">", $meta_file || die; + print $out $full_definition; + } + + 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; + } + + notice("File '$file' created as well."); } } -setup(); +sub parse_args { + my ($options) = @_; + GetOptions( + 'login|user=s' => \ my $login, + all => \ my $all, + sugar => \ my $sugar, + 'no-commit' => \ 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; +} -my %blacklist = SL::DB::Helper::Mappings->get_blacklist; -my %package_names = SL::DB::Helper::Mappings->get_package_names; +sub usage { + pod2usage(verbose => 99, sections => 'SYNOPSIS'); +} -my @tables = (); -if (($ARGV[0] eq '--all') || ($ARGV[0] eq '-a') || ($ARGV[0] eq '--sugar') || ($ARGV[0] eq '-s')) { - my ($type, $prefix) = ($ARGV[0] eq '--sugar') || ($ARGV[0] eq '-s') ? ('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} } } - $db->list_tables; +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} } } + $db->list_tables; + } elsif (@ARGV) { + @tables = @ARGV; + } else { + error("You specified neither --sugar nor --all nor any specific tables."); + usage(); + } -} else { - @tables = @ARGV; + @tables; } -foreach my $table (@tables) { +sub error { + print STDERR colored(shift, 'red'), $/; +} + +sub notice { + print @_, $/; +} + +parse_args(\%config); +setup(); +my @tables = make_tables(); + +for my $table (@tables) { # add default model name unless model name is given or no defaults exists $table .= '=' . $package_names{LXOFFICE}->{lc $table} if $table !~ /=/ && $package_names{LXOFFICE}->{lc $table}; process_table($table); } + +1; + +__END__ + +=encoding utf-8 + +=head1 NAME + +rose_auto_create_model - mana Rose::DB::Object classes for Lx-Office + +=head1 SYNOPSIS + + scripts/rose_create_model.pl --login login table1[=package1] [table2[=package2] ...] + scripts/rose_create_model.pl --login login [--all|-a] [--sugar|-s] + + # updates all models + scripts/rose_create_model.pl --login login --all + + # updates only customer table, login taken from config + scripts/rose_create_model.pl customer + + # updates only parts table, package will be Part + scripts/rose_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 --verbose parts + +=head1 DESCRIPTION + +Rose::DB::Object comes with a nice function named auto initialization with code +generation. The documentation of Rose describes it like this: + +I<[...] auto-initializing metadata at runtime by querying the database has many +caveats. An alternate approach is to query the database for metadata just once, +and then generate the equivalent Perl code which can be pasted directly into +the class definition in place of the call to auto_initialize.> + +I + +I + +Unfortunately this ready easier than it is, since classes need to get in the +right package and directory, certain stuff need to be adjusted and table names +need to be translated into their class names. This script will wrap all that +behind a few simple options. + +In the most basic version, just give it a login and + +=head1 OPTIONS + +=over 4 + +=item C<--login, -l LOGIN> + +=item C<--user, -u LOGIN> + +Provide a login. If not present the login is loaded from the config key +C. If that too is not found, an error is thrown. + +=item C<--all, -a> + +Process all tables from the database. Only those that are blacklistes in +L 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> + +Do not write back generated files. This will do everything as usual but not +actually modify any files. + +=item C<--help, -h> + +Print this help. + +=item C<--verbose, -v> + +Prints extra information, such as skipped files that were not changed and +errors where the auto initialization failed. + +=back + +=head1 BUGS + +None yet. + +=head1 AUTHOR + +Sven Schöling Es.schoeling@linet-services.deE + +=cut -- 2.20.1