/
githubmirror
/
pocketbase
Обзор
Документация
Войти
/
githubmirror
/
pocketbase
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
tools/dbutils/select_test.go
38 строк
814 B
Gani Georgiev
use group by instead of distinct when possible
13 янв 2026, 19:47
13 янв 2026, 19:47
0b9a646
Код
Авторство
О чём код?
package dbutils_test import ( "testing" "github.com/pocketbase/pocketbase/tools/dbutils" ) func TestAliasOrIdentifier(t *testing.T) { scenarios := []struct { value string expected string }{ {"", ""}, {"abc", "abc"}, {"abc ", "abc "}, // return unmodified {"abc.def", "abc.def"}, {"abc.123 def", "def"}, {"abc.123 as def.456", "def.456"}, {"(abc) def", "def"}, {"(abc) as def", "def"}, {"abc def", "def"}, {"abc as def", "def"}, // technically invalid identifier but consistent with the dbx regex matching {"a b c d", "d"}, {"a b c as d", "d"}, } for _, s := range scenarios { t.Run(s.value, func(t *testing.T) { result := dbutils.AliasOrIdentifier(s.value) if result != s.expected { t.Fatalf("Expected\n%v\ngot\n%v", s.expected, result) } }) } }