How can i modify data in QML tableview

NCsoft

Hi
i used a sqltablemodel in c++ and a tableview in qml, and i use a textinput as delegates.
Now the data in mysql database can displayed in tableview,and i can edit data in tableview,but how i can save the data that i edit in tableview into database?

NCsoft

Here is the delegate code:
Component {
id: myDelegate
Button{
width: ddddd.width
height: 20
MouseArea {
onDoubleClicked: {
test.selectAll()
}
}
TextInput {
id:test
anchors.fill:parent
selectByMouse: true
text: styleData.value
onAccepted: {
}
}
}
}

SGaist

Hi and welcome to devnet,

Are you looking for something like this wiki article ?

NCsoft

@SGaist said:

devnet

THAN
i saw this article before.this article shows how i display mysql data in tableview,but can't edit mysql data in tableview.

SGaist

You have also to implement setData to handle the custom roles for your model

NCsoft

@SGaist
hello i've redefine setData in my model,but it still can't work.
Here is my code.

DbTableModel.h
class DbTableModel : public QSqlTableModel
{
Q_OBJECT
private:
QHash<int, QByteArray> roles;
void generateRoleNames();
public:
explicit DbTableModel(const DbTableModel &other, QObject *parent = 0);
explicit DbTableModel(QObject *parent = 0);
~DbTableModel();
Q_INVOKABLE QVariant data(const QModelIndex &index, int role=Qt::DisplayRole ) const;
Q_INVOKABLE void saveData();
Q_INVOKABLE bool setData(int row, int column, const QVariant value);
Qt::ItemFlags flags(const QModelIndex &index) const ;
virtual void setTable ( const QString &tableName );
virtual QHash<int, QByteArray> roleNames() const;
QModelIndex index1;
};
DbTableModel.cpp
DbTableModel::DbTableModel(const DbTableModel &other, QObject *parent)
: QSqlTableModel(parent,other.database())
{
index1 = QModelIndex();

}

DbTableModel::DbTableModel(QObject *parent)
: QSqlTableModel(parent)
{

}

DbTableModel::~DbTableModel()
{

}

QVariant DbTableModel::data ( const QModelIndex & index, int role ) const
{

if(index.row() >= rowCount())
{
    return QString("");
}
if(role < Qt::UserRole)
{
    return QSqlTableModel::data(index, role);
}

QModelIndex modelIndex = this->index(index.row(), role - Qt::UserRole - 1 );
return QSqlQueryModel::data(modelIndex, Qt::DisplayRole);

}

void DbTableModel::generateRoleNames()
{
roles.clear();
for (int i = 0; i < columnCount(); i++)
{
roles[Qt::UserRole + i + 1] = QVariant(headerData(i, Qt::Horizontal).toString()).toByteArray();
}
}

QHash<int, QByteArray> DbTableModel::roleNames() const
{
return roles;
}

void DbTableModel::setTable (const QString &tableName )
{
QSqlTableModel::setTable(tableName);
generateRoleNames();
}

void DbTableModel::saveData()
{
this->database().transaction();
this->database().commit();
}

bool DbTableModel::setData(int row, int column, const QVariant value)
{
int role = Qt::UserRole + 1 + column;
return QSqlTableModel::setData(index(row,role - Qt::UserRole - 1), value, role);
}

Qt::ItemFlags DbTableModel::flags(const QModelIndex &index) const
{
return Qt::ItemIsEditable | QAbstractTableModel::flags(index);
}

And i call setData(styleData.row,styleData.column,myText.text) in QML.

Forum Updated on Feb 6th

Unsolved How can i modify data in QML tableview