sorted it out with some help from the kexi source code...
heres my .h
Qt Code: 
  1. #ifndef BACKEND_H
  2. #define BACKEND_H
  3.  
  4. #include <QObject>
  5. #include <QSqlDatabase>
  6. #include <QSqlTableModel>
  7. #include <QSqlQuery>
  8. #include <QSqlRecord>
  9. #include <QDebug>
  10. #include <QStringList>
  11. #include <QList>
  12.  
  13. struct field {
  14.     QString type;
  15.     QString name;
  16.  
  17.     bool isKey;
  18.     bool isNotNull;
  19.     bool isAutoIncrement;
  20.  
  21.     field() : isKey(false), isNotNull(false), isAutoIncrement(false){}
  22.  
  23. };
  24.  
  25. Q_DECLARE_METATYPE(field);
  26.  
  27. class backend : public QObject
  28. {
  29.     Q_OBJECT
  30. public:
  31.     explicit backend(QObject *parent = 0);
  32.     ~backend();
  33.  
  34.     QSqlDatabase * database() { return ptr_db; }
  35.     bool sqlExec(QString sql);
  36.     bool addTable(QString name, const QList<field>& fields);
  37.     bool dropTable(QString name);
  38.     void addRecord(QString table, QSqlRecord record, int pos = -1);
  39.     bool isConnected() { return connected; }
  40.     bool connectDatabase(QString connection_name, QString db_name);
  41.     QString connectionName() { return ptr_db->connectionName(); }
  42.  
  43.  
  44. signals:
  45.  
  46. public slots:
  47.  
  48. private:
  49.     QSqlDatabase *ptr_db;
  50.     bool connected;
  51. };
  52.  
  53. #endif // BACKEND_H
To copy to clipboard, switch view to plain text mode 

and the .cpp
Qt Code: 
  1. #include "backend.h"
  2.  
  3. backend::backend(QObject *parent) :
  4.     QObject(parent)
  5. {
  6.     connected = false;
  7. }
  8.  
  9. backend::~backend()
  10. {
  11.     ptr_db->close();
  12.     ptr_db->removeDatabase(ptr_db->connectionName());
  13. }
  14.  
  15. bool backend::connectDatabase(QString connection_name, QString db_name)
  16. {
  17.     ptr_db = new QSqlDatabase(QSqlDatabase::addDatabase("QSQLITE", connection_name));
  18.     ptr_db->setDatabaseName(db_name);
  19.     if (ptr_db->open()){
  20.         connected = true;
  21.         qDebug() << "database connection established...";
  22.         return true;
  23.     }
  24.     connected = false;
  25.     qDebug() << "unable to connect to database...";
  26.     return false;
  27. }
  28.  
  29. bool backend::dropTable(QString name)
  30. {
  31.     QSqlQuery query(*ptr_db);
  32.     if (!query.exec("DROP TABLE IF EXISTS " + name)){
  33.         return false;
  34.     }
  35.     qDebug() << "table" << name << "dropped from database...";
  36.     return true;
  37. }
  38.  
  39. void backend::addRecord(QString table, QSqlRecord record, int pos)
  40. {
  42.     model.setTable(table);
  43.     model.database().transaction();
  44.     model.insertRecord(pos, record);
  45.     model.database().commit();
  46. }
  47.  
  48. bool backend::sqlExec(QString sql)
  49. {
  50.     QSqlQuery query(sql, *ptr_db);
  51.     if (!query.isActive()){
  52.         return false;
  53.     }
  54.     return true;
  55. }
  56.  
  57. bool backend::addTable(QString name, const QList<field> &fields)
  58. {
  60.     bool first = true;
  61.  
  62.     s = "CREATE TABLE ";
  63.     s.append(name.toLatin1() + " ( ");
  64.  
  65.     foreach (field f , fields){
  66.         if (first){
  67.             first = false;
  68.         } else {
  69.             s.append(", ");
  70.         }
  71.  
  72.         s.append(f.name.toLatin1() + " " + f.type.toLatin1());
  73.  
  74.         if (f.isKey){
  75.             s.append(" PRIMARY KEY");
  76.         }
  77.  
  78.         if (f.isAutoIncrement){
  79.             s.append(" AUTOINCREMENT");
  80.         }
  81.  
  82.         if (f.isNotNull){
  83.             s.append(" NOT NULL");
  84.         }
  85.     }
  86.  
  87.     s.append(")");
  88.  
  89.     QSqlQuery q(*ptr_db);
  90.  
  91.     if (q.exec(s)){
  92.         return true;
  93.     }
  94.  
  95.     return false;
  96. }
To copy to clipboard, switch view to plain text mode