blob: 6b2a0071932b6c4d349c37fb724d3b8fd8ae1ac6 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
package db
import "database/sql"
func (d *DB) GetSetting(key string) (string, error) {
var val string
err := d.db.QueryRow(`SELECT value FROM settings WHERE key = ?`, key).Scan(&val)
if err == sql.ErrNoRows {
return "", nil
}
return val, err
}
func (d *DB) SetSetting(key, value string) error {
_, err := d.db.Exec(
`INSERT INTO settings (key, value) VALUES (?, ?)
ON CONFLICT(key) DO UPDATE SET value = excluded.value`,
key, value,
)
return err
}
|
