diff options
Diffstat (limited to 'DAL/DB/CRUD_test.go')
| -rw-r--r-- | DAL/DB/CRUD_test.go | 16 |
1 files changed, 14 insertions, 2 deletions
diff --git a/DAL/DB/CRUD_test.go b/DAL/DB/CRUD_test.go index 474c937..3b60aa0 100644 --- a/DAL/DB/CRUD_test.go +++ b/DAL/DB/CRUD_test.go @@ -15,11 +15,23 @@ var testDataTable = DataTable[testDataType] { TableName: "DataTable", } -func TestFormSelectRequest(t *testing.T) { +func TestSelectRequestForm(t *testing.T) { var expected = "SELECT (Id, username, Data) FROM DataTable;" - var request = testDataTable.formSelectRequest() + 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) + } +} + + |
