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
|
package reader
import (
"log"
"testing"
)
func TestReadDML(t *testing.T) {
d, _ := ReadDML("testdata/datamap.csv")
// Test Key values
if d[0].Key != "Project/Programme Name" {
t.Errorf("d[0].Key = %s; want Project/Programme Name", d[0].Key)
}
if d[1].Key != "Department" {
t.Errorf("d[1].Key = %s; want Department (without a space)", d[1].Key)
}
if d[2].Key != "Delivery Body" {
t.Errorf("d[2].Key = %s; want Delivery Body (without a space)", d[2].Key)
}
// Test Sheet values
if d[0].Sheet != "Introduction" {
t.Errorf("d[0].Sheet = %s; want Introduction", d[0].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 TestReadXLSX(t *testing.T) {
data := ReadXLSX("testdata/test_template.xlsx")
if data[0].colL != "A" {
t.Errorf("Expected data[0].colL to be A, got %v", data[0].colL)
}
if data[0].value != "Date:" {
t.Errorf("Expected data[0].value to be Date:, got %v", data[0].value)
}
if data[0].rowLidx != 2 {
t.Errorf("Expected data[0].rowLidx to be 2, got %v", data[0].rowLidx)
}
}
func TestAlphaStream(t *testing.T) {
if colstream[26] != "AA" {
t.Errorf("Expected AA, got %v", colstream[26])
}
if len(colstream) > maxCols {
t.Errorf(`Number of columns in alphastream exceeds Excel maximum.
alphastream contains %d, maxCols is %d`, len(colstream), maxCols)
}
log.Printf("Length of alphastream: %d", len(colstream))
}
func TestAlphaSingle(t *testing.T) {
ab := alphabet()
if ab[0] != "A" {
t.Errorf("Expected A, got %v", ab[0])
}
if ab[1] != "B" {
t.Errorf("Expected B, got %v", ab[1])
}
if ab[25] != "Z" {
t.Errorf("Expected Z, got %v", ab[25])
}
}
func TestAlphas(t *testing.T) {
ecs := cols(2)
if ecs[0] != "A" {
t.Errorf("Expected A, got %v", ecs[0])
}
if ecs[25] != "Z" {
t.Errorf("Expected Z, got %v", ecs[25])
}
if ecs[26] != "AA" {
t.Errorf("Expected AA, got %v", ecs[26])
}
if ecs[52] != "BA" {
t.Errorf("Expected BA, got %v", ecs[52])
}
}
func TestGetSheetsFromDM(t *testing.T) {
slice, _ := ReadDML("testdata/datamap.csv")
sheetNames := getSheetNames(slice)
if len(sheetNames) != 14 {
t.Errorf("Expected 14 sheets in slice, got %d",
len(sheetNames))
}
}
func TestReadXLSXToMap(t *testing.T) {
d := ReadXLSToMap("testdata/datamap.csv", "testdata/test_template.xlsx")
_ = d
}
|
