From c64d43552497d46ae30272d5bf93c2162ea2a1db Mon Sep 17 00:00:00 2001
From: Physick <96335032+DegustatorPonos@users.noreply.github.com>
Date: Sat, 29 Nov 2025 21:05:36 +0500
Subject: Filtered query generator

---
 DAL/DB/CRUD_test.go | 16 ++++++++++++++--
 1 file changed, 14 insertions(+), 2 deletions(-)

(limited to 'DAL/DB/CRUD_test.go')

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)
+	}
+}
+
+
-- 
cgit v1.3