ResolveIncidentsByFailingMonitors.hs

{- This file was auto-generated from queries.sql by sqlc-hs. -}
{-# LANGUAGE BangPatterns #-}
{-# LANGUAGE DataKinds #-}
{-# LANGUAGE DuplicateRecordFields #-}
{-# LANGUAGE FlexibleInstances #-}
{-# LANGUAGE OverloadedStrings #-}
{-# LANGUAGE RecordWildCards #-}
{-# LANGUAGE TypeFamilies #-}
module Pulse.Database.ResolveIncidentsByFailingMonitors where

import Pulse.Database.Internal (Query(..), Enum, Params, Result)
import qualified Database.PostgreSQL.Simple
import qualified Database.PostgreSQL.Simple.FromRow
import qualified Database.PostgreSQL.Simple.ToField
import qualified Database.PostgreSQL.Simple.ToRow

import qualified Data.Int
import qualified GHC.Base
import qualified Pulse.Database.Types
import qualified Data.Time
import qualified Data.Foldable

query_resolveIncidentsByFailingMonitors :: Query "resolveIncidentsByFailingMonitors" ":many"
query_resolveIncidentsByFailingMonitors = Query "WITH resolved_incidents AS (\n  UPDATE\n      incidents\n  SET\n      status = 'resolved',\n      updated_at = NOW()\n  WHERE\n      incidents.organization_id = ?\n      AND incidents.status <> 'resolved'\n      AND incidents.failing_monitor IN ?\n  RETURNING id, organization_id, display_name, description, failing_monitor, status, lead_by, acknowledged_by, unacknowledged_at, created_at, updated_at\n),\nrecovered_monitor_event AS (\n  INSERT INTO\n    incident_events (incident_id, type, failing_monitor)\n  SELECT\n    resolved_incidents.id, 'monitor_recovered', resolved_incidents.failing_monitor\n  FROM\n    resolved_incidents\n)\nINSERT INTO\n  incident_events (incident_id, type)\nSELECT\n  resolved_incidents.id, 'incident_resolved'\nFROM\n  resolved_incidents\nRETURNING id, incident_id, type, failing_monitor, notification_recipients, acknowledged_by, resolved_by, created_at"

data instance Params "resolveIncidentsByFailingMonitors" = Params_resolveIncidentsByFailingMonitors
  {
    incidents_organization_id :: Data.Int.Int32,
    incidents_failing_monitors :: GHC.Base.Maybe [Data.Int.Int32]
  }

data instance Result "resolveIncidentsByFailingMonitors" = Result_resolveIncidentsByFailingMonitors
  {
    incident_events_id :: !(Data.Int.Int64),
    incident_events_incident_id :: !(Data.Int.Int64),
    incident_events_type :: !((Pulse.Database.Types.Enum "event_type")),
    incident_events_failing_monitor :: !(GHC.Base.Maybe Data.Int.Int32),
    incident_events_notification_recipients :: !(GHC.Base.Maybe Data.Int.Int32),
    incident_events_acknowledged_by :: !(GHC.Base.Maybe Data.Int.Int32),
    incident_events_resolved_by :: !(GHC.Base.Maybe Data.Int.Int32),
    incident_events_created_at :: !((Maybe Data.Time.UTCTime))
  }

instance Database.PostgreSQL.Simple.ToRow.ToRow (Params "resolveIncidentsByFailingMonitors") where
  toRow Params_resolveIncidentsByFailingMonitors{..} =
    [ 
      Database.PostgreSQL.Simple.ToField.toField incidents_organization_id, 

      Database.PostgreSQL.Simple.ToField.toField (fmap (Database.PostgreSQL.Simple.In . Data.Foldable.toList) incidents_failing_monitors)
    ]

instance Database.PostgreSQL.Simple.FromRow.FromRow (Result "resolveIncidentsByFailingMonitors") where
  fromRow =
    pure Result_resolveIncidentsByFailingMonitors
      <*> Database.PostgreSQL.Simple.FromRow.field
      <*> Database.PostgreSQL.Simple.FromRow.field
      <*> Database.PostgreSQL.Simple.FromRow.field
      <*> Database.PostgreSQL.Simple.FromRow.field
      <*> Database.PostgreSQL.Simple.FromRow.field
      <*> Database.PostgreSQL.Simple.FromRow.field
      <*> Database.PostgreSQL.Simple.FromRow.field
      <*> Database.PostgreSQL.Simple.FromRow.field