forked from vmware-archive/atc
/
worker_base_resource_type.go
50 lines (42 loc) · 1.09 KB
/
worker_base_resource_type.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
package db
import (
"database/sql"
sq "github.com/Masterminds/squirrel"
)
type WorkerBaseResourceType struct {
Name string
WorkerName string
}
type UsedWorkerBaseResourceType struct {
ID int
Name string
Version string
WorkerName string
}
func (workerBaseResourceType WorkerBaseResourceType) Find(runner sq.Runner) (*UsedWorkerBaseResourceType, bool, error) {
var id int
var version string
err := psql.Select("wbrt.id, wbrt.version").
From("worker_base_resource_types wbrt").
LeftJoin("base_resource_types brt ON brt.id = wbrt.base_resource_type_id").
LeftJoin("workers w ON w.name = wbrt.worker_name").
Where(sq.Eq{
"brt.name": workerBaseResourceType.Name,
"wbrt.worker_name": workerBaseResourceType.WorkerName,
}).
RunWith(runner).
QueryRow().
Scan(&id, &version)
if err != nil {
if err == sql.ErrNoRows {
return nil, false, nil
}
return nil, false, err
}
return &UsedWorkerBaseResourceType{
ID: id,
Name: workerBaseResourceType.Name,
Version: version,
WorkerName: workerBaseResourceType.WorkerName,
}, true, nil
}