Portability	portable
Stability	experimental
Maintainer	Bryan O'Sullivan <bos@serpentine.com>
Safe Haskell	None

Database.MySQL.Base.C

Contents

Connection management
- Connection information
Querying
- Escaping
- Results
Working with results
- Multiple results
Transactions
General information
Error handling

Description

Direct bindings to the C mysqlclient API.

Synopsis

Connection management

mysql_init

Arguments

:: Ptr MYSQL	should usually be `nullPtr`
-> IO (Ptr MYSQL)

mysql_options :: Ptr MYSQL -> Option -> IO CInt

mysql_ssl_set

Arguments

:: Ptr MYSQL
-> CString	Key.
-> CString	Cert.
-> CString	CA.
-> CString	CA path.
-> CString	Ciphers.
-> IO MyBool

mysql_real_connect

Arguments

:: Ptr MYSQL	Context (from `mysql_init`).
-> CString	Host name.
-> CString	User name.
-> CString	Password.
-> CString	Database.
-> CInt	Port.
-> CString	Unix socket.
-> CULong	Flags.
-> IO (Ptr MYSQL)

mysql_close :: Ptr MYSQL -> IO ()

mysql_ping :: Ptr MYSQL -> IO CInt

mysql_autocommit :: Ptr MYSQL -> MyBool -> IO MyBool

mysql_change_user

Arguments

:: Ptr MYSQL
-> CString	user
-> CString	password
-> CString	database
-> IO MyBool

mysql_select_db :: Ptr MYSQL -> CString -> IO CInt

mysql_set_character_set :: Ptr MYSQL -> CString -> IO CInt

Connection information

mysql_thread_id :: Ptr MYSQL -> IO CULong

mysql_get_server_info :: Ptr MYSQL -> IO CString

mysql_get_host_info :: Ptr MYSQL -> IO CString

mysql_get_proto_info :: Ptr MYSQL -> IO CUInt

mysql_character_set_name :: Ptr MYSQL -> IO CString

mysql_get_ssl_cipher :: Ptr MYSQL -> IO CString

mysql_stat :: Ptr MYSQL -> IO CString

Querying

mysql_real_query :: Ptr MYSQL -> CString -> CULong -> IO CInt

mysql_insert_id :: Ptr MYSQL -> IO CULLong

Escaping

mysql_real_escape_string :: Ptr MYSQL -> CString -> CString -> CULong -> IO CULong

Results

mysql_field_count :: Ptr MYSQL -> IO CUInt

mysql_affected_rows :: Ptr MYSQL -> IO CULLong

mysql_store_result :: Ptr MYSQL -> IO (Ptr MYSQL_RES)

mysql_use_result :: Ptr MYSQL -> IO (Ptr MYSQL_RES)

mysql_fetch_lengths :: Ptr MYSQL_RES -> IO (Ptr CULong)

mysql_fetch_lengths_nonblock :: Ptr MYSQL_RES -> IO (Ptr CULong)

mysql_fetch_row :: Ptr MYSQL_RES -> IO MYSQL_ROW

mysql_fetch_row_nonblock :: Ptr MYSQL_RES -> IO MYSQL_ROW

Working with results

mysql_free_result :: Ptr MYSQL_RES -> IO ()

mysql_free_result_nonblock :: Ptr MYSQL_RES -> IO ()

mysql_fetch_fields :: Ptr MYSQL_RES -> IO (Ptr Field)

mysql_fetch_fields_nonblock :: Ptr MYSQL_RES -> IO (Ptr Field)

mysql_data_seek :: Ptr MYSQL_RES -> CULLong -> IO ()

mysql_row_seek :: Ptr MYSQL_RES -> MYSQL_ROW_OFFSET -> IO MYSQL_ROW_OFFSET

mysql_row_tell :: Ptr MYSQL_RES -> IO MYSQL_ROW_OFFSET

Multiple results

mysql_next_result :: Ptr MYSQL -> IO CInt

Transactions

mysql_commit :: Ptr MYSQL -> IO MyBool

mysql_rollback :: Ptr MYSQL -> IO MyBool

General information

mysql_get_client_info :: CString

mysql_get_client_version :: CULong

Error handling

mysql_errno :: Ptr MYSQL -> IO CInt

mysql_error :: Ptr MYSQL -> IO CString