Skip to content

Filter query: has-agent connecting, connected, disconnected, timeout #5145

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 30 commits into from
Nov 24, 2022
Merged

Filter query: has-agent connecting, connected, disconnected, timeout #5145

Changes from 1 commit
Commits
Show all changes
30 commits
Select commit Hold shift + click to select a range
ee6577d
WIP
mtojek Nov 21, 2022
7d61519
has-agent:connecting, connected
mtojek Nov 22, 2022
b5a1ecc
Fix
mtojek Nov 22, 2022
dca2b8b
Fix
mtojek Nov 22, 2022
0a4746c
has-agent:disconnected, timeout
mtojek Nov 22, 2022
70952e1
Fix: typo
mtojek Nov 22, 2022
7965a54
Fix
mtojek Nov 22, 2022
c1bd839
TODOs
mtojek Nov 22, 2022
2af4133
databasefake
mtojek Nov 22, 2022
f9e2167
Fix: typo
mtojek Nov 22, 2022
45957c1
More TODOs
mtojek Nov 22, 2022
66892d7
databasefake
mtojek Nov 22, 2022
fc93f90
Timeout tests
mtojek Nov 22, 2022
e587b5d
Address PR comments
mtojek Nov 22, 2022
458a8eb
Implement FIXMEs
mtojek Nov 23, 2022
81d9fef
Renamings
mtojek Nov 23, 2022
5ca8c17
Address PR comments
mtojek Nov 23, 2022
ec2d571
Fix: readability
mtojek Nov 23, 2022
4b2f831
Fix: refactor CASE logic
mtojek Nov 23, 2022
3c0d4fe
CASE logic
mtojek Nov 23, 2022
9067a9e
Fix
mtojek Nov 23, 2022
c14663c
Use CTE
mtojek Nov 23, 2022
9c2f64a
Polishing
mtojek Nov 23, 2022
44bf343
Comment
mtojek Nov 24, 2022
598b140
WIP
mtojek Nov 24, 2022
f3787d1
Merge branch 'main' into 4679-surface-agent
mtojek Nov 24, 2022
ba13e03
IS NOT NULL
mtojek Nov 24, 2022
d74b072
Without CTE
mtojek Nov 24, 2022
4255448
One more optimization
mtojek Nov 24, 2022
4ace659
2nd optimization
mtojek Nov 24, 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
Prev Previous commit
Next Next commit
WIP
  • Loading branch information
@mtojek
mtojek committed Nov 24, 2022
commit 598b140fac6d3b76a81f43e4bea99898d84e397f
6 changes: 3 additions & 3 deletions coderd/database/queries/workspaces.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -64,15 +64,15 @@ WITH workspace_builds_agents AS (
) AS agent_status
FROM
workspace_builds
LEFT JOIN
JOIN
provisioner_jobs
ON
provisioner_jobs.id = workspace_builds.job_id
LEFT JOIN
JOIN
workspace_resources
ON
workspace_resources.job_id = provisioner_jobs.id
LEFT JOIN
JOIN
workspace_agents
ON
workspace_agents.resource_id = workspace_resources.id
Expand Down