Commit70ecdcc

authored and

committed

Simplify workspace_latest_build view

Signed-off-by: Danny Kopping <dannykopping@gmail.com>

1 parentad9a2c5 commit70ecdccCopy full SHA for 70ecdcc

File tree

+20

-33

lines changed

+20

-33

lines changed

Lines changed: 17 additions & 22 deletions

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

Lines changed: 3 additions & 11 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,15 +1,7 @@`
`1`	`1`	`CREATEVIEWworkspace_latest_buildAS`
`2`		`-SELECT wb.*`
`3`		`-FROM (SELECTtv.template_id,`
`4`		`-wbmax.workspace_id,`
`5`		`-MAX(wbmax.build_number)as max_build_number`
`6`		`-FROM workspace_builds wbmax`
`7`		`-JOIN template_versions tvON (tv.id=wbmax.template_version_id)`
`8`		`-GROUP BYtv.template_id,wbmax.workspace_id) wbmax`
`9`		`-JOIN workspace_builds wbON (`
`10`		`-wb.workspace_id=wbmax.workspace_id`
`11`		`-ANDwb.build_number=wbmax.max_build_number`
`12`		`-);`
	`2`	`+SELECT DISTINCTON (workspace_id)*`
	`3`	`+FROM workspace_builds`
	`4`	`+ORDER BY workspace_id, build_numberDESC;`
`13`	`5`
`14`	`6`	`CREATEVIEWworkspace_prebuildsAS`
`15`	`7`	`WITH`

Comments

(0)