/
delete.go
48 lines (41 loc) · 1.18 KB
/
delete.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
package queries
import (
"database/sql"
"fmt"
"strings"
"github.com/Nv7-Github/Nv7Haven/eod/types"
"github.com/Nv7-Github/sevcord/v2"
)
func (q *Queries) DeleteQuery(c sevcord.Ctx, opts []any) {
c.Acknowledge()
var name string
err := q.db.QueryRow("SELECT name FROM queries WHERE LOWER(name)=$1 AND guild=$2", strings.ToLower(opts[0].(string)), c.Guild()).Scan(&name)
if err != nil {
q.base.Error(c, err, "Query **"+opts[0].(string)+"** doesn't exist!")
return
}
// Check if used
var usedName string
err = q.db.QueryRow(`SELECT name FROM queries WHERE data->>'query'=$1 OR data->>'left'=$1 OR data->>'right'=$1 AND guild=$2`, name, c.Guild()).Scan(&usedName)
if err != nil && err != sql.ErrNoRows {
q.base.Error(c, err)
return
}
if err == nil {
c.Respond(sevcord.NewMessage(fmt.Sprintf("Cannot delete query **%s** because it is used in query **%s**! "+types.RedCircle, name, usedName)))
return
}
// Delete
res := q.polls.CreatePoll(c, &types.Poll{
Kind: types.PollKindDelQuery,
Data: types.PgData{
"query": name,
},
})
if !res.Ok {
c.Respond(res.Response())
return
}
// Respond
c.Respond(sevcord.NewMessage("Suggested to delete query! 🗑️"))
}