IToolkitMySQL

IToolkitMySQLResult

int GetRowCount()

Returns the total number of rows in the result set.

int GetFieldCount()

Returns the number of columns in the result set.

bool FieldNameToNum(name, columnId)

Converts a field name into a column index.

• name const char* — Field name to search for.
• columnId unsigned int* — Output column index.

const char* FieldNumToName(colId)

Returns the field name for a column index.

• colId unsigned int — Column index.

bool MoreRows()

Checks whether additional rows are available.

IToolkitMySQLRow* FetchRow()

Fetches the next row from the result set.

IToolkitMySQLRow* CurrentRow()

Returns the currently active row.

bool Rewind()

Rewinds the internal row cursor to the beginning.

int GetFieldType(field)

Returns the MySQL field type of a column.

• field unsigned int — Column index.

const char* GetString(columnId, length)

Retrieves a string value from a column.

• columnId unsigned int — Column index.
• length size_t* — Optional output string length.

size_t GetDataSize(columnId)

Returns the raw data size of a column value.

• columnId unsigned int — Column index.

float GetFloat(columnId)

Retrieves a floating-point value from a column.

• columnId unsigned int — Column index.

int GetInt(columnId)

Retrieves an integer value from a column.

• columnId unsigned int — Column index.

int64_t GetInt64(columnId)

Retrieves a 64-bit integer value from a column.

• columnId unsigned int — Column index.

bool IsNull(columnId)

Checks whether a column contains a NULL value.

• columnId unsigned int — Column index.

IToolkitMySQLQuery

IToolkitMySQLResult* GetResultSet()

Returns the current result set.

bool FetchMoreResults()

Advances to the next available result set.

unsigned int GetInsertId()

Returns the last inserted row ID.

unsigned int GetAffectedRows()

Returns the number of affected rows.

IToolkitMySQLConnection

Connect(callback)

Establishes a connection to the MySQL server.

• callback ToolkitMySQLConnectCallbackFunc — Callback invoked after connection attempt.

Query(query, callback)

Executes a raw SQL query.

• query char* — SQL query string.
• callback ToolkitMySQLQueryCallbackFunc — Callback invoked with query result.

Query(query, callback, )

Executes a formatted SQL query.

• query const char* — SQL format string.
• callback ToolkitMySQLQueryCallbackFunc — Callback invoked with query result.
• ...

ExecuteTransaction(txn, success, failure)

Executes multiple queries as a transaction.

• txn ToolkitMySQLTransaction — Transaction query batch.
• success ToolkitMySQLTransactionSuccessCallbackFunc — Callback invoked on success.
• failure ToolkitMySQLTransactionFailureCallbackFunc — Callback invoked on failure.

Destroy()

Destroys and releases the connection instance.

std::string Escape(string)

Escapes a mutable string for safe SQL usage.

• string char* — Input string.

std::string Escape(string)

Escapes a constant string for safe SQL usage.

• string const char* — Input string.

IToolkitMySQL

IToolkitMySQLConnection* CreateConnection(info)

Creates a new MySQL connection instance.

• info ToolkitMySQLConnectionInfo — Connection configuration data.