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
|
#!/bin/sh
# PCP QA Test No. 1406
# simple exerciser for sheet2pcp - base CSV variant
#
# PCP_ARCHIVE_VERSION V3 variant, see 372 for the V2 variant.
#
# Copyright (c) 2010 Ken McDonell. All Rights Reserved.
#
seq=`basename $0`
echo "QA output created by $seq"
# get standard environment, filters and checks
. ./common.product
. ./common.filter
. ./common.check
which sheet2pcp >/dev/null 2>&1
[ $? -eq 0 ] || _notrun "sheet2pcp not installed"
perl -e "use XML::TokeParser" >/dev/null 2>&1
[ $? -eq 0 ] || _notrun "perl XML::TokeParser module not installed"
perl -e "use Spreadsheet::Read" >/dev/null 2>&1
[ $? -eq 0 ] || _notrun "perl Spreadsheet::Read module not installed"
perl -e "use Text::CSV_XS" >/dev/null 2>&1
[ $? -eq 0 ] || _notrun "perl Text::CSV_XS module not installed"
status=0 # success is the default!
trap "rm -f $tmp.*; exit \$status" 0 1 2 3 15
# real QA test starts here
cat <<'End-of-File' >$tmp.mapfile
<?xml version="1.0" encoding="UTF-8"?>
<!-- For PCP QA 1406 -->
<sheet heading="1" hostname="time.greenwich.com" datefmt="DMY">
<metric sem="PM_SEM_COUNTER">metric.a</metric>
<metric sem="PM_SEM_COUNTER">metric.b</metric>
<metric>metric.c</metric>
<metric type="PM_TYPE_32">metric.d</metric>
<metric type="PM_TYPE_STRING">metric.e</metric>
<datetime></datetime>
<data>metric.a</data>
<data>metric.b</data>
<data>metric.c</data>
<data>metric.d</data>
<data>metric.e</data>
</sheet>
End-of-File
echo "=== CSV ==="
rm -f $tmp.0 $tmp.index $tmp.meta
sheet2pcp -V3 sheet/simple.csv $tmp.mapfile $tmp 2>&1
[ -f $tmp.0 ] && pmdumplog -dilmstz $tmp
echo
echo "=== resaved CSV ==="
rm -f $tmp.0 $tmp.index $tmp.meta
sheet2pcp -V3 sheet/simple-resave.csv $tmp.mapfile $tmp 2>&1
[ -f $tmp.0 ] && pmdumplog -dilmstz $tmp
echo
echo "=== /dev/null ==="
rm -f $tmp.0 $tmp.index $tmp.meta
sheet2pcp -V3 /dev/null $tmp.mapfile $tmp 2>&1
[ -f $tmp.0 ] && pmdumplog -dilmstz $tmp
echo
echo "=== bad datetime CSV ==="
rm -f $tmp.0 $tmp.index $tmp.meta
cp sheet/simple.csv $tmp.baddate.csv
echo '34/13/2010 13:02:03;13;20;27;4;"bad-date"' >>$tmp.baddate.csv
sheet2pcp -V3 $tmp.baddate.csv $tmp.mapfile $tmp 2>&1
# success, all done
exit
|
