mariadb++

C++ client library for MariaDB. Uses the C connector.

Features

• Prepared statements
• Transactions and savepoints
• Concurrency allows connection sharing between threads
• Data type support: blob, decimal, datetime, time, timespan, etc.
• Exceptions

Dependencies

Install mariadbclient or mysqlclient libraries.

Usage (local)

1. Initialize Git submodules: git submodule update --init
2. Add mariadbclientpp as a subdirectory in your own CMakeLists.txt:

add_subdirectory(/path/to/mariadbpp)
...
target_link_libraries(target mariadbclientpp)

Usage (global)

Build and install instructions

1. Initialize Git submodules: git submodule update --init
2. mkdir build; cd build
3. cmake ..
4. make install

Linking instructions

Add mariadbclientpp as a CMake package to your CMake project. Make sure that the environment variable CMAKE_PREFIX_PATH includes the directory where the mariadbclientpp-config.cmake file was installed:

find_package(mariadbclientpp)
...
target_link_libraries(target mariadbclientpp::mariadbclientpp)

Building tests

1. Create database and user according to the information in test/CMakeLists.txt or adjust these values.
2. Enable tests with -DMARIADBPP_TEST=ON and build the software.

Example

// set up the account
account_ref acc = account::create(...);

// create connection
connection_ref con = connection::create(acc);

// insert, update, select on the connection
u64 id = con->insert("INSERT INTO table VALUES (1, 2, 3)");
u64 affected = con->execute("UPDATE table SET a=1");
result_set_ref result = con->query("SELECT * FROM table");

// create statement
statement_ref stmt = con->create_statement(...);

// insert, update, select on the statement
u64 id = stmt->insert();
u64 affected = stmt->execute();
result_set_ref result = stmt->query();

// reading from a result set
while (result->next()) {
    int a = result->get_unsigned32(0);
    int b = result->get_unsigned32("b");
}

// insert using prepared statement
statement_ref stmt = con->create_statement("INSERT INTO table (?, ?, ?)");
stmt->set_unsigned32(0, 13);
stmt->set_unsigned32(1, 37);
stmt->set_unsigned32(2, 42);
stmt->insert();

More usage examples can be found in the test/ directory.

License

This library is subject to the Boost Software License. See accompanying LICENSE file.