This repository has been archived by the owner on Oct 31, 2021. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 3
/
database.go
119 lines (100 loc) · 3.01 KB
/
database.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
115
116
117
118
119
package efgs
import (
"context"
"github.com/covid19cz/erouska-backend/internal/logging"
"net"
"github.com/GoogleCloudPlatform/cloudsql-proxy/proxy/proxy"
"github.com/covid19cz/erouska-backend/internal/secrets"
"github.com/go-pg/pg/v10"
"github.com/go-pg/pg/v10/orm"
)
//Singleton database struct.
var database Database
//Database Contains database connection pool.
type Database struct {
connection *pg.DB
}
//Create new database connection pool. Credentials must be specified in secret manager.
func init() {
ctx := context.Background()
logger := logging.FromContext(ctx)
secretsClient := secrets.Client{}
efgsDatabaseName, err := secretsClient.Get("efgs-database-name")
if err != nil {
logger.Fatalf("Connection to secret manager failed: %s", err)
return
}
efgsDatabasePassword, err := secretsClient.Get("efgs-database-password")
if err != nil {
logger.Fatalf("Connection to secret manager failed: %s", err)
return
}
efgsDatabaseUser, err := secretsClient.Get("efgs-database-login")
if err != nil {
logger.Fatalf("Connection to secret manager failed: %s", err)
return
}
efgsDatabaseConnectionName, err := secretsClient.Get("efgs-database-connection-name")
if err != nil {
logger.Fatalf("Connection to secret manager failed: %s", err)
return
}
database.connection = pg.Connect(&pg.Options{
Dialer: func(ctx context.Context, network, addr string) (net.Conn, error) {
return proxy.Dial(string(efgsDatabaseConnectionName))
},
User: string(efgsDatabaseUser),
Password: string(efgsDatabasePassword),
Database: string(efgsDatabaseName),
})
if err := database.createSchema(); err != nil {
logger.Fatalf("Error while creating DB schema: %s", err)
return
}
}
//PersistDiagnosisKeys Save array of DiagnosisKey to database
func (db Database) PersistDiagnosisKeys(keys []*DiagnosisKey) error {
connection := db.connection.Conn()
defer connection.Close()
_, err := connection.Model(keys).Insert()
if err != nil {
return err
}
return nil
}
//GetDiagnosisKeys Get keys from database that are not yet in EFGS and are older than date in parameter.
func (db Database) GetDiagnosisKeys(date string) ([]*DiagnosisKeyWrapper, error) {
connection := db.connection.Conn()
defer connection.Close()
var keys []*DiagnosisKeyWrapper
if err := connection.Model(&keys).Where("created_at >= ?", date).Select(); err != nil {
return nil, err
}
return keys, nil
}
//RemoveDiagnosisKey Remove array of DiagnosisKeyWrapper from database.
func (db Database) RemoveDiagnosisKey(keys []*DiagnosisKeyWrapper) error {
connection := db.connection.Conn()
defer connection.Close()
_, err := connection.Model(keys).WherePK().Delete()
if err != nil {
return err
}
return nil
}
func (db Database) createSchema() error {
connection := db.connection.Conn()
defer connection.Close()
models := []interface{}{
(*DiagnosisKeyWrapper)(nil),
}
for _, model := range models {
err := connection.Model(model).CreateTable(&orm.CreateTableOptions{
IfNotExists: true,
})
if err != nil {
return err
}
}
return nil
}