Filtered query generator

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)
+	}
+}
+
+