jlelse
/
kis3
Archived
1
Fork 0
This repository has been archived on 2021-01-04. You can view files and clone it, but cannot push or open issues or pull requests.
kis3/database_test.go

137 lines
4.4 KiB
Go

package main
import (
"database/sql"
"testing"
)
func TestViewsRequest_buildDateTimeFilter(t *testing.T) {
t.Run("No DateTime filter", func(t *testing.T) {
request := &ViewsRequest{
from: "",
to: "",
}
namedArgs := &[]sql.NamedArg{}
if gotDateTimeFilter := request.buildDateTimeFilter(namedArgs); gotDateTimeFilter != "" ||
len(*namedArgs) != 0 {
t.Errorf("ViewsRequest.buildDateTimeFilter(): Wrong return string or length of namedArgs, should be empty")
}
})
t.Run("From filter", func(t *testing.T) {
request := &ViewsRequest{
from: "2019-01-01",
to: "",
}
namedArgs := &[]sql.NamedArg{}
if gotDateTimeFilter := request.buildDateTimeFilter(namedArgs); gotDateTimeFilter != "datetime(time, 'localtime') >= :from" ||
len(*namedArgs) != 1 ||
(*namedArgs)[0].Name != "from" ||
(*namedArgs)[0].Value != "2019-01-01" {
t.Errorf("ViewsRequest.buildDateTimeFilter(): Wrong return string or namedArgs")
}
})
t.Run("To filter", func(t *testing.T) {
request := &ViewsRequest{
from: "",
to: "2019-01-01",
}
namedArgs := &[]sql.NamedArg{}
if gotDateTimeFilter := request.buildDateTimeFilter(namedArgs); gotDateTimeFilter != "datetime(time, 'localtime') <= :to" ||
len(*namedArgs) != 1 ||
(*namedArgs)[0].Name != "to" ||
(*namedArgs)[0].Value != "2019-01-01" {
t.Errorf("ViewsRequest.buildDateTimeFilter(): Wrong return string or namedArgs")
}
})
t.Run("From & To filter", func(t *testing.T) {
request := &ViewsRequest{
from: "2018-01-01",
to: "2019-01-01",
}
namedArgs := &[]sql.NamedArg{}
if gotDateTimeFilter := request.buildDateTimeFilter(namedArgs); gotDateTimeFilter != "datetime(time, 'localtime') between :from and :to" ||
len(*namedArgs) != 2 ||
(*namedArgs)[0].Name != "from" ||
(*namedArgs)[0].Value != "2018-01-01" ||
(*namedArgs)[1].Name != "to" ||
(*namedArgs)[1].Value != "2019-01-01" {
t.Errorf("ViewsRequest.buildDateTimeFilter(): Wrong return string or namedArgs")
}
})
}
func TestViewsRequest_buildUrlFilter(t *testing.T) {
t.Run("No url filter", func(t *testing.T) {
request := &ViewsRequest{
url: "",
}
namedArgs := &[]sql.NamedArg{}
if gotUrlFilter := request.buildUrlFilter(namedArgs); gotUrlFilter != "" ||
len(*namedArgs) != 0 {
t.Errorf("ViewsRequest.buildUrlFilter(): Wrong return string or length of namedArgs, should be empty")
}
})
t.Run("Url filter", func(t *testing.T) {
request := &ViewsRequest{
url: "google",
}
namedArgs := &[]sql.NamedArg{}
if gotUrlFilter := request.buildUrlFilter(namedArgs); gotUrlFilter != "url like :url" ||
len(*namedArgs) != 1 ||
(*namedArgs)[0].Name != "url" ||
(*namedArgs)[0].Value != "%google%" {
t.Errorf("ViewsRequest.buildUrlFilter(): Wrong return string or namedArgs")
}
})
}
func TestViewsRequest_buildRefFilter(t *testing.T) {
t.Run("No ref filter", func(t *testing.T) {
request := &ViewsRequest{
ref: "",
}
namedArgs := &[]sql.NamedArg{}
if gotRefFilter := request.buildRefFilter(namedArgs); gotRefFilter != "" ||
len(*namedArgs) != 0 {
t.Errorf("ViewsRequest.buildRefFilter(): Wrong return string or length of namedArgs, should be empty")
}
})
t.Run("Ref filter", func(t *testing.T) {
request := &ViewsRequest{
ref: "google",
}
namedArgs := &[]sql.NamedArg{}
if gotRefFilter := request.buildRefFilter(namedArgs); gotRefFilter != "ref like :ref" ||
len(*namedArgs) != 1 ||
(*namedArgs)[0].Name != "ref" ||
(*namedArgs)[0].Value != "%google%" {
t.Errorf("ViewsRequest.buildRefFilter(): Wrong return string or namedArgs")
}
})
}
func TestViewsRequest_buildUseragentFilter(t *testing.T) {
t.Run("No useragent filter", func(t *testing.T) {
request := &ViewsRequest{
ua: "",
}
namedArgs := &[]sql.NamedArg{}
if gotUseragentFilter := request.buildUseragentFilter(namedArgs); gotUseragentFilter != "" ||
len(*namedArgs) != 0 {
t.Errorf("ViewsRequest.buildUseragentFilter(): Wrong return string or length of namedArgs, should be empty")
}
})
t.Run("Useragent filter", func(t *testing.T) {
request := &ViewsRequest{
ua: "Firefox",
}
namedArgs := &[]sql.NamedArg{}
if gotUseragentFilter := request.buildUseragentFilter(namedArgs); gotUseragentFilter != "useragent like :ua" ||
len(*namedArgs) != 1 ||
(*namedArgs)[0].Name != "ua" ||
(*namedArgs)[0].Value != "%Firefox%" {
t.Errorf("ViewsRequest.buildUseragentFilter(): Wrong return string or namedArgs")
}
})
}