Database.Groundhog.MySQL

Documentation

withMySQLPool

Arguments

:: (MonadBaseControl IO m, MonadIO m)

=> ConnectInfo

-> Int

number of connections to open

-> (Pool MySQL -> m a)

-> m a

withMySQLConn :: (MonadBaseControl IO m, MonadIO m) => ConnectInfo -> (MySQL -> m a) -> m a

runDbConn :: (MonadBaseControl IO m, MonadIO m, ConnectionManager cm conn) => DbPersist conn m a -> cm -> m a

Runs action within connection. It can handle a simple connection, a pool of them, etc.

data MySQL

Instances

SqlDb MySQL

DbDescriptor MySQL

Savepoint MySQL

ConnectionManager MySQL MySQL

SingleConnectionManager MySQL MySQL

ConnectionManager (Pool MySQL) MySQL

(MonadBaseControl IO m, MonadIO m) => SchemaAnalyzer (DbPersist MySQL m)

(MonadBaseControl IO m, MonadIO m) => PersistBackend (DbPersist MySQL m)

module Database.Groundhog

module Database.Groundhog.Generic.Sql.Functions

data ConnectInfo

Constructors

ConnectInfo

Fields

connectHost :: String

connectPort :: Word16

connectUser :: String

connectPassword :: String

connectDatabase :: String

connectOptions :: [Option]

connectPath :: FilePath

connectSSL :: Maybe SSLInfo

Instances

Eq ConnectInfo

Read ConnectInfo

Show ConnectInfo

Typeable ConnectInfo

data SSLInfo

Constructors

SSLInfo

Fields

sslKey :: FilePath

sslCert :: FilePath

sslCA :: FilePath

sslCAPath :: FilePath

sslCiphers :: String

Comma-separated list of cipher names.

Instances

Eq SSLInfo

Read SSLInfo

Show SSLInfo

Typeable 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" }

defaultSSLInfo :: SSLInfo

Default (empty) information for setting up an SSL connection.