/
db.go
57 lines (47 loc) · 1.25 KB
/
db.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
package main
import (
"io/ioutil"
"net/http"
"github.com/Sirupsen/logrus"
"github.com/dancannon/gorethink"
)
var session *gorethink.Session
func initializeDB() {
var err error
session, err = gorethink.Connect(gorethink.ConnectOpts{Address: config.DBHost, Database: config.DBName})
if err != nil {
logrus.Fatal("db:", err)
}
}
func getRemoteObject(url string) (Object, error) {
rows, err := gorethink.Table("objects").GetAllByIndex("url", url).Run(session)
var row Object
err = rows.One(&row)
if err != nil && err != gorethink.ErrEmptyResult {
return Object{}, err
}
if err == gorethink.ErrEmptyResult {
res, err := http.Get(url)
if err != nil {
return Object{}, err
}
defer res.Body.Close()
content, err := ioutil.ReadAll(res.Body)
if err != nil {
return Object{}, err
}
result, err := gorethink.Table("objects").Insert(Object{URL: url, Content: content}).RunWrite(session)
if err != nil {
return Object{}, err
}
return Object{ID: result.GeneratedKeys[0], URL: url, Content: content}, nil
}
return row, nil
}
func updateRemoteObject(objectID string, fileID string) error {
_, err := gorethink.Table("objects").Get(objectID).Update(Object{FileID: fileID}).RunWrite(session)
if err != nil {
return err
}
return nil
}