0068.yml

version: 68
description: add queue_artifact_present
methods:
  queue_artifact_present:
    serviceName: queue
    description: |-
      Mark the given queue artifact as present, returning the updated artifact.  Returns
      nothing if no such artifact exists.
    mode: write
    args: task_id_in text, run_id_in integer, name_in text
    returns: table(task_id text, run_id integer, name text, storage_type text, content_type text, details jsonb, present boolean, expires timestamptz)
    body: |-
      begin
        return query
        update queue_artifacts
        set present = true
        where
          queue_artifacts.task_id = task_id_in and
          queue_artifacts.run_id = run_id_in and
          queue_artifacts.name = name_in
        returning
          queue_artifacts.task_id,
          queue_artifacts.run_id,
          queue_artifacts.name,
          queue_artifacts.storage_type,
          queue_artifacts.content_type,
          queue_artifacts.details,
          queue_artifacts.present,
          queue_artifacts.expires;
      end