tipitypy/reader/db_reader.go
2025-02-16 00:56:53 +02:00

17 lines
328 B
Go

package reader
import (
"fmt"
"tipitypy/db"
)
func GetSourceWords() ([]string, error) {
dbc := db.Connect()
var res []string
err := dbc.Raw(`SELECT value FROM words WHERE deleted_at IS NULL ORDER BY RANDOM() LIMIT 10;`).Scan(&res).Error
if err != nil {
return nil, fmt.Errorf("dbc.Raw: %w", err)
}
return res, nil
}