4 if (! -d "bin" || ! -d "SL") {
5 print("This tool must be run from the Lx-Office ERP base directory.\n");
12 use English '-no_match_vars';
20 $lxdebug = LXDebug->new();
32 my ($opt_list, $opt_tree, $opt_rtree, $opt_nodeps, $opt_graphviz, $opt_help);
33 my ($opt_user, $opt_apply);
35 our (%myconfig, $form, $user);
38 print("dbupgrade2_tool.pl [--list] [--tree] [--rtree] [--graphviz]\n" .
39 " [--nodepds] [--user=name --apply=tag] [--help]\n");
45 sub calc_rev_depends {
46 map({ $_->{"rev_depends"} = []; } values(%{$controls}));
47 foreach my $control (values(%{$controls})) {
48 map({ push(@{$controls->{$_}{"rev_depends"}}, $control->{"tag"}) }
49 @{$control->{"depends"}});
54 my @sorted_controls = sort_dbupdate_controls($controls);
56 print("LIST VIEW\n\n");
57 print("number tag depth priority\n");
59 foreach (@sorted_controls) {
60 print("$i $_->{tag} $_->{depth} $_->{priority}\n");
68 my ($tag, $depth) = @_;
70 print(" " x $depth . $tag . "\n");
72 my $c = $controls->{$tag};
73 my $num = scalar(@{$c->{"depends"}});
74 for (my $i = 0; $i < $num; $i++) {
75 dump_node($c->{"depends"}[$i], $depth + 1);
80 print("TREE VIEW\n\n");
84 my @sorted_controls = sort_dbupdate_controls($controls);
86 foreach my $control (@sorted_controls) {
87 dump_node($control->{"tag"}, "") unless (@{$control->{"rev_depends"}});
93 sub dump_node_reverse {
94 my ($tag, $depth) = @_;
96 print(" " x $depth . $tag . "\n");
98 my $c = $controls->{$tag};
99 my $num = scalar(@{$c->{"rev_depends"}});
100 for (my $i = 0; $i < $num; $i++) {
101 dump_node_reverse($c->{"rev_depends"}[$i], $depth + 1);
105 sub dump_tree_reverse {
106 print("REVERSE TREE VIEW\n\n");
110 my @sorted_controls = sort_dbupdate_controls($controls);
112 foreach my $control (@sorted_controls) {
113 last if ($control->{"depth"} > 1);
114 dump_node_reverse($control->{"tag"}, "");
121 print("GRAPHVIZ POSTCRIPT\n\n");
122 print("Output will be written to db_dependencies.ps\n");
124 open(OUT, "${dot}> db_dependencies.ps");
126 "digraph db_dependencies {\n" .
127 "node [shape=box];\n");
129 foreach my $c (values(%{$controls})) {
130 $ranks{$c->{"depth"}} = [] unless ($ranks{$c->{"depth"}});
131 push(@{$ranks{$c->{"depth"}}}, $c->{"tag"});
133 foreach (sort(keys(%ranks))) {
134 print(OUT "{ rank = same; " .
135 join("", map({ '"' . $_ . '"; ' } @{$ranks{$_}})) .
138 foreach my $c (values(%{$controls})) {
139 print(OUT "$c->{tag};\n");
140 foreach my $d (@{$c->{"depends"}}) {
141 print(OUT "$c->{tag} -> $d;\n");
151 print("SCRIPTS NO OTHER SCRIPTS DEPEND ON\n\n" .
154 grep({ !@{$_->{"rev_depends"}} }
155 values(%{$controls})))) .
162 $form->error("Unknown dbupgrade tag '$name'") if (!$controls->{$name});
166 build_upgrade_order($name, \@order, \%tags);
168 my @upgradescripts = map { $controls->{$_}->{"applied"} = 0; $controls->{$_} } @order;
170 my $dbh = $form->dbconnect_noauto(\%myconfig);
172 $dbh->{PrintWarn} = 0;
173 $dbh->{PrintError} = 0;
175 $user->create_schema_info_table($form, $dbh);
177 my $query = qq|SELECT tag FROM schema_info|;
178 $sth = $dbh->prepare($query);
179 $sth->execute() || $form->dberror($query);
180 while (($tag) = $sth->fetchrow_array()) {
181 $controls->{$tag}->{"applied"} = 1 if defined $controls->{$tag};
186 foreach (@upgradescripts) {
187 if (!$_->{"applied"}) {
194 print "The upgrade has already been applied.\n";
198 foreach my $control (@upgradescripts) {
199 next if ($control->{"applied"});
201 $control->{"file"} =~ /\.(sql|pl)$/;
205 print "Applying upgrade $control->{file}\n";
207 if ($file_type eq "sql") {
208 $user->process_query($form, $dbh, "sql/$form->{dbdriver}-upgrade2/$control->{file}", $control);
210 $user->process_perl_script($form, $dbh, "sql/$form->{dbdriver}-upgrade2/$control->{file}", $control);
217 sub build_upgrade_order {
222 my $control = $controls->{$name};
224 foreach my $dependency (@{ $control->{"depends"} }) {
225 next if $tags->{$dependency};
226 $tags->{$dependency} = 1;
227 build_upgrade_order($dependency, $order, $tag);
230 push @{ $order }, $name;
237 eval { require "lx-erp.conf"; };
240 $locale = Locale->new("de", "login");
246 GetOptions("list" => \$opt_list,
247 "tree" => \$opt_tree,
248 "rtree" => \$opt_rtree,
249 "nodeps" => \$opt_nodeps,
250 "graphviz" => \$opt_graphviz,
251 "user=s" => \$opt_user,
252 "apply=s" => \$opt_apply,
253 "help" => \$opt_help,
261 $controls = parse_dbupdate_controls($form, "Pg");
284 my $file_name = "users/${opt_user}.conf";
286 eval { require($file_name); };
287 $form->error("File '$file_name' was not found") if $@;
288 $locale = new Locale($myconfig{countrycode}, "all");
289 $user = new User("users/members", $opt_user);
290 map { $form->{$_} = $myconfig{$_} } keys %myconfig;
294 $form->error("--apply used but no configuration file given with --user.") if (!$user);
295 apply_upgrade($opt_apply);