Opaleye.Internal.RunQuery

Documentation

data QueryRunnerColumn pgType haskellType

A QueryRunnerColumn pgType haskellType encodes how to turn a value of Postgres type pgType into a value of Haskell type haskellType. For example a value of type QueryRunnerColumn PGText String encodes how to turn a PGText result from the database into a Haskell String.

"QueryRunnerColumn pgType haskellType" corresponds to postgresql-simple's "FieldParser haskellType".

Constructors

QueryRunnerColumn (Unpackspec (Column pgType) ()) (FieldParser haskellType)

Instances

QueryRunnerColumnDefault sqlType haskellType => Default FromField sqlType haskellType

Defined in Opaleye.Internal.RunQuery

Methods

def :: FromField sqlType haskellType

Functor (FromField u)

Defined in Opaleye.Internal.RunQuery

Methods

fmap :: (a -> b) -> FromField u a -> FromField u b

(<$) :: a -> FromField u b -> FromField u a

type FromField = QueryRunnerColumn

data QueryRunner columns haskells

A QueryRunner specifies how to convert Postgres values (columns) into Haskell values (haskells). Most likely you will never need to create on of these or handle one directly. It will be provided for you by the Default QueryRunner instance.

"QueryRunner columns haskells" corresponds to postgresql-simple's "RowParser haskells". "Default QueryRunner columns haskells" corresponds to postgresql-simple's "FromRow haskells".

Constructors

QueryRunner (Unpackspec columns ()) (columns -> RowParser haskells) (columns -> Bool)

Instances

Profunctor FromFields

Defined in Opaleye.Internal.RunQuery

Methods

dimap :: (a -> b) -> (c -> d) -> FromFields b c -> FromFields a d

lmap :: (a -> b) -> FromFields b c -> FromFields a c

rmap :: (b -> c) -> FromFields a b -> FromFields a c

(#.) :: Coercible c b => q b c -> FromFields a b -> FromFields a c

(.#) :: Coercible b a => FromFields b c -> q a b -> FromFields a c

ProductProfunctor FromFields

Defined in Opaleye.Internal.RunQuery

Methods

purePP :: b -> FromFields a b

(****) :: FromFields a (b -> c) -> FromFields a b -> FromFields a c

empty :: FromFields () ()

(***!) :: FromFields a b -> FromFields a' b' -> FromFields (a, a') (b, b')

SumProfunctor FromFields

Defined in Opaleye.Internal.RunQuery

Methods

(+++!) :: FromFields a b -> FromFields a' b' -> FromFields (Either a a') (Either b b')

QueryRunnerColumnDefault a b => Default QueryRunner (Column a) b

Defined in Opaleye.Internal.RunQuery

Methods

def :: QueryRunner (Column a) b

Functor (FromFields c)

Defined in Opaleye.Internal.RunQuery

Methods

fmap :: (a -> b) -> FromFields c a -> FromFields c b

(<$) :: a -> FromFields c b -> FromFields c a

Applicative (FromFields c)

Defined in Opaleye.Internal.RunQuery

Methods

pure :: a -> FromFields c a

(<*>) :: FromFields c (a -> b) -> FromFields c a -> FromFields c b

liftA2 :: (a -> b -> c0) -> FromFields c a -> FromFields c b -> FromFields c c0

(*>) :: FromFields c a -> FromFields c b -> FromFields c b

(<*) :: FromFields c a -> FromFields c b -> FromFields c a

type FromFields = QueryRunner

fieldQueryRunnerColumn :: FromField haskell => FromField pgType haskell

fieldParserQueryRunnerColumn :: FieldParser haskell -> FromField pgType haskell

queryRunner :: FromField a b -> FromFields (Column a) b

queryRunnerColumnNullable :: FromField a b -> FromField (Nullable a) (Maybe b)

class QueryRunnerColumnDefault pgType haskellType where

A QueryRunnerColumnDefault pgType haskellType represents the default way to turn a pgType result from the database into a Haskell value of type haskellType.

"QueryRunnerColumnDefault pgType haskellType" corresponds to postgresql-simple's "FromField haskellType".

Creating an instance of QueryRunnerColumnDefault for your own types is necessary for retrieving those types from the database.

You should use one of the three methods below for writing a QueryRunnerColumnDefault instance.

1. If you already have a FromField instance for your haskellType, use fieldQueryRunnerColumn. (This is how most of the built-in instances are defined.)
2. If you don't have a FromField instance, use queryRunnerColumn if possible. See the documentation for queryRunnerColumn for an example.
3. If you have a more complicated case, but not a FromField instance, write a FieldParser for your type and use fieldParserQueryRunnerColumn. You can also add a FromField instance using this.

Minimal complete definition

queryRunnerColumnDefault

Methods

queryRunnerColumnDefault :: QueryRunnerColumn pgType haskellType

Instances

QueryRunnerColumnDefault PGJsonb String

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGJsonb String

QueryRunnerColumnDefault PGJsonb Value

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGJsonb Value

QueryRunnerColumnDefault PGJson String

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGJson String

QueryRunnerColumnDefault PGJson Value

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGJson Value

QueryRunnerColumnDefault PGBytea ByteString

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGBytea ByteString

QueryRunnerColumnDefault PGBytea ByteString

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGBytea ByteString

QueryRunnerColumnDefault PGUuid UUID

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGUuid UUID

QueryRunnerColumnDefault PGTimestamptz UTCTime

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGTimestamptz UTCTime

QueryRunnerColumnDefault PGTimestamptz ZonedTime

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGTimestamptz ZonedTime

QueryRunnerColumnDefault PGTimestamp LocalTime

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGTimestamp LocalTime

QueryRunnerColumnDefault PGTime TimeOfDay

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGTime TimeOfDay

QueryRunnerColumnDefault PGText String

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGText String

QueryRunnerColumnDefault PGText Text

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGText Text

QueryRunnerColumnDefault PGText Text

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGText Text

QueryRunnerColumnDefault PGNumeric Scientific

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGNumeric Scientific

QueryRunnerColumnDefault PGInt4 Int

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGInt4 Int

QueryRunnerColumnDefault PGInt4 Int32

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGInt4 Int32

QueryRunnerColumnDefault PGInt8 Int64

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGInt8 Int64

QueryRunnerColumnDefault PGFloat8 Double

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGFloat8 Double

QueryRunnerColumnDefault PGDate Day

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGDate Day

QueryRunnerColumnDefault PGBool Bool

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGBool Bool

QueryRunnerColumnDefault PGCitext (CI Text)

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGCitext (CI Text)

QueryRunnerColumnDefault PGCitext (CI Text)

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn PGCitext (CI Text)

QueryRunnerColumnDefault a b => QueryRunnerColumnDefault (Nullable a) (Maybe b)

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn (Nullable a) (Maybe b)

(Typeable b, FromField b, QueryRunnerColumnDefault a b) => QueryRunnerColumnDefault (PGRange a) (PGRange b)

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn (PGRange a) (PGRange0 b)

(Typeable b, QueryRunnerColumnDefault a b) => QueryRunnerColumnDefault (PGArray a) [b]

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: QueryRunnerColumn (PGArray a) [b]

arrayColumn :: Column (PGArray a) -> Column a

jsonFieldParser :: FieldParser String

jsonbFieldParser :: FieldParser String

jsonFieldTypeParser :: ByteString -> FieldParser String

prepareRowParser :: FromFields columns haskells -> columns -> RowParser haskells

data Cursor haskells

Cursor within a transaction.

Constructors

EmptyCursor

Cursor (RowParser haskells) Cursor