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
102
103
104
105
106
107
108
109
|
# --
# 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 (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
use strict;
use warnings;
use utf8;
use vars (qw($Self));
use Kernel::System::ObjectManager;
use Kernel::System::VariableCheck qw(:all);
my $ConfigObject = $Kernel::OM->Get('Kernel::Config');
my $MainObject = $Kernel::OM->Get('Kernel::System::Main');
my $DBCRUDFormatObject = $Kernel::OM->Get('Kernel::System::DBCRUD::Format');
my $Home = $ConfigObject->Get('Home');
$ConfigObject->{'UnitTestDBCRUD'} = {};
my $YMLString = $MainObject->FileRead(
Location => $Home . '/scripts/test/sample/DBCRUD/example.yml',
);
my $YAMLContent = $DBCRUDFormatObject->GetContent(
Format => 'yml',
Content => ${$YMLString},
Overwrite => 1,
);
$Self->IsDeeply(
$YAMLContent,
[
{
'Age' => '88',
'Description' => 'description yaml 88',
'Name' => 'yaml 88'
},
{
'Age' => '99',
'Description' => 'description yaml 99',
'Name' => 'yaml 99'
}
],
'YAMLContent',
);
my $CSVString = $MainObject->FileRead(
Location => $Home . '/scripts/test/sample/DBCRUD/example.csv',
);
# Content csv
my $CSVContent = $DBCRUDFormatObject->GetContent(
Format => 'CSV',
Content => ${$CSVString},
Overwrite => 1,
);
$Self->IsDeeply(
$CSVContent,
[
{
'Age' => '11',
'Description' => 'description csv 11',
'Name' => 'csv 11'
},
{
'Age' => '22',
'Description' => 'description csv 22',
'Name' => 'csv 22'
}
],
'CSVContent',
);
# Content Excel
my $ExcelString = $MainObject->FileRead(
Location => $Home . '/scripts/test/sample/DBCRUD/example.xlsx',
);
my $ExcelContent = $DBCRUDFormatObject->GetContent(
Format => 'Excel',
Content => ${$ExcelString},
Overwrite => 1,
);
$Self->IsDeeply(
$ExcelContent,
[
{
'Age' => '33',
'Description' => 'excel description',
'Name' => 'excel 1'
},
{
'Age' => '44',
'Description' => 'excel description',
'Name' => 'excel 2'
}
],
'ExcelContent',
);
1;
|
