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
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
|
package reader
import (
"fmt"
"testing"
)
func TestOpenSQLiteFile(t *testing.T) {
// db, err := sql.Open("sqlite3", "testdata/test.db")
db, err := SetupDB("testdata/test.db")
defer db.Close()
if err != nil {
t.Fatal("Expected to be able to set up the database.")
}
stmt := `insert into datamap(id, name) values(1,'cock')`
_, err = db.Exec(stmt)
if err != nil {
t.Errorf("Cannot add record to db")
}
rows, err := db.Query("select name from datamap")
if err != nil {
t.Errorf("Cannot run select statement")
}
defer rows.Close()
for rows.Next() {
var name string
err = rows.Scan(&name)
if err != nil {
t.Errorf("Cannot scan resulting row")
}
fmt.Println(name)
}
}
func TestReadDML(t *testing.T) {
d, _ := ReadDML("testdata/datamap.csv")
cases := []struct {
idx int
val string
}{
{0, "Project/Programme Name"},
{1, "Department"},
{2, "Delivery Body"},
}
for _, c := range cases {
if got := d[c.idx].Key; got != c.val {
t.Errorf("The test expected %s, got %s.", c.val, d[c.idx].Key)
}
}
}
func TestNoFileReturnsError(t *testing.T) {
// this file does not exist
_, err := ReadDML("/home/bobbins.csv")
// if we get no error, something has gone wrong
if err == nil {
t.Errorf("Should have thrown error %s", err)
}
}
func TestBadDMLLine(t *testing.T) {
_, err := ReadDML("/home/lemon/code/python/bcompiler-engine/tests/resources/datamap_empty_cols.csv")
if err == nil {
t.Errorf("No error so test failed.")
}
}
func TestGetSheetsFromDM(t *testing.T) {
slice, _ := ReadDML("testdata/datamap.csv")
sheetNames := getSheetNames(slice)
if len(sheetNames) != 15 {
t.Errorf("The test expected 14 sheets in slice, got %d.",
len(sheetNames))
}
}
func TestReadXLSX(t *testing.T) {
d := ReadXLSX("testdata/test_template.xlsx")
cases := []struct {
sheet, cellref, val string
}{
{"Summary", "A2", "Date:"},
{"Summary", "IG10", "botticelli"},
{"Another Sheet", "F5", "4.2"},
{"Another Sheet", "J22", "18"},
}
for _, c := range cases {
got := d[c.sheet][c.cellref].Value
if got != c.val {
t.Errorf("The test expected %s in %s sheet to be %s "+
" - instead it is %s.", c.cellref, c.sheet, c.val, d[c.sheet][c.cellref].Value)
}
}
}
func TestExtract(t *testing.T) {
d := Extract("testdata/datamap.csv", "testdata/test_template.xlsx")
cases := []struct {
sheet, cellref, val string
}{
{"Introduction", "C9", "Test Department"},
{"Introduction", "J9", "Greedy Parrots"},
{"Introduction", "A1", "10"},
{"Introduction", "C22", "VUNT"},
}
for _, c := range cases {
got := d[c.sheet][c.cellref].Value
if got != c.val {
t.Errorf("The test expected %s in %s sheet to be %s "+
"- instead it is %s.", c.sheet, c.cellref, c.val,
d[c.sheet][c.cellref].Value)
}
}
if d["Another Sheet"]["E26"].Value != "Integer:" {
t.Errorf("Expected E26 in Another Sheet sheet to be Integer: - instead it is %s", d["Another Sheet"]["E26"].Value)
}
}
// func TestGetTargetFiles(t *testing.T) {
// // This is not a suitable test for parameterisation, but doing it this way anyway.
// type args struct {
// path string
// }
// tests := []struct {
// name string
// args args
// want []string
// wantErr bool
// }{
// {"TestGetTargetFiles",
// args{"/home/lemon/go/src/github.com/hammerheadlemon/datamaps-go/reader/testdata/"},
// []string{"/home/lemon/go/src/github.com/hammerheadlemon/datamaps-go/reader/testdata/test_template.xlsx"},
// false,
// },
// }
// for _, tt := range tests {
// t.Run(tt.name, func(t *testing.T) {
// got, err := GetTargetFiles(tt.args.path)
// if (err != nil) != tt.wantErr {
// t.Errorf("GetTargetFiles() error = %v, wantErr %v", err, tt.wantErr)
// return
// }
// if !reflect.DeepEqual(got, tt.want) {
// t.Errorf("GetTargetFiles() = %v, want %v", got, tt.want)
// }
// })
// }
// }
|
