-
Notifications
You must be signed in to change notification settings - Fork 0
/
psql.go
80 lines (69 loc) · 1.96 KB
/
psql.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
// Copyright (C) 2023 Shanhu Tech Inc.
//
// This program is free software: you can redistribute it and/or modify it
// under the terms of the GNU Affero General Public License as published by the
// Free Software Foundation, either version 3 of the License, or (at your
// option) any later version.
//
// This program is distributed in the hope that it will be useful, but WITHOUT
// ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
// FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License
// for more details.
//
// You should have received a copy of the GNU Affero General Public License
// along with this program. If not, see <https://www.gnu.org/licenses/>.
package objects
import (
"shanhu.io/g/hashutil"
"shanhu.io/g/pathutil"
"shanhu.io/g/sqlx"
)
type psql struct {
db *sqlx.DB
}
// NewPsql wraps a database connection into a store.
func NewPsql(db *sqlx.DB) Store {
if db == nil {
return NewMemStore()
}
return &psql{db: db}
}
// InitPsql initializes the object store database.
func InitPsql(b *sqlx.DB) error {
q := `create table objects (
k varchar(255) primary key not null,
v bytea not null
)`
_, err := b.X(q)
return err
}
// DestroyPsql destroys the object store database.
func DestroyPsql(db *sqlx.DB) error {
return sqlx.DestroyTable(db, "objects")
}
func (db *psql) Put(bs []byte) (string, error) {
hash := hashutil.Hash(bs)
q := `insert into objects (k, v)
values ($1, $2) on conflict do nothing`
if _, err := db.db.X(q, hash, bs); err != nil {
return "", err
}
return hash, nil
}
func (db *psql) Get(hash string) ([]byte, error) {
q := `select v from objects where k=$1`
row := db.db.Q1(q, hash)
var ret []byte
if has, err := row.Scan(&ret); err != nil {
return nil, err
} else if !has {
return nil, pathutil.NotExist(hash)
}
return ret, nil
}
func (db *psql) Has(hash string) (bool, error) {
q := `select 1 from objects where k=$1`
row := db.db.Q1(q, hash)
var v int
return row.Scan(&v)
}