-
Notifications
You must be signed in to change notification settings - Fork 42
/
getattachmentmeta.go
83 lines (74 loc) · 2.16 KB
/
getattachmentmeta.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
81
82
83
// Licensed under the Apache License, Version 2.0 (the "License"); you may not
// use this file except in compliance with the License. You may obtain a copy of
// the License at
//
// http:https://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
// WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
// License for the specific language governing permissions and limitations under
// the License.
package sqlite
import (
"context"
"database/sql"
"errors"
"net/http"
"github.com/go-kivik/kivik/v4/driver"
internal "github.com/go-kivik/kivik/v4/int/errors"
)
func (d *db) GetAttachmentMeta(ctx context.Context, docID, filename string, options driver.Options) (*driver.Attachment, error) {
opts := newOpts(options)
tx, err := d.db.BeginTx(ctx, nil)
if err != nil {
return nil, err
}
defer tx.Rollback()
var requestedRev revision
if rev := opts.rev(); rev != "" {
requestedRev, err = parseRev(rev)
if err != nil {
return nil, &internal.Error{Message: err.Error(), Status: http.StatusBadRequest}
}
} else {
requestedRev, err = d.winningRev(ctx, tx, docID)
if err != nil {
return nil, err
}
}
attachment, err := d.getAttachmentMetadata(ctx, tx, docID, filename, requestedRev)
if errors.Is(err, sql.ErrNoRows) {
return nil, &internal.Error{Status: http.StatusNotFound, Message: "missing"}
}
if err != nil {
return nil, err
}
return attachment, tx.Commit()
}
func (d *db) getAttachmentMetadata(
ctx context.Context,
tx *sql.Tx,
docID, filename string,
rev revision,
) (*driver.Attachment, error) {
var att driver.Attachment
var hash md5sum
err := tx.QueryRowContext(ctx, d.query(`
SELECT
att.filename,
att.content_type,
att.digest,
att.length
FROM {{ .Attachments }} AS att
JOIN {{ .AttachmentsBridge }} AS bridge ON bridge.pk = att.pk
WHERE
bridge.id = $1
AND att.filename = $2
AND bridge.rev = $3
AND bridge.rev_id = $4
`), docID, filename, rev.rev, rev.id).
Scan(&att.Filename, &att.ContentType, &hash, &att.Size)
att.Digest = hash.Digest()
return &att, err
}