summaryrefslogtreecommitdiff
path: root/db.go
blob: 49e7656ab9b181f6158a5b26ff2f9509254d5344 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
package main

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

type Database struct {
	DB *sql.DB
}

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

func (d *Database) GetOS(w http.ResponseWriter, r *http.Request) {
	rows, err := d.DB.Query("SELECT DISTINCT os FROM manpages;")
	if err != nil {
		log.Println(err)
		ErrorPage(w, 500)
		return
	}
	defer rows.Close()

	for rows.Next() {
		var osName string

		if err := rows.Scan(&osName); err != nil {
			log.Println(err)
			ErrorPage(w, 500)
			return
		}

		fmt.Fprintf(w, "<option value=\"%s\">%s</option>", osName, osName)
	}
}

func (d *Database) Search(w http.ResponseWriter, r *http.Request) {
	query := r.URL.Query()

	log.Println("Request for:", r.URL.String())

	name := query["name"][0]
	section := query["section"][0]
	osName := query["os"][0]

	log.Println(name)

	rows, err := d.DB.Query("SELECT * FROM manpages WHERE name == ? AND section == ? AND os == ?;", name, section, osName)
	if err != nil {
		log.Println(err)
		ErrorPage(w, 500)
		return
	}
	defer rows.Close()

	var entries []Entry
	for rows.Next() {
		var entry Entry

		if err := rows.Scan(&entry.os, &entry.name, &entry.section, &entry.path); err != nil {
			log.Println(err)
			ErrorPage(w, 500)
			return
		}

		entries = append(entries, entry)
	}

	if len(entries) > 0 {
		fmt.Fprintf(w, "<hr>")
		for _, e := range entries {
			data, err := os.ReadFile(e.path)
			if err != nil {
				log.Println(err)
				ErrorPage(w, 500)
				return
			}
			fmt.Fprintf(w, "%s", data)
		}
		fmt.Fprintf(w, "<hr>")
	} else {
		fmt.Fprintf(w, "<center><h1>No results found for %s %s(%s)</h1></center>", osName, name, section)
	}
}