*

workspace_builds

id = $1

1;

*

workspace_builds

job_id = $1

1;

SELECT * FROM workspace_builds WHERE created_at > $1;

*

workspace_builds

workspace_id = $1

AND build_number = $2;

*

workspace_builds

workspace_builds.workspace_id = $1

AND workspace_builds.created_at > @since

AND CASE

-- This allows using the last element on a page as effectively a cursor.

-- This is an important option for scripts that need to paginate without

-- duplicating or missing data.

WHEN @after_id :: uuid != '00000000-00000000-00000000-00000000' THEN (

-- The pagination cursor is the last ID of the previous page.

-- The query is ordered by the build_number field, so select all

-- rows after the cursor.

build_number > (

SELECT

build_number

FROM

workspace_builds

WHERE

id = @after_id

)

)

ELSE true

END

build_number desc OFFSET @offset_opt

-- A null limit means "no limit", so 0 means return all

NULLIF(@limit_opt :: int, 0);

*

workspace_builds

workspace_id = $1

build_number desc

1;

SELECT wb.*

FROM (

SELECT

workspace_id, MAX(build_number) as max_build_number

FROM

workspace_builds

WHERE

workspace_id = ANY(@ids :: uuid [ ])

GROUP BY

workspace_id

) m

workspace_builds wb

ON m.workspace_id = wb.workspace_id AND m.max_build_number = wb.build_number;

SELECT wb.*

FROM (

SELECT

workspace_id, MAX(build_number) as max_build_number

FROM

workspace_builds

GROUP BY

workspace_id

) m

workspace_builds wb

ON m.workspace_id = wb.workspace_id AND m.max_build_number = wb.build_number;

workspace_builds (

id,

created_at,

updated_at,

workspace_id,

template_version_id,

"build_number",

transition,

initiator_id,

job_id,

provisioner_state,

deadline,

reason

)

($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12) RETURNING *;

workspace_builds

updated_at = $2,

provisioner_state = $3,

deadline = $4

id = $1;