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
|
# --
# Copyright (C) 2001-2021 OTRS AG, https://otrs.com/
# Copyright (C) 2021 Znuny GmbH, https://znuny.org/
# --
# 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.
# --
use strict;
use warnings;
use utf8;
use vars (qw($Self));
# get helper object
$Kernel::OM->ObjectParamAdd(
'Kernel::System::UnitTest::Helper' => {
RestoreDatabase => 1,
},
);
my $HelperObject = $Kernel::OM->Get('Kernel::System::UnitTest::Helper');
# get command object
my $CommandObject = $Kernel::OM->Get('Kernel::System::Console::Command::Dev::Tools::Database::XMLExecute');
my ( $Result, $ExitCode );
my $Home = $Kernel::OM->Get('Kernel::Config')->Get('Home');
my $TableCreateXML = "$Home/scripts/test/Console/Command/Dev/Tools/Database/XMLExecute/TableCreate.xml";
my $TableDropXML = "$Home/scripts/test/Console/Command/Dev/Tools/Database/XMLExecute/TableDrop.xml";
# try to execute command without any options
$ExitCode = $CommandObject->Execute();
$Self->Is(
$ExitCode,
1,
"No options",
);
$ExitCode = $CommandObject->Execute($TableCreateXML);
$Self->Is(
$ExitCode,
0,
"Table created",
);
my $Success = $Kernel::OM->Get('Kernel::System::DB')->Prepare(
SQL => "SELECT * FROM test_xml_execute",
);
$Self->True(
$Success,
"SELECT after table create",
);
while ( my @Row = $Kernel::OM->Get('Kernel::System::DB')->FetchrowArray() ) { }
$ExitCode = $CommandObject->Execute($TableDropXML);
$Self->Is(
$ExitCode,
0,
"Table dropped",
);
$Success = $Kernel::OM->Get('Kernel::System::DB')->Prepare(
SQL => "SELECT * FROM test_xml_execute",
);
$Self->False(
$Success,
"SELECT after table drop",
);
# cleanup cache is done by RestoreDatabase
1;
|
