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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
// dbasik provides a service with which to convert spreadsheets containing
// data to JSON for further processing.
// Copyright (C) 2024 M R Lemon
// This program is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
// You should have received a copy of the GNU General Public License
// along with this program. If not, see <https://www.gnu.org/licenses/>.
// Package main is the entry point for dbasik.
// It provides the main functionality for the dbasik application.
package main
import (
"context"
"database/sql"
"flag"
"fmt"
"log"
"log/slog"
"net/http"
"os"
"time"
"github.com/joho/godotenv"
_ "github.com/mattn/go-sqlite3"
)
const version = "0.0.1"
// holds the config for our application
// We will read this from the command line flags when we run the application
type config struct {
port int
env string
db string
}
// This application struct holds the dependencies for our HTTP handlers, helpers and
// middleware.
type application struct {
config config
logger *slog.Logger
models Models
}
func main() {
// Instance of config
var cfg config
err := godotenv.Load()
if err != nil {
log.Fatal("Cannot load .env file - is it present?")
}
// Read the flags into the config struct. Defaults are provided if none given.
flag.IntVar(&cfg.port, "port", 5000, "API server port")
flag.StringVar(&cfg.env, "env", "development", "Environment (development|staging|production)")
flag.StringVar(&cfg.db, "db-dsn", os.Getenv("DBASIK_DB_DSN"), "sqlite3 DSN")
flag.Parse()
// Initialize a new structured logger which writes to stdout
logger := slog.New(slog.NewTextHandler(os.Stdout, nil))
// set up the database pool
db, err := openDB(cfg)
if err != nil {
logger.Error(err.Error())
os.Exit(1)
}
defer db.Close()
logger.Info("database connection pool established")
// An instance of application struct, containing the config struct and the logger
app := &application{
config: cfg,
logger: logger,
models: NewModels(db),
}
// Declare an http server which listens provided in the config struct and has
// sensible timeout settings and writes log messages to the structured logger at
// Error level.
srv := &http.Server{
Addr: fmt.Sprintf(":%d", cfg.port),
Handler: app.routes(),
IdleTimeout: time.Minute,
ReadTimeout: 5 * time.Second,
WriteTimeout: 10 * time.Second,
ErrorLog: slog.NewLogLogger(logger.Handler(), slog.LevelError),
}
logger.Info("starting server", "addr", srv.Addr, "env", cfg.env)
err = srv.ListenAndServe()
logger.Error(err.Error())
os.Exit(1)
}
func openDB(cfg config) (*sql.DB, error) {
db, err := sql.Open("sqlite3", cfg.db)
if err != nil {
return nil, err
}
// create a context with a 5 second timeout
// if the database hasn't connected within this time, there is a problem
ctx, cancel := context.WithTimeout(context.Background(), 5*time.Second)
defer cancel()
err = db.PingContext(ctx)
if err != nil {
return nil, err
}
return db, nil
}
|
