forked from sourcegraph/sourcegraph-public-snapshot
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathbatchchanges.go
More file actions
132 lines (114 loc) · 3.92 KB
/
batchchanges.go
File metadata and controls
132 lines (114 loc) · 3.92 KB
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
package adminanalytics
import (
"context"
"github.com/keegancsmith/sqlf"
"github.com/sourcegraph/sourcegraph/internal/database"
)
type BatchChanges struct {
DateRange string
Grouping string
DB database.DB
Cache bool
}
var changesetsCreatedNodesQuery = `
SELECT
%s AS date,
COUNT(DISTINCT changesets.id) AS count,
COUNT(DISTINCT batch_changes.creator_id) AS unique_users,
COUNT(DISTINCT batch_changes.creator_id) AS registered_users
FROM
changesets
INNER JOIN batch_changes ON batch_changes.id = changesets.owned_by_batch_change_id
WHERE changesets.created_at %s AND changesets.publication_state = 'PUBLISHED'
GROUP BY date
`
var changesetsCreatedSummaryQuery = `
SELECT
COUNT(DISTINCT changesets.id) AS total_count,
COUNT(DISTINCT batch_changes.creator_id) AS total_unique_users,
COUNT(DISTINCT batch_changes.creator_id) AS total_registered_users
FROM
changesets
INNER JOIN batch_changes ON batch_changes.id = changesets.owned_by_batch_change_id
WHERE changesets.created_at %s AND changesets.publication_state = 'PUBLISHED'
`
func (s *BatchChanges) ChangesetsCreated() (*AnalyticsFetcher, error) {
dateTruncExp, dateBetweenCond, err := makeDateParameters(s.DateRange, s.Grouping, "changesets.created_at")
if err != nil {
return nil, err
}
nodesQuery := sqlf.Sprintf(changesetsCreatedNodesQuery, dateTruncExp, dateBetweenCond)
summaryQuery := sqlf.Sprintf(changesetsCreatedSummaryQuery, dateBetweenCond)
return &AnalyticsFetcher{
db: s.DB,
dateRange: s.DateRange,
grouping: s.Grouping,
nodesQuery: nodesQuery,
summaryQuery: summaryQuery,
group: "BatchChanges:ChangesetsCreated",
cache: s.Cache,
}, nil
}
var changesetsMergedNodesQuery = `
SELECT
%s AS date,
COUNT(DISTINCT changesets.id) AS count,
COUNT(DISTINCT batch_changes.creator_id) AS unique_users,
COUNT(DISTINCT batch_changes.creator_id) AS registered_users
FROM
changeset_events
INNER JOIN changesets ON changesets.id = changeset_events.changeset_id
INNER JOIN batch_changes ON batch_changes.id = changesets.owned_by_batch_change_id
WHERE changeset_events.created_at %s AND changeset_events.kind IN (%s)
GROUP BY date
`
var changesetsMergedSummaryQuery = `
SELECT
COUNT(DISTINCT changesets.id) AS total_count,
COUNT(DISTINCT batch_changes.creator_id) AS total_unique_users,
COUNT(DISTINCT batch_changes.creator_id) AS total_registered_users
FROM
changeset_events
INNER JOIN changesets ON changesets.id = changeset_events.changeset_id
INNER JOIN batch_changes ON batch_changes.id = changesets.owned_by_batch_change_id
WHERE changeset_events.created_at %s AND changeset_events.kind IN (%s)
`
var mergeEventKinds = sqlf.Join([]*sqlf.Query{
sqlf.Sprintf("'github:merged'"),
sqlf.Sprintf("'bitbucketserver:merged'"),
sqlf.Sprintf("'gitlab:merged'"),
sqlf.Sprintf("'bitbucketcloud:pullrequest:fulfilled'"),
}, ",")
func (s *BatchChanges) ChangesetsMerged() (*AnalyticsFetcher, error) {
dateTruncExp, dateBetweenCond, err := makeDateParameters(s.DateRange, s.Grouping, "changesets.created_at")
if err != nil {
return nil, err
}
nodesQuery := sqlf.Sprintf(changesetsMergedNodesQuery, dateTruncExp, dateBetweenCond, mergeEventKinds)
summaryQuery := sqlf.Sprintf(changesetsMergedSummaryQuery, dateBetweenCond, mergeEventKinds)
return &AnalyticsFetcher{
db: s.DB,
dateRange: s.DateRange,
grouping: s.Grouping,
nodesQuery: nodesQuery,
summaryQuery: summaryQuery,
group: "BatchChanges:ChangesetsMerged",
cache: s.Cache,
}, nil
}
func (s *BatchChanges) CacheAll(ctx context.Context) error {
fetcherBuilders := []func() (*AnalyticsFetcher, error){s.ChangesetsCreated, s.ChangesetsMerged}
for _, buildFetcher := range fetcherBuilders {
fetcher, err := buildFetcher()
if err != nil {
return err
}
if _, err := fetcher.Nodes(ctx); err != nil {
return err
}
if _, err := fetcher.Summary(ctx); err != nil {
return err
}
}
return nil
}