Database.MySQL.Base.C

Direct bindings to the C mysqlclient API.

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_server_version :: Ptr MYSQL -> IO CULong

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

Concurrency

mysql_library_init :: CInt -> Ptr (Ptr Char) -> Ptr (Ptr Char) -> IO CInt

mysql_thread_init :: IO MyBool

mysql_thread_end :: IO ()