Skip to content

Commit 16b59c9

Browse files
committed
fixup! chore: get latest preset id
1 parent 7906899 commit 16b59c9

File tree

2 files changed

+10
-8
lines changed

2 files changed

+10
-8
lines changed

coderd/database/queries.sql.go

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

coderd/database/queries/prebuilds.sql

Lines changed: 5 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -55,7 +55,6 @@ WITH latest_prebuilds AS (
5555
workspaces.name,
5656
workspaces.template_id,
5757
workspace_latest_builds.template_version_id,
58-
workspace_latest_builds.template_version_preset_id,
5958
workspace_latest_builds.job_id,
6059
workspaces.created_at
6160
FROM workspace_latest_builds
@@ -66,11 +65,13 @@ WITH latest_prebuilds AS (
6665
AND NOT workspaces.deleted
6766
),
6867
workspace_latest_presets AS (
69-
SELECT DISTINCT ON (latest_prebuilds.id) latest_prebuilds.id AS workspace_id,
70-
workspace_builds.template_version_preset_id AS current_preset_id
68+
SELECT DISTINCT ON (latest_prebuilds.id)
69+
latest_prebuilds.id AS workspace_id,
70+
workspace_builds.template_version_preset_id AS current_preset_id
7171
FROM latest_prebuilds
7272
JOIN workspace_builds ON workspace_builds.workspace_id = latest_prebuilds.id
7373
WHERE workspace_builds.transition = 'start'::workspace_transition
74+
AND workspace_builds.template_version_preset_id IS NOT NULL
7475
ORDER BY latest_prebuilds.id, workspace_builds.build_number DESC
7576
),
7677
ready_agents AS (
@@ -89,7 +90,7 @@ SELECT
8990
latest_prebuilds.name,
9091
latest_prebuilds.template_id,
9192
latest_prebuilds.template_version_id,
92-
latest_prebuilds.template_version_preset_id AS current_preset_id,
93+
workspace_latest_presets.current_preset_id,
9394
COALESCE(ready_agents.ready, false)::boolean AS ready,
9495
latest_prebuilds.created_at
9596
FROM latest_prebuilds

0 commit comments

Comments
 (0)