Database.PostgreSQL.Store.Entity

Result and query entity

class Entity a where

An entity that is used as a parameter or result of a query.

Methods

insertEntity :: a -> QueryBuilder

Insert an instance of a into the query.

insertEntity :: (GenericEntity a, GEntity (AnalyzeEntity a)) => a -> QueryBuilder

Insert an instance of a into the query.

parseEntity :: RowParser a

Retrieve an instance of a from the result set.

parseEntity :: (GenericEntity a, GEntity (AnalyzeEntity a)) => RowParser a

Retrieve an instance of a from the result set.

Instances

Entity Bool

boolean

Methods

insertEntity :: Bool -> QueryBuilder

parseEntity :: RowParser Bool

Entity Double

Any floating-point number

Methods

insertEntity :: Double -> QueryBuilder

parseEntity :: RowParser Double

Entity Float

Any floating-point number

Methods

insertEntity :: Float -> QueryBuilder

parseEntity :: RowParser Float

Entity Int

Any integer

Methods

insertEntity :: Int -> QueryBuilder

parseEntity :: RowParser Int

Entity Int8

Any integer

Methods

insertEntity :: Int8 -> QueryBuilder

parseEntity :: RowParser Int8

Entity Int16

Any integer

Methods

insertEntity :: Int16 -> QueryBuilder

parseEntity :: RowParser Int16

Entity Int32

Any integer

Methods

insertEntity :: Int32 -> QueryBuilder

parseEntity :: RowParser Int32

Entity Int64

Any integer

Methods

insertEntity :: Int64 -> QueryBuilder

parseEntity :: RowParser Int64

Entity Integer

Any integer

Methods

insertEntity :: Integer -> QueryBuilder

parseEntity :: RowParser Integer

Entity Word

Any unsigned integer

Methods

insertEntity :: Word -> QueryBuilder

parseEntity :: RowParser Word

Entity Word8

Any unsigned integer

Methods

insertEntity :: Word8 -> QueryBuilder

parseEntity :: RowParser Word8

Entity Word16

Any unsigned integer

Methods

insertEntity :: Word16 -> QueryBuilder

parseEntity :: RowParser Word16

Entity Word32

Any unsigned integer

Methods

insertEntity :: Word32 -> QueryBuilder

parseEntity :: RowParser Word32

Entity Word64

Any unsigned integer

Methods

insertEntity :: Word64 -> QueryBuilder

parseEntity :: RowParser Word64

Entity ByteString

bytea - byte array encoded in hex format

Methods

insertEntity :: ByteString -> QueryBuilder

parseEntity :: RowParser ByteString

Entity ByteString

bytea - byte array encoded in hex format

Methods

insertEntity :: ByteString -> QueryBuilder

parseEntity :: RowParser ByteString

Entity Scientific

Any numeric type

Methods

insertEntity :: Scientific -> QueryBuilder

parseEntity :: RowParser Scientific

Entity String

char, varchar or text - UTF-8 encoded

Methods

insertEntity :: String -> QueryBuilder

parseEntity :: RowParser String

Entity Text

char, varchar or text - UTF-8 encoded

Methods

insertEntity :: Text -> QueryBuilder

parseEntity :: RowParser Text

Entity Value

json or jsonb

Methods

insertEntity :: Value -> QueryBuilder

parseEntity :: RowParser Value

Entity Text

char, varchar or text - UTF-8 encoded

Methods

insertEntity :: Text -> QueryBuilder

parseEntity :: RowParser Text

Entity Natural

Any unsigned integer

Methods

insertEntity :: Natural -> QueryBuilder

parseEntity :: RowParser Natural

Entity TypedValue

Typed column value

Methods

insertEntity :: TypedValue -> QueryBuilder

parseEntity :: RowParser TypedValue

Entity Value

Untyped column value

Methods

insertEntity :: Value -> QueryBuilder

parseEntity :: RowParser Value

Entity QueryBuilder

QueryBuilder

Methods

insertEntity :: QueryBuilder -> QueryBuilder

parseEntity :: RowParser QueryBuilder

Entity a => Entity (Maybe a)

A value which may normally not be NULL.

Methods

insertEntity :: Maybe a -> QueryBuilder

parseEntity :: RowParser (Maybe a)

(Entity a, Entity b) => Entity (a, b)

2 result entities in sequence

Methods

insertEntity :: (a, b) -> QueryBuilder

parseEntity :: RowParser (a, b)

(Entity a, Entity b, Entity c) => Entity (a, b, c)

3 result entities in sequence

Methods

insertEntity :: (a, b, c) -> QueryBuilder

parseEntity :: RowParser (a, b, c)

(Entity a, Entity b, Entity c, Entity d) => Entity (a, b, c, d)

4 result entities in sequence

Methods

insertEntity :: (a, b, c, d) -> QueryBuilder

parseEntity :: RowParser (a, b, c, d)

(Entity a, Entity b, Entity c, Entity d, Entity e) => Entity (a, b, c, d, e)

5 result entities in sequence

Methods

insertEntity :: (a, b, c, d, e) -> QueryBuilder

parseEntity :: RowParser (a, b, c, d, e)

(Entity a, Entity b, Entity c, Entity d, Entity e, Entity f) => Entity (a, b, c, d, e, f)

6 result entities in sequence

Methods

insertEntity :: (a, b, c, d, e, f) -> QueryBuilder

parseEntity :: RowParser (a, b, c, d, e, f)

(Entity a, Entity b, Entity c, Entity d, Entity e, Entity f, Entity g) => Entity (a, b, c, d, e, f, g)

7 result entities in sequence

Methods

insertEntity :: (a, b, c, d, e, f, g) -> QueryBuilder

parseEntity :: RowParser (a, b, c, d, e, f, g)

insertGeneric :: (GenericEntity a, GEntity (AnalyzeEntity a)) => a -> QueryBuilder

Insert generic entity into the query.

parseGeneric :: (GenericEntity a, GEntity (AnalyzeEntity a)) => RowParser a

Generic RowParser for an entity.

Helpers

class GEntityRecord rec where

Generic record entity

Minimal complete definition

gInsertRecord, gParseRecord

Methods

gInsertRecord :: Record rec -> QueryBuilder

gParseRecord :: RowParser (Record rec)

Instances

(GEntityRecord lhs, GEntityRecord rhs) => GEntityRecord (TCombine lhs rhs)

Methods

gInsertRecord :: Record (TCombine lhs rhs) -> QueryBuilder

gParseRecord :: RowParser (Record (TCombine lhs rhs))

Entity typ => GEntityRecord (TSingle meta typ)

Methods

gInsertRecord :: Record (TSingle meta typ) -> QueryBuilder

gParseRecord :: RowParser (Record (TSingle meta typ))

class GEntityEnum enum where

Generic enumeration entity

Minimal complete definition

gInsertEnum, gEnumValues

Methods

gInsertEnum :: FlatSum enum -> QueryBuilder

gEnumValues :: [(ByteString, FlatSum enum)]

Instances

KnownSymbol name => GEntityEnum (TValue (MetaCons name f r))

Methods

gInsertEnum :: FlatSum (TValue (MetaCons name f r)) -> QueryBuilder

gEnumValues :: [(ByteString, FlatSum (TValue (MetaCons name f r)))]

(GEntityEnum lhs, GEntityEnum rhs) => GEntityEnum (TChoose lhs rhs)

Methods

gInsertEnum :: FlatSum (TChoose lhs rhs) -> QueryBuilder

gEnumValues :: [(ByteString, FlatSum (TChoose lhs rhs))]

class GEntity dat where

Generic entity

Minimal complete definition

gInsertEntity, gParseEntity

Methods

gInsertEntity :: DataType dat -> QueryBuilder

gParseEntity :: RowParser (DataType dat)

Instances

GEntityEnum enum => GEntity (TFlatSum d enum)

Methods

gInsertEntity :: DataType (TFlatSum d enum) -> QueryBuilder

gParseEntity :: RowParser (DataType (TFlatSum d enum))

GEntityRecord rec => GEntity (TRecord d c rec)

Methods

gInsertEntity :: DataType (TRecord d c rec) -> QueryBuilder

gParseEntity :: RowParser (DataType (TRecord d c rec))