-- name: InsertWorkspaceAgentScripts :many

INSERT INTO

workspace_agent_scripts (workspace_agent_id, created_at, log_source_id, log_path, script, cron, start_blocks_login, run_on_start, run_on_stop, timeout_seconds, display_name, id)

SELECT

@workspace_agent_id :: uuid AS workspace_agent_id,

@created_at :: timestamptz AS created_at,

unnest(@log_source_id :: uuid [ ]) AS log_source_id,

unnest(@log_path :: text [ ]) AS log_path,

unnest(@script :: text [ ]) AS script,

unnest(@cron :: text [ ]) AS cron,

unnest(@start_blocks_login :: boolean [ ]) AS start_blocks_login,

unnest(@run_on_start :: boolean [ ]) AS run_on_start,

unnest(@run_on_stop :: boolean [ ]) AS run_on_stop,

unnest(@timeout_seconds :: integer [ ]) AS timeout_seconds,

unnest(@display_name :: text [ ]) AS display_name,

unnest(@id :: uuid [ ]) AS id

RETURNING workspace_agent_scripts.*;

-- name: GetWorkspaceAgentScriptsByAgentIDs :many

SELECT

DISTINCT ON (workspace_agent_scripts.id) workspace_agent_scripts.*,

workspace_agent_script_timings.exit_code,

workspace_agent_script_timings.status

FROM workspace_agent_scripts

LEFT JOIN workspace_agent_script_timings

ON workspace_agent_script_timings.script_id = workspace_agent_scripts.id

WHERE workspace_agent_scripts.workspace_agent_id = ANY(@ids :: uuid [ ])

ORDER BY workspace_agent_scripts.id, workspace_agent_script_timings.started_at

DESC NULLS LAST;