Skip to content

Commit f68a163

Browse files
hugodutkahugodutka
committed
add the GetTelemetryItems query
1 parent 32876a2 commit f68a163

File tree

8 files changed

+72
-0
lines changed

8 files changed

+72
-0
lines changed

‎coderd/database/dbauthz/dbauthz.go

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -2110,6 +2110,13 @@ func (q *querier) GetTelemetryItem(ctx context.Context, key string) (database.Te
21102110
return q.db.GetTelemetryItem(ctx, key)
21112111
}
21122112

2113+
func (q *querier) GetTelemetryItems(ctx context.Context) ([]database.TelemetryItem, error) {
2114+
if err := q.authorizeContext(ctx, policy.ActionRead, rbac.ResourceSystem); err != nil {
2115+
return nil, err
2116+
}
2117+
return q.db.GetTelemetryItems(ctx)
2118+
}
2119+
21132120
func (q *querier) GetTemplateAppInsights(ctx context.Context, arg database.GetTemplateAppInsightsParams) ([]database.GetTemplateAppInsightsRow, error) {
21142121
if err := q.authorizeTemplateInsights(ctx, arg.TemplateIDs); err != nil {
21152122
return nil, err

‎coderd/database/dbauthz/dbauthz_test.go

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -4233,6 +4233,9 @@ func (s *MethodTestSuite) TestSystemFunctions() {
42334233
s.Run("GetTelemetryItem", s.Subtest(func(db database.Store, check *expects) {
42344234
check.Args("test").Asserts(rbac.ResourceSystem, policy.ActionRead).Errors(sql.ErrNoRows)
42354235
}))
4236+
s.Run("GetTelemetryItems", s.Subtest(func(db database.Store, check *expects) {
4237+
check.Args().Asserts(rbac.ResourceSystem, policy.ActionRead)
4238+
}))
42364239
s.Run("InsertTelemetryItemIfNotExists", s.Subtest(func(db database.Store, check *expects) {
42374240
check.Args(database.InsertTelemetryItemIfNotExistsParams{
42384241
Key: "test",

‎coderd/database/dbmem/dbmem.go

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -4356,6 +4356,10 @@ func (q *FakeQuerier) GetTelemetryItem(_ context.Context, key string) (database.
43564356
return database.TelemetryItem{}, sql.ErrNoRows
43574357
}
43584358

4359+
func (q *FakeQuerier) GetTelemetryItems(_ context.Context) ([]database.TelemetryItem, error) {
4360+
return q.telemetryItems, nil
4361+
}
4362+
43594363
func (q *FakeQuerier) GetTemplateAppInsights(ctx context.Context, arg database.GetTemplateAppInsightsParams) ([]database.GetTemplateAppInsightsRow, error) {
43604364
err := validateDatabaseType(arg)
43614365
if err != nil {

‎coderd/database/dbmetrics/querymetrics.go

Lines changed: 7 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/dbmock/dbmock.go

Lines changed: 15 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/querier.go

Lines changed: 1 addition & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/queries.sql.go

Lines changed: 32 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/queries/telemetryitems.sql

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -10,3 +10,6 @@ SELECT * FROM telemetry_items WHERE key = $1;
1010
INSERT INTO telemetry_items (key, value)
1111
VALUES ($1, $2)
1212
ON CONFLICT (key) DO UPDATE SET value = $2, updated_at = NOW() WHERE telemetry_items.key = $1;
13+
14+
-- name: GetTelemetryItems :many
15+
SELECT * FROM telemetry_items;

0 commit comments

Comments
 (0)