/
randoms.go
73 lines (62 loc) · 1.4 KB
/
randoms.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
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
package sql
import (
"database/sql"
"errors"
"github.com/Brawl345/gobot/logger"
"github.com/Brawl345/gobot/model"
"github.com/jmoiron/sqlx"
)
type randomService struct {
*sqlx.DB
log *logger.Logger
}
func NewRandomService(db *sqlx.DB) *randomService {
return &randomService{
DB: db,
log: logger.New("randomService"),
}
}
func (db *randomService) exists(random string) (bool, error) {
const query = `SELECT 1 FROM randoms WHERE text = ?`
var exists bool
err := db.Get(&exists, query, random)
if err != nil {
if errors.Is(err, sql.ErrNoRows) {
return false, nil
}
return false, err
}
return exists, nil
}
func (db *randomService) DeleteRandom(random string) error {
exists, err := db.exists(random)
if err != nil {
return err
}
if !exists {
return model.ErrNotFound
}
const query = `DELETE FROM randoms WHERE text = ?`
_, err = db.Exec(query, random)
return err
}
func (db *randomService) GetRandom() (string, error) {
var random string
err := db.Get(&random, "SELECT text FROM randoms ORDER BY RAND() LIMIT 1")
if errors.Is(err, sql.ErrNoRows) {
return "", model.ErrNotFound
}
return random, err
}
func (db *randomService) SaveRandom(random string) error {
exists, err := db.exists(random)
if err != nil {
return err
}
if exists {
return model.ErrAlreadyExists
}
const query = `INSERT INTO randoms (text) VALUES (?)`
_, err = db.Exec(query, random)
return err
}