Safe Haskell | None |
---|
An ODBC backend for persistent.
- withODBCPool :: MonadIO m => Maybe DBType -> ConnectionString -> Int -> (ConnectionPool -> m a) -> m a
- withODBCConn :: (MonadIO m, MonadBaseControl IO m) => Maybe DBType -> ConnectionString -> (Connection -> m a) -> m a
- createODBCPool :: MonadIO m => Maybe DBType -> ConnectionString -> Int -> m ConnectionPool
- type ConnectionString = String
- data OdbcConf = OdbcConf {
- odbcConnStr :: ConnectionString
- odbcPoolSize :: Int
- odbcDbtype :: String
- openSimpleConn :: Maybe DBType -> Connection -> IO Connection
- data DBType
- mysql :: DBType
- postgres :: DBType
- mssqlMin2012 :: DBType
- mssql :: DBType
- oracleMin12c :: DBType
- oracle :: DBType
- db2 :: DBType
- sqlite :: DBType
Documentation
:: MonadIO m | |
=> Maybe DBType | |
-> ConnectionString | Connection string to the database. |
-> Int | Number of connections to be kept open in the pool. |
-> (ConnectionPool -> m a) | Action to be executed that uses the connection pool. |
-> m a |
Create an ODBC connection pool and run the given
action. The pool is properly released after the action
finishes using it. Note that you should not use the given
ConnectionPool
outside the action since it may be already
been released.
withODBCConn :: (MonadIO m, MonadBaseControl IO m) => Maybe DBType -> ConnectionString -> (Connection -> m a) -> m aSource
Same as withODBCPool
, but instead of opening a pool
of connections, only one connection is opened.
:: MonadIO m | |
=> Maybe DBType | |
-> ConnectionString | Connection string to the database. |
-> Int | Number of connections to be kept open in the pool. |
-> m ConnectionPool |
Create an ODBC connection pool. Note that it's your
responsibility to properly close the connection pool when
unneeded. Use withODBCPool
for an automatic resource
control.
type ConnectionString = StringSource
An HDBC-odbc
connection string. A simple example of connection
string would be DSN=hdbctest1
.
Information required to connect to a PostgreSQL database
using persistent
's generic facilities. These values are the
same that are given to withODBCPool
.
OdbcConf | |
|
PersistConfig OdbcConf |
openSimpleConn :: Maybe DBType -> Connection -> IO ConnectionSource
Generate a persistent Connection
from an odbc Connection
List of DBMS that are supported