/
var_val.go
74 lines (62 loc) · 1.82 KB
/
var_val.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
74
package pail
import "github.com/FryDay/pail/sqlite"
type Var struct {
ID int64 `db:"id"`
Name string `db:"name"`
}
type Value struct {
ID int64 `db:"id"`
VarID int64 `db:"var_id"`
Value string `db:"value"`
}
type VarValue struct {
*Var
*Value
}
func NewVar(name string) *Var {
return &Var{Name: name}
}
func NewValue(varID int64, value string) *Value {
return &Value{VarID: varID, Value: value}
}
func getVar(db *sqlite.DB, name string) (*Var, error) {
v := &Var{}
if err := db.Get(`select id, name from var where name=:name`, map[string]interface{}{"name": name}, v); err != nil {
if err == sqlite.ErrNoRows {
return nil, nil
}
return nil, err
}
return v, nil
}
func getValue(db *sqlite.DB, varID int64, value string) (*Value, error) {
val := &Value{}
if err := db.Get(`select id, var_id, value from value where var_id=:var_id and value=:value`, map[string]interface{}{"var_id": varID, "value": value}, val); err != nil {
if err == sqlite.ErrNoRows {
return nil, nil
}
return nil, err
}
return val, nil
}
func findVarValue(db *sqlite.DB, name string) (*VarValue, error) {
varValue := &VarValue{}
if err := db.Get(`select ('$' || v.name) name, val.value from value val join var v on v.id = val.var_id where v.name=:name order by random() limit 1`, map[string]interface{}{"name": name}, varValue); err != nil {
if err == sqlite.ErrNoRows {
return nil, nil
}
return nil, err
}
return varValue, nil
}
func (v *Var) insert(db *sqlite.DB) (err error) {
v.ID, err = db.Insert(`insert into var (name) values (:name)`, v)
return err
}
func (val *Value) insert(db *sqlite.DB) (err error) {
val.ID, err = db.Insert(`insert into value (var_id, value) values (:var_id, :value)`, val)
return err
}
func (val *Value) delete(db *sqlite.DB) error {
return db.Delete(`delete from value where id=:id`, val)
}