Re: LuaSQL and PRAGMAs

[Ignacio Burgueño <iburgueno@...>]

I see that this fix has been just merged.

https://github.com/keplerproject/luasql/pull/8

On Tue, Feb 12, 2013 at 5:42 PM, Ryan Pusztai <rpusztai@gmail.com> wrote:

Yes Petite is correct. I found this a while back and asked if it could be fixed. Does anyone maintain LuaSQL these days?
Can it be fixed and a new rockspec be created? This would help me during deployment. Cascaded deletes need to be turned on through PRAGMA in sqlite3.

Thoughts and help?
--
Regards,
Ryan

Sent from my Droid

On Feb 12, 2013 2:31 PM, "Petite Abeille" <petite.abeille@gmail.com> wrote:

On Feb 12, 2013, at 8:00 AM, Vadim Peretokin <vperetokin@gmail.com> wrote:

> Has anyone had luck with PRAGMAs using a recent sqlite and LuaSQL version?

Yes. In ls_sqlite3.c -> conn_execute() -> line 350, change sqlite3_prepare to sqlite3_prepare_v2.