/
data.go
48 lines (35 loc) · 803 Bytes
/
data.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
package insights
import (
"database/sql"
"log"
_ "github.com/mattn/go-sqlite3" //Database driver
)
type Data struct {
db *sql.DB
AdDownloads AdDownloadsTable
AdViews AdViewsTable
AdClickThroughs AdClickThroughsTable
AdConversions AdConversionsTable
}
func (d *Data) Init() {
log.Println("Data INIT")
db, err := sql.Open("sqlite3", "./insights.db")
checkErr(err)
d.db = db
d.AdDownloads = &AdDownloadsSQLLite{db: db}
d.AdDownloads.Init()
d.AdViews = &AdViewsSQLLite{db: db}
d.AdViews.Init()
d.AdClickThroughs = &AdClickThroughsSQLLite{db: db}
d.AdClickThroughs.Init()
d.AdConversions = &AdConversionsSQLLite{db: db}
d.AdConversions.Init()
}
func checkErr(err error) {
if err != nil {
panic(err)
}
}
func (d *Data) Close() {
d.db.Close()
}