bergmann 406e80570b | 5 years ago | |
---|---|---|
cmake | 5 years ago | |
include | 5 years ago | |
src | 5 years ago | |
test | 5 years ago | |
.gitignore | 6 years ago | |
.gitmodules | 6 years ago | |
CMakeLists.txt | 5 years ago | |
LICENSE.txt | 6 years ago | |
README.md | 6 years ago |
A C++11 class wrapper for the mysql/mariadb C connector.
Before you can use cppmariadb you need to download and install the official mariadb C connector). And if you want to run the tests you additionally need the google testing framework.
The cpputils libary will be automatically downladed during the build.
#include <iostream>
#include <exception>
#include <cppmariadb.h>
using namespace ::cppmariadb;
int main(int argc, char** argv)
{
try
{
/* establish connection to database */
connection c = database::connect("localhost", 3306, "testuser", "password", "database", client_flags::empty());
/* prepare a query */
statement s("SELECT * FROM my_table WHERE id=?id?");
s.set("id", 5);
/* execute the query */
result_used* res = con.execute_used(s);
if (res == nullptr)
{
throw std::exception("unable to fetch from table from database!");
}
/* iterate over result set */
row* r = res->next();
while(r != nullptr)
{
std::cout << "new dataset:" << std::endl;
for (size_t i = 0; i < r->size(); ++i)
{
field f = r->at(i);
std::cout << " " << f.column().name << ": " << f.get<std::string>() << std::endl;
}
std::cout << std::endl;
r = res->next();
}
return 0;
}
catch(const std::exception& ex)
{
std::cout << ex.what() << std::endl;
}
return 1
}
This project is licensed under the MIT License - see the LICENSE.txt file for details