Skip to content

High performance self-hosted photo and video management solution.

3.5 KB
Raw Blame
-- NOTE: This file is auto generated by ./sql-generator

-- WorkflowRepository.search
select
  "workflow"."id",
  "workflow"."name",
  "workflow"."description",
  "workflow"."trigger",
  "workflow"."enabled",
  "workflow"."createdAt",
  "workflow"."updatedAt",
  "workflow"."logging",
  (
    select
      coalesce(json_agg(agg), '[]')
    from
      (
        select
          "plugin"."name" as "pluginName",
          "plugin_method"."name" as "methodName",
          "workflow_step"."config",
          "workflow_step"."enabled"
        from
          "workflow_step"
          inner join "plugin_method" on "plugin_method"."id" = "workflow_step"."pluginMethodId"
          inner join "plugin" on "plugin"."id" = "plugin_method"."pluginId"
        where
          "workflow"."id" = "workflow_step"."workflowId"
        order by
          "workflow_step"."order" asc
      ) as agg
  ) as "steps"
from
  "workflow"
order by
  "createdAt" desc

-- WorkflowRepository.get
select
  "workflow"."id",
  "workflow"."name",
  "workflow"."description",
  "workflow"."trigger",
  "workflow"."enabled",
  "workflow"."createdAt",
  "workflow"."updatedAt",
  "workflow"."logging",
  (
    select
      coalesce(json_agg(agg), '[]')
    from
      (
        select
          "plugin"."name" as "pluginName",
          "plugin_method"."name" as "methodName",
          "workflow_step"."config",
          "workflow_step"."enabled"
        from
          "workflow_step"
          inner join "plugin_method" on "plugin_method"."id" = "workflow_step"."pluginMethodId"
          inner join "plugin" on "plugin"."id" = "plugin_method"."pluginId"
        where
          "workflow"."id" = "workflow_step"."workflowId"
        order by
          "workflow_step"."order" asc
      ) as agg
  ) as "steps"
from
  "workflow"
where
  "id" = $1

-- WorkflowRepository.getForWorkflowRun
select
  "workflow"."id",
  "workflow"."name",
  "workflow"."trigger",
  "workflow"."logging",
  (
    select
      coalesce(json_agg(agg), '[]')
    from
      (
        select
          "workflow_step"."id",
          "workflow_step"."config",
          "plugin_method"."pluginId" as "pluginId",
          "plugin_method"."name" as "methodName",
          "plugin_method"."types" as "types",
          "plugin_method"."hostFunctions",
          "plugin_method"."allowedHosts"
        from
          "workflow_step"
          inner join "plugin_method" on "plugin_method"."id" = "workflow_step"."pluginMethodId"
        where
          "workflow_step"."workflowId" = "workflow"."id"
          and "workflow_step"."enabled" = $1
        order by
          "workflow_step"."order" asc
      ) as agg
  ) as "steps"
from
  "workflow"
where
  "id" = $2
  and "enabled" = $3

-- WorkflowRepository.getLogs
select
  "workflow_log"."id",
  "workflow_log"."createdAt",
  "workflow_log"."result",
  "workflow_log"."workflowId",
  "workflow_log"."workflowStepId",
  "workflow_log"."triggerDataId",
  (
    select
      to_json(obj)
    from
      (
        select
          "plugin_method"."pluginId",
          "plugin_method"."name" as "methodName",
          "workflow_step"."order"
        from
          "workflow_step"
          inner join "plugin_method" on "plugin_method"."id" = "workflow_step"."pluginMethodId"
        where
          "workflow_step"."id" = "workflow_log"."workflowStepId"
      ) as obj
  ) as "step"
from
  "workflow_log"
where
  "workflow_log"."workflowId" = $1
order by
  "workflow_log"."createdAt" desc
limit
  $2

-- WorkflowRepository.delete
delete from "workflow"
where
  "id" = $1