ref: master
db/bot.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 |
package db import ( "database/sql" "errors" ) func GetBot() (displayName, avatarPath string, err error) { row := db.QueryRow("select display_name, avatar_path from matrix_bot") err = row.Scan(&displayName, &avatarPath) if err != nil { if errors.Is(err, sql.ErrNoRows) { return "", "", nil } return "", "", err } return } func SaveBot(displayName, avatarPath string) error { _, err := db.Exec("insert into matrix_bot values(0, $1, $2) on conflict(bot) do update set display_name = $1, avatar_path = $2 ", displayName, avatarPath) return err } |