The diff query generator

1 files changed, 19 insertions, 1 deletions

diff --git a/DAL/DB/CRUD_test.go b/DAL/DB/CRUD_test.go
index 3b60aa0..d6fba1f 100644
--- a/DAL/DB/CRUD_test.go
+++ b/DAL/DB/CRUD_test.go
@@ -34,4 +34,22 @@ func TestFilteredSelectRequestForm(t *testing.T) {
 	}
 }
 
-
+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)
+	}
+}