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

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

ProductProfunctor Constant

Methods

empty :: Constant () ()

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

SumProfunctor Constant

Methods

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

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 String (Column PGText)

Methods

def :: Constant String (Column PGText)

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 LocalTime (Column PGTimestamp)

Methods

def :: Constant LocalTime (Column PGTimestamp)

Default Constant TimeOfDay (Column PGTime)

Methods

def :: Constant TimeOfDay (Column PGTime)

Default Constant UTCTime (Column PGTimestamptz)

Methods

def :: Constant UTCTime (Column PGTimestamptz)

Default Constant Day (Column PGDate)

Methods

def :: Constant Day (Column PGDate)

Default Constant Text (Column PGText)

Methods

def :: Constant Text (Column PGText)

Default Constant Text (Column PGText)

Methods

def :: Constant Text (Column PGText)

Default Constant Value (Column PGJsonb)

Methods

def :: Constant Value (Column PGJsonb)

Default Constant Value (Column PGJson)

Methods

def :: Constant Value (Column PGJson)

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)

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