Copyright	(c) Ole Krüger 2015-2016
License	BSD3
Maintainer	Ole Krüger <ole@vprsm.de>
Safe Haskell	None
Language	Haskell2010

Database.PostgreSQL.Store.Columns

Contents

Description

Synopsis

data Value Source #

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 Source #
Methods (==) :: Value -> Value -> Bool # (/=) :: Value -> Value -> Bool #
Ord Value Source #
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 Source #
Methods showsPrec :: Int -> Value -> ShowS # show :: Value -> String # showList :: [Value] -> ShowS #
Column Value Source #
Methods pack :: Value -> Value Source # unpack :: Value -> Maybe Value Source # columnTypeName :: Proxy * Value -> String Source # columnAllowNull :: Proxy * Value -> Bool Source # columnCheck :: Proxy * Value -> String -> Maybe String Source # columnDescription :: Proxy * Value -> String -> String Source #
QueryBuildable ByteString Value Query Source #
Methods buildQuery :: ByteString -> [Value] -> Query

class Column a where Source #

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

Minimal complete definition

pack, unpack, columnTypeName

Methods

pack :: a -> Value Source #

Pack column value.

unpack :: Value -> Maybe a Source #

Unpack column value.

columnTypeName :: Proxy a -> String Source #

Name of the underlying SQL type.

columnAllowNull :: Proxy a -> Bool Source #

May the column be NULL?

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

A condition that must hold true for the column.

columnDescription :: Proxy a -> String -> String Source #

Generate column description in SQL. Think CREATE TABLE.

Instances

Column Bool Source #
Methods pack :: Bool -> Value Source # unpack :: Value -> Maybe Bool Source # columnTypeName :: Proxy * Bool -> String Source # columnAllowNull :: Proxy * Bool -> Bool Source # columnCheck :: Proxy * Bool -> String -> Maybe String Source # columnDescription :: Proxy * Bool -> String -> String Source #
Column Int Source #
Methods pack :: Int -> Value Source # unpack :: Value -> Maybe Int Source # columnTypeName :: Proxy * Int -> String Source # columnAllowNull :: Proxy * Int -> Bool Source # columnCheck :: Proxy * Int -> String -> Maybe String Source # columnDescription :: Proxy * Int -> String -> String Source #
Column Int8 Source #
Methods pack :: Int8 -> Value Source # unpack :: Value -> Maybe Int8 Source # columnTypeName :: Proxy * Int8 -> String Source # columnAllowNull :: Proxy * Int8 -> Bool Source # columnCheck :: Proxy * Int8 -> String -> Maybe String Source # columnDescription :: Proxy * Int8 -> String -> String Source #
Column Int16 Source #
Methods pack :: Int16 -> Value Source # unpack :: Value -> Maybe Int16 Source # columnTypeName :: Proxy * Int16 -> String Source # columnAllowNull :: Proxy * Int16 -> Bool Source # columnCheck :: Proxy * Int16 -> String -> Maybe String Source # columnDescription :: Proxy * Int16 -> String -> String Source #
Column Int32 Source #
Methods pack :: Int32 -> Value Source # unpack :: Value -> Maybe Int32 Source # columnTypeName :: Proxy * Int32 -> String Source # columnAllowNull :: Proxy * Int32 -> Bool Source # columnCheck :: Proxy * Int32 -> String -> Maybe String Source # columnDescription :: Proxy * Int32 -> String -> String Source #
Column Int64 Source #
Methods pack :: Int64 -> Value Source # unpack :: Value -> Maybe Int64 Source # columnTypeName :: Proxy * Int64 -> String Source # columnAllowNull :: Proxy * Int64 -> Bool Source # columnCheck :: Proxy * Int64 -> String -> Maybe String Source # columnDescription :: Proxy * Int64 -> String -> String Source #
Column Integer Source #
Methods pack :: Integer -> Value Source # unpack :: Value -> Maybe Integer Source # columnTypeName :: Proxy * Integer -> String Source # columnAllowNull :: Proxy * Integer -> Bool Source # columnCheck :: Proxy * Integer -> String -> Maybe String Source # columnDescription :: Proxy * Integer -> String -> String Source #
Column Word Source #
Methods pack :: Word -> Value Source # unpack :: Value -> Maybe Word Source # columnTypeName :: Proxy * Word -> String Source # columnAllowNull :: Proxy * Word -> Bool Source # columnCheck :: Proxy * Word -> String -> Maybe String Source # columnDescription :: Proxy * Word -> String -> String Source #
Column Word8 Source #
Methods pack :: Word8 -> Value Source # unpack :: Value -> Maybe Word8 Source # columnTypeName :: Proxy * Word8 -> String Source # columnAllowNull :: Proxy * Word8 -> Bool Source # columnCheck :: Proxy * Word8 -> String -> Maybe String Source # columnDescription :: Proxy * Word8 -> String -> String Source #
Column Word16 Source #
Methods pack :: Word16 -> Value Source # unpack :: Value -> Maybe Word16 Source # columnTypeName :: Proxy * Word16 -> String Source # columnAllowNull :: Proxy * Word16 -> Bool Source # columnCheck :: Proxy * Word16 -> String -> Maybe String Source # columnDescription :: Proxy * Word16 -> String -> String Source #
Column Word32 Source #
Methods pack :: Word32 -> Value Source # unpack :: Value -> Maybe Word32 Source # columnTypeName :: Proxy * Word32 -> String Source # columnAllowNull :: Proxy * Word32 -> Bool Source # columnCheck :: Proxy * Word32 -> String -> Maybe String Source # columnDescription :: Proxy * Word32 -> String -> String Source #
Column Word64 Source #
Methods pack :: Word64 -> Value Source # unpack :: Value -> Maybe Word64 Source # columnTypeName :: Proxy * Word64 -> String Source # columnAllowNull :: Proxy * Word64 -> Bool Source # columnCheck :: Proxy * Word64 -> String -> Maybe String Source # columnDescription :: Proxy * Word64 -> String -> String Source #
Column ByteString Source #
Methods pack :: ByteString -> Value Source # unpack :: Value -> Maybe ByteString Source # columnTypeName :: Proxy * ByteString -> String Source # columnAllowNull :: Proxy * ByteString -> Bool Source # columnCheck :: Proxy * ByteString -> String -> Maybe String Source # columnDescription :: Proxy * ByteString -> String -> String Source #
Column ByteString Source #
Methods pack :: ByteString -> Value Source # unpack :: Value -> Maybe ByteString Source # columnTypeName :: Proxy * ByteString -> String Source # columnAllowNull :: Proxy * ByteString -> Bool Source # columnCheck :: Proxy * ByteString -> String -> Maybe String Source # columnDescription :: Proxy * ByteString -> String -> String Source #
Column Text Source #
Methods pack :: Text -> Value Source # unpack :: Value -> Maybe Text Source # columnTypeName :: Proxy * Text -> String Source # columnAllowNull :: Proxy * Text -> Bool Source # columnCheck :: Proxy * Text -> String -> Maybe String Source # columnDescription :: Proxy * Text -> String -> String Source #
Column Text Source #
Methods pack :: Text -> Value Source # unpack :: Value -> Maybe Text Source # columnTypeName :: Proxy * Text -> String Source # columnAllowNull :: Proxy * Text -> Bool Source # columnCheck :: Proxy * Text -> String -> Maybe String Source # columnDescription :: Proxy * Text -> String -> String Source #
Column UTCTime Source #
Methods pack :: UTCTime -> Value Source # unpack :: Value -> Maybe UTCTime Source # columnTypeName :: Proxy * UTCTime -> String Source # columnAllowNull :: Proxy * UTCTime -> Bool Source # columnCheck :: Proxy * UTCTime -> String -> Maybe String Source # columnDescription :: Proxy * UTCTime -> String -> String Source #
Column Value Source #
Methods pack :: Value -> Value Source # unpack :: Value -> Maybe Value Source # columnTypeName :: Proxy * Value -> String Source # columnAllowNull :: Proxy * Value -> Bool Source # columnCheck :: Proxy * Value -> String -> Maybe String Source # columnDescription :: Proxy * Value -> String -> String Source #
Column [Char] Source #
Methods pack :: [Char] -> Value Source # unpack :: Value -> Maybe [Char] Source # columnTypeName :: Proxy * [Char] -> String Source # columnAllowNull :: Proxy * [Char] -> Bool Source # columnCheck :: Proxy * [Char] -> String -> Maybe String Source # columnDescription :: Proxy * [Char] -> String -> String Source #
Column a => Column (Maybe a) Source #
Methods pack :: Maybe a -> Value Source # unpack :: Value -> Maybe (Maybe a) Source # columnTypeName :: Proxy * (Maybe a) -> String Source # columnAllowNull :: Proxy * (Maybe a) -> Bool Source # columnCheck :: Proxy * (Maybe a) -> String -> Maybe String Source # columnDescription :: Proxy * (Maybe a) -> String -> String Source #
QueryTable a => Column (Reference a) Source #
Methods pack :: Reference a -> Value Source # unpack :: Value -> Maybe (Reference a) Source # columnTypeName :: Proxy * (Reference a) -> String Source # columnAllowNull :: Proxy * (Reference a) -> Bool Source # columnCheck :: Proxy * (Reference a) -> String -> Maybe String Source # columnDescription :: Proxy * (Reference a) -> String -> String Source #