C++ driver tutorial
In this tutorial, we’ll build a sample application with the C++ driver capable of basic interaction with TypeDB:
-
Connect to a TypeDB server (Core or Cloud),
-
Manage databases, sessions, and transactions,
-
Send different types of queries.
Follow the steps below or see the full source code.
Environment setup
To run this sample application, you’ll need:
-
TypeDB: either a TypeDB Cloud deployment or a TypeDB Core server. For TypeDB Core installation instructions, see the TypeDB Core installation guide page.
-
Download the TypeDB C++ driver. For the driver installation instructions, see the C++ driver page.
Includes
To be able to use the TypeDB C++ driver API in the Sample application, use the following include statements:
#include <iostream>
#include <fstream>
#include <vector>
#include <typedb_driver.hpp>
Default values
We store default values as constants in the source code:
const std::string DB_NAME = "sample_app_db";
const std::string SERVER_ADDR = "127.0.0.1:1729";
enum edition { core, cloud };
edition TYPEDB_EDITION = edition::core;
const std::string CLOUD_USERNAME = "admin";
const std::string CLOUD_PASSWORD = "password";
where DB_NAME
— the name of the database to use;
SERVER_ADDR
— address of the TypeDB server to connect to;
TYPEDB_EDITION
— TypeDB Core or Cloud edition selector;
CLOUD_USERNAME
/CLOUD_PASSWORD
— credentials to connect to TypeDB Cloud.
Program structure
The main workflow of this sample application includes establishing a connection to TypeDB, a new database setup, and querying.
int main() {
TypeDB::Driver driver = connectToTypeDB(TYPEDB_EDITION, SERVER_ADDR);
if (driver.isOpen()) {
if (dbSetup(driver, DB_NAME)) {
queries(driver, DB_NAME);
return EXIT_SUCCESS;
} else {
std::cerr << "Failed to set up the database. Terminating..." << std::endl;
exit(EXIT_FAILURE);
}
} else {
std::cerr << "Failed to connect to TypeDB server. Terminating..." << std::endl;
exit(EXIT_FAILURE);
}
}
The entire main()
function code is executed in the context of the network connection,
represented by the driver
object that is returned by the function.
TypeDB connection
The connectToTypeDB()
function takes edition
and addr
as mandatory parameters.
TypeDB::Driver connectToTypeDB(const edition typedb_edition,
const std::string& addr,
const std::string& username=CLOUD_USERNAME,
const std::string& password=CLOUD_PASSWORD,
const bool encryption = true) {
if (typedb_edition == edition::core) { return TypeDB::Driver::coreDriver(addr); };
if (typedb_edition == edition::cloud) { return TypeDB::Driver::cloudDriver({addr}, TypeDB::Credential(username, password, encryption));; };
exit(EXIT_FAILURE);
}
The edition
is expected to be an Enum for selecting a TypeDB edition.
Depending on the TypeDB edition selected, this function initializes either a TypeDB Core or TypeDB Cloud connection.
TypeDB Cloud connection requires an object of the TypeDB::Credential
class
that is initialized with a username and password.
For our sample application, we have the default credentials for the admin
account set in the code of the
connectToTypeDB
function.
TypeDB Cloud requires the default password for the default |
Database setup
To set up a TypeDB database, we need to make sure that it exists and has the correct schema and data. First, we check whether a database with the provided name already exists on the server.
If such a database doesn’t exist, we create a new database, define its schema, and load initial data.
To prevent data loss, avoid deleting an existing database without confirmation from a user. |
If a database with the specified name already exists, we check whether we need to replace it.
To do so, we check the dbReset
parameter, and, if it’s false
, ask for an input from a user.
If any of the two suggesting replacement of the database is acceptable,
we replace the database by deleting the existing database and then creating a new one.
As the final step of the database setup, we test it.
bool dbSetup(TypeDB::Driver& driver, const std::string& dbName, bool dbReset = false) {
std::cout << "Setting up the database: " << dbName << std::endl;
if (driver.databases.contains(dbName)) {
if (dbReset) {
replaceDatabase(driver, dbName);
} else {
std::string answer;
std::cout << "Found a pre-existing database. Do you want to replace it? (Y/N) ";
std::cin >> answer;
if (answer == "Y" || answer == "y") {
replaceDatabase(driver, dbName);
} else {
std::cout << "Reusing an existing database." << std::endl;
}
}
} else {
if (!createDatabase(driver, dbName)) {
std::cout << "Failed to create a new database. Terminating..." << std::endl;
exit(EXIT_FAILURE);
}
}
TypeDB::Options options;
if (driver.databases.contains(dbName)) {
TypeDB::Session session = driver.session(dbName, TypeDB::SessionType::DATA, options);
return dbCheck(session);
} else {
std::cout << "Failed to find the database. Terminating..." << std::endl;
exit(EXIT_FAILURE);
}
}
Creating a new database
We create a new database with the specified name (sample_app_db
by default)
and call functions to define its schema and load initial data.
bool createDatabase(TypeDB::Driver& driver, const std::string& dbName) {
std::cout << "Creating a new database...";
driver.databases.create(dbName);
std::cout << "OK" << std::endl;
TypeDB::Options options;
{
TypeDB::Session session = driver.session(dbName, TypeDB::SessionType::SCHEMA, options);
dbSchemaSetup(session);
}
{
TypeDB::Session session = driver.session(dbName, TypeDB::SessionType::DATA, options);
dbDatasetSetup(session);
}
return true;
}
Replacing a database
We delete a database with the specified name (sample_app_db
by default)
and call a function to create a new one instead:
bool replaceDatabase(TypeDB::Driver& driver, const std::string& dbName) {
std::cout << "Deleting an existing database...";
driver.databases.get(dbName).deleteDatabase(); // Delete the database if it exists already
std::cout << "OK" << std::endl;
if (!createDatabase(driver, dbName)) {
std::cout << "Failed to create a new database. Terminating..." << std::endl;
exit(EXIT_FAILURE);
}
return true;
}
Defining a schema
We use a Define query to define a schema for the newly created database:
void dbSchemaSetup(TypeDB::Session& schemaSession, const std::string& schemaFile = "iam-schema.tql") {
std::string defineQuery;
std::ifstream newfile;
newfile.open(schemaFile, std::ios::in);
if (newfile.is_open()){
std::string tmp;
while(getline(newfile, tmp)){
defineQuery = defineQuery + tmp + "\n";
}
newfile.close();
} else {
std::cerr << "Failed to open a file. Terminating..." << std::endl;
exit(EXIT_FAILURE);
}
TypeDB::Options options;
TypeDB::Transaction tx = schemaSession.transaction(TypeDB::TransactionType::WRITE, options);
std::cout << "Defining schema...";
tx.query.define(defineQuery).get();
tx.commit();
std::cout << "OK" << std::endl;
}
The schema for the sample application is stored in the iam-schema.tql file.
See the full schema
define
credential sub attribute, value string;
full-name sub attribute, value string;
id sub attribute, abstract, value string;
email sub id, value string;
name sub id, value string;
number sub id, value string;
path sub id, value string;
object-type sub attribute, value string;
ownership-type sub attribute, value string;
review-date sub attribute, value datetime;
size-kb sub attribute, value long;
validity sub attribute, value boolean;
access sub relation,
relates action,
relates object,
plays change-request:change,
plays permission:access;
change-request sub relation,
relates change,
relates requestee,
relates requester;
membership sub relation,
relates member,
relates parent;
collection-membership sub membership,
relates collection as parent;
group-membership sub membership,
relates group as parent;
set-membership sub membership,
relates set as parent;
ownership sub relation,
relates owned,
relates owner;
group-ownership sub ownership,
owns ownership-type,
relates group as owned;
object-ownership sub ownership,
owns ownership-type,
relates object as owned;
permission sub relation,
owns review-date,
owns validity,
relates access,
relates subject;
segregation-policy sub relation,
owns name,
relates action,
plays segregation-violation:policy;
violation sub relation,
abstract;
segregation-violation sub violation,
relates object,
relates policy,
relates subject;
action sub entity,
abstract,
owns name,
owns object-type,
plays access:action,
plays membership:member,
plays segregation-policy:action;
operation sub action;
operation-set sub action,
plays set-membership:set;
object sub entity,
abstract,
owns object-type,
plays access:object,
plays membership:member,
plays object-ownership:object,
plays segregation-violation:object;
resource sub object,
abstract;
file sub resource,
owns path,
owns size-kb;
record sub resource,
owns number;
resource-collection sub object,
abstract,
plays collection-membership:collection;
database sub resource-collection,
owns name;
directory sub resource-collection,
owns path,
owns size-kb;
subject sub entity,
abstract,
owns credential,
plays change-request:requestee,
plays change-request:requester,
plays membership:member,
plays ownership:owner,
plays permission:subject,
plays segregation-violation:subject;
user sub subject,
abstract;
person sub user,
owns email,
owns full-name;
user-group sub subject,
abstract,
plays group-membership:group,
plays group-ownership:group;
business-unit sub user-group,
owns name;
user-account sub user-group,
owns email;
user-role sub user-group,
owns name;
rule add-view-permission: when {
$modify isa action, has name "modify_file";
$view isa action, has name "view_file";
$ac_modify (object: $obj, action: $modify) isa access;
$ac_view (object: $obj, action: $view) isa access;
(subject: $subj, access: $ac_modify) isa permission;
} then {
(subject: $subj, access: $ac_view) isa permission;
};
We use a session object passed as a parameter to open a transaction. Then we send the contents of the file as a TypeQL Define query and commit the changes made by the transaction.
Loading initial data
With the schema defined, we can load initial data into our database with the Insert query:
void dbDatasetSetup(TypeDB::Session& dataSession, const std::string& dataFile = "iam-data-single-query.tql") {
std::ifstream file(dataFile);
std::string insertQuery((std::istreambuf_iterator<char>(file)), std::istreambuf_iterator<char>());
TypeDB::Options options;
TypeDB::Transaction tx = dataSession.transaction(TypeDB::TransactionType::WRITE, options);
std::cout << "Loading data...";
TypeDB::ConceptMapIterable response = tx.query.insert(insertQuery);
int16_t count = 0;
for (TypeDB::ConceptMap& conceptMap : response) { count += 1; }
tx.commit();
std::cout << "OK" << std::endl;
}
We read the iam-data-single-query.tql file, send its contents as a single query, and then commit the changes.
See the full Insert query
insert
$p1 isa person,
has full-name "Masako Holley",
has email "masako.holley@typedb.com";
$p2 isa person,
has full-name "Pearle Goodman",
has email "pearle.goodman@typedb.com";
$p3 isa person,
has full-name "Kevin Morrison",
has email "kevin.morrison@typedb.com";
$f1 isa file,
has path "iopvu.java",
has size-kb 55;
$modify isa operation, has name "modify_file";
$view isa operation, has name "view_file";
$a1 (object: $f1, action: $modify) isa access;
$a11 (object: $f1, action: $view) isa access;
$permission1 (subject: $p3, access: $a1) isa permission;
$f2 isa file,
has path "zlckt.ts",
has size-kb 143;
$a2 (object: $f2, action: $modify) isa access;
$a22 (object: $f2, action: $view) isa access;
$permission2 (subject: $p3, access: $a2) isa permission;
$f3 isa file,
has path "psukg.java",
has size-kb 171;
$a3 (object: $f3, action: $modify) isa access;
$a33 (object: $f3, action: $view) isa access;
$permission3 (subject: $p3, access: $a3) isa permission;
$f4 isa file,
has path "axidw.java",
has size-kb 212;
$a4 (object: $f4, action: $modify) isa access;
$a44 (object: $f4, action: $view) isa access;
$permission4 (subject: $p3, access: $a4) isa permission;
$f5 isa file,
has path "lzfkn.java",
has size-kb 70;
$a5 (object: $f5, action: $modify) isa access;
$a55 (object: $f5, action: $view) isa access;
$permission5 (subject: $p3, access: $a5) isa permission;
$f6 isa file,
has path "budget_2022-05-01.xlsx",
has size-kb 758;
$a6 (object: $f6, action: $modify) isa access;
$a66 (object: $f6, action: $view) isa access;
$permission6 (subject: $p3, access: $a6) isa permission;
$permission66 (subject: $p2, access: $a66) isa permission;
$f7 isa file,
has path "zewhb.java";
$a7 (object: $f7, action: $modify) isa access;
$a77 (object: $f7, action: $view) isa access;
$permission7 (subject: $p3, access: $a7) isa permission;
$permission77 (subject: $p2, access: $a77) isa permission;
$f8 isa file,
has path "budget_2021-08-01.xlsx",
has size-kb 1705;
$a8 (object: $f8, action: $modify) isa access;
$a88 (object: $f8, action: $view) isa access;
$permission8 (subject: $p3, access: $a8) isa permission;
$permission88 (subject: $p2, access: $a88) isa permission;
$f9 isa file,
has path "LICENSE";
$a9 (object: $f9, action: $modify) isa access;
$a99 (object: $f9, action: $view) isa access;
$permission9 (subject: $p3, access: $a9) isa permission;
$permission99 (subject: $p2, access: $a99) isa permission;
$f10 isa file,
has path "README.md";
$a10 (object: $f10, action: $modify) isa access;
$a100 (object: $f10, action: $view) isa access;
$permission10 (subject: $p3, access: $a10) isa permission;
$permission100 (subject: $p2, access: $a100) isa permission;
Testing a database
With the schema defined and data loaded, we test our database to make sure it’s ready. To test the database, we send a query to count the number of users in the database:
bool dbCheck(TypeDB::Session& dataSession) {
TypeDB::Options options;
TypeDB::Transaction tx = dataSession.transaction(TypeDB::TransactionType::READ, options);
std::string testQuery = "match $u isa user; get $u; count;";
std::cout << "Testing the database...";
TypeDB::AggregateFuture response = tx.query.getAggregate(testQuery);
int16_t result = response.get().value().get()->asLong();
if (result == 3) {
std::cout << "Passed" << std::endl;
return true;
} else {
std::cout << "Failed with the result: " << result << "\nExpected result: 3." << std::endl;
return false;
}
}
Query examples
After database setup is complete, we proceed with querying our database with different types of queries in the
queries()
function:
void queries(TypeDB::Driver& driver, const std::string& dbName) {
std::cout << "\nRequest 1 of 6: Fetch all users as JSON objects with full names and emails" << std::endl;
std::vector<TypeDB::JSON> users = fetchAllUsers(driver, dbName);
std::string newName = "Jack Keeper";
std::string newEmail = "jk@typedb.com";
std::cout << "\nRequest 2 of 6: Add a new user with the full-name " << newName << " and email " << newEmail << std::endl;
insertNewUser(driver, dbName, newName, newEmail);
std::string name = "Kevin Morrison";
std::cout << "\nRequest 3 of 6: Find all files that the user " << name << " has access to view (no inference)" << std::endl;
std::vector<std::string> noFiles = getFilesByUser(driver, dbName, name);
std::cout << "\nRequest 4 of 6: Find all files that the user " << name << " has access to view (with inference)" << std::endl;
std::vector<std::string> files = getFilesByUser(driver, dbName, name, true);
std::string oldPath = "lzfkn.java";
std::string newPath = "lzfkn2.java";
std::cout << "\nRequest 5 of 6: Update the path of a file from " << oldPath << " to " << newPath << std::endl;
int16_t updatedFiles = updateFilePath(driver, dbName, oldPath, newPath);
std::string filePath = "lzfkn2.java";
std::cout << "\nRequest 6 of 6: Delete the file with path " << filePath << std::endl;
bool deleted = deleteFile(driver, dbName, filePath);
}
The queries are as follows:
-
Fetch query — to retrieve information in a JSON format
-
Insert query — to insert new data into the database
-
Get query — to retrieve data from the database as stateful objects
-
Get query with inference — to retrieve data from the database as stateful objects using inference
-
Update query — to replace data in the database
-
Delete query — to delete data from the database
Every query is implemented as a function that includes some output of the query response and returns some meaningful data.
Fetch query
The main way to retrieve data from a TypeDB database is to use fetching to get values of attributes, matched by a pattern.
Let’s use a Fetch query to fetch names and emails for all users in the database:
std::vector<TypeDB::JSON> fetchAllUsers(TypeDB::Driver& driver, const std::string& dbName) {
std::vector<TypeDB::JSON> users;
TypeDB::Options options;
{
TypeDB::Session session = driver.session(dbName, TypeDB::SessionType::DATA, options);
TypeDB::Transaction tx = session.transaction(TypeDB::TransactionType::READ, options);
TypeDB::JSONIterable queryResult = tx.query.fetch("match $u isa user; fetch $u: full-name, email;");
int16_t c = 1;
for (TypeDB::JSON user : queryResult) {
users.push_back(user);
std::cout << "User #" << c++ << " ";
printJSON(user);
std::cout << std::endl;
}
}
return users;
}
We get the response as a stream of JSONs and iterate through it to print all String values from each JSON.
To print the values, we use the printJSON()
function:
void printJSON(TypeDB::JSON json) {
if (json.isString()) {
std::cout << "'" << json.asString() << "'" << std::endl;
}
if (json.isMap()) {
TypeDB::JSONMap jsonMap = json.asMap();
for (const auto& p : jsonMap ) {
std::cout << p.first << ": "<< std::endl;
printJSON(p.second);
}
}
}
Insert query
Let’s insert a new user with a full-name
and email
attributes to the database.
std::vector<TypeDB::ConceptMap> insertNewUser(TypeDB::Driver& driver, const std::string& dbName, const std::string& name, const std::string& email) {
std::vector<TypeDB::ConceptMap> response;
TypeDB::Options options;
{
TypeDB::Session session = driver.session(dbName, TypeDB::SessionType::DATA, options);
TypeDB::Transaction tx = session.transaction(TypeDB::TransactionType::WRITE, options);
TypeDB::ConceptMapIterable response = tx.query.insert("insert $p isa person, has full-name $fn, has email $e; $fn == '" + name + "'; $e == '" + email + "';");
for (TypeDB::ConceptMap& conceptMap : response) {
std::string name = conceptMap.get("fn")->asAttribute()->getValue()->asString();
std::string email = conceptMap.get("e")->asAttribute()->getValue()->asString();
std::cout << "Added new user. Name: " << name << ", E-mail: " << email << std::endl;
}
tx.commit();
}
return response;
}
The Insert query returns a stream of ConceptMaps: one for every insert
clause execution.
We iterate through the stream and print name and email for each ConceptMap returned.
Since the Insert query has no match
clause, the insert
clause is executed exactly once.
But the Insert query always returns a list of ConceptMap objects, where every ConceptMap represents an inserted result.
Get query
Let’s retrieve all files available for a user with a getFilesByUser()
function.
It can be used with or without inference enabled.
std::vector<std::string> getFilesByUser(TypeDB::Driver& driver, const std::string& dbName, const std::string& name, bool inference = false) {
TypeDB::Options options;
options.infer(inference);
{
std::vector<std::string> files;
TypeDB::Session session = driver.session(dbName, TypeDB::SessionType::DATA, options);
TypeDB::Transaction tx = session.transaction(TypeDB::TransactionType::READ, options);
TypeDB::ConceptMapIterable users = tx.query.get("match $u isa user, has full-name '" + name + "'; get;");
int16_t userCount = 0;
for (TypeDB::ConceptMap& user : users) {userCount += 1;}
if (userCount > 1) {
std::cout << "Error: Found more than one user with that name." << std::endl;
return files;
} else if (userCount == 1) {
TypeDB::ConceptMapIterable response = tx.query.get(R"(
match
$fn == ')" + name + R"(';
$u isa user, has full-name $fn;
$p($u, $pa) isa permission;
$o isa object, has path $fp;
$pa($o, $va) isa access;
$va isa action, has name 'view_file';
get $fp; sort $fp asc;
)");
int16_t resultCounter = 0;
for (TypeDB::ConceptMap& cm : response) {
resultCounter += 1;
files.push_back(cm.get("fp") ->asAttribute()->getValue()->asString());
std::cout << "File #" << std::to_string(resultCounter) << ": " << cm.get("fp") ->asAttribute()->getValue()->asString() << std::endl;
}
if (resultCounter == 0) {
std::cout << "No files found. Try enabling inference." << std::endl;
}
return files;
} else {
std::cout << "Error: No users found with that name." << std::endl;
return files;
}
}
}
We call the function with the inference disabled (false
) and expect it to return no results, as the query pattern
matches only files available for view_file
action, and there are no such files initially in the database.
The getFilesByUser()
function checks
that there is only one user matched with the name provided by an input parameter.
It then executes the query to find the files, collect the results, and
iterates through them to print a value of every matched path
attribute.
For bigger numbers of results, it might be faster to iterate through a stream, rather than collect and store the results first. |
Get query with inference
To get query results with inferred data, let’s enable the infer
parameter of the TypeDB transaction options.
We use the same getFilesByUser()
function, but set the inference
parameter to true
when we call it again.
The add-view-permission
rule provides us with some inferred results this time.
Update query
Let’s replace a path for one of the files with a new path. We can do that by deleting ownership of the old path attribute from the file entity and assigning it with ownership of the new path attribute with the Update query:
int16_t updateFilePath(TypeDB::Driver& driver, const std::string& dbName, const std::string& oldPath, const std::string& newPath) {
std::vector<TypeDB::ConceptMap> response;
int16_t count = 0;
{
TypeDB::Options options;
TypeDB::Session session = driver.session(dbName, TypeDB::SessionType::DATA, options);
TypeDB::Transaction tx = session.transaction(TypeDB::TransactionType::WRITE, options);
TypeDB::ConceptMapIterable response = tx.query.update(R"(
match
$f isa file, has path $old_path;
$old_path = ')" + oldPath + R"(';
delete
$f has $old_path;
insert
$f has path $new_path;
$new_path = ')" + newPath + R"(';
)");
for (TypeDB::ConceptMap& conceptMap : response) { count += 1; }
if (count > 0) {
tx.commit();
std::cout << "Total number of paths updated: " << count << "." << std::endl;
} else {
std::cout << "No matched paths: nothing to update." << std::endl;
}
}
return count;
}
We iterate through the response of the Update query and count the length of it to determine
the number of times the delete
and insert
clauses are executed.
We then commit the changes only if the number meets our expectation.
Delete query
Finally, let’s delete the same file we updated the path for. First, we match the file in a Get (or Fetch) query to check how many files get matched to prevent unplanned deletes. If the number (or any other relevant parameters) of matched results is as expected, we proceed with a Delete query with the same match clause.
By using the same write
transaction we employ snapshot isolation
to prevent any other transactions from changing the expected results.
If any other transaction makes a conflicting change before we commit this transaction,
then our transaction fails upon a commit.
bool deleteFile(TypeDB::Driver& driver, const std::string& dbName, const std::string& path) {
{
TypeDB::Options options;
TypeDB::Session session = driver.session(dbName, TypeDB::SessionType::DATA, options);
TypeDB::Transaction tx = session.transaction(TypeDB::TransactionType::WRITE, options);
TypeDB::ConceptMapIterable response = tx.query.get(R"(
match
$f isa file, has path ')" + path + R"(';
get;
)");
int16_t count = 0;
for (TypeDB::ConceptMap& conceptMap : response) { count += 1; }
if (count == 1) {
tx.query.matchDelete(R"(
match
$f isa file, has path ')" + path + R"(';
delete
$f isa file;
)").get();
tx.commit();
std::cout << "The file has been deleted." << std::endl;
return true;
} else if (count > 1) {
std::cout << "Matched more than one file with the same path." << std::endl;
std::cout << "No files were deleted." << std::endl;
return false;
} else {
std::cout << "No files matched in the database." << std::endl;
std::cout << "No files were deleted." << std::endl;
return false;
}
}
}