Re: [SR-Users] app_lua sr.sqlops.query exit status - sr-users

9 Jan 2018

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/#s…

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(a)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(a)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(a)lists.kamailio.org
> 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