-
Notifications
You must be signed in to change notification settings - Fork 1
/
storage.go
83 lines (74 loc) · 2.08 KB
/
storage.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
package storage
import (
"database/sql"
// "time"
// "fmt"
// "strconv"
"log"
_ "github.com/mattn/go-sqlite3"
)
type TimeSeriesDatum struct {
Id int64
Instrument int32
Value float32
Timestamp int64
}
type MikapodDB struct {
database *sql.DB
}
func InitMikapodDB() *MikapodDB {
// DEVELOPERS NOTE:
// (1) SQLite3 Fields via https://www.sqlite.org/datatype3.html
// (2) Learn SQL through W3Schools via https://www.w3schools.com/sql/default.asp
database, err := sql.Open("sqlite3", "./mikapod.db")
if err != nil {
log.Fatal(err)
}
statement, err := database.Prepare("CREATE TABLE IF NOT EXISTS time_series_data (id INTEGER PRIMARY KEY AUTOINCREMENT, instrument INTEGER, value REAL, timestamp UNSIGNED BIG INT)")
if err != nil {
log.Fatal(err)
}
statement.Exec()
return &MikapodDB{
database: database,
}
}
func (s *MikapodDB) InsertTimeSeriesData(instrument int32, value float32, t int64) error {
statement, err := s.database.Prepare("INSERT INTO time_series_data (instrument, value, timestamp) VALUES (?, ?, ?)")
statement.Exec(instrument, value, t)
// log.Printf("Executed Insertion")
return err
}
func (s *MikapodDB) ListTimeSeriesData(limit int32) []TimeSeriesDatum {
statement, err := s.database.Prepare("SELECT id, instrument, value, timestamp FROM time_series_data ORDER BY id DESC LIMIT ?")
if err != nil {
log.Println(err)
return nil
}
rows, _ := statement.Query(limit)
arr := make([]TimeSeriesDatum, 1)
var id int64
var instrument int32
var value float32
var timestamp int64
for rows.Next() {
rows.Scan(&id, &instrument, &value, ×tamp)
// log.Printf("Rows: %v", rows)
arr = append(arr, TimeSeriesDatum{
Id: id,
Instrument: instrument,
Value: value,
Timestamp: timestamp,
})
}
// log.Printf("Executed Listing")
return arr
}
func (s *MikapodDB) DeleteTimeSeriesData(pks []int64) {
// log.Printf("Deleting time-series data with PKs: %v", pks)
for _, v := range pks {
statement, _ := s.database.Prepare("DELETE FROM time_series_data WHERE id=(?)")
statement.Exec(v)
}
// log.Printf("Executed Deletions")
}