Cannot display qsqlquerymodel to a qml list view

[ironexmaiden]

Consider problem SOLVED i solved it with implementing

class SqlQueryModel: public QSqlQueryModel
{
    Q_OBJECT
    QHash<int,QByteArray> *hash;
public:
    explicit SqlQueryModel(QObject * parent) : QSqlQueryModel(parent)
    {
        hash = new QHash<int,QByteArray>;
        hash->insert(Qt::UserRole,      QByteArray("someRoleName"));
        hash->insert(Qt::UserRole + 1,  QByteArray("otherRoleName"));
    }
    QVariant data(const QModelIndex &index, int role) const
    {
       if(role < Qt::UserRole) {
          return QSqlQueryModel::data(index, role);
       }
       QSqlRecord r = record(index.row());
       return r.value(QString(hash->value(role))).toString();
    }
    inline RoleNameHash roleNames() const { return *hash; }
};

class SqlQueryModel: public QSqlQueryModel
{
    Q_OBJECT
    QHash<int,QByteArray> *hash;
public:
    explicit SqlQueryModel(QObject * parent) : QSqlQueryModel(parent)
    {
        hash = new QHash<int,QByteArray>;
        hash->insert(Qt::UserRole,      QByteArray("someRoleName"));
        hash->insert(Qt::UserRole + 1,  QByteArray("otherRoleName"));
    }
    QVariant data(const QModelIndex &index, int role) const
    {
       if(role < Qt::UserRole) {
          return QSqlQueryModel::data(index, role);
       }
       QSqlRecord r = record(index.row());
       return r.value(QString(hash->value(role))).toString();
    }
    inline RoleNameHash roleNames() const { return *hash; }
};

To copy to clipboard, switch view to plain text mode 

[grol]

Hey there,

I am trying the same since some days now. Can you maybe post the whole project as a zip file?
Or post the main.cpp and how you implement it?

Would be awsome...

inline RoleNameHash roleNames() const { return *hash; }

does not name a type, is one of the errors i get...

[anda_skoa]

Just implement this method http://qt-project.org/doc/qt-5/qabst...html#roleNames

ironexmaiden probably had a typedef for the return type.

Cheers,
_

[grol]

solved like following. thanks!

#ifndef SQLQUERYMODEL_H
#define SQLQUERYMODEL_H
 
#include <QtSql>
#include <QAbstractItemModel>
 
class SqlQueryModel: public QSqlQueryModel
{
    Q_OBJECT
    QHash<int,QByteArray> *hash;
public:
    explicit SqlQueryModel() : QSqlQueryModel()
    {
        hash = new QHash<int,QByteArray>;
        hash->insert(Qt::UserRole, QByteArray("name"));
        hash->insert(Qt::UserRole + 1, QByteArray("title"));
    }
    QVariant data(const QModelIndex &index, int role) const
    {
        if(role < Qt::UserRole) {
            return QSqlQueryModel::data(index, role);
        }
        QSqlRecord r = record(index.row());
        return r.value(QString(hash->value(role))).toString();
    }
    inline QHash<int, QByteArray> roleNames() const { return *hash; }
};

#ifndef SQLQUERYMODEL_H
#define SQLQUERYMODEL_H

#include <QtSql>
#include <QAbstractItemModel>

class SqlQueryModel: public QSqlQueryModel
{
    Q_OBJECT
    QHash<int,QByteArray> *hash;
public:
    explicit SqlQueryModel() : QSqlQueryModel()
    {
        hash = new QHash<int,QByteArray>;
        hash->insert(Qt::UserRole, QByteArray("name"));
        hash->insert(Qt::UserRole + 1, QByteArray("title"));
    }
    QVariant data(const QModelIndex &index, int role) const
    {
        if(role < Qt::UserRole) {
            return QSqlQueryModel::data(index, role);
        }
        QSqlRecord r = record(index.row());
        return r.value(QString(hash->value(role))).toString();
    }
    inline QHash<int, QByteArray> roleNames() const { return *hash; }
};

To copy to clipboard, switch view to plain text mode 

#endif // SQLQUERYMODEL_H

[anda_skoa]

You can just have the hash on the stack, no need for allocating it on the heap using new.

QHash<int,QByteArray> hash;

QHash<int,QByteArray> hash;

To copy to clipboard, switch view to plain text mode 

Currently you leak it.

Cheers,
_

[grol]

you mean like following?

class SqlQueryModel: public QSqlQueryModel
{
    Q_OBJECT
    QHash<int,QByteArray> hash;
public:
    explicit SqlQueryModel() : QSqlQueryModel()
    {
        //hash = new QHash<int,QByteArray>;
        hash.insert(Qt::UserRole, QByteArray("name"));
        hash.insert(Qt::UserRole + 1, QByteArray("title"));
    }
    QVariant data(const QModelIndex &index, int role) const
    {
        if(role < Qt::UserRole) {
            return QSqlQueryModel::data(index, role);
        }
        QSqlRecord r = record(index.row());
        return r.value(QString(hash.value(role))).toString();
    }
    inline QHash<int, QByteArray> roleNames() const { return hash; }
};

class SqlQueryModel: public QSqlQueryModel
{
    Q_OBJECT
    QHash<int,QByteArray> hash;
public:
    explicit SqlQueryModel() : QSqlQueryModel()
    {
        //hash = new QHash<int,QByteArray>;
        hash.insert(Qt::UserRole, QByteArray("name"));
        hash.insert(Qt::UserRole + 1, QByteArray("title"));
    }
    QVariant data(const QModelIndex &index, int role) const
    {
        if(role < Qt::UserRole) {
            return QSqlQueryModel::data(index, role);
        }
        QSqlRecord r = record(index.row());
        return r.value(QString(hash.value(role))).toString();
    }
    inline QHash<int, QByteArray> roleNames() const { return hash; }
};

To copy to clipboard, switch view to plain text mode 

[anda_skoa]

Exactly!

Cheers,
_