Not exactly what you are asking for, but did you consider using sqlite in memory? On Sat, 7 Aug 2021 at 23:23, Esteban Maringolo <emaringolo@gmail.com> wrote:
I've been doing exactly that. It is, creating a new DB file for each test, and I was having the same problem as you.
I suggested a change to the driver to cover that situation: https://github.com/pharo-rdbms/Pharo-SQLite3/pull/22/files
Try applying that change and see if that works.
I still prefer to recreate the database, it will give you a full fresh start, and if you want you can halt before the deletion of the db, to analyze its internal state.
Best regards!
Esteban A. Maringolo
On Sat, Aug 7, 2021 at 11:13 PM <vinref@gmail.com> wrote:
Hi
Actually I will just do a bunch of
DROP TABLE IF EXISTS
instead of dropping the db altogether.
Thanks, Vince