[sr-dev] Feature request: sql row number, route-specific avps

[Jasmin Schnatterbeck]

Hi Henning,

thank you for your e-mail.

I use the function sql_query() instead of avp_db_query now, works
perfectly...

Regarding the route specific AVPs the idea is to make it possible to
have something like "private" variables (compared with e.g. c-code).

If private variables would be available, they would be very useful for
recursive route calls. Otherwise (as you have stated) you need different
variables for every recursion. The same with iterations, because if you
convert the recursion to an iteration, you need a stack to save values
temporarily (of course the same happens with recursions, but then you do
not have to do it by yourself) and (that's the main problem) at this
point, you do not now, how many recursion levels will be there, so you
do not know also, how much avps/variables you need to save the stack.

With avp_pushto (as I understand the module doc) it is only possible to
push avps into sip-msg (r-uri/domain etc.). Or can you also use that
function to build something like a memory stack?

Cheers ;-)
Jasmin

> On Tuesday 30 March 2010, Jasmin Schnatterbeck wrote:
> > while thinking about the idea to build a recursive code block in
> > kamailio.cfg I noticed, that there are no route-specific avps available.
> > 
> > Of course you can convert a recursion to an iteration, but you need
> > something like a stack to save variables on it, which is not available
> > also.
> 
> Hi Jasmin,
> 
> i think you could load a few values into an AVP, and then use avp_pushto to 
> 'push' the value from this stack. 
>  
> > Do you think it's reasonable to make route specific avps available in
> > future releases?
> 
> If you want to use a route specific AVP, why its not possible for you to use 
> different AVPs for every route you have in the script?
> 
> > I also noticed, that it does not seem to be possible to get the number
> > of result rows of avp_db_query - may (in the case of an successful
> > query) can the function return the number of results for example?
> 
> The avp_db_query is a bit a deprecated function, take a look to the 'sqlops' 
> module, which provides a more advanced interface. I think it also export the 
> number of rows.
> 
> Cheers,
> 
> Henning