You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
41 lines
860 B
Go
41 lines
860 B
Go
package main
|
|
|
|
import (
|
|
"database/sql"
|
|
"fmt"
|
|
"time"
|
|
"math/rand"
|
|
"os"
|
|
|
|
_ "modernc.org/sqlite"
|
|
)
|
|
|
|
func main() {
|
|
rand.Seed(time.Now().UnixNano())
|
|
db, err := sql.Open("sqlite", "prayers.db")
|
|
if err != nil {
|
|
fmt.Println("error loading database driver: "+ err.Error())
|
|
os.Exit(1)
|
|
}
|
|
langcode := "en"
|
|
if len(os.Args) > 1 {
|
|
langcode = os.Args[1]
|
|
}
|
|
rows, err := db.Query("select text, author from prayers where language = ?", langcode)
|
|
if err != nil {
|
|
fmt.Println("database query failed (is prayers.db in your current directory?): " +err.Error())
|
|
os.Exit(2)
|
|
}
|
|
var prayers []string
|
|
for rows.Next() {
|
|
var prayer, author string
|
|
rows.Scan(&prayer, &author)
|
|
prayers = append(prayers, prayer+"\n\n-- "+author)
|
|
}
|
|
if len(prayers) < 1 {
|
|
fmt.Println("query returns no prayers")
|
|
os.Exit(3)
|
|
}
|
|
fmt.Println(prayers[rand.Intn(len(prayers))])
|
|
}
|