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

createMySQLPool

Arguments

:: MonadIO m

=> ConnectInfo

-> Int

number of connections to open

-> m (Pool MySQL)

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

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

newtype MySQL

Constructors

MySQL Connection

Instances

SchemaAnalyzer MySQL

Methods

schemaExists :: (PersistBackend m, (* ~ Conn m) MySQL) => String -> m Bool

getCurrentSchema :: (PersistBackend m, (* ~ Conn m) MySQL) => m (Maybe String)

listTables :: (PersistBackend m, (* ~ Conn m) MySQL) => Maybe String -> m [String]

listTableTriggers :: (PersistBackend m, (* ~ Conn m) MySQL) => QualifiedName -> m [String]

analyzeTable :: (PersistBackend m, (* ~ Conn m) MySQL) => QualifiedName -> m (Maybe TableInfo)

analyzeTrigger :: (PersistBackend m, (* ~ Conn m) MySQL) => QualifiedName -> m (Maybe String)

analyzeFunction :: (PersistBackend m, (* ~ Conn m) MySQL) => QualifiedName -> m (Maybe (Maybe [DbTypePrimitive], Maybe DbTypePrimitive, String))

getMigrationPack :: (PersistBackend m, (* ~ Conn m) MySQL) => m (MigrationPack MySQL)

SqlDb MySQL

Methods

append :: (ExpressionOf MySQL r a String, ExpressionOf MySQL r b String) => a -> b -> Expr MySQL r String

signum' :: (ExpressionOf MySQL r x a, Num a) => x -> Expr MySQL r a

quotRem' :: (ExpressionOf MySQL r x a, ExpressionOf MySQL r y a, Integral a) => x -> y -> (Expr MySQL r a, Expr MySQL r a)

equalsOperator :: RenderS MySQL r -> RenderS MySQL r -> RenderS MySQL r

notEqualsOperator :: RenderS MySQL r -> RenderS MySQL r -> RenderS MySQL r

FloatingSqlDb MySQL

Methods

log' :: (ExpressionOf MySQL r x a, Floating a) => x -> Expr MySQL r a

logBase' :: (ExpressionOf MySQL r b a, ExpressionOf MySQL r x a, Floating a) => b -> x -> Expr MySQL r a

DbDescriptor MySQL

Associated Types

type AutoKeyType MySQL :: *

type QueryRaw MySQL :: * -> *

Methods

backendName :: proxy MySQL -> String

PersistBackendConn MySQL

Methods

insert :: (PersistEntity v, PersistBackend m, (* ~ Conn m) MySQL) => v -> m (AutoKey v)

insert_ :: (PersistEntity v, PersistBackend m, (* ~ Conn m) MySQL) => v -> m ()

insertBy :: (PersistEntity v, IsUniqueKey (Key v (Unique u)), PersistBackend m, (* ~ Conn m) MySQL) => u (UniqueMarker v) -> v -> m (Either (AutoKey v) (AutoKey v))

insertByAll :: (PersistEntity v, PersistBackend m, (* ~ Conn m) MySQL) => v -> m (Either (AutoKey v) (AutoKey v))

replace :: (PersistEntity v, PrimitivePersistField (Key v BackendSpecific), PersistBackend m, (* ~ Conn m) MySQL) => Key v BackendSpecific -> v -> m ()

replaceBy :: (PersistEntity v, IsUniqueKey (Key v (Unique u)), PersistBackend m, (* ~ Conn m) MySQL) => u (UniqueMarker v) -> v -> m ()

select :: (PersistEntity v, EntityConstr v c, HasSelectOptions opts MySQL (RestrictionHolder v c), PersistBackend m, (* ~ Conn m) MySQL) => opts -> m [v]

selectStream :: (PersistEntity v, EntityConstr v c, HasSelectOptions opts MySQL (RestrictionHolder v c), PersistBackend m, (* ~ Conn m) MySQL) => opts -> m (RowStream v)

selectAll :: (PersistEntity v, PersistBackend m, (* ~ Conn m) MySQL) => m [(AutoKey v, v)]

selectAllStream :: (PersistEntity v, PersistBackend m, (* ~ Conn m) MySQL) => m (RowStream (AutoKey v, v))

get :: (PersistEntity v, PrimitivePersistField (Key v BackendSpecific), PersistBackend m, (* ~ Conn m) MySQL) => Key v BackendSpecific -> m (Maybe v)

getBy :: (PersistEntity v, IsUniqueKey (Key v (Unique u)), PersistBackend m, (* ~ Conn m) MySQL) => Key v (Unique u) -> m (Maybe v)

update :: (PersistEntity v, EntityConstr v c, PersistBackend m, (* ~ Conn m) MySQL) => [Update MySQL (RestrictionHolder v c)] -> Cond MySQL (RestrictionHolder v c) -> m ()

delete :: (PersistEntity v, EntityConstr v c, PersistBackend m, (* ~ Conn m) MySQL) => Cond MySQL (RestrictionHolder v c) -> m ()

deleteBy :: (PersistEntity v, PrimitivePersistField (Key v BackendSpecific), PersistBackend m, (* ~ Conn m) MySQL) => Key v BackendSpecific -> m ()

deleteAll :: (PersistEntity v, PersistBackend m, (* ~ Conn m) MySQL) => v -> m ()

count :: (PersistEntity v, EntityConstr v c, PersistBackend m, (* ~ Conn m) MySQL) => Cond MySQL (RestrictionHolder v c) -> m Int

countAll :: (PersistEntity v, PersistBackend m, (* ~ Conn m) MySQL) => v -> m Int

project :: (PersistEntity v, EntityConstr v c, Projection' p MySQL (RestrictionHolder v c) a, HasSelectOptions opts MySQL (RestrictionHolder v c), PersistBackend m, (* ~ Conn m) MySQL) => p -> opts -> m [a]

projectStream :: (PersistEntity v, EntityConstr v c, Projection' p MySQL (RestrictionHolder v c) a, HasSelectOptions opts MySQL (RestrictionHolder v c), PersistBackend m, (* ~ Conn m) MySQL) => p -> opts -> m (RowStream a)

migrate :: (PersistEntity v, PersistBackend m, (* ~ Conn m) MySQL) => v -> Migration m

executeRaw :: (PersistBackend m, (* ~ Conn m) MySQL) => Bool -> String -> [PersistValue] -> m ()

queryRaw :: (PersistBackend m, (* ~ Conn m) MySQL) => Bool -> String -> [PersistValue] -> m (RowStream [PersistValue])

insertList :: (PersistField a, PersistBackend m, (* ~ Conn m) MySQL) => [a] -> m Int64

getList :: (PersistField a, PersistBackend m, (* ~ Conn m) MySQL) => Int64 -> m [a]

ConnectionManager MySQL

Methods

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

Savepoint MySQL

Methods

withConnSavepoint :: (MonadBaseControl IO m, MonadIO m) => String -> m a -> MySQL -> m a

ExtractConnection MySQL MySQL

Methods

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

ExtractConnection (Pool MySQL) MySQL

Methods

extractConn :: (MonadBaseControl IO m, MonadIO m) => (MySQL -> m a) -> Pool MySQL -> m a

type QueryRaw MySQL

type QueryRaw MySQL = Snippet MySQL

type AutoKeyType MySQL

type AutoKeyType MySQL = Int64

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

Methods

(==) :: ConnectInfo -> ConnectInfo -> Bool

(/=) :: ConnectInfo -> ConnectInfo -> Bool

Read ConnectInfo

Methods

readsPrec :: Int -> ReadS ConnectInfo

readList :: ReadS [ConnectInfo]

readPrec :: ReadPrec ConnectInfo

readListPrec :: ReadPrec [ConnectInfo]

Show ConnectInfo

Methods

showsPrec :: Int -> ConnectInfo -> ShowS

show :: ConnectInfo -> String

showList :: [ConnectInfo] -> ShowS

data SSLInfo :: *

Constructors

SSLInfo

Fields

• sslKey :: FilePath
• sslCert :: FilePath
• sslCA :: FilePath
• sslCAPath :: FilePath
• sslCiphers :: String

  Comma-separated list of cipher names.

Instances

Eq SSLInfo

Methods

(==) :: SSLInfo -> SSLInfo -> Bool

(/=) :: SSLInfo -> SSLInfo -> Bool

Read SSLInfo

Methods

readsPrec :: Int -> ReadS SSLInfo

readList :: ReadS [SSLInfo]

readPrec :: ReadPrec SSLInfo

readListPrec :: ReadPrec [SSLInfo]

Show SSLInfo

Methods

showsPrec :: Int -> SSLInfo -> ShowS

show :: SSLInfo -> String

showList :: [SSLInfo] -> ShowS

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.