packages feed

sqlc-hs-0.4.0.0: test/golden/hasql-features/Queries/FindUsers.hs

{- This file was auto-generated from query/users.sql by sqlc-hs. -}
{-# LANGUAGE BangPatterns #-}
{-# LANGUAGE DataKinds #-}
{-# LANGUAGE DuplicateRecordFields #-}
{-# LANGUAGE FlexibleInstances #-}
{-# LANGUAGE OverloadedStrings #-}
{-# LANGUAGE RecordWildCards #-}
{-# LANGUAGE TypeFamilies #-}
module Queries.FindUsers where

import Queries.Internal (Query(..), Enum, Params)
import qualified Queries.Internal
import qualified Data.Int
import qualified Data.Vector
import qualified Hasql.Decoders
import qualified Hasql.Encoders
import qualified Hasql.Mapping.IsScalar
import qualified Hasql.Mapping.IsStatement
import qualified Hasql.Statement

import qualified Data.Text
import qualified Data.Int
import qualified Data.Foldable
import qualified Data.Functor.Contravariant

query_FindUsers :: Query "FindUsers" ":many"
query_FindUsers = Query "SELECT id FROM users WHERE name = ANY ($1) AND email <> ALL ($2) AND age > $3;"

data instance Params "FindUsers" = Params_FindUsers
  {
    names :: [Data.Text.Text],
    emails :: [Data.Text.Text],
    age :: Data.Int.Int32
  }

data instance Queries.Internal.Result "FindUsers" = Result_FindUsers
  {
    id :: !(Data.Int.Int32)
  }

instance Hasql.Mapping.IsStatement.IsStatement (Params "FindUsers") where
  type Result (Params "FindUsers") = Data.Vector.Vector (Queries.Internal.Result "FindUsers")
  statement =
    Hasql.Statement.preparable sql paramsEncoder (Hasql.Decoders.rowVector rowDecoder)
    where
      Query sql = query_FindUsers

      paramsEncoder :: Hasql.Encoders.Params (Params "FindUsers")
      paramsEncoder =
        mconcat
          [ 
          Data.Functor.Contravariant.contramap (\Params_FindUsers{..} -> names) (Hasql.Encoders.param (Hasql.Encoders.nonNullable (Hasql.Encoders.foldableArray (Hasql.Encoders.nonNullable Hasql.Encoders.text)))), 

          Data.Functor.Contravariant.contramap (\Params_FindUsers{..} -> emails) (Hasql.Encoders.param (Hasql.Encoders.nonNullable (Hasql.Encoders.foldableArray (Hasql.Encoders.nonNullable Hasql.Encoders.text)))), 

          Data.Functor.Contravariant.contramap (\Params_FindUsers{..} -> age) (Hasql.Encoders.param (Hasql.Encoders.nonNullable Hasql.Encoders.int4))
          ]
      {-# INLINE paramsEncoder #-}
      rowDecoder :: Hasql.Decoders.Row (Queries.Internal.Result "FindUsers")
      rowDecoder =
        pure Result_FindUsers
          <*> Hasql.Decoders.column (Hasql.Decoders.nonNullable Hasql.Decoders.int4)
      {-# INLINE rowDecoder #-}