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
|
# --
# 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));
my $HelperObject = $Kernel::OM->Get('Kernel::System::UnitTest::Helper');
my $Success = $HelperObject->ProvideTestDatabase();
if ( !$Success ) {
$Self->False(
0,
'Test database could not be provided, skipping test',
);
return 1;
}
$Self->True(
$Success,
'ProvideTestDatabase - Database cleared',
);
my $DBObject = $Kernel::OM->Get('Kernel::System::DB');
my @Tables = $DBObject->ListTables();
$Self->Is(
scalar @Tables,
0,
'No tables found',
);
my $Home = $Kernel::OM->Get('Kernel::Config')->Get('Home');
my @DatabaseXMLFiles = (
"$Home/scripts/database/schema.xml",
"$Home/scripts/database/initial_insert.xml",
);
$Success = $HelperObject->ProvideTestDatabase(
DatabaseXMLFiles => \@DatabaseXMLFiles,
);
$Self->True(
$Success,
'ProvideTestDatabase - Load and execute XML files',
);
@Tables = $DBObject->ListTables();
# Count number of table elements in OTRS schema for comparison.
my $XMLString = $Kernel::OM->Get('Kernel::System::Main')->FileRead(
Location => $DatabaseXMLFiles[0],
);
my $TableCount = () = ( ${$XMLString} =~ /<Table/g );
$Self->Is(
scalar @Tables,
$TableCount,
'OTRS tables found',
);
# Cleanup is done by TmpDatabaseCleanup().
1;
|
