simple.cpp

This is a simple example of how to use the Simple Database API. The test consists of the following steps:

• Connect to the data source.
• Create a query object from the database.
• Create the columns that will be bound to the query.
• Bind the columns to the query.
• Execute the query.
• Fetch the result of the query.

#include <SimpleDB.h>

int main(int argc, char ** argv) {
  SimpleDB::Database db("simpledb-examples");    
  SimpleDB::Query query(db);
  SimpleDB::IntColumn intCol;
  SimpleDB::Column * columns[1] = {&intCol};
  query.bind(columns, 1);
  query.execute("SELECT count(contact_number) FROM contacts");
  query.fetchRow();
  std::cout << "Number: " << intCol << std::endl;
  return 0;
}