/
database.go
48 lines (39 loc) · 1.11 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
package database
import (
"crypto/sha256"
"encoding/base64"
"fmt"
"github.com/cosmos/cosmos-sdk/codec"
"github.com/jmoiron/sqlx"
"github.com/desmos-labs/caerus/utils"
)
type Database struct {
url string
cdc codec.Codec
SQL *sqlx.DB
}
// NewDatabase returns a new Database instance
func NewDatabase(url string, cdc codec.Codec) (*Database, error) {
sqlDb, err := sqlx.Open("postgres", url)
if err != nil {
return nil, err
}
return &Database{
url: url,
cdc: cdc,
SQL: sqlDb,
}, nil
}
// NewDatabaseFromEnvVariables returns a new Database instance reading the configuration from the environment variables
func NewDatabaseFromEnvVariables(cdc codec.Codec) (*Database, error) {
databaseURI := utils.GetEnvOr(EnvDatabaseURI, "")
if databaseURI == "" {
return nil, fmt.Errorf("missing environment variable %s", EnvDatabaseURI)
}
return NewDatabase(databaseURI, cdc)
}
// encryptValue encrypts the given values so that it can be stored in the database safely
func (db *Database) encryptValue(value string) string {
hashBz := sha256.Sum256([]byte(value))
return base64.StdEncoding.EncodeToString(hashBz[:])
}