forked from infamousjoeg/kwik-e-mart
/
connect.go
59 lines (49 loc) · 1.32 KB
/
connect.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
package postgres
import (
"database/sql"
"fmt"
"strings"
_ "github.com/lib/pq"
)
var (
emptyEnv []string
)
func checkEnvValues(host string, user string, password string, dbname string) error {
if host == "" {
emptyEnv = append(emptyEnv, "DB_HOST")
}
if user == "" {
emptyEnv = append(emptyEnv, "DB_USERNAME")
}
if password == "" {
emptyEnv = append(emptyEnv, "DB_PASSWORD")
}
if dbname == "" {
emptyEnv = append(emptyEnv, "DB_NAME")
}
if emptyEnv == nil {
return nil
}
return fmt.Errorf("required environment variable(s) missing: %s", strings.Join(emptyEnv, ","))
}
// Connect completes a connection to a PostgreSQL database host
func Connect(host string, port int, user string, password string, dbname string) (*sql.DB, error) {
// Check required environment variable values
err := checkEnvValues(host, user, password, dbname)
if err != nil {
return nil, fmt.Errorf("%s", err)
}
// Database connection string
psqlConn := fmt.Sprintf("host=%s port=%d user=%s password=%s", host, port, user, password)
// Open database
db, err := sql.Open("postgres", psqlConn)
if err != nil {
return nil, fmt.Errorf("an error occured while connecting to database: %s", err)
}
return db, nil
}
// Close the database connection using by calling this function
func Close(db *sql.DB) {
// Close database
defer db.Close()
}