-
Notifications
You must be signed in to change notification settings - Fork 0
/
cockroachdb.go
93 lines (79 loc) · 1.78 KB
/
cockroachdb.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
package testparts
import (
"log"
"os"
"time"
"gorm.io/driver/postgres"
"gorm.io/gorm"
"gorm.io/gorm/logger"
)
func OpenCockroachDB(dsn string, autoMigrate bool) (*gorm.DB, error) {
newLogger := logger.New(
log.New(os.Stdout, "\r\n", log.LstdFlags), // io writer
logger.Config{
SlowThreshold: time.Millisecond * 500, // Slow SQL threshold
LogLevel: logger.Info, // Log level
},
)
db, err := gorm.Open(postgres.Open(dsn),
&gorm.Config{
Logger: newLogger,
SkipDefaultTransaction: true,
},
)
if err != nil {
return nil, err
}
// only need to run this when the schema changes
if autoMigrate {
err = db.AutoMigrate(&GormTest{}, &GormQuestion{}, &GormQuestionChoice{},
GromPreference{}, GormClass{}, &GormStudent{}, GormTestAttempt{},
GormTestSession{})
}
return db, err
}
func CloseCockroachDB(db *gorm.DB) error {
sqlDB, err := db.DB()
if err == nil {
err = sqlDB.Close()
}
return err
}
type Preference struct {
dsn string
}
func newPreference(dsn string) *Preference {
return &Preference{
dsn: dsn,
}
}
func (p *Preference) Set(key, value string) error {
db, err := OpenCockroachDB(p.dsn, false)
if err != nil {
return err
}
defer CloseCockroachDB(db)
return db.Create(
&GromPreference{
Key: key,
Value: value,
}).Error
}
func (p *Preference) Get(key string) (string, error) {
db, err := OpenCockroachDB(p.dsn, false)
if err != nil {
return "", err
}
defer CloseCockroachDB(db)
pref := GromPreference{}
result := db.Where(&GromPreference{Key: key}).First(&pref)
return pref.Value, result.Error
}
func (p *Preference) Del(key string) error {
db, err := OpenCockroachDB(p.dsn, false)
if err != nil {
return err
}
defer CloseCockroachDB(db)
return db.Delete(&GromPreference{Key: key}).Error
}