Takusen-0.8.2: Database library with left-fold interface, for PostgreSQL, Oracle, SQLite, ODBC.ContentsIndex
Database.Oracle.Enumerator
Portabilitynon-portable
Stabilityexperimental
Maintaineroleg@pobox.com, alistair@abayley.org
Description
Oracle OCI implementation of Database.Enumerator.
Synopsis
data Session
connect :: String -> String -> String -> ConnectA Session
prepareStmt :: QueryString -> PreparationA Session PreparedStmtObj
preparePrefetch :: Int -> QueryString -> PreparationA Session PreparedStmtObj
prepareQuery :: QueryString -> PreparationA Session PreparedStmtObj
prepareLargeQuery :: Int -> QueryString -> PreparationA Session PreparedStmtObj
prepareCommand :: QueryString -> PreparationA Session PreparedStmtObj
prepareLargeCommand :: Int -> QueryString -> 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
type StmtHandle = Ptr StmtStruct
newtype Out a = Out a
module Database.Enumerator
Documentation
data Session
show/hide 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 PreparedStmtObj 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 StmtHandle) Session Query
DBBind (Maybe CalendarTime) Session PreparedStmtObj BindObj
DBBind (Maybe Double) Session PreparedStmtObj BindObj
DBBind (Maybe Int) Session PreparedStmtObj BindObj
DBBind (Maybe String) Session PreparedStmtObj BindObj
DBBind (Maybe UTCTime) Session PreparedStmtObj BindObj
Show a => DBBind (Maybe a) Session PreparedStmtObj BindObj
DBBind (Out (Maybe Double)) Session PreparedStmtObj BindObj
DBBind (Out (Maybe Int)) Session PreparedStmtObj BindObj
DBBind (Out (Maybe StmtHandle)) Session PreparedStmtObj BindObj
DBBind (Out (Maybe String)) Session PreparedStmtObj BindObj
DBBind (Out (Maybe UTCTime)) Session PreparedStmtObj BindObj
Show a => DBBind (Out (Maybe a)) Session PreparedStmtObj BindObj
DBBind (Out (Maybe a)) Session PreparedStmtObj BindObj => DBBind (Out a) Session PreparedStmtObj BindObj
Statement (NextResultSet mark PreparedStmtObj) Session Query
connect :: String -> String -> String -> ConnectA Session
prepareStmt :: QueryString -> PreparationA Session PreparedStmtObj
preparePrefetch :: Int -> QueryString -> PreparationA Session PreparedStmtObj
prepareQuery :: QueryString -> PreparationA Session PreparedStmtObj
prepareLargeQuery :: Int -> QueryString -> PreparationA Session PreparedStmtObj
prepareCommand :: QueryString -> PreparationA Session PreparedStmtObj
prepareLargeCommand :: Int -> QueryString -> PreparationA Session PreparedStmtObj
Seems like an odd alternative to prepareCommand (what is a large command?) but is actually useful for when the outer query it a procedure call that returns one or more cursors. The prefetch count for the inner cursors is inherited from the outer statement, which in this case is a command, rather than a select. Normally prefetch would be irrelevant (and indeed it is for the outer command), but we also save it in the statement so that it can be reused for the child cursors.
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
type StmtHandle = Ptr StmtStruct
newtype Out a
Constructors
Out a
show/hide Instances
DBBind (Out (Maybe Double)) Session PreparedStmtObj BindObj
DBBind (Out (Maybe Int)) Session PreparedStmtObj BindObj
DBBind (Out (Maybe StmtHandle)) Session PreparedStmtObj BindObj
DBBind (Out (Maybe String)) Session PreparedStmtObj BindObj
DBBind (Out (Maybe UTCTime)) Session PreparedStmtObj BindObj
Show a => DBBind (Out (Maybe a)) Session PreparedStmtObj BindObj
DBBind (Out (Maybe a)) Session PreparedStmtObj BindObj => DBBind (Out a) Session PreparedStmtObj BindObj
module Database.Enumerator
Produced by Haddock version 0.7