Database.PostgreSQL.Enumerator

PostgreSQL implementation of Database.Enumerator.

Documentation

data Session

Instances

Typeable Session

ISession Session

Command String Session

Command BoundStmt Session

Command CommandBind Session

Command QueryString Session

IQuery Query Session ColumnBuffer

Statement String Session Query

Statement QueryStringTuned Session Query

Statement BoundStmt Session Query

Statement QueryString Session Query

DBBind (Maybe a) Session PreparedStmtObj BindObj => DBBind a Session PreparedStmtObj BindObj

IPrepared PreparedStmtObj Session BoundStmt BindObj

Statement (RefCursor String) Session Query

DBBind (Maybe Double) Session PreparedStmtObj BindObj

DBBind (Maybe Float) Session PreparedStmtObj BindObj

DBBind (Maybe Int) Session PreparedStmtObj BindObj

DBBind (Maybe Int64) Session PreparedStmtObj BindObj

DBBind (Maybe String) Session PreparedStmtObj BindObj

Show a => DBBind (Maybe a) Session PreparedStmtObj BindObj

DBBind (Maybe UTCTime) Session PreparedStmtObj BindObj

Statement (NextResultSet mark PreparedStmtObj) Session Query

connect :: [ConnectAttr] -> ConnectA Session

data ConnectAttr

Specify connection options to connect. You only need to use whatever subset is relevant for your connection.

Constructors

CAhost String

CAhostaddr String

CAport String

CAdbname String

CAuser String

CApassword String

CAconnect_timeout Int

CAoptions String

CAsslmode String

CAservice String

prepareStmt :: String -> QueryString -> [Oid] -> PreparationA Session PreparedStmtObj

preparePrefetch :: Int -> String -> QueryString -> [Oid] -> PreparationA Session PreparedStmtObj

prepareQuery :: String -> QueryString -> [Oid] -> PreparationA Session PreparedStmtObj

prepareLargeQuery :: Int -> String -> QueryString -> [Oid] -> PreparationA Session PreparedStmtObj

prepareCommand :: String -> QueryString -> [Oid] -> PreparationA Session PreparedStmtObj

sql :: String -> QueryString

The simplest kind of a statement: no tuning parameters, all default, little overhead.

sqlbind :: String -> [BindA Session PreparedStmtObj BindObj] -> QueryStringTuned

prefetch :: Int -> String -> [BindA Session PreparedStmtObj BindObj] -> QueryStringTuned

cmdbind :: String -> [BindA Session PreparedStmtObj BindObj] -> CommandBind

bindType :: PGType a => a -> Oid

bindType is useful when constructing the list of Oids for stmtPrepare. You don't need to pass the actual bind values, just dummy values of the same type (the value isn't used, so undefined is OK here).

module Database.Enumerator