Hello,
I needed to know in order to suggest use of "KSR" package or not, instead of "sr". The "sr" package likely to be obsoleted soon, as KSR has lot more exported functions and it is part of the kemi framework. See:
http://kamailio.org/docs/tutorials/devel/kamailio-kemi-framework/
http://kamailio.org/docs/tutorials/devel/kamailio-kemi-framework/modules/#sq...
However, 5.0 doesn't have so many KSR exports as 5.1, and not sure if KSR has the sqlops exports in that version -- too late to check more in the code now...
Looking at the code, sr.sqlops.query() should return -1 in case of error and 0 if ok.
Cheers, Daniel
On 09.01.18 20:53, jenus@cyberchaos.nl wrote:
Daniel,
Currently running kamailio 5.0.5.
Jan
Daniel-Constantin Mierla schreef op 2018-01-09 13:27:
Hello,
what version of kamailio are you using?
Cheers, Daniel
On 07.01.18 22:14, jenus@cyberchaos.nl wrote:
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
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users