lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]


Quoth Luciano de Souza <luchyanus@gmail.com>, on 2011-03-12 21:20:47 -0300:
> function annotation:__init()
> obj = self
> self.env = luasql.sqlite3()
> self.con = self.env:connect(filename)
> self.cur = self.con:execute('select * from annotation_master')
> end

Aside from the versioning bit someone else mentioned, I don't see a
PRAGMA foreign_keys anywhere in there.  That pragma is not persistent
between database connections; you must set it for each connection.
(It's a client-specific behavior, not a database-wide one.)

   ---> Drake Wilson