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