Takusen-0.8.2: Database library with left-fold interface, for PostgreSQL, Oracle, SQLite, ODBC. Contents Index

Database.PostgreSQL.Enumerator Portability non-portable Stability experimental Maintainer oleg@pobox.com, alistair@abayley.org

Description

PostgreSQL implementation of Database.Enumerator.

Synopsis

data Session connect :: [ConnectAttr] -> ConnectA Session data ConnectAttr = 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 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 module Database.Enumerator

Documentation

data Session

Instances ISession Session Typeable Session Command BoundStmt Session Command CommandBind Session Command QueryString Session Command String Session IQuery Query Session ColumnBuffer Statement BoundStmt Session Query Statement QueryString Session Query Statement QueryStringTuned Session Query Statement String 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 DBBind (Maybe UTCTime) Session PreparedStmtObj BindObj Show a => DBBind (Maybe a) 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

Produced by Haddock version 0.7