Database.MySQL.Base

A low-level client library for the MySQL database, implemented as bindings to the C mysqlclient API.

Licensing

Important licensing note: This library is BSD-licensed under the terms of the MySQL FOSS License Exception http://www.mysql.com/about/legal/licensing/foss-exception/.

Since this library links against the GPL-licensed mysqlclient library, a non-open-source application that uses it may be subject to the terms of the GPL.

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

type Seconds = Word

data Protocol

Constructors

TCP

Socket

Pipe

Memory

Instances

Enum Protocol

Eq Protocol

Read Protocol

Show Protocol

Typeable Protocol

data Option

Constructors

ConnectTimeout Seconds

Compress

NamedPipe

InitCommand ByteString

ReadDefaultFile FilePath

ReadDefaultGroup ByteString

CharsetDir FilePath

CharsetName String

LocalInFile Bool

Protocol Protocol

SharedMemoryBaseName ByteString

ReadTimeout Seconds

WriteTimeout Seconds

UseRemoteConnection

UseEmbeddedConnection

GuessConnection

ClientIP ByteString

SecureAuth Bool

ReportDataTruncation Bool

Reconnect Bool

SSLVerifyServerCert Bool

FoundRows

IgnoreSIGPIPE

IgnoreSpace

Interactive

LocalFiles

MultiResults

MultiStatements

NoSchema

Instances

Eq Option

Read Option

Show Option

Typeable Option

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.

data Connection

Connection to a MySQL database.

Instances

Typeable Connection

data Result

Result of a database query.

Instances

Typeable Result

data Type

Column types supported by MySQL.

Constructors

Decimal

Tiny

Short

Long

Float

Double

Null

Timestamp

LongLong

Int24

Date

Time

DateTime

Year

NewDate

VarChar

Bit

NewDecimal

Enum

Set

TinyBlob

MediumBlob

LongBlob

Blob

VarString

String

Geometry

Instances

Enum Type

Eq Type

Show Type

Typeable Type

data Row

A row cursor, used by rowSeek and rowTell.

Instances

Typeable Row

data MySQLError

Instances

Eq MySQLError

Show MySQLError

Typeable MySQLError

Exception MySQLError

Connection management

connect :: ConnectInfo -> IO Connection

Connect to a database.

close :: Connection -> IO ()

Close a connection, and mark any outstanding Result as invalid.

autocommit :: Connection -> Bool -> IO ()

Turn autocommit on or off.

By default, MySQL runs with autocommit mode enabled. In this mode, as soon as you modify a table, MySQL stores your modification permanently.

ping :: Connection -> IO ()

changeUser :: Connection -> String -> String -> Maybe String -> IO ()

selectDB :: Connection -> String -> IO ()

setCharacterSet :: Connection -> String -> IO ()

Connection information

threadId :: Connection -> IO Word

serverInfo :: Connection -> IO String

hostInfo :: Connection -> IO String

protocolInfo :: Connection -> IO Word

characterSet :: Connection -> IO String

sslCipher :: Connection -> IO (Maybe String)

serverStatus :: Connection -> IO String

Querying

query :: Connection -> ByteString -> IO ()

insertID :: Connection -> IO Word64

Return the value generated for an AUTO_INCREMENT column by the previous INSERT or UPDATE statement.

See http://dev.mysql.com/doc/refman/5.5/en/mysql-insert-id.html

Escaping

escape :: Connection -> ByteString -> IO ByteString

Results

fieldCount :: Either Connection Result -> IO Int

Return the number of fields (columns) in a result.

• If Left Connection, returns the number of columns for the most recent query on the connection.
• For Right Result, returns the number of columns in each row of this result.

The number of columns may legitimately be zero.

affectedRows :: Connection -> IO Int64

Working with results

isResultValid :: Result -> IO Bool

Check whether a Result is still valid, i.e. backed by a live MYSQL_RES value.

freeResult :: Result -> IO ()

Immediately free the MYSQL_RES value associated with this Result, and mark the Result as invalid.

storeResult :: Connection -> IO Result

Retrieve a complete result.

Any previous outstanding Result is first marked as invalid.

useResult :: Connection -> IO Result

Initiate a row-by-row retrieval of a result.

Any previous outstanding Result is first marked as invalid.

fetchRow :: Result -> IO [Maybe ByteString]

fetchFields :: Result -> IO [Field]

dataSeek :: Result -> Int64 -> IO ()

rowSeek :: Result -> Row -> IO Row

rowTell :: Result -> IO Row

Multiple results

nextResult :: Connection -> IO Bool

Read the next statement result. Returns True if another result is available, False otherwise.

This function marks the current Result as invalid, if one exists.

Transactions

commit :: Connection -> IO ()

Commit the current transaction.

rollback :: Connection -> IO ()

Roll back the current transaction.

General information

clientInfo :: String

clientVersion :: Word