Skip to content

feat(coderd/database): rewrite GetTemplateAppInsightsByTemplate to use template_usage_stats #12670

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
wants to merge 19 commits into from
Closed

feat(coderd/database): rewrite GetTemplateAppInsightsByTemplate to use template_usage_stats #12670

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
19 commits
Select commit Hold shift + click to select a range
9052117
feat(coderd/database): add `template_usage_stats` table and rollup query
mafredri Mar 18, 2024
c9bd6af
test(coderd): fix insights tests
mafredri Mar 19, 2024
9037b25
feat(coderd/database): rewrite `GetTemplateInsights` to use `template…
mafredri Mar 18, 2024
e626ab0
fix: implement `UpsertTemplateUsageStats` in dbmem
mafredri Mar 20, 2024
4da99d8
fix: implement `GetTemplateInsights` in dbmem
mafredri Mar 20, 2024
3651cc9
feat(coderd/database): rewrite `GetTemplateInsightsByInterval` to use…
mafredri Mar 18, 2024
af55118
fix: implement `GetTemplateInsightsByInterval` in dbmem
mafredri Mar 20, 2024
e5da393
feat(coderd/database): rewrite `GetTemplateInsightsByTemplate` to use…
mafredri Mar 18, 2024
a234c5d
fix: implement `GetTemplateInsightsByTemplate` in dbmem
mafredri Mar 20, 2024
23f382c
feat(coderd/database): rewrite `GetTemplateAppInsights` to use `templ…
mafredri Mar 18, 2024
803de96
fix gen
mafredri Mar 20, 2024
fcaaff8
simplify query
mafredri Mar 20, 2024
ce9890e
fix: implement `GetTemplateAppInsights` in dbmem
mafredri Mar 20, 2024
385e019
fix dbauthz
mafredri Mar 20, 2024
b11b3b6
update join comment
mafredri Mar 20, 2024
460c244
update join comment
mafredri Mar 20, 2024
af3fc3e
feat(coderd/database): rewrite `GetTemplateAppInsightsByTemplate` to …
mafredri Mar 18, 2024
310f545
add fixture
mafredri Mar 20, 2024
7145189
feat(coderd/database): add `dbrollup` service to rollup insights
mafredri Mar 18, 2024
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
update join comment
  • Loading branch information
@mafredri
mafredri committed Mar 20, 2024
commit 460c244cfce2ac482098c873ba3162fdae9741f6
4 changes: 3 additions & 1 deletion coderd/database/queries.sql.go
View file
Open in desktop

Some generated files are not rendered by default. Learn more about how customized files appear on GitHub.

4 changes: 3 additions & 1 deletion coderd/database/queries/insights.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -196,7 +196,9 @@ WITH
FROM
template_usage_stats AS tus, jsonb_each(app_usage_mins) AS app_usage
LEFT JOIN LATERAL (
-- Fetch the latest app info for each app based on slug and template.
-- The joins in this query are necessary to associate an app with a
-- template, we use this to get the app metadata like display name
-- and icon.
SELECT
app.display_name,
app.icon,
Expand Down