-
Notifications
You must be signed in to change notification settings - Fork 134
/
sql_repository.go
148 lines (131 loc) · 4.5 KB
/
sql_repository.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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
package repository
import (
"context"
"database/sql"
"github.com/doug-martin/goqu/v9"
_ "github.com/doug-martin/goqu/v9/dialect/postgres"
"github.com/armadaproject/armada/internal/common/util"
"github.com/armadaproject/armada/pkg/api/lookout"
)
// Emulates JobStates enum
// can't use protobuf enums because gogoproto + grpc-gateway is hard with K8s specific messages
type JobState string
const (
JobQueued JobState = "QUEUED"
JobPending JobState = "PENDING"
JobRunning JobState = "RUNNING"
JobSucceeded JobState = "SUCCEEDED"
JobFailed JobState = "FAILED"
JobCancelled JobState = "CANCELLED"
JobDuplicate JobState = "DUPLICATE"
JobQueuedOrdinal = 1
JobPendingOrdinal = 2
JobRunningOrdinal = 3
JobSucceededOrdinal = 4
JobFailedOrdinal = 5
JobCancelledOrdinal = 6
JobDuplicateOrdinal = 7
)
type JobRepository interface {
GetQueueInfos(ctx context.Context) ([]*lookout.QueueInfo, error)
GetJobSetInfos(ctx context.Context, opts *lookout.GetJobSetsRequest) ([]*lookout.JobSetInfo, error)
GetJobs(ctx context.Context, opts *lookout.GetJobsRequest) ([]*lookout.JobInfo, error)
}
type SQLJobRepository struct {
goquDb *goqu.Database
clock util.Clock
}
var (
// Tables
jobTable = goqu.T("job")
jobRunTable = goqu.T("job_run")
jobRunContainerTable = goqu.T("job_run_container")
userAnnotationLookupTable = goqu.T("user_annotation_lookup")
// Columns: job table
job_jobId = goqu.I("job.job_id")
job_queue = goqu.I("job.queue")
job_owner = goqu.I("job.owner")
job_jobset = goqu.I("job.jobset")
job_priority = goqu.I("job.priority")
job_submitted = goqu.I("job.submitted")
job_cancelled = goqu.I("job.cancelled")
job_orig_job_spec = goqu.I("job.orig_job_spec")
job_state = goqu.I("job.state")
job_duplicate = goqu.I("job.duplicate")
job_jobUpdated = goqu.I("job.job_updated")
// Columns: job_run table
jobRun_runId = goqu.I("job_run.run_id")
jobRun_jobId = goqu.I("job_run.job_id")
jobRun_podNumber = goqu.I("job_run.pod_number")
jobRun_cluster = goqu.I("job_run.cluster")
jobRun_node = goqu.I("job_run.node")
jobRun_created = goqu.I("job_run.created")
jobRun_started = goqu.I("job_run.started")
jobRun_finished = goqu.I("job_run.finished")
jobRun_preempted = goqu.I("job_run.preempted")
jobRun_succeeded = goqu.I("job_run.succeeded")
jobRun_error = goqu.I("job_run.error")
// Columns: annotation table
annotation_jobId = goqu.I("user_annotation_lookup.job_id")
annotation_key = goqu.I("user_annotation_lookup.key")
annotation_value = goqu.I("user_annotation_lookup.value")
)
type JobRow struct {
JobId sql.NullString `db:"job_id"`
Queue sql.NullString `db:"queue"`
Owner sql.NullString `db:"owner"`
JobSet sql.NullString `db:"jobset"`
Priority sql.NullFloat64 `db:"priority"`
Submitted sql.NullTime `db:"submitted"`
Cancelled sql.NullTime `db:"cancelled"`
Preempted sql.NullTime `db:"preempted"`
OrigJobSpec []byte `db:"orig_job_spec"`
State sql.NullInt64 `db:"state"`
RunId sql.NullString `db:"run_id"`
PodNumber sql.NullInt64 `db:"pod_number"`
Cluster sql.NullString `db:"cluster"`
Node sql.NullString `db:"node"`
Created sql.NullTime `db:"created"`
Started sql.NullTime `db:"started"`
Finished sql.NullTime `db:"finished"`
Succeeded sql.NullBool `db:"succeeded"`
Error sql.NullString `db:"error"`
}
var AllJobStates = []JobState{
JobQueued,
JobPending,
JobRunning,
JobSucceeded,
JobFailed,
JobCancelled,
JobDuplicate,
}
var JobStateToIntMap = map[JobState]int{
JobQueued: JobQueuedOrdinal,
JobPending: JobPendingOrdinal,
JobRunning: JobRunningOrdinal,
JobSucceeded: JobSucceededOrdinal,
JobFailed: JobFailedOrdinal,
JobCancelled: JobCancelledOrdinal,
JobDuplicate: JobDuplicateOrdinal,
}
var IntToJobStateMap = map[int]JobState{
JobQueuedOrdinal: JobQueued,
JobPendingOrdinal: JobPending,
JobRunningOrdinal: JobRunning,
JobSucceededOrdinal: JobSucceeded,
JobFailedOrdinal: JobFailed,
JobCancelledOrdinal: JobCancelled,
JobDuplicateOrdinal: JobDuplicate,
}
var defaultQueryStates = []JobState{
JobQueued,
JobPending,
JobRunning,
JobSucceeded,
JobFailed,
JobCancelled,
}
func NewSQLJobRepository(db *goqu.Database, clock util.Clock) *SQLJobRepository {
return &SQLJobRepository{goquDb: db, clock: clock}
}