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 my $help_text = <<'END_HELP'
39 dbupgrade2_tool.pl [options]
41 A validation and information tool for the database upgrade scripts
44 At startup dbupgrade2_tool.pl will always check the consistency
45 of all database upgrade scripts (e.g. circular references, invalid
46 formats, missing meta information). You can but don't have to specifiy
50 --list Lists all database upgrade tags
51 --tree Lists all database upgrades in tree form
52 --rtree Lists all database upgrades in reverse tree form
53 --graphviz[=file] Create a Postscript document showing a tree of
54 all database upgrades and their dependencies.
55 If no file name is given then the output is
56 written to 'db_dependencies.ps'.
57 --apply=tag Applies the database upgrades 'tag' and all
58 upgrades it depends on. If '--apply' is used
59 then the option '--user' must be used as well.
60 --help Show this help and exit.
63 --user=name The name of the user configuration to use for
64 database connectivity.
75 sub calc_rev_depends {
76 map({ $_->{"rev_depends"} = []; } values(%{$controls}));
77 foreach my $control (values(%{$controls})) {
78 map({ push(@{$controls->{$_}{"rev_depends"}}, $control->{"tag"}) }
79 @{$control->{"depends"}});
84 my @sorted_controls = sort_dbupdate_controls($controls);
86 print("LIST VIEW\n\n");
87 print("number tag depth priority\n");
89 foreach (@sorted_controls) {
90 print("$i $_->{tag} $_->{depth} $_->{priority}\n");
98 my ($tag, $depth) = @_;
100 print(" " x $depth . $tag . "\n");
102 my $c = $controls->{$tag};
103 my $num = scalar(@{$c->{"depends"}});
104 for (my $i = 0; $i < $num; $i++) {
105 dump_node($c->{"depends"}[$i], $depth + 1);
110 print("TREE VIEW\n\n");
114 my @sorted_controls = sort_dbupdate_controls($controls);
116 foreach my $control (@sorted_controls) {
117 dump_node($control->{"tag"}, "") unless (@{$control->{"rev_depends"}});
123 sub dump_node_reverse {
124 my ($tag, $depth) = @_;
126 print(" " x $depth . $tag . "\n");
128 my $c = $controls->{$tag};
129 my $num = scalar(@{$c->{"rev_depends"}});
130 for (my $i = 0; $i < $num; $i++) {
131 dump_node_reverse($c->{"rev_depends"}[$i], $depth + 1);
135 sub dump_tree_reverse {
136 print("REVERSE TREE VIEW\n\n");
140 my @sorted_controls = sort_dbupdate_controls($controls);
142 foreach my $control (@sorted_controls) {
143 last if ($control->{"depth"} > 1);
144 dump_node_reverse($control->{"tag"}, "");
151 my $file_name = shift || "db_dependencies.ps";
153 print("GRAPHVIZ POSTCRIPT\n\n");
154 print("Output will be written to '${file_name}'\n");
156 open(OUT, "${dot}> \"${file_name}\"");
158 "digraph db_dependencies {\n" .
159 "node [shape=box];\n");
161 foreach my $c (values(%{$controls})) {
162 $ranks{$c->{"depth"}} = [] unless ($ranks{$c->{"depth"}});
163 push(@{$ranks{$c->{"depth"}}}, $c->{"tag"});
165 foreach (sort(keys(%ranks))) {
166 print(OUT "{ rank = same; " .
167 join("", map({ '"' . $_ . '"; ' } @{$ranks{$_}})) .
170 foreach my $c (values(%{$controls})) {
171 print(OUT "$c->{tag};\n");
172 foreach my $d (@{$c->{"depends"}}) {
173 print(OUT "$c->{tag} -> $d;\n");
183 print("SCRIPTS NO OTHER SCRIPTS DEPEND ON\n\n" .
186 grep({ !@{$_->{"rev_depends"}} }
187 values(%{$controls})))) .
194 my (@order, %tags, @all_tags);
196 if ($name eq "ALL") {
198 @all_tags = map { $_->{"tag"} } grep { !@{$_->{"rev_depends"}} } values %{$controls};
201 $form->error("Unknown dbupgrade tag '$name'") if (!$controls->{$name});
205 foreach my $tag (@all_tags) {
206 build_upgrade_order($tag, \@order, \%tags);
209 my @upgradescripts = map { $controls->{$_}->{"applied"} = 0; $controls->{$_} } @order;
211 my $dbh = $form->dbconnect_noauto(\%myconfig);
213 $dbh->{PrintWarn} = 0;
214 $dbh->{PrintError} = 0;
216 $user->create_schema_info_table($form, $dbh);
218 my $query = qq|SELECT tag FROM schema_info|;
219 $sth = $dbh->prepare($query);
220 $sth->execute() || $form->dberror($query);
221 while (($tag) = $sth->fetchrow_array()) {
222 $controls->{$tag}->{"applied"} = 1 if defined $controls->{$tag};
226 @upgradescripts = sort { $a->{"priority"} <=> $b->{"priority"} } grep { !$_->{"applied"} } @upgradescripts;
227 if (!@upgradescripts) {
228 print "The upgrade has already been applied.\n";
232 foreach my $control (@upgradescripts) {
233 $control->{"file"} =~ /\.(sql|pl)$/;
237 print "Applying upgrade $control->{file}\n";
239 if ($file_type eq "sql") {
240 $user->process_query($form, $dbh, "sql/$form->{dbdriver}-upgrade2/$control->{file}", $control);
242 $user->process_perl_script($form, $dbh, "sql/$form->{dbdriver}-upgrade2/$control->{file}", $control);
249 sub build_upgrade_order {
254 my $control = $controls->{$name};
256 foreach my $dependency (@{ $control->{"depends"} }) {
257 next if $tags->{$dependency};
258 $tags->{$dependency} = 1;
259 build_upgrade_order($dependency, $order, $tag);
262 push @{ $order }, $name;
270 eval { require "lx-erp.conf"; };
273 $locale = Locale->new("de", "login");
279 GetOptions("list" => \$opt_list,
280 "tree" => \$opt_tree,
281 "rtree" => \$opt_rtree,
282 "nodeps" => \$opt_nodeps,
283 "graphviz:s" => \$opt_graphviz,
284 "user=s" => \$opt_user,
285 "apply=s" => \$opt_apply,
286 "help" => \$opt_help,
293 $controls = parse_dbupdate_controls($form, "Pg");
307 if (defined $opt_graphviz) {
308 dump_graphviz($opt_graphviz);
316 my $file_name = "users/${opt_user}.conf";
318 eval { require($file_name); };
319 $form->error("File '$file_name' was not found") if $@;
320 $locale = new Locale($myconfig{countrycode}, "all");
321 $user = new User("users/members", $opt_user);
322 map { $form->{$_} = $myconfig{$_} } keys %myconfig;
326 $form->error("--apply used but no configuration file given with --user.") if (!$user);
327 apply_upgrade($opt_apply);