-
Notifications
You must be signed in to change notification settings - Fork 0
/
orm.go
48 lines (44 loc) · 1.18 KB
/
orm.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 main
import (
"database/sql"
"fmt"
_ "github.com/GoogleCloudPlatform/cloudsql-proxy/proxy/dialers/postgres"
"log"
)
var dsn = fmt.Sprintf("host=%s dbname=%s user=%s password=%s sslmode=disable",
InstanceConnectionName,
DatabaseName,
DatabaseUser,
Password)
// getAlertEventTime returns the alert with the given id.
func getAlertEventTime(id int) string {
db, err := sql.Open("cloudsqlpostgres", dsn)
if err != nil {
log.Fatalf("failed to open DB: %v\n", err)
}
defer db.Close()
row, err := db.Query("SELECT event_time FROM alert where id = $1", id)
if err != nil {
log.Fatalf("failed to query alert: %v\n", err)
}
var et string
for row.Next() {
if err = row.Scan(&et); err != nil {
log.Fatalf("failed to recover event time from alert: %v\n", err)
}
}
_ = row.Close()
return et
}
// checkAlert marks the alert with `id` as sent in the DB.
func checkAlert(id int) {
db, err := sql.Open("cloudsqlpostgres", dsn)
if err != nil {
log.Fatalf("failed to open DB: %v\n", err)
}
defer db.Close()
_, err = db.Exec("UPDATE alert SET notification_sent = true WHERE id = $1", id)
if err != nil {
log.Fatalf("failed to update notification_set to true: %v\n", err)
}
}