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
|
# --
# 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.
# --
## no critic (Modules::RequireExplicitPackage)
use strict;
use warnings;
use utf8;
use vars (qw($Self));
# get ticket object
my $ColumnFilterObject = $Kernel::OM->Get('Kernel::System::Ticket::ColumnFilter');
# get helper object
$Kernel::OM->ObjectParamAdd(
'Kernel::System::UnitTest::Helper' => {
RestoreDatabase => 1,
},
);
my $HelperObject = $Kernel::OM->Get('Kernel::System::UnitTest::Helper');
my @Tests = (
{
Name => 'No array',
Params => {
ColumnName => 'ticket.id',
TicketIDs => 1,
},
Result => undef,
},
{
Name => 'Single Integer',
Params => {
ColumnName => 'ticket.id',
TicketIDs => [1],
},
Result => ' AND ( ticket.id IN (1) ) ',
},
{
Name => 'Single Integer, default table',
Params => {
TicketIDs => [1],
},
Result => ' AND ( t.id IN (1) ) ',
},
{
Name => 'Single Integer, no AND',
Params => {
TicketIDs => [1],
IncludeAdd => 0,
},
Result => ' t.id IN (1) ',
},
{
Name => 'Sorted values',
Params => {
ColumnName => 'ticket.id',
TicketIDs => [ 2, 1, -1, 0 ],
},
Result => ' AND ( ticket.id IN (-1, 0, 1, 2) ) ',
},
{
Name => 'Invalid value',
Params => {
ColumnName => 'ticket.id',
TicketIDs => [1.1],
},
Result => undef,
},
{
Name => 'Mix of valid and invalid values',
Params => {
ColumnName => 'ticket.id',
TicketIDs => [ 1, 1.1 ],
},
Result => undef,
},
);
for my $Test (@Tests) {
$Self->Is(
scalar $ColumnFilterObject->_TicketIDStringGet( %{ $Test->{Params} } ),
$Test->{Result},
"$Test->{Name} _TicketIDStringGet()"
);
}
# cleanup is done by RestoreDatabase.
1;
|
