Check If Database is Open in Lua

Question

How can I check with Lua to see if my connection to my sqlite database is still open?

What SQLite binding are you using? It's hard to tell, but generally, the connection is open as long as you keep a reference to the connection (have it in a variable) and do not call the close method. — Michal Kottman
– Michal Kottman, Commented Jan 27, 2012 at 4:37

jpjacobs · Accepted Answer · 2012-01-27 11:21:00Z

4

LuaSQLite and LuaSQL are the most widely spread SQLite libraries for Lua.

Using luasqlite it is:

sqlite3=require"sqlite3"
db1=sqlite3.open_memory()
db2=sqlite3.open_memory()
db2:close()
print("db1 is ".. (db1:isopen() and "is open" or "it's not open"))
print("db2 is ".. (db2:isopen() and "is open" or "it's not open"))

Using luasql with the sqlite backend:

sqlite3=require('luasql.sqlite3')
env=sqlite3.sqlite3()
con1=env:connect(':memory:')
con2=env:connect(':memory:')
con2:close()
print("con1 is ".. (tostring(con1):match'closed' and "not open" or "open"))
print("con2 is ".. (tostring(con2):match'closed' and "not open" or "open"))

edited Jan 27, 2012 at 11:21

answered Jan 27, 2012 at 11:03

jpjacobs

9,66940 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Check If Database is Open in Lua

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related