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
|
package db
import (
"testing"
"time"
)
type testDataType struct {
Id uint64
Name string `sql:"username"`
Data time.Time
}
var testDataTable = DataTable[testDataType] {
TableName: "DataTable",
}
func TestSelectRequestForm(t *testing.T) {
var expected = "SELECT (Id, username, Data) FROM DataTable;"
var request = testDataTable.formSelectAllQuery()
if request != expected {
t.Errorf("Incorrect select query. \n Expected: '%s' \n Got: '%s'", expected, request)
}
}
func TestFilteredSelectRequestForm(t *testing.T) {
var expected = "SELECT (Id, username, Data) FROM DataTable WHERE (Id = 10 AND username = 'physick');"
var request = testDataTable.formQueryWithFilters(map[string]any{
"Id": 10,
"username": "physick",
})
if request != expected {
t.Errorf("Incorrect select query. \n Expected: '%s' \n Got: '%s'", expected, request)
}
}
func TestSearchSimilarElementQuery(t *testing.T) {
var reference = testDataType {
Id: 10,
Name: "physick",
Data: time.Now(),
}
var expected = "SELECT (Id, username, Data) FROM DataTable WHERE (Id = 10 AND username = 'physick');"
var request, err = testDataTable.GetSimilarFieldsQuery(reference, []string {
"Id",
"username",
})
if err != nil {
t.Error(err.Error())
return
}
if request != expected {
t.Errorf("Incorrect select query. \n Expected: '%s' \n Got: '%s'", expected, request)
}
}
|
