package main

import (
	"database/sql"
	_ "modernc.org/sqlite"
	"fmt"
	"log"
	_ "modernc.org/sqlite"
)

type Entry struct {
	os      string
	name    string
	section int
	path    string
}

func main() {
	db, err := sql.Open("sqlite", "man.db")
	if err != nil {
		log.Fatal(err)
	}

	if err := db.Ping(); err != nil {
		log.Fatal(err)
	}

	r, err := db.Query("SELECT * FROM manpages WHERE name == 'intro';")
	if err != nil {
		log.Fatal(err)
	}
	defer r.Close()

	for r.Next() {
		var entry Entry
		if err := r.Scan(&entry.os, &entry.name, &entry.section, &entry.path); err != nil {
			log.Fatal(err)
		}
		fmt.Println(entry.os, entry.name, entry.section, entry.path)
	}

	err = db.Close()
	if err != nil {
		log.Fatal(err)
	}
}