Database.PostgreSQL.Store.Result

data ResultError

Error that occured during result processing

Constructors

ColumnMissing ByteString

ValueError Row Column Oid Format ColumnDescription

Instances

Eq ResultError

Show ResultError

type ResultProcessor = ReaderT Result (ExceptT ResultError IO)

Result processor

type ColumnInfo = (Column, Oid, Format)

Column information

runResultProcessor :: Result -> ResultProcessor a -> ExceptT ResultError IO a

Process the result.

columnNumber :: ByteString -> ResultProcessor Column

Get the column number for a column name.

columnType :: Column -> ResultProcessor Oid

Get the type of a column.

columnFormat :: Column -> ResultProcessor Format

Get the format of a column.

columnInfo :: ByteString -> ResultProcessor ColumnInfo

Get information about a column.

foreachRow :: (Row -> ResultProcessor a) -> ResultProcessor [a]

Do something for each row.

cellValue :: Row -> ColumnInfo -> ResultProcessor Value

Get cell value.

unpackCellValue :: Column a => Row -> ColumnInfo -> ResultProcessor a

Unpack cell value.

Result

class Result a where

Result row

Methods

resultProcessor :: ResultProcessor [a]

Extract rows from the given result.

Instances

Result ()

Result RawRow

Table a => Result (Reference a)

Table a => Result (Row a)

(Result a, Result b) => Result (a, b)

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

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

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

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

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

newtype RawRow

A row containing all a list of all column values.

Constructors

RawRow [Value]

Instances

Eq RawRow

Ord RawRow

Show RawRow

Result RawRow