app_lua sr.sqlops.query exit status - sr-users

7 Jan 2018

Hello,

I'm doing some tests with a lua script and app_lua. I'm using 
sr.sqlops.query to insert records into the database but would like to 
test the exit status of the sql query. In kamailio i can do:

if(!sql_query("kamailio", "INSERT INTO subscriber ..."))

Is there some kind of exit status for the lua function sr.sqlops.query 
in order to do the same check in lua? In other words, is it possible to 
check if a sql query was successful in lua? The result seems to be nill 
in all cases for a INSERT in lua using sr.sqlops.query.

Thanks,

Jan Hazenberg