Function setJobResultKey

apps/sim/lib/table/jobs/service.ts:320–332

(
  tableId: string,
  jobId: string,
  resultKey: string
)

 * The download route reads it; the janitor deletes the file when the terminal job is pruned.
 */
export async function setJobResultKey(
  tableId: string,
  jobId: string,
  resultKey: string
): Promise<void> {
  await db
    .update(tableJobs)
    .set({
      payload: sql`coalesce(${tableJobs.payload}, '{}'::jsonb) || jsonb_build_object('resultKey', ${resultKey}::text)`,
      updatedAt: new Date(),
    })
    .where(ownsActiveJob(tableId, jobId))
}

/** Shared WHERE for terminal transitions: this job run, and still in-flight (write-once). */
function ownsActiveJob(tableId: string, jobId: string) {