Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit16b59c9

Browse files
committed
fixup! chore: get latest preset id
1 parent7906899 commit16b59c9

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 aboutcustomizing 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 NOTworkspaces.deleted
6766
),
6867
workspace_latest_presetsAS (
69-
SELECT DISTINCTON (latest_prebuilds.id)latest_prebuilds.idAS workspace_id,
70-
workspace_builds.template_version_preset_idAS current_preset_id
68+
SELECT DISTINCTON (latest_prebuilds.id)
69+
latest_prebuilds.idAS workspace_id,
70+
workspace_builds.template_version_preset_idAS current_preset_id
7171
FROM latest_prebuilds
7272
JOIN workspace_buildsONworkspace_builds.workspace_id=latest_prebuilds.id
7373
WHEREworkspace_builds.transition='start'::workspace_transition
74+
ANDworkspace_builds.template_version_preset_idIS NOT NULL
7475
ORDER BYlatest_prebuilds.id,workspace_builds.build_numberDESC
7576
),
7677
ready_agentsAS (
@@ -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_idAScurrent_preset_id,
93+
workspace_latest_presets.current_preset_id,
9394
COALESCE(ready_agents.ready, false)::booleanAS ready,
9495
latest_prebuilds.created_at
9596
FROM latest_prebuilds

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp