-
Notifications
You must be signed in to change notification settings - Fork 0
/
fielddesc.go
54 lines (48 loc) · 1.38 KB
/
fielddesc.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
// Package database - Content managed by Project Forge, see [projectforge.md] for details.
package database
import (
"fmt"
"strings"
"github.com/pkg/errors"
"admini.dev/admini/app/util"
)
func QueryFieldDescs(fields util.FieldDescs, query string, argOffset int) (string, []any, error) {
if !strings.Contains(query, ":") {
return "", nil, errors.New("search query [%s] does not contain [:], and should not be passed to this method")
}
parts := util.StringSplitAndTrim(query, ",")
if len(parts) == 0 {
return "", nil, nil
}
wcs := make([]string, 0, len(parts))
vals := make([]any, 0, len(parts))
for _, part := range parts {
col, q := util.StringSplit(part, ':', true)
if q == "" {
continue
}
desc := fields.Get(col)
if desc == nil {
return "", nil, errors.Errorf("invalid field [%s]", col)
}
var v any
switch desc.Type {
case "string":
v = "%" + q + "%"
default:
var err error
v, err = desc.Parse(q)
if err != nil {
return "", nil, errors.Wrapf(err, "invalid search term [%s] for field [%s] of type [%s]", q, desc.Key, desc.Type)
}
}
if v == nil {
return "", nil, errors.Errorf("unable to parse [%s] value for search field [%s]", desc.Type, desc.Key)
}
wc := fmt.Sprintf("%s like $%d", desc.Key, len(wcs)+1+argOffset)
wcs = append(wcs, wc)
vals = append(vals, v)
}
wc := "(" + strings.Join(wcs, " and ") + ")"
return wc, vals, nil
}