Deleting row from QTableWidget and from Sqlite database

[Risver]

@JonB said in Deleting row from QTableWidget and from Sqlite database:

@Risver
OK, so independent of your selection querymodel->removeRows(0, 1); fails to remove the first row? We can then rule out anything to do with the UI or the selection.

Do you have something specific in mind ?

[JonB]

@Risver
Hang on. Does QSqlQueryModel allow any removing it all? It's a query, it won't/shouldn't do anything to the database for sure.

[Yep, I'm sure, QSqlQueryModel is a read only model, you can't remove rows from it.]

If you are wanting to alter the underlying the database table, I think you should be using QSqlTableModel instead?

I leave this to you, or @Christian-Ehrlicher, now, as I'm done for the week :)

[Risver]

@JonB said in Deleting row from QTableWidget and from Sqlite database:

@Risver
Hang on. Does QSqlQueryModel allow any removing it all? It's a query, it won't/shouldn't do anything to the database for sure.

[Yep, I'm sure, QSqlQueryModel is a read only model, you can't remove rows from it.]

If you are wanting to alter the underlying the database table, I think you should be using QSqlTableModel instead?

I leave this to you, or @Christian-Ehrlicher, now, as I'm done for the week :)

Okay, thank You, I will try to use QSqlTableModel.

[Risver]

I've changed the QSqlQueryModel into QSqlTableModel and everything is working !
Thank you all ! :)

I have one more question - how can i refresh the table at the current time ?

Done it !

[Risver]

I have one more question - can i get data from column and replace these with other data ?

[SGaist]

Hi,

Do you mean an entire column ?

[Risver]

@SGaist said in Deleting row from QTableWidget and from Sqlite database:

Hi,

Do you mean an entire column ?

Hi, yes i mean all the cells that are in the column

[SGaist]

Yes, select the whole column and then use a loop to parse the selection.

[Risver]

@SGaist
Okay and can i replace the old data with new data ?

[JonB]

@Risver
What "new data", from where? Do you mean something like over-pasting a selected column's data with other data in the QTreeView UI? Do you mean updating all rows to change one column's data in the model and/or the SQL database? Programatically or by user interaction? Or what?

[Risver]

@JonB said in Deleting row from QTableWidget and from Sqlite database:

@Risver
What "new data", from where? Do you mean something like over-pasting a selected column's data with other data in the QTreeView UI? Do you mean updating all rows to change one column's data in the model and/or the SQL database? Programatically or by user interaction? Or what?

I mean updating all rows to change one column's data in the model(not in SQL), I would like this to happen programatically.

The passwords in database are encrypted, I want them to be decrypted when I open the application.

[JonB]

@Risver
The you must loop over each row, updating the column:

for (int row = 0; row < querymodel->rowCount(); row++)
    querymodel->setData(querymodel->index(row, someColumnNumber), someValue);

Is that what you meant?

[Risver]

@JonB said in Deleting row from QTableWidget and from Sqlite database:

@Risver
The you must loop over each row, updating the column:

for (int row = 0; row < querymodel->rowCount(); row++)
    querymodel->setData(querymodel->index(row, someColumnNumber), someValue);

Is that what you meant?

Yes, thank you. But it is also changing the data in database.

[JonB]

@Risver
Of course. If you change a QSqlTableModel's data it will end up updating the database. That's the point of it.

You need to think out what you do and do not want to update, when and why.

[Risver]

@JonB
Now i'm using

ui->tableView->model()->setData(ui->tableView->model()->index(i, 3), passdecoded);

But it's only work for first row.

    for(int i = 0; i < table->rowCount(); i++)
    {
        QByteArray pass = ui->tableView->model()->data(ui->tableView->model()->index(i, 3)).toString().toUtf8();
        pass = QByteArray::fromBase64(pass);
        QString passdecoded = decoding(pass);
        qDebug() << passdecoded;
        ui->tableView->model()->setData(ui->tableView->model()->index(i, 3), passdecoded);
    }

Now i see its also changing the data in database...

[JonB]

@Risver
Read https://doc.qt.io/qt-5/qsqltablemodel.html#submitAll, https://doc.qt.io/qt-5/qsqltablemodel.html#EditStrategy-enum and https://doc.qt.io/qt-5/qsqltablemodel.html#setEditStrategy, and check what yours currently is.

[Risver]

@JonB said in Deleting row from QTableWidget and from Sqlite database:

@Risver
Read https://doc.qt.io/qt-5/qsqltablemodel.html#submitAll, https://doc.qt.io/qt-5/qsqltablemodel.html#EditStrategy-enum and https://doc.qt.io/qt-5/qsqltablemodel.html#setEditStrategy, and check what yours currently is.

I'm not sure, before i used setEditStrategy() only the first row was changed, when i used OnFieldChange, all was changed but it was applied to database, when i used OnRowChange and OnManualSubmit only the last row was changed.

[JonB]

@Risver This is over to you now.

[Risver]

@JonB said in Deleting row from QTableWidget and from Sqlite database:

@Risver This is over to you now.

Thank you for your help, but I already solved the problem myself. Passwords are decrypted when the application is turned on, and encrypted when closed.

[JonB]

@Risver That sounds like nothing to do with your model/database/update issues, which should now be working correctly.