-
Notifications
You must be signed in to change notification settings - Fork 546
Tutorial
This is an introduction to usage of the MongoDB database from a C++ program.
First, install MongoDB – see the installation page for details.
Next, you may wish to take a look at the MongoDB Manual for a language independent look at how to use MongoDB. Also, we suggest some basic familiarity with the mongo shell – the shell is the primary database administration tool and is useful for manually inspecting the contents of a database after your C++ program runs.
Please see [download and compile page](Download and Compile) for instructions on how to download, build, and install the C++ client driver.
#include <cstdlib>
#include <iostream>
#include "mongo/client/dbclient.h" // for the driver
using namespace std;
using namespace mongo;
void run() {
DBClientConnection c;
c.connect("localhost");
}
int main() {
try {
run();
cout << "connected ok" << endl;
} catch( const DBException &e ) {
cout << "caught " << e.what() << endl;
}
return EXIT_SUCCESS;
}
If you are using gcc on Linux, you would compile with something like this, depending on location of your include files and libraries:
$ g++ tutorial.cpp -pthread -lmongoclient -lboost_thread-mt -lboost_system -o tutorial
$ ./tutorial
connected ok
Warning
- Since the tutorial program attempts to connect to a MongoDB database server, you must start it by running mongod before running the tutorial.
- You may need to append -mt to boost_filesystem and boost_program_options. If using a recent boost, -mt is not needed anymore.
- You may need to use -I and -L to specify the locations of your mongo and boost headers and libraries.
- If using the 26compat branch you need to additionally specify
-lboost_filesystem
and-lboost_program_options
The MongoDB database stores data in BSON format. BSON is a binary object format that is JSON-like in terms of the data which can be stored (some extensions exist, for example, a Date datatype).
To save data in the database we must create objects of class BSONObj. The components of a BSONObj are represented as BSONElement objects. We use BSONObjBuilder to make BSON objects, and BSONObjIterator to enumerate BSON objects.
Let’s now create a BSON “person” object which contains name and age. We might invoke:
BSONObjBuilder b;
b.append("name", "Joe");
b.append("age", 33);
BSONObj p = b.obj();
Or more concisely:
BSONObj p = BSONObjBuilder().append("name", "Joe").append("age", 33).obj();
We can also create BSON objects using the stream oriented syntax:
BSONObjBuilder b;
b << "name" << "Joe" << "age" << 33;
BSONObj p = b.obj();
The BSON Macro lets us be even more compact:
BSONObj p = BSON( "name" << "Joe" << "age" << 33 );
Use the GENOID helper to add an object id to your object. The server will add an _id automatically if it is not included explicitly.
BSONObj p = BSON( GENOID << "name" << "Joe" << "age" << 33 );
// result is: { _id : ..., name : "Joe", age : 33 }
GENOID should be at the beginning of the generated object. We can do something similar with the non-stream builder syntax:
BSONObj p = BSONObjBuilder().genOID().append("name","Joe").append("age",33).obj();
Other helpers are listed [BSON Helpers](BSON Helper Functions).
We now save our person object in a persons collection in the database:
c.insert("tutorial.persons", p);
The first parameter to insert is the namespace. tutorial is the database and persons is the collection name.
Let’s now fetch all objects from the persons collection, and display them. We’ll also show here how to use count().
cout << "count:" << c.count("tutorial.persons") << endl;
auto_ptr<DBClientCursor> cursor = c.query("tutorial.persons", BSONObj());
while (cursor->more())
cout << cursor->next().toString() << endl;
BSONObj()
is an empty BSON object – it represents {}
which indicates an empty query pattern (an empty query is a query for all objects).
We use BSONObj::toString()
above to print out information about each object retrieved. BSONObj::toString
is a diagnostic function which prints an abbreviated JSON string representation of the object. For full JSON output, use BSONObj::jsonString
.
Let’s now write a function which prints out the name (only) of all persons in the collection whose age is a given value:
void printIfAge(DBClientConnection& c, int age) {
auto_ptr<DBClientCursor> cursor =
c.query("tutorial.persons", QUERY("age" << age));
while (cursor->more()) {
BSONObj p = cursor->next();
cout << p.getStringField("name") << endl;
}
}
getStringField()
is a helper that assumes the name field is of type string. To manipulate an element in a more generic fashion we can retrieve the particular BSONElement from the enclosing object:
BSONElement name = p["name"];
// or:
BSONElement name = p.getField("name");
See the api docs, and jsobj.h, for more information.
Our query above, written as JSON, is of the form
{ age : <agevalue> }
Queries are BSON objects of a particular format – in fact, we could have used the BSON() macro above instead of QUERY(). See class Query in dbclient.h for more information on Query objects, and the Sorting section below.
In the mongo shell (which uses javascript), we could invoke:
use tutorial;
db.persons.find({age : 33});
Let’s suppose we want to have an index on age so that our queries are fast. We would use:
c.ensureIndex("tutorial.persons", fromjson("{age:1}"));
The ensureIndex method checks if the index exists; if it does not, it is created. ensureIndex is intelligent and does not repeat transmissions to the server; thus it is safe to call it many times in your code, for example, adjacent to every insert operation.
In the above example we use a new function, fromjson. fromjson converts a JSON string to a BSONObj. This is sometimes a convenient way to specify BSON. Alternatively, we could have written:
c.ensureIndex("tutorial.persons", BSON( "age" << 1 ));
Let’s now make the results from printIfAge sorted alphabetically by name. To do this, we change the query statement from:
auto_ptr<DBClientCursor> cursor = c.query("tutorial.persons", QUERY("age" << age));
to
auto_ptr<DBClientCursor> cursor = c.query("tutorial.persons", QUERY("age" << age ).sort("name"));
Here we have used Query::sort()
to add a modifier to our query expression for sorting.
Use the update()
method to perform a database update . For example the following update in the mongo shell:
> use tutorial
> db.persons.update( { name : 'Joe', age : 33 },
... { $inc : { visits : 1 } } )
is equivalent to the following C++ code:
db.update("tutorial.persons",
BSON("name" << "Joe" << "age" << 33),
BSON("$inc" << BSON( "visits" << 1))
);
A simple example illustrating usage of BSON arrays and the $nin
operator is available here.
This overview just touches on the basics of using MongoDB from C++. There are many more capabilities. For further exploration:
- See the language-independent MongoDB Manual;
- Experiment with the mongo shell;
- Review the doxygen API docs;
- See connecting pooling information in the API docs;
- See GridFS file storage information in the API docs;
- Consider getting involved to make the product (either C++ driver, tools, or the database itself) better!