Skip to content

feat(site): display user status counts over time as an indicator of license usage #15893

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 25 commits into from
Closed

feat(site): display user status counts over time as an indicator of license usage #15893

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
25 commits
Select commit Hold shift + click to select a range
69e4a09
add user_status_changes table
SasSwart Dec 14, 2024
0913355
add GetUserStatusCountsByDay
SasSwart Dec 14, 2024
d952af0
rename unused variable
SasSwart Dec 14, 2024
34ac634
Test GetUserStatusCountsByDay
SasSwart Dec 17, 2024
d5d3021
make gen
SasSwart Dec 17, 2024
c6b50af
fix dbauthz tests
SasSwart Dec 17, 2024
b2fb346
do the plumbing to get sql, api and frontend talking to one another
SasSwart Dec 23, 2024
ad42c16
rename migration
SasSwart Dec 23, 2024
ed86820
move aggregation logic for GetUserStatusChanges into the SQL
SasSwart Dec 24, 2024
0f17038
use window functions for efficiency
SasSwart Dec 24, 2024
1b3976d
ensure we use the same time zone as the start_time param
SasSwart Dec 24, 2024
e2d0d15
ensure we use the same time zone as the start_time param
SasSwart Dec 24, 2024
7fdd9a5
Merge remote-tracking branch 'origin/main' into jjs/dau-history
SasSwart Dec 24, 2024
aed4132
make gen
SasSwart Dec 24, 2024
9c65856
update field names and fix tests
SasSwart Dec 24, 2024
d6c5a4f
exclude deleted users from the user status graph
SasSwart Dec 27, 2024
d1c5baf
Merge remote-tracking branch 'origin/main' into jjs/dau-history
SasSwart Dec 30, 2024
fa66382
GetUserStatusChanges now passes all querier tests
SasSwart Jan 2, 2025
a8c125c
renumber migrations
SasSwart Jan 2, 2025
726bcba
add partial fixture for CI
SasSwart Jan 3, 2025
8bcbe03
fix migration numbers
SasSwart Jan 3, 2025
494f165
rename and document sql function
SasSwart Jan 3, 2025
dbebf0b
revert backend changes for now. so that we can review and merge the d…
SasSwart Jan 3, 2025
e85bc1f
Merge remote-tracking branch 'origin/main' into jjs/dau-history-backend
SasSwart Jan 3, 2025
e738a0e
make gen
SasSwart Jan 3, 2025
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
GetUserStatusChanges now passes all querier tests
  • Loading branch information
@SasSwart
SasSwart committed Jan 2, 2025
commit fa66382836f476121d6de96b7535a8ca7cf7faa4
8 changes: 5 additions & 3 deletions Makefile
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -500,6 +500,7 @@ lint/helm:
# All files generated by the database should be added here, and this can be used
# as a target for jobs that need to run after the database is generated.
DB_GEN_FILES := \
coderd/database/dump.sql \
coderd/database/querier.go \
coderd/database/unique_constraint.go \
coderd/database/dbmem/dbmem.go \
Expand All @@ -519,8 +520,6 @@ GEN_FILES := \
provisionersdk/proto/provisioner.pb.go \
provisionerd/proto/provisionerd.pb.go \
vpn/vpn.pb.go \
coderd/database/dump.sql \
$(DB_GEN_FILES) \
site/src/api/typesGenerated.ts \
coderd/rbac/object_gen.go \
codersdk/rbacresources_gen.go \
Expand All @@ -540,9 +539,12 @@ GEN_FILES := \
coderd/database/pubsub/psmock/psmock.go

# all gen targets should be added here and to gen/mark-fresh
gen: $(GEN_FILES)
gen: gen/db $(GEN_FILES)
.PHONY: gen

gen/db: $(DB_GEN_FILES)
.PHONY: gen/db

# Mark all generated files as fresh so make thinks they're up-to-date. This is
# used during releases so we don't run generation scripts.
gen/mark-fresh:
Expand Down
Loading
Loading