Opaleye.Constant

Documentation

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

constant provides a convenient typeclass wrapper around the Column creation functions in Opaleye.PGTypes. 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 columns )
     => Connection
     -> Table columns columns'
     -> haskells
     -> IO Int64
  customInsert conn table haskells = runInsert conn table $ constant haskells

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

newtype Constant haskells columns

Constructors

Constant

Fields

• constantExplicit :: haskells -> columns

Instances

SumProfunctor Constant

Methods

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

ProductProfunctor Constant

Methods

empty :: Constant () ()

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

Profunctor 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 => (b -> c) -> Constant a b -> Constant a c

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

Default Constant Bool (Column PGBool)

Methods

def :: Constant Bool (Column PGBool)

Default Constant Double (Column PGFloat8)

Methods

def :: Constant Double (Column PGFloat8)

Default Constant Int (Column PGInt4)

Methods

def :: Constant Int (Column PGInt4)

Default Constant Int32 (Column PGInt4)

Methods

def :: Constant Int32 (Column PGInt4)

Default Constant Int64 (Column PGInt8)

Methods

def :: Constant Int64 (Column PGInt8)

Default Constant ByteString (Column PGJsonb)

Methods

def :: Constant ByteString (Column PGJsonb)

Default Constant ByteString (Column PGJson)

Methods

def :: Constant ByteString (Column PGJson)

Default Constant ByteString (Column PGBytea)

Methods

def :: Constant ByteString (Column PGBytea)

Default Constant ByteString (Column PGJsonb)

Methods

def :: Constant ByteString (Column PGJsonb)

Default Constant ByteString (Column PGJson)

Methods

def :: Constant ByteString (Column PGJson)

Default Constant ByteString (Column PGBytea)

Methods

def :: Constant ByteString (Column PGBytea)

Default Constant String (Column PGText)

Methods

def :: Constant String (Column PGText)

Default Constant Text (Column PGText)

Methods

def :: Constant Text (Column PGText)

Default Constant UTCTime (Column PGTimestamptz)

Methods

def :: Constant UTCTime (Column PGTimestamptz)

Default Constant Value (Column PGJsonb)

Methods

def :: Constant Value (Column PGJsonb)

Default Constant Value (Column PGJson)

Methods

def :: Constant Value (Column PGJson)

Default Constant Text (Column PGText)

Methods

def :: Constant Text (Column PGText)

Default Constant LocalTime (Column PGTimestamp)

Methods

def :: Constant LocalTime (Column PGTimestamp)

Default Constant TimeOfDay (Column PGTime)

Methods

def :: Constant TimeOfDay (Column PGTime)

Default Constant Day (Column PGDate)

Methods

def :: Constant Day (Column PGDate)

Default Constant UUID (Column PGUuid)

Methods

def :: Constant UUID (Column PGUuid)

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

Methods

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

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

Methods

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

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

Methods

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

Default Constant (CI Text) (Column PGCitext)

Methods

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

Default Constant (CI Text) (Column PGCitext)

Methods

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

Default Constant (PGRange Int) (Column (PGRange PGInt4))

Methods

def :: Constant (PGRange Int) (Column (PGRange PGInt4))

Default Constant (PGRange Int64) (Column (PGRange PGInt8))

Methods

def :: Constant (PGRange Int64) (Column (PGRange PGInt8))

Default Constant (PGRange UTCTime) (Column (PGRange PGTimestamptz))

Methods

def :: Constant (PGRange UTCTime) (Column (PGRange PGTimestamptz))

Default Constant (PGRange LocalTime) (Column (PGRange PGTimestamp))

Methods

def :: Constant (PGRange LocalTime) (Column (PGRange PGTimestamp))

Default Constant (PGRange Day) (Column (PGRange PGDate))

Methods

def :: Constant (PGRange Day) (Column (PGRange PGDate))

Functor (Constant a)

Methods

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

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

Applicative (Constant a)

Methods

pure :: a -> Constant a a

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

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

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