Opaleye.Constant

Documentation

toFields :: Default Constant haskells fields => haskells -> fields

toFields provides a convenient typeclass wrapper around the Column creation functions in Opaleye.SqlTypes. Besides convenience it doesn't provide any additional functionality.

It can be used with functions like runInsert to insert custom Haskell types into the database. The following is an example of a function for inserting custom types.

  customInsert
     :: ( Default Constant haskells fields )
     => Connection
     -> Table fields fields'
     -> haskells
     -> IO Int64
  customInsert conn table haskells = runInsert conn table $ toFields haskells

In order to use this function with your custom types, you need to define an instance of Default Constant for your custom types.

constant :: Default Constant haskells fields => haskells -> fields

newtype Constant haskells fields

Constructors

Constant

Fields

• constantExplicit :: haskells -> fields

Instances

Profunctor Constant

Defined in Opaleye.Constant

Methods

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

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

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

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

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

ProductProfunctor Constant

Defined in Opaleye.Constant

Methods

purePP :: b -> Constant a b

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

empty :: Constant () ()

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

SumProfunctor Constant

Defined in Opaleye.Constant

Methods

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

Default Constant Bool (Column SqlBool)

Defined in Opaleye.Constant

Methods

def :: Constant Bool (Column SqlBool)

Default Constant Double (Column SqlFloat8)

Defined in Opaleye.Constant

Methods

def :: Constant Double (Column SqlFloat8)

Default Constant Int (Column SqlInt4)

Defined in Opaleye.Constant

Methods

def :: Constant Int (Column SqlInt4)

Default Constant Int32 (Column SqlInt4)

Defined in Opaleye.Constant

Methods

def :: Constant Int32 (Column SqlInt4)

Default Constant Int64 (Column SqlInt8)

Defined in Opaleye.Constant

Methods

def :: Constant Int64 (Column SqlInt8)

Default Constant ByteString (Column SqlJsonb)

Defined in Opaleye.Constant

Methods

def :: Constant ByteString (Column SqlJsonb)

Default Constant ByteString (Column SqlJson)

Defined in Opaleye.Constant

Methods

def :: Constant ByteString (Column SqlJson)

Default Constant ByteString (Column SqlBytea)

Defined in Opaleye.Constant

Methods

def :: Constant ByteString (Column SqlBytea)

Default Constant ByteString (Column SqlJsonb)

Defined in Opaleye.Constant

Methods

def :: Constant ByteString (Column SqlJsonb)

Default Constant ByteString (Column SqlJson)

Defined in Opaleye.Constant

Methods

def :: Constant ByteString (Column SqlJson)

Default Constant ByteString (Column SqlBytea)

Defined in Opaleye.Constant

Methods

def :: Constant ByteString (Column SqlBytea)

Default Constant Scientific (Column SqlNumeric)

Defined in Opaleye.Constant

Methods

def :: Constant Scientific (Column SqlNumeric)

Default Constant String (Column SqlText)

Defined in Opaleye.Constant

Methods

def :: Constant String (Column SqlText)

Default Constant Text (Column SqlText)

Defined in Opaleye.Constant

Methods

def :: Constant Text (Column SqlText)

Default Constant UTCTime (Column SqlTimestamptz)

Defined in Opaleye.Constant

Methods

def :: Constant UTCTime (Column SqlTimestamptz)

Default Constant Value (Column SqlJsonb)

Defined in Opaleye.Constant

Methods

def :: Constant Value (Column SqlJsonb)

Default Constant Value (Column SqlJson)

Defined in Opaleye.Constant

Methods

def :: Constant Value (Column SqlJson)

Default Constant Text (Column SqlText)

Defined in Opaleye.Constant

Methods

def :: Constant Text (Column SqlText)

Default Constant ZonedTime (Column SqlTimestamptz)

Defined in Opaleye.Constant

Methods

def :: Constant ZonedTime (Column SqlTimestamptz)

Default Constant LocalTime (Column SqlTimestamp)

Defined in Opaleye.Constant

Methods

def :: Constant LocalTime (Column SqlTimestamp)

Default Constant TimeOfDay (Column SqlTime)

Defined in Opaleye.Constant

Methods

def :: Constant TimeOfDay (Column SqlTime)

Default Constant Day (Column SqlDate)

Defined in Opaleye.Constant

Methods

def :: Constant Day (Column SqlDate)

Default Constant UUID (Column SqlUuid)

Defined in Opaleye.Constant

Methods

def :: Constant UUID (Column SqlUuid)

(Default Constant a (Column b), IsSqlType b) => Default Constant [a] (Column (SqlArray b))

Defined in Opaleye.Constant

Methods

def :: Constant [a] (Column (SqlArray b))

Default Constant haskell (Column sql) => Default Constant (Maybe haskell) (Maybe (Column sql))

Defined in Opaleye.Constant

Methods

def :: Constant (Maybe haskell) (Maybe (Column sql))

Default Constant haskell (Column sql) => Default Constant (Maybe haskell) (Column (Nullable sql))

Defined in Opaleye.Constant

Methods

def :: Constant (Maybe haskell) (Column (Nullable sql))

Default Constant (CI Text) (Column SqlCitext)

Defined in Opaleye.Constant

Methods

def :: Constant (CI Text) (Column SqlCitext)

Default Constant (CI Text) (Column SqlCitext)

Defined in Opaleye.Constant

Methods

def :: Constant (CI Text) (Column SqlCitext)

Default Constant (PGRange Int) (Column (SqlRange SqlInt4))

Defined in Opaleye.Constant

Methods

def :: Constant (PGRange Int) (Column (SqlRange SqlInt4))

Default Constant (PGRange Int64) (Column (SqlRange SqlInt8))

Defined in Opaleye.Constant

Methods

def :: Constant (PGRange Int64) (Column (SqlRange SqlInt8))

Default Constant (PGRange Scientific) (Column (SqlRange SqlNumeric))

Defined in Opaleye.Constant

Methods

def :: Constant (PGRange Scientific) (Column (SqlRange SqlNumeric))

Default Constant (PGRange UTCTime) (Column (SqlRange SqlTimestamptz))

Defined in Opaleye.Constant

Methods

def :: Constant (PGRange UTCTime) (Column (SqlRange SqlTimestamptz))

Default Constant (PGRange LocalTime) (Column (SqlRange SqlTimestamp))

Defined in Opaleye.Constant

Methods

def :: Constant (PGRange LocalTime) (Column (SqlRange SqlTimestamp))

Default Constant (PGRange Day) (Column (SqlRange SqlDate))

Defined in Opaleye.Constant

Methods

def :: Constant (PGRange Day) (Column (SqlRange SqlDate))

Functor (Constant a)

Defined in Opaleye.Constant

Methods

fmap :: (a0 -> b) -> Constant a a0 -> Constant a b

(<$) :: a0 -> Constant a b -> Constant a a0

Applicative (Constant a)

Defined in Opaleye.Constant

Methods

pure :: a0 -> Constant a a0

(<*>) :: Constant a (a0 -> b) -> Constant a a0 -> Constant a b

liftA2 :: (a0 -> b -> c) -> Constant a a0 -> Constant a b -> Constant a c

(*>) :: Constant a a0 -> Constant a b -> Constant a b

(<*) :: Constant a a0 -> Constant a b -> Constant a a0

type ToFields = Constant