Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Ian Mitchell on January 04, 2022, 08:53:13 pm

Title: Explicit 'commit' for updates to QEA databases
Post by: Ian Mitchell on January 04, 2022, 08:53:13 pm

Whilst playing around with the new QEA database, I can't seem to find out how to make EA commit changes, specifically changes to the values of Tagged Values (also true for other changes, but I haven't explored therse in detail).
If I open a QEA repository, change the value of a TV, then look at the data in a SQLite browser, the data in t_ObjectProperties looks the same, even when I tell the SQLite browser to refresh. If I save and close the diagram that the element is in, there is still no commit. EA user interface is working prefectly, showing all my changes correctly - it's just the DB commit that I can't seem to force.
Brute-force solution is to close the rep and re-open, which isn't ideal.
Side-effect is that if EA crashes during operation (due to stuff I'm doing, not instability on the part of EA :-) ) it loses lots of changes.
Are these DB commits now being batched-up? Excellent for performance no doubt, but maybe EA might have a 'commit all' function added to V16 Beta 2 ?

Title: Re: Explicit 'commit' for updates to QEA databases
Post by: Eve on January 05, 2022, 08:32:01 am

.qea is single user. That includes SQLite browser.
.qeax is multiple user and should be better in the situation you have described.

Title: Re: Explicit 'commit' for updates to QEA databases
Post by: Ian Mitchell on January 05, 2022, 11:43:24 pm

Ah - so a situation where I have my test app AND the EA UI effectively puts me into the  'multi-user' use case - I'll give it a try with the QEAX-style repository.
Thanks