1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
# --
# Copyright (C) 2001-2021 OTRS AG, https://otrs.com/
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (GPL). If you
# did not receive this file, see https://www.gnu.org/licenses/gpl-3.0.txt.
# --
package Kernel::System::Console::Command::Dev::Tools::Database::XMLExecute;
use strict;
use warnings;
use parent qw(Kernel::System::Console::BaseCommand);
our @ObjectDependencies = (
'Kernel::System::DB',
'Kernel::System::Main',
'Kernel::System::XML',
);
sub Configure {
my ( $Self, %Param ) = @_;
$Self->Description('Convert an OTRS database XML file to SQL and execute it in the current database.');
$Self->AddArgument(
Name => 'source-path',
Description => "Specify the location of the database XML file to be executed.",
Required => 1,
ValueRegex => qr/.*/smx,
);
$Self->AddOption(
Name => 'sql-part',
Description => "Generate only 'pre' or 'post' SQL",
Required => 0,
HasValue => 1,
ValueRegex => qr/^(pre|post)$/smx,
);
return;
}
sub PreRun {
my ( $Self, %Param ) = @_;
my $SourcePath = $Self->GetArgument('source-path');
if ( !-r $SourcePath ) {
die "Source file $SourcePath does not exist / is not readable.\n";
}
return;
}
sub Run {
my ( $Self, %Param ) = @_;
my $XML = $Kernel::OM->Get('Kernel::System::Main')->FileRead(
Location => $Self->GetArgument('source-path'),
);
if ( !$XML ) {
$Self->PrintError("Could not read XML source.");
return $Self->ExitCodeError();
}
my @XMLArray = $Kernel::OM->Get('Kernel::System::XML')->XMLParse( String => $XML );
my @SQL = $Kernel::OM->Get('Kernel::System::DB')->SQLProcessor(
Database => \@XMLArray,
);
if ( !@SQL ) {
$Self->PrintError("Could not generate SQL.");
return $Self->ExitCodeError();
}
my @SQLPost = $Kernel::OM->Get('Kernel::System::DB')->SQLProcessorPost();
my $SQLPart = $Self->GetOption('sql-part') || 'both';
my @SQLCollection;
if ( $SQLPart eq 'both' ) {
push @SQLCollection, @SQL, @SQLPost;
}
elsif ( $SQLPart eq 'pre' ) {
push @SQLCollection, @SQL;
}
elsif ( $SQLPart eq 'post' ) {
push @SQLCollection, @SQLPost;
}
for my $SQL (@SQLCollection) {
$Self->Print("$SQL\n");
my $Success = $Kernel::OM->Get('Kernel::System::DB')->Do( SQL => $SQL );
if ( !$Success ) {
$Self->PrintError("Database action failed. Exiting.");
return $Self->ExitCodeError();
}
}
$Self->Print("<green>Done.</green>\n");
return $Self->ExitCodeOk();
}
1;
|
