diff -r e4b6ee329501 -r a7451a8eb5dc contactengine/dbtools.cpp
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/contactengine/dbtools.cpp	Mon Aug 09 14:37:31 2010 +0100
@@ -0,0 +1,116 @@
+#include <QtCore/QCoreApplication>
+#include <QtSql>
+
+#include "database.h"
+#include "dbtools.h"
+
+bool DBTools::createTable(QString sqlStmt)
+{
+    QSqlQuery query;
+    return query.exec(sqlStmt);
+}
+
+int DBTools::getLastInsertRowId()
+{
+    int rc = -1;
+    QSqlQuery query;
+    query.exec("select last_insert_rowid()");
+    if (!query.exec()) {
+        QString errCode =  "last rowid query Failed: " + query.lastError().text();
+        qWarning(errCode.toStdString().c_str());
+
+    } else {
+        query.next();
+        rc = query.value(0).toInt();
+    }
+    return rc;
+}
+
+void DBTools::insertContact( QString name, QString mobile, QString deskphone,
+                    int xtn, QString email, QString skype,
+                    QString twitter, QString title, int site,
+                    int department, int floor)
+{
+    QSqlQuery query;
+
+    query.prepare("INSERT INTO contacts ( name, mobile, deskphone, xtn, "
+                  "email, skype, twitter, title, site, department, floor) "
+                  "VALUES (:name,:mobile,:deskphone,:xtn,:email,:skype, "
+                  ":twitter, :title, :site, :department, :floor)");
+
+    query.bindValue(":name", name);
+    query.bindValue(":mobile", mobile);
+    query.bindValue(":deskphone", deskphone);
+    query.bindValue(":xtn", xtn);
+    query.bindValue(":twitter", twitter);
+    query.bindValue(":skype", skype);
+    query.bindValue(":email", email);
+    query.bindValue(":title", title);
+    query.bindValue(":site", site);
+    query.bindValue(":department", department);
+    query.bindValue(":floor", floor);
+
+    if (!query.exec())
+    {
+        qDebug() << query.lastError();
+        qFatal("Failed to add fish.");
+    }
+}
+
+
+bool DBTools::createDB()
+{
+    QSqlDatabase db;
+
+    // Find QSLite driver
+    db = QSqlDatabase::addDatabase("QSQLITE");
+
+    db.setDatabaseName("C:\\workspace\\QtExamples\\contactengine\\contactengine.db");
+
+    // Open databasee
+    if(!db.open())
+    {
+        qDebug() << "DB: failed to open" << endl;
+        exit (1);
+    }
+
+    qDebug() << "DB: database opened " << endl;
+
+    bool rc = createTable("create table contacts "
+                "(cid integer primary key, "
+                "name varchar(128),"
+                "mobile varchar(128),"
+                "deskphone varchar(128),"
+                "xtn int,"
+                "email varchar(128),"
+                "skype varchar(128),"
+                "twitter varchar(128),"
+                "title varchar(128),"
+                "site int,"
+                "department int,"
+                "floor int");
+
+    return rc;
+}
+
+void DBTools::testDB()
+{
+    createDB();
+    insertContact("Tom", "12345", "45678", 22, "tom@symbian.org", "thetom", "tomtom",
+                  "Senior Tom", SITE_LONDON, DEPT_TDM, 0);
+}
+
+void DBTools::importCSV(QString fileName)
+{
+
+}
+
+DBTools::DBTools(QObject *parent)
+{
+    QObject();
+}
+
+DBTools::~DBTools()
+{
+
+}