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 sqlite3
import (
"database/sql"
"log"
"os"
_ "github.com/mattn/go-sqlite3"
)
// initErr will log the error and close the database connection if
// necessary.
func initErr(db *DB, err error) {
if db.Conn != nil {
db.Conn.Close()
}
log.Fatalf("Initialization Error :: %s", err.Error())
}
// Init initializes a sqlite3 database.
func Init(db *DB) {
var err error
// We set the database path, first the environment variable
// PERSEUS_DBPATH is checked. If it doesn't exist then use set
// it to the default (perseus.db). Note that this is LookupEnv
// so if the user has set PERSEUS_DBPATH="" then it'll return
// true for exists as it should because technically user has
// set the env var, the sql.Open statement will fail though.
envDBPath, exists := os.LookupEnv("PERSEUS_DBPATH")
if !exists {
envDBPath = "perseus.db"
}
db.Path = envDBPath
db.Conn, err = sql.Open("sqlite3", db.Path)
if err != nil {
log.Printf("sqlite3/init.go: %s\n",
"Failed to open database connection")
initErr(db, err)
}
sqlstmt := []string{
// Users can login with multiple devices and so
// multiple tokens will be created. This shouldn't be
// used for login, logins should be verified with
// users table only.
`CREATE TABLE IF NOT EXISTS access (
id TEXT NOT NULL,
token TEXT NOT NULL,
genTime TEXT NOT NULL);`,
`CREATE TABLE IF NOT EXISTS users (
id TEXT PRIMARY KEY,
type TEXT NOT NULL DEFAULT user,
username VARCHAR(128) NOT NULL UNIQUE,
password TEXT NOT NULL,
regTime TEXT NOT NULL);`,
}
// We range over statements and execute them one by one, this
// is during initialization so it doesn't matter if it takes
// few more ms. This way we know which statement caused the
// program to fail.
for _, s := range sqlstmt {
stmt, err := db.Conn.Prepare(s)
if err != nil {
log.Printf("sqlite3/init.go: %s\n",
"Failed to prepare statement")
log.Println(s)
initErr(db, err)
}
_, err = stmt.Exec()
stmt.Close()
if err != nil {
log.Printf("sqlite3/init.go: %s\n",
"Failed to execute statement")
log.Println(s)
initErr(db, err)
}
}
}
|