#include <QSqlDatabase>
#include <QSqlQuery>
#include <QVariant>
#include <stdio.h>

int main(int argc, char * argv[])
{
    Q_UNUSED(argc);
    Q_UNUSED(argv);

    /** Connect to database */
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");

    /** Set database name (and login for other db drivers) */
    db.setDatabaseName(":memory:");
    //db.setDatabaseName("test.db");

    /** Open database */
    if (!db.open())
    {
        return 1;
    }

    /* Do some queries with the default connectin */
    QSqlQuery query;

    query.exec("CREATE TABLE test (id int primary key, name varchar(20))");

    query.exec("INSERT INTO test VALUES (1, 'Name 1')");
    query.exec("INSERT INTO test VALUES (2, 'Name 2')");
    query.exec("INSERT INTO test VALUES (3, 'Name 3')");
    query.prepare("INSERT INTO test VALUES (4, :bindval)");
    query.bindValue(":bindval", "Name 4");
    query.exec();

    query.exec("SELECT * FROM test WHERE id > '2'");

    while (query.next())
    {
        QString name = query.value(1).toString();
        printf("Name: %s\n", name.toLatin1().constData());
    }

    /** Database closed in destructor */
    return 0;
}