Problem after transaction commit failed

Question

I inserted entity "a" into table with unique column content. Then

Db.driver().commitTransaction()

Then begin new transaction and repeated. Transaction failed. As I can guess next action is automatic transacion rollback. Then I tried

Dlg.Table.model().select()

but it returned 0 rows (although there are several rows in table). Why? How to fix this?

EDIT: No, rollback have to be done manually.

Why downvote? I'll try not to repeat this mistake in the future — DSblizzard
– DSblizzard, Commented Jan 13, 2011 at 7:03
You need to post more code for somebody to be able to answer this. Right now this is completely out of context. — Maxim Sloyko
– Maxim Sloyko, Commented Jan 13, 2011 at 8:58

DSblizzard · Accepted Answer · 2011-01-13 06:59:10Z

1

Only solution that I have found is using something like this function:

def refresh_model(Dlg):
    Dlg.Model = QSqlRelationalTableModel()
    Dlg.Model.setTable(Dlg.TableName)
    Dlg.Model.setEditStrategy(QSqlTableModel.OnManualSubmit)
    for Col in range(len(DisplColNames[Dlg.TableName])):
        Dlg.Model.setHeaderData( Col, Qt.Horizontal, DisplColNames[Dlg.TableName][Col])
    Dlg.tvTable.setModel(Dlg.Model)
    Dlg.Model.select()

But why I need to set new model after fail of transaction is unclear.

answered Jan 13, 2011 at 6:59

DSblizzard

4,1697 gold badges52 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem after transaction commit failed

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related