packages feed

sqlc-hs-0.2.0.0: test/golden/out/Pulse/Database/CreateOpcuaNodeIncident.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.CreateOpcuaNodeIncident 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 Data.Text
import qualified Pulse.Database.DBTypes
import qualified Data.Vector
import qualified Data.Foldable

query_createOpcuaNodeIncident :: Query "createOpcuaNodeIncident" ":exec"
query_createOpcuaNodeIncident = Query "WITH opcua_node_incidents AS (\n  INSERT INTO\n    opcua_node_incidents (id, description_template, opcua_attribute_values)\n    VALUES (?, ?, ?)\n    ON CONFLICT (id) DO NOTHING\n    RETURNING id, description_template, opcua_attribute_values, created_at, updated_at\n),\nmonitor_failed_event AS (\n  INSERT INTO\n    incident_events (incident_id, type, failing_monitor)\n  SELECT\n    opcua_node_incidents.id, 'monitor_failed', incidents.failing_monitor\n  FROM\n    opcua_node_incidents JOIN incidents ON opcua_node_incidents.id = incidents.id\n)\nINSERT INTO\n  incident_events (incident_id, type)\nSELECT\n  opcua_node_incidents.id, 'incident_started'\nFROM\n  opcua_node_incidents JOIN incidents ON opcua_node_incidents.id = incidents.id"

data instance Params "createOpcuaNodeIncident" = Params_createOpcuaNodeIncident
  {
    opcua_node_incidents_id :: Data.Int.Int64,
    opcua_node_incidents_description_template :: Data.Text.Text,
    opcua_node_incidents_opcua_attribute_values :: Data.Vector.Vector Pulse.Database.DBTypes.OpcuaAttributeValue
  }

data instance Result "createOpcuaNodeIncident" = Result_createOpcuaNodeIncident
  {
  }

instance Database.PostgreSQL.Simple.ToRow.ToRow (Params "createOpcuaNodeIncident") where
  toRow Params_createOpcuaNodeIncident{..} =
    [ 
      Database.PostgreSQL.Simple.ToField.toField opcua_node_incidents_id, 

      Database.PostgreSQL.Simple.ToField.toField opcua_node_incidents_description_template, 

      Database.PostgreSQL.Simple.ToField.toField opcua_node_incidents_opcua_attribute_values
    ]

instance Database.PostgreSQL.Simple.FromRow.FromRow (Result "createOpcuaNodeIncident") where
  fromRow =
    pure Result_createOpcuaNodeIncident