QSqlRelationalTableModel removeRows or deleteRowFromTable?

[Snowman]

Hi

I'm currently developing an application that will be talking to a database of over 300 tables.

All the tables share a common set of columns one of which holds whether the row is deleted or not. Yes DELETE FROM isn't called, its historic and I don't plan on changing it.

If I create a class derived from QSqlRelationTableModel or QSqlTableModel, which of removeRows or deleteRowFromTable am I best implementing such that an UPDATE SET happens instead of the delete?

[Pl45m4]

@Snowman said in QSqlRelationalTableModel removeRows or deleteRowFromTable?:

which of removeRows or deleteRowFromTable am I best implementing such that an UPDATE SET happens instead of the delete?

removeRow(s) will call deleteRowFromTable at the end.

• https://doc.qt.io/qt-5/qsqltablemodel.html#deleteRowFromTable

[JonB]

@Snowman
As @Pl45m4 has said, deleteRowFromTable() is the low-level method which does the deletion.

I don't know whether you will have problems. Qt assumes deleting a row will delete it from the database. There must be more to your code than your "update column for deletion instead". For example, your normal "populate table" SELECT command must be something like SELECT from table WHERE deletion_column <> true or similar? What would happen if you try to re-add a row where it already exists but has its deletion flag set --- Qt will expect to do an INSERT, you will need an un-UPDATE.

Not saying you can't do it, just I don't know how well it will play with Qt's QSqlTableModel assumptions.....

[Snowman]

Hi @JonB yes the selects are used as you've described. While waiting for answers I refound QxORM via Inqlude which looks like it has a soft deleted option so may more than do what I require.

Thanks for the response