forked from concourse/concourse
/
pipeline_lifecycle.go
133 lines (110 loc) · 2.47 KB
/
pipeline_lifecycle.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
package db
import (
"database/sql"
"fmt"
sq "github.com/Masterminds/squirrel"
"github.com/pf-qiu/concourse/v6/atc/db/lock"
)
//go:generate counterfeiter . PipelineLifecycle
type PipelineLifecycle interface {
ArchiveAbandonedPipelines() error
RemoveBuildEventsForDeletedPipelines() error
}
func NewPipelineLifecycle(conn Conn, lockFactory lock.LockFactory) PipelineLifecycle {
return &pipelineLifecycle{
conn: conn,
lockFactory: lockFactory,
}
}
type pipelineLifecycle struct {
conn Conn
lockFactory lock.LockFactory
}
func (pl *pipelineLifecycle) ArchiveAbandonedPipelines() error {
tx, err := pl.conn.Begin()
if err != nil {
return err
}
defer Rollback(tx)
rows, err := pipelinesQuery.
LeftJoin("jobs j ON j.id = p.parent_job_id").
LeftJoin("pipelines p2 ON j.pipeline_id = p2.id").
Where(sq.Or{
// parent pipeline was destroyed
sq.And{
sq.NotEq{"p.parent_build_id": nil},
sq.Eq{"j.id": nil},
},
// pipeline was set by a job. The job was removed from the parent pipeline
sq.Eq{"j.active": false},
// parent pipeline was archived
sq.Eq{"p2.archived": true},
}).
RunWith(tx).
Query()
if err != nil {
return err
}
defer rows.Close()
err = archivePipelines(tx, pl.conn, pl.lockFactory, rows)
if err != nil {
return err
}
err = tx.Commit()
if err != nil {
return err
}
return nil
}
func archivePipelines(tx Tx, conn Conn, lockFactory lock.LockFactory, rows *sql.Rows) error {
var toArchive []pipeline
for rows.Next() {
p := newPipeline(conn, lockFactory)
if err := scanPipeline(p, rows); err != nil {
return err
}
toArchive = append(toArchive, *p)
}
for _, pipeline := range toArchive {
err := pipeline.archive(tx)
if err != nil {
return err
}
}
return nil
}
func (p *pipelineLifecycle) RemoveBuildEventsForDeletedPipelines() error {
rows, err := psql.Select("id").
From("deleted_pipelines").
RunWith(p.conn).
Query()
if err != nil {
return err
}
var idsToDelete []int
for rows.Next() {
var id int
if err := rows.Scan(&id); err != nil {
return err
}
idsToDelete = append(idsToDelete, id)
}
rows.Close()
if len(idsToDelete) == 0 {
return nil
}
for _, id := range idsToDelete {
_, err = p.conn.Exec(fmt.Sprintf("DROP TABLE IF EXISTS pipeline_build_events_%d", id))
if err != nil {
return err
}
}
_, err = psql.Delete("deleted_pipelines").
Where(sq.Eq{"id": idsToDelete}).
RunWith(p.conn).
Exec()
if err != nil {
return err
}
return nil
}