blob: 3b60aa088290ee0c4139e218ea3584eb2b2b5c9b (
plain)
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
|
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)
}
}
|
