Database.PostgreSQL.Store.Columns

data Value

Query parameter or value of a column - see pack on how to generate Values manually but conveniently.

Constructors

Value

Fields

• valueType :: Oid

  Type object identifier

• valueData :: ByteString

  Data value

NullValue

Instances

Eq Value

Methods

(==) :: Value -> Value -> Bool

(/=) :: Value -> Value -> Bool

Ord Value

Methods

compare :: Value -> Value -> Ordering

(<) :: Value -> Value -> Bool

(<=) :: Value -> Value -> Bool

(>) :: Value -> Value -> Bool

(>=) :: Value -> Value -> Bool

max :: Value -> Value -> Value

min :: Value -> Value -> Value

Show Value

Methods

showsPrec :: Int -> Value -> ShowS

show :: Value -> String

showList :: [Value] -> ShowS

Column Value

Methods

pack :: Value -> Value

unpack :: Value -> Maybe Value

columnTypeName :: Proxy * Value -> String

columnAllowNull :: Proxy * Value -> Bool

columnCheck :: Proxy * Value -> String -> Maybe String

columnDescription :: Proxy * Value -> String -> String

QueryBuildable ByteString Value Query

Methods

buildQuery :: ByteString -> [Value] -> Query

class Column a where

Types which implement this type class may be used as column types.

Minimal complete definition

pack, unpack, columnTypeName

Methods

pack :: a -> Value

Pack column value.

unpack :: Value -> Maybe a

Unpack column value.

columnTypeName :: Proxy a -> String

Name of the underlying SQL type.

columnAllowNull :: Proxy a -> Bool

May the column be NULL?

columnCheck :: Proxy a -> String -> Maybe String

A condition that must hold true for the column.

columnDescription :: Proxy a -> String -> String

Generate column description in SQL. Think CREATE TABLE.

Instances

Column Bool

Methods

pack :: Bool -> Value

unpack :: Value -> Maybe Bool

columnTypeName :: Proxy * Bool -> String

columnAllowNull :: Proxy * Bool -> Bool

columnCheck :: Proxy * Bool -> String -> Maybe String

columnDescription :: Proxy * Bool -> String -> String

Column Int

Methods

pack :: Int -> Value

unpack :: Value -> Maybe Int

columnTypeName :: Proxy * Int -> String

columnAllowNull :: Proxy * Int -> Bool

columnCheck :: Proxy * Int -> String -> Maybe String

columnDescription :: Proxy * Int -> String -> String

Column Int8

Methods

pack :: Int8 -> Value

unpack :: Value -> Maybe Int8

columnTypeName :: Proxy * Int8 -> String

columnAllowNull :: Proxy * Int8 -> Bool

columnCheck :: Proxy * Int8 -> String -> Maybe String

columnDescription :: Proxy * Int8 -> String -> String

Column Int16

Methods

pack :: Int16 -> Value

unpack :: Value -> Maybe Int16

columnTypeName :: Proxy * Int16 -> String

columnAllowNull :: Proxy * Int16 -> Bool

columnCheck :: Proxy * Int16 -> String -> Maybe String

columnDescription :: Proxy * Int16 -> String -> String

Column Int32

Methods

pack :: Int32 -> Value

unpack :: Value -> Maybe Int32

columnTypeName :: Proxy * Int32 -> String

columnAllowNull :: Proxy * Int32 -> Bool

columnCheck :: Proxy * Int32 -> String -> Maybe String

columnDescription :: Proxy * Int32 -> String -> String

Column Int64

Methods

pack :: Int64 -> Value

unpack :: Value -> Maybe Int64

columnTypeName :: Proxy * Int64 -> String

columnAllowNull :: Proxy * Int64 -> Bool

columnCheck :: Proxy * Int64 -> String -> Maybe String

columnDescription :: Proxy * Int64 -> String -> String

Column Integer

Methods

pack :: Integer -> Value

unpack :: Value -> Maybe Integer

columnTypeName :: Proxy * Integer -> String

columnAllowNull :: Proxy * Integer -> Bool

columnCheck :: Proxy * Integer -> String -> Maybe String

columnDescription :: Proxy * Integer -> String -> String

Column Word

Methods

pack :: Word -> Value

unpack :: Value -> Maybe Word

columnTypeName :: Proxy * Word -> String

columnAllowNull :: Proxy * Word -> Bool

columnCheck :: Proxy * Word -> String -> Maybe String

columnDescription :: Proxy * Word -> String -> String

Column Word8

Methods

pack :: Word8 -> Value

unpack :: Value -> Maybe Word8

columnTypeName :: Proxy * Word8 -> String

columnAllowNull :: Proxy * Word8 -> Bool

columnCheck :: Proxy * Word8 -> String -> Maybe String

columnDescription :: Proxy * Word8 -> String -> String

Column Word16

Methods

pack :: Word16 -> Value

unpack :: Value -> Maybe Word16

columnTypeName :: Proxy * Word16 -> String

columnAllowNull :: Proxy * Word16 -> Bool

columnCheck :: Proxy * Word16 -> String -> Maybe String

columnDescription :: Proxy * Word16 -> String -> String

Column Word32

Methods

pack :: Word32 -> Value

unpack :: Value -> Maybe Word32

columnTypeName :: Proxy * Word32 -> String

columnAllowNull :: Proxy * Word32 -> Bool

columnCheck :: Proxy * Word32 -> String -> Maybe String

columnDescription :: Proxy * Word32 -> String -> String

Column Word64

Methods

pack :: Word64 -> Value

unpack :: Value -> Maybe Word64

columnTypeName :: Proxy * Word64 -> String

columnAllowNull :: Proxy * Word64 -> Bool

columnCheck :: Proxy * Word64 -> String -> Maybe String

columnDescription :: Proxy * Word64 -> String -> String

Column ByteString

Methods

pack :: ByteString -> Value

unpack :: Value -> Maybe ByteString

columnTypeName :: Proxy * ByteString -> String

columnAllowNull :: Proxy * ByteString -> Bool

columnCheck :: Proxy * ByteString -> String -> Maybe String

columnDescription :: Proxy * ByteString -> String -> String

Column ByteString

Methods

pack :: ByteString -> Value

unpack :: Value -> Maybe ByteString

columnTypeName :: Proxy * ByteString -> String

columnAllowNull :: Proxy * ByteString -> Bool

columnCheck :: Proxy * ByteString -> String -> Maybe String

columnDescription :: Proxy * ByteString -> String -> String

Column Text

Methods

pack :: Text -> Value

unpack :: Value -> Maybe Text

columnTypeName :: Proxy * Text -> String

columnAllowNull :: Proxy * Text -> Bool

columnCheck :: Proxy * Text -> String -> Maybe String

columnDescription :: Proxy * Text -> String -> String

Column Text

Methods

pack :: Text -> Value

unpack :: Value -> Maybe Text

columnTypeName :: Proxy * Text -> String

columnAllowNull :: Proxy * Text -> Bool

columnCheck :: Proxy * Text -> String -> Maybe String

columnDescription :: Proxy * Text -> String -> String

Column UTCTime

Methods

pack :: UTCTime -> Value

unpack :: Value -> Maybe UTCTime

columnTypeName :: Proxy * UTCTime -> String

columnAllowNull :: Proxy * UTCTime -> Bool

columnCheck :: Proxy * UTCTime -> String -> Maybe String

columnDescription :: Proxy * UTCTime -> String -> String

Column Value

Methods

pack :: Value -> Value

unpack :: Value -> Maybe Value

columnTypeName :: Proxy * Value -> String

columnAllowNull :: Proxy * Value -> Bool

columnCheck :: Proxy * Value -> String -> Maybe String

columnDescription :: Proxy * Value -> String -> String

Column [Char]

Methods

pack :: [Char] -> Value

unpack :: Value -> Maybe [Char]

columnTypeName :: Proxy * [Char] -> String

columnAllowNull :: Proxy * [Char] -> Bool

columnCheck :: Proxy * [Char] -> String -> Maybe String

columnDescription :: Proxy * [Char] -> String -> String

Column a => Column (Maybe a)

Methods

pack :: Maybe a -> Value

unpack :: Value -> Maybe (Maybe a)

columnTypeName :: Proxy * (Maybe a) -> String

columnAllowNull :: Proxy * (Maybe a) -> Bool

columnCheck :: Proxy * (Maybe a) -> String -> Maybe String

columnDescription :: Proxy * (Maybe a) -> String -> String

QueryTable a => Column (Reference a)

Methods

pack :: Reference a -> Value

unpack :: Value -> Maybe (Reference a)

columnTypeName :: Proxy * (Reference a) -> String

columnAllowNull :: Proxy * (Reference a) -> Bool

columnCheck :: Proxy * (Reference a) -> String -> Maybe String

columnDescription :: Proxy * (Reference a) -> String -> String