view_random.go 556 B

12345678910111213141516171819202122232425262728293031
  1. package main
  2. import (
  3. "encoding/json"
  4. "fmt"
  5. "os"
  6. "opennamu/tool"
  7. )
  8. func main() {
  9. call_arg := os.Args[1:]
  10. db_set := map[string]string{}
  11. json.Unmarshal([]byte(call_arg[0]), &db_set)
  12. db := tool.DB_connect(db_set)
  13. if db == nil {
  14. return
  15. }
  16. defer db.Close()
  17. var title string
  18. err := db.QueryRow(tool.DB_change(db_set, "select title from data where title not like 'user:%' and title not like 'category:%' and title not like 'file:%' order by random() limit 1")).Scan(&title)
  19. if err != nil {
  20. fmt.Println(err)
  21. return
  22. }
  23. fmt.Print(title)
  24. }