- Notifications
You must be signed in to change notification settings - Fork258
MySQL Connector/C++ is a MySQL database connector for C++. It lets you develop C++ and C applications that connect to MySQL Server.
License
mysql/mysql-connector-cpp
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
This is a release of MySQL Connector/C++,the C++ interface for communicating with MySQL servers.
For detailed information please visit the officialMySQL Connector/C++ documentation.
Please refer to files README and LICENSE, available in this repository, andLegal Notices in documentation for further details.
MySQL Connector/C++ can be installed from pre-compiled packages that can be downloaded from theMySQL downloads page.The process of installing of Connector/C++ from a binary distribution is described inMySQL online manuals
MySQL Connector/C++ can be installed from the source. Please checkMySQL online manuals
This repository contains the MySQL Connector/C++ source code as per latest released version. You should expect to see the same contents here and within the latest released Connector/C++ package.
#include <iostream>#include <mysqlx/xdevapi.h>using ::std::cout;using ::std::endl;using namespace ::mysqlx;int main(int argc, const char* argv[])try { const char *url = (argc > 1 ? argv[1] : "mysqlx://root@127.0.0.1"); cout << "Creating session on " << url << " ..." << endl; Session sess(url); cout <<"Session accepted, creating collection..." <<endl; Schema sch= sess.getSchema("test"); Collection coll= sch.createCollection("c1", true); cout <<"Inserting documents..." <<endl; coll.remove("true").execute(); { DbDoc doc(R"({ "name": "foo", "age": 1 })"); Result add = coll.add(doc) .add(R"({ "name": "bar", "age": 2, "toys": [ "car", "ball" ] })") .add(R"({ "name": "bar", "age": 2, "toys": [ "car", "ball" ] })") .add(R"({ "name": "baz", "age": 3, "date": { "day": 20, "month": "Apr" } })") .add(R"({ "_id": "myuuid-1", "name": "foo", "age": 7 })") .execute(); std::list<string> ids = add.getGeneratedIds(); for (string id : ids) cout <<"- added doc with id: " << id <<endl; } cout <<"Fetching documents..." <<endl; DocResult docs = coll.find("age > 1 and name like 'ba%'").execute(); int i = 0; for (DbDoc doc : docs) { cout <<"doc#" <<i++ <<": " <<doc <<endl; for (Field fld : doc) { cout << " field `" << fld << "`: " <<doc[fld] << endl; } string name = doc["name"]; cout << " name: " << name << endl; if (doc.hasField("date") && Value::DOCUMENT == doc.fieldType("date")) { cout << "- date field" << endl; DbDoc date = doc["date"]; for (Field fld : date) { cout << " date `" << fld << "`: " << date[fld] << endl; } string month = doc["date"]["month"]; int day = date["day"]; cout << " month: " << month << endl; cout << " day: " << day << endl; } if (doc.hasField("toys") && Value::ARRAY == doc.fieldType("toys")) { cout << "- toys:" << endl; for (auto toy : doc["toys"]) { cout << " " << toy << endl; } } cout << endl; } cout <<"Done!" <<endl;}catch (const mysqlx::Error &err){ cout <<"ERROR: " <<err <<endl; return 1;}catch (std::exception &ex){ cout <<"STD EXCEPTION: " <<ex.what() <<endl; return 1;}catch (const char *ex){ cout <<"EXCEPTION: " <<ex <<endl; return 1;}About
MySQL Connector/C++ is a MySQL database connector for C++. It lets you develop C++ and C applications that connect to MySQL Server.
Resources
License
Contributing
Security policy
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Packages0
Uh oh!
There was an error while loading.Please reload this page.