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/#sqlops 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, [email protected] 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, [email protected] 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 >>> [email protected] >>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > -- Daniel-Constantin Mierla www.twitter.com/miconda -- www.linkedin.com/in/miconda Kamailio Advanced Training - March 5-7, 2018, Berlin - www.asipto.com Kamailio World Conference - May 14-16, 2018 - www.kamailioworld.com _______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
