| Safe Haskell | None |
|---|
Database.Persist.MySQL
Description
A MySQL backend for persistent.
- withMySQLPool :: MonadIO m => ConnectInfo -> Int -> (ConnectionPool -> m a) -> m a
- withMySQLConn :: (MonadBaseControl IO m, MonadIO m) => ConnectInfo -> (Connection -> m a) -> m a
- createMySQLPool :: MonadIO m => ConnectInfo -> Int -> m ConnectionPool
- module Database.Persist.Sql
- data ConnectInfo = ConnectInfo {
- connectHost :: String
- connectPort :: Word16
- connectUser :: String
- connectPassword :: String
- connectDatabase :: String
- connectOptions :: [Option]
- connectPath :: FilePath
- connectSSL :: Maybe SSLInfo
- data SSLInfo = SSLInfo {
- sslKey :: FilePath
- sslCert :: FilePath
- sslCA :: FilePath
- sslCAPath :: FilePath
- sslCiphers :: String
- defaultConnectInfo :: ConnectInfo
- defaultSSLInfo :: SSLInfo
- data MySQLConf = MySQLConf {
- myConnInfo :: ConnectInfo
- myPoolSize :: Int
Documentation
Arguments
| :: MonadIO m | |
| => ConnectInfo | Connection information. |
| -> 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 a MySQL 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.
Arguments
| :: (MonadBaseControl IO m, MonadIO m) | |
| => ConnectInfo | Connection information. |
| -> (Connection -> m a) | Action to be executed that uses the connection. |
| -> m a |
Same as withMySQLPool, but instead of opening a pool
of connections, only one connection is opened.
Arguments
| :: MonadIO m | |
| => ConnectInfo | Connection information. |
| -> Int | Number of connections to be kept open in the pool. |
| -> m ConnectionPool |
Create a MySQL connection pool. Note that it's your
responsability to properly close the connection pool when
unneeded. Use withMySQLPool for automatic resource control.
module Database.Persist.Sql
data ConnectInfo
Constructors
| ConnectInfo | |
Fields
| |
Instances
| Eq ConnectInfo | |
| Read ConnectInfo | |
| Show ConnectInfo | |
| Typeable ConnectInfo |
data SSLInfo
defaultConnectInfo :: ConnectInfo
Default information for setting up a connection.
Defaults are as follows:
- Server on
localhost - User
root - No password
- Database
test - Character set
utf8
Use as in the following example:
connect defaultConnectInfo { connectHost = "db.example.com" }
Default (empty) information for setting up an SSL connection.
Information required to connect to a MySQL database
using persistent's generic facilities. These values are the
same that are given to withMySQLPool.
Constructors
| MySQLConf | |
Fields
| |
Instances