error: QSqlDatabase: No such file or directory

[learningqt]

I am a newbie and I was trying this code from http://developer.qt.nokia.com/ on QSqlQueryModel

ArtistsSqlModel.h

#ifndef ARTISTSSQLMODEL_H
#define ARTISTSSQLMODEL_H
#include "database.h"
 
class ArtistsSqlModel : public QSqlQueryModel
{
    Q_OBJECT
 
    public:
        explicit ArtistsSqlModel(QObject *parent);
        void refresh();
        QVariant data(const QModelIndex &index, int role) const;
 
    signals:
 
    public slots:
 
    private:
        const static char* COLUMN_NAMES[];
        const static char* SQL_SELECT;
};
 
const char* ArtistsSqlModel::COLUMN_NAMES[] = {
 "artist",
 "title",
 "year",
 NULL
};
 
const char* ArtistsSqlModel::SQL_SELECT =
"SELECT artists.artist, albums.title, albums.year"
"  FROM albums"
"       JOIN artists ON albums.artistid = artists.id";
 
#endif // ARTISTSSQLMODEL_H

#ifndef ARTISTSSQLMODEL_H
#define ARTISTSSQLMODEL_H
#include "database.h"

class ArtistsSqlModel : public QSqlQueryModel
{
    Q_OBJECT

    public:
        explicit ArtistsSqlModel(QObject *parent);
        void refresh();
        QVariant data(const QModelIndex &index, int role) const;

    signals:

    public slots:

    private:
        const static char* COLUMN_NAMES[];
        const static char* SQL_SELECT;
};

const char* ArtistsSqlModel::COLUMN_NAMES[] = {
 "artist",
 "title",
 "year",
 NULL
};

const char* ArtistsSqlModel::SQL_SELECT =
"SELECT artists.artist, albums.title, albums.year"
"  FROM albums"
"       JOIN artists ON albums.artistid = artists.id";

#endif // ARTISTSSQLMODEL_H

To copy to clipboard, switch view to plain text mode 

database.h

#ifndef DATABASE_H
 #define DATABASE_H
 
 #include <QMessageBox>
 #include <QSqlDatabase>
 #include <QSqlError>
 #include <QSqlQuery>
 
 static bool createConnection()
 {
     QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
     db.setDatabaseName(":memory:");
     if (!db.open()) {
         QMessageBox::critical(0, qApp->tr("Cannot open database"),
             qApp->tr("Unable to establish a database connection.\n"
                      "This example needs SQLite support. Please read "
                      "the Qt SQL driver documentation for information how "
                      "to build it.\n\n"
                      "Click Cancel to exit."), QMessageBox::Cancel);
         return false;
     }
 
     QSqlQuery query;
 
     query.exec("create table artists (id int primary key, "
                                      "artist varchar(40), "
                                      "albumcount int)");
 
     query.exec("insert into artists values(0, '<all>', 0)");
     query.exec("insert into artists values(1, 'Ane Brun', 2)");
     query.exec("insert into artists values(2, 'Thomas Dybdahl', 3)");
     query.exec("insert into artists values(3, 'Kaizers Orchestra', 3)");
 
     query.exec("create table albums (albumid int primary key, "
                                      "title varchar(50), "
                                      "artistid int, "
                                      "year int)");
 
     query.exec("insert into albums values(1, 'Spending Time With Morgan', 1, "
                        "2003)");
     query.exec("insert into albums values(2, 'A Temporary Dive', 1, 2005)");
     query.exec("insert into albums values(3, '...The Great October Sound', 2, "
                        "2002)");
     query.exec("insert into albums values(4, 'Stray Dogs', 2, 2003)");
     query.exec("insert into albums values(5, "
         "'One day you`ll dance for me, New York City', 2, 2004)");
     query.exec("insert into albums values(6, 'Ompa Til Du D\xf8r', 3, 2001)");
     query.exec("insert into albums values(7, 'Evig Pint', 3, 2002)");
     query.exec("insert into albums values(8, 'Maestro', 3, 2005)");
 
     return true;
 }
 
 #endif

#ifndef DATABASE_H
 #define DATABASE_H

 #include <QMessageBox>
 #include <QSqlDatabase>
 #include <QSqlError>
 #include <QSqlQuery>

 static bool createConnection()
 {
     QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
     db.setDatabaseName(":memory:");
     if (!db.open()) {
         QMessageBox::critical(0, qApp->tr("Cannot open database"),
             qApp->tr("Unable to establish a database connection.\n"
                      "This example needs SQLite support. Please read "
                      "the Qt SQL driver documentation for information how "
                      "to build it.\n\n"
                      "Click Cancel to exit."), QMessageBox::Cancel);
         return false;
     }

     QSqlQuery query;

     query.exec("create table artists (id int primary key, "
                                      "artist varchar(40), "
                                      "albumcount int)");

     query.exec("insert into artists values(0, '<all>', 0)");
     query.exec("insert into artists values(1, 'Ane Brun', 2)");
     query.exec("insert into artists values(2, 'Thomas Dybdahl', 3)");
     query.exec("insert into artists values(3, 'Kaizers Orchestra', 3)");

     query.exec("create table albums (albumid int primary key, "
                                      "title varchar(50), "
                                      "artistid int, "
                                      "year int)");

     query.exec("insert into albums values(1, 'Spending Time With Morgan', 1, "
                        "2003)");
     query.exec("insert into albums values(2, 'A Temporary Dive', 1, 2005)");
     query.exec("insert into albums values(3, '...The Great October Sound', 2, "
                        "2002)");
     query.exec("insert into albums values(4, 'Stray Dogs', 2, 2003)");
     query.exec("insert into albums values(5, "
         "'One day you`ll dance for me, New York City', 2, 2004)");
     query.exec("insert into albums values(6, 'Ompa Til Du D\xf8r', 3, 2001)");
     query.exec("insert into albums values(7, 'Evig Pint', 3, 2002)");
     query.exec("insert into albums values(8, 'Maestro', 3, 2005)");

     return true;
 }

 #endif

To copy to clipboard, switch view to plain text mode 

ArtistsSqlModel.cpp

#include "ArtistsSqlModel.h";
 
 
ArtistsSqlModel::ArtistsSqlModel(QObject *parent) :
    QSqlQueryModel(parent)
{
    int idx = 0;
    QHash<int, QByteArray> roleNames;
    while( COLUMN_NAMES[idx]) {
            roleNames[Qt::UserRole + idx + 1] = COLUMN_NAMES[idx];
            idx++;
    }
    setRoleNames(roleNames);
    refresh();
}

#include "ArtistsSqlModel.h";


ArtistsSqlModel::ArtistsSqlModel(QObject *parent) :
    QSqlQueryModel(parent)
{
    int idx = 0;
    QHash<int, QByteArray> roleNames;
    while( COLUMN_NAMES[idx]) {
            roleNames[Qt::UserRole + idx + 1] = COLUMN_NAMES[idx];
            idx++;
    }
    setRoleNames(roleNames);
    refresh();
}

To copy to clipboard, switch view to plain text mode 

ArtistItemDelegate.qml

import Qt 4.7
 
    Item {
        id: delegate
        width: delegate.ListView.view.width;
        height: 30
        clip: true
        anchors.margins: 4
 
        Row {
            anchors.margins: 4
            anchors.fill: parent
            spacing: 4;
 
            Text {
                text: artist
                width: 150
            }
 
            Text {
                text: title
                width: 300;
            }
 
            Text {
                text: year
                width: 50;
            }
        }
    }

import Qt 4.7

    Item {
        id: delegate
        width: delegate.ListView.view.width;
        height: 30
        clip: true
        anchors.margins: 4

        Row {
            anchors.margins: 4
            anchors.fill: parent
            spacing: 4;

            Text {
                text: artist
                width: 150
            }

            Text {
                text: title
                width: 300;
            }

            Text {
                text: year
                width: 50;
            }
        }
    }

To copy to clipboard, switch view to plain text mode 

main.qml

import QtQuick 1.1
 
Rectangle {
    width: 360
    height: 360
 
    ListView {
                id: list_view1
                clip: true
                anchors.margins: 10
                anchors.fill: parent
                model: artistsModel
                delegate: ArtistItemDelegate {}
            }
 
}

import QtQuick 1.1

Rectangle {
    width: 360
    height: 360

    ListView {
                id: list_view1
                clip: true
                anchors.margins: 10
                anchors.fill: parent
                model: artistsModel
                delegate: ArtistItemDelegate {}
            }

}

To copy to clipboard, switch view to plain text mode 

main.cpp

#include <QtGui/QApplication>
#include "qmlapplicationviewer.h"
#include "ArtistsSqlModel.h"
 
QVariant ArtistsSqlModel::data(const QModelIndex &index, int role) const
{
    QVariant value = QSqlQueryModel::data(index, role);
    if(role < Qt::UserRole)
    {
        value = QSqlQueryModel::data(index, role);
    }
    else
    {
        int columnIdx = role - Qt::UserRole - 1;
        QModelIndex modelIndex = this->index(index.row(), columnIdx);
        value = QSqlQueryModel::data(modelIndex, Qt::DisplayRole);
    }
    return value;
}
 
Q_DECL_EXPORT int main(int argc, char *argv[])
{
    ArtistsSqlModel *artistsSqlModel = new ArtistsSqlModel( qApp);
       QmlApplicationViewer viewer;
       viewer.rootContext()->setContextProperty("artistsModel", artistsSqlModel);
       viewer.setOrientation(QmlApplicationViewer::ScreenOrientationAuto);
       viewer.setMainQmlFile(QLatin1String("qml/SQLListView/main.qml"));
       viewer.showExpanded();
}

#include <QtGui/QApplication>
#include "qmlapplicationviewer.h"
#include "ArtistsSqlModel.h"

QVariant ArtistsSqlModel::data(const QModelIndex &index, int role) const
{
    QVariant value = QSqlQueryModel::data(index, role);
    if(role < Qt::UserRole)
    {
        value = QSqlQueryModel::data(index, role);
    }
    else
    {
        int columnIdx = role - Qt::UserRole - 1;
        QModelIndex modelIndex = this->index(index.row(), columnIdx);
        value = QSqlQueryModel::data(modelIndex, Qt::DisplayRole);
    }
    return value;
}

Q_DECL_EXPORT int main(int argc, char *argv[])
{
    ArtistsSqlModel *artistsSqlModel = new ArtistsSqlModel( qApp);
       QmlApplicationViewer viewer;
       viewer.rootContext()->setContextProperty("artistsModel", artistsSqlModel);
       viewer.setOrientation(QmlApplicationViewer::ScreenOrientationAuto);
       viewer.setMainQmlFile(QLatin1String("qml/SQLListView/main.qml"));
       viewer.showExpanded();
}

To copy to clipboard, switch view to plain text mode 

I was getting this error

/home/sobingt/QtSDK/Test6/finalQlist-build-desktop-Desktop_Qt_4_8_0_for_GCC__Qt_SDK__Release/../finalQlist/database.h:5: error: QSqlDatabase: No such file or directory

/home/sobingt/QtSDK/Test6/finalQlist-build-desktop-Desktop_Qt_4_8_0_for_GCC__Qt_SDK__Release/../finalQlist/database.h:5: error: QSqlDatabase: No such file or directory

To copy to clipboard, switch view to plain text mode 

I know i must have done a very very stupid mistake.Sorry for wasting your time. but can u help me..

[Lykurg]

Du you have

QT += sql

QT += sql

To copy to clipboard, switch view to plain text mode 

in the *.pro file?

[learningqt]

thankz got it..
had to add some more lines to solve error: invalid use of incomplete type 'struct QDeclarativeContext'

#include <QDeclarativeContext>
#include <QKeyEvent>

QT +=sql
QT += core gui declarative

Thankz Lykurg

[Lykurg]

You are welcome.