Commit7906899

committed

chore: get latest preset id

1 parent0f21e44 commit7906899Copy full SHA for 7906899

File tree

+18

-2

lines changed

+18

-2

lines changed

Lines changed: 9 additions & 1 deletion

Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

Lines changed: 9 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -65,6 +65,14 @@ WITH latest_prebuilds AS (`
`65`	`65`	`ANDworkspaces.owner_id='c42fdf75-3097-471c-8c33-fb52454d81c0'::UUID`
`66`	`66`	`AND NOTworkspaces.deleted`
`67`	`67`	`),`
	`68`	`+workspace_latest_presetsAS (`
	`69`	`+SELECT DISTINCTON (latest_prebuilds.id)latest_prebuilds.idAS workspace_id,`
	`70`	`+workspace_builds.template_version_preset_idAS current_preset_id`
	`71`	`+FROM latest_prebuilds`
	`72`	`+JOIN workspace_buildsONworkspace_builds.workspace_id=latest_prebuilds.id`
	`73`	`+WHEREworkspace_builds.transition='start'::workspace_transition`
	`74`	`+ORDER BYlatest_prebuilds.id,workspace_builds.build_numberDESC`
	`75`	`+),`
`68`	`76`	`ready_agentsAS (`
`69`	`77`	`SELECT`
`70`	`78`	`latest_prebuilds.job_id,`
`@@ -81,12 +89,12 @@ SELECT`
`81`	`89`	`latest_prebuilds.name,`
`82`	`90`	`latest_prebuilds.template_id,`
`83`	`91`	`latest_prebuilds.template_version_id,`
`84`		`--- TODO(cian): this can be null, which differs from prebuilt_workspaces view.`
`85`	`92`	`latest_prebuilds.template_version_preset_idAS current_preset_id,`
`86`	`93`	`COALESCE(ready_agents.ready, false)::booleanAS ready,`
`87`	`94`	`latest_prebuilds.created_at`
`88`	`95`	`FROM latest_prebuilds`
`89`	`96`	`LEFT JOIN ready_agentsONready_agents.job_id=latest_prebuilds.job_id`
	`97`	`+LEFT JOIN workspace_latest_presetsONworkspace_latest_presets.workspace_id=latest_prebuilds.id`
`90`	`98`	`;`
`91`	`99`
`92`	`100`	`-- name: CountInProgressPrebuilds :many`

Comments

(0)