#include <QObject>

#include <QSqlDatabase>

#include <QSqlError>

#include <QSqlQuery>

#include <QString>

class DatabaseManager : public QObject

    {

    public:

        DatabaseManager(QObject *parent = );

        ~DatabaseManager();

    public:

        bool openDB();

        bool deletePerson(int id);

    private:

        QSqlDatabase db;

    };

bool DatabaseManager::deletePerson(int id)

    {

    bool ret = false;

    if (db.isOpen())

        {

        QSqlQuery query;

        ret = query.exec(QString("delete from person where id=%1").arg(id));

        }

    return ret;

    }

bool DatabaseManager::openDB()

    {

    // Find QSLite driver

    db = QSqlDatabase::addDatabase("QSQLITE");

    #ifdef Q_OS_LINUX

    // NOTE: We have to store database file into user home folder in Linux

    QString path(QDir::home().path());

    path.append(QDir::separator()).append("my.db.sqlite");

    path = QDir::toNativeSeparators(path);

    db.setDatabaseName(path);

    #else

    // NOTE: File exists in the application private folder, in Symbian Qt implementation

    db.setDatabaseName("my.db.sqlite");

    #endif

    // Open databasee

    return db.open();

    }

bool DatabaseManager::getPerson(int id, PersonData*& person)

    {

    bool ret = false;

    QSqlQuery query(QString("select * from person where id = %1").arg(id));

    if (query.next())

        {

        person->id = query.value().toInt();

        person->firstname = query.value().toString();

        person->lastname = query.value().toString();

        person->age = query.value().toInt();

        ret = true;

        }

    return ret;

    }