hi,
i'm trying to do multiple inserts using a single execution / transaction, but when executing a statement with begin transaction the driver don't insert any data... if i call the inserts one by one no problem.
i try playing with setautocommit (true/false) method but same results..
Is there a limitation to execute sql with begin/end transaction?
The sqlite3 interface from the command line it works ok:
sqlite3 /dev/shm/test.db "begin transaction; insert into tableTest (id, name) values (2, 'some name'); insert into tableTest (id, name) values (3, 'some name'); end transaction;"
Attach my test script.
I'm running it on debian 11.6 (bullseye), using backports version of lua-sql-sqlite3:amd64 2.6.0-2+1.
hi, i'm trying to do multiple inserts using a single execution / transaction, but when executing a statement with begin transaction the driver don't insert any data... if i call the inserts one by one no problem.
i try playing with setautocommit (true/false) method but same results..
Is there a limitation to execute sql with begin/end transaction?
The sqlite3 interface from the command line it works ok:
sqlite3 /dev/shm/test.db "begin transaction; insert into tableTest (id, name) values (2, 'some name'); insert into tableTest (id, name) values (3, 'some name'); end transaction;"Attach my test script. I'm running it on debian 11.6 (bullseye), using backports version of lua-sql-sqlite3:amd64 2.6.0-2+1.
Thanks for the help. test-lusql-sqlite3-transaction.lua.txt