-
Notifications
You must be signed in to change notification settings - Fork 0
/
store.go
114 lines (96 loc) · 2.25 KB
/
store.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
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
package store
import (
"database/sql"
"fmt"
"os"
"sync"
"github.com/dgraph-io/badger/v4"
_ "github.com/mattn/go-sqlite3"
"github.com/sirupsen/logrus"
)
func New(logger *logrus.Logger,
path string, inMem, logging bool) (Store, error) {
badgerDB, err := initBadger(logger, path, inMem, logging)
if err != nil {
return nil, err
}
sqlDB, err := initSQLite()
if err != nil {
return nil, err
}
return &store{
badgerDB: badgerDB,
badgerMutex: &sync.Mutex{},
sqlDB: sqlDB,
sqlMutex: &sync.Mutex{},
}, nil
}
func initBadger(logger *logrus.Logger,
path string, inMem, logging bool) (*badger.DB, error) {
var badgerOpts badger.Options
if inMem {
badgerOpts = badger.DefaultOptions("").WithInMemory(inMem)
} else {
badgerOpts = badger.DefaultOptions(path)
}
if logging {
badgerOpts = badgerOpts.WithLogger(logger)
}
db, err := badger.Open(badgerOpts)
if err != nil {
return nil, fmt.Errorf("error bootstrapping badgerDB: %w", err)
}
return db, nil
}
func initSQLite() (*sql.DB, error) {
// Create the directory if it does not exist
dbPath := "data/db"
if _, err := os.Stat(dbPath); os.IsNotExist(err) {
err := os.MkdirAll(dbPath, 0755) // Create the directory with appropriate permissions
if err != nil {
return nil, err
}
}
db, err := sql.Open("sqlite3", "./data/db/av.db")
if err != nil {
return nil, err
}
// Use a ping to ensure the database is accessible
err = db.Ping()
if err != nil {
return nil, err
}
err = migrations(db)
if err != nil {
return nil, err
}
return db, err
}
func migrations(db *sql.DB) error {
createTableSQL := `CREATE TABLE IF NOT EXISTS zipped (
id INTEGER PRIMARY KEY AUTOINCREMENT,
zipFileName TEXT NOT NULL,
fileName TEXT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);`
_, err := db.Exec(createTableSQL)
if err != nil {
return err
}
return nil
}
type store struct {
badgerDB *badger.DB
badgerMutex *sync.Mutex
sqlDB *sql.DB
sqlMutex *sync.Mutex
}
type Store interface {
// Get , Put and Delete for BadgerDb
Get(key string) ([]byte, error)
Put(key string, value []byte) error
Delete(key string) error
// Get , Put and Delete for SQLite
InsertZipRecord(zipFileName, fileName string) error
DeleteZipRecord(zipFileName string) error
}