-
Notifications
You must be signed in to change notification settings - Fork 0
/
role.go
34 lines (29 loc) · 1001 Bytes
/
role.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
package handler
import (
"github.com/labstack/echo/v4"
"github.com/mccune1224/betrayal-widget/data"
"github.com/mccune1224/betrayal-widget/view/page"
)
func (h *Handler) SearchRole(c echo.Context) error {
nameSearch := c.FormValue("name")
descriptionSearch := c.FormValue("description")
searchResults := []*data.ComplexRole{}
if nameSearch != "" {
roles := []*data.ComplexRole{}
err := h.models.Roles.DB.Select(&roles, "SELECT * from roles WHERE name ILIKE $1", nameSearch)
if err != nil {
return TemplRender(c, page.Error500(c, err))
}
if len(roles) != 1 {
// SELECT * FROM abilities WHERE levenshtein(name, $1) <=4 LIMIT 5
err := h.models.Roles.DB.Select(&roles, "SELECT * FROM roles WHERE levenshtein(name, $1) <=4 LIMIT 5", nameSearch)
if err != nil {
return TemplRender(c, page.Error500(c, err))
}
}
searchResults = append(searchResults, roles...)
}
if descriptionSearch != "" {
}
return TemplRender(c, page.PlayerRoleResults(c, searchResults))
}