-
Notifications
You must be signed in to change notification settings - Fork 0
/
sn.go
84 lines (66 loc) · 1.5 KB
/
sn.go
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
package main
import (
"fmt"
"log/slog"
"os"
"github.com/alecthomas/kong"
"github.com/olekukonko/tablewriter"
"github.com/ringmaster/Sn/sn"
)
var CLI struct {
Serve struct {
} `cmd:"serve" help:"Start the server"`
Sql struct {
Query string `arg:"" required:"" help:"The query to execute"`
} `cmd:"sql" help:"Perform queries against repo data"`
}
func serve() {
sn.ConfigSetup()
sn.RegisterTemplateHelpers()
sn.RegisterPartials()
sn.DBConnect()
defer sn.DBClose()
sn.DBLoadRepos()
sn.WebserverStart()
}
func sql(query string) {
fmt.Printf("Connecting to Database\n")
sn.ConfigSetup()
sn.RegisterTemplateHelpers()
sn.RegisterPartials()
sn.DBConnect()
defer sn.DBClose()
sn.DBLoadReposSync()
fmt.Printf("Running Query: %s\n", query)
rows, _ := sn.DBQuery(query)
fmt.Printf("Query Complete\n")
cols, _ := rows.Columns()
result, _ := sn.RowToMapSlice(rows)
table := tablewriter.NewWriter(os.Stdout)
table.SetHeader(cols)
for _, v := range result {
table.Append(v)
}
table.Render() // Send output
}
func main() {
slog.SetDefault(slog.New(slog.NewJSONHandler(os.Stdout, nil)))
ctx := kong.Parse(
&CLI,
kong.Description("A simple web server that dynamically serves blog entries"),
kong.UsageOnError(),
kong.ConfigureHelp(kong.HelpOptions{
Compact: true,
Summary: true,
}))
switch ctx.Command() {
case "serve":
slog.Default().Info("started Sn serve")
serve()
case "sql <query>":
sqlQuery := CLI.Sql.Query
sql(sqlQuery)
default:
fmt.Println(ctx.Command())
}
}