Skip to content

feat: add count to get users endpoint #5016

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

Merged
merged 17 commits into from
Nov 14, 2022
Merged

feat: add count to get users endpoint #5016

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
17 commits
Select commit Hold shift + click to select a range
f771959
feat: add count to queries in window function
f0ssel Nov 10, 2022
ed5a147
make initial tests pass
f0ssel Nov 14, 2022
5da633e
fix more tests
f0ssel Nov 14, 2022
8a00932
idk
f0ssel Nov 14, 2022
206381d
get presleys help
f0ssel Nov 14, 2022
a1b7e4e
rename test
f0ssel Nov 14, 2022
482b59f
remove count endpoint
f0ssel Nov 14, 2022
0d738e8
remove more
f0ssel Nov 14, 2022
d5b5000
fmt
f0ssel Nov 14, 2022
ada3995
fix js tests
f0ssel Nov 14, 2022
bd34b05
keep fixing
f0ssel Nov 14, 2022
6249824
fmt
f0ssel Nov 14, 2022
8a92b2b
fmt
f0ssel Nov 14, 2022
ef32b99
fix all js tests
f0ssel Nov 14, 2022
7f43a6c
fix
f0ssel Nov 14, 2022
991b518
move states
f0ssel Nov 14, 2022
b86e0cb
fmt
f0ssel Nov 14, 2022
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
4 changes: 2 additions & 2 deletions coderd/database/querier.go
View file
Open in desktop

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

49 changes: 41 additions & 8 deletions 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.

2 changes: 1 addition & 1 deletion coderd/database/queries/users.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -128,7 +128,7 @@ WHERE

-- name: GetUsers :many
SELECT
*
*, COUNT(*) OVER() AS count
FROM
users
WHERE
Expand Down
2 changes: 1 addition & 1 deletion coderd/database/queries/workspaces.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -10,7 +10,7 @@ LIMIT

-- name: GetWorkspaces :many
SELECT
workspaces.*
workspaces.*, COUNT(workspaces.*) OVER() AS count
FROM
workspaces
LEFT JOIN LATERAL (
Expand Down