diff -r edc0144719a1 -r b56d7e268634 contactengine/dbtools.cpp
--- a/contactengine/dbtools.cpp	Thu Aug 26 14:34:34 2010 -0700
+++ b/contactengine/dbtools.cpp	Fri Sep 03 07:59:16 2010 -0700
@@ -1,108 +1,12 @@
 #include <QtCore/QCoreApplication>
-#include <QtSql>
 #include <QFile>
 
+#include <QDebug>
+#include <QStringList>
+
 #include "database.h"
 #include "dbtools.h"
 
-bool DBTools::createTable(QString sqlStmt)
-{
-    qDebug() << "DB: create table statement: " << sqlStmt << endl;
-
-    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:\\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)");
-
-    qDebug() << "DB: create table rc=" << rc << endl;
-    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)
 {
@@ -173,7 +77,6 @@
 DBTools::DBTools(QObject *parent)
 {
     QObject();
-    createDB();
 }
 
 DBTools::~DBTools()