30 Mar
2010
30 Mar
'10
8:53 a.m.
Hi list,
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.
Do you think it's reasonable to make route specific avps available in
future releases?
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?
Thank you very much...
Jasmin
30 Mar
30 Mar
10:02 a.m.
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
31 Mar
31 Mar
4:52 a.m.
Am 30.03.2010 16:02, schrieb Henning Westerholt:
Indeed,
http://sip-router.org/docbook/sip-router/branch/master/modules_k/sqlops/sql…
regards
klaus
On Tuesday 30 March 2010, Jasmin Schnatterbeck wrote:
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.
2 Apr
2 Apr
11:07 a.m.
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
6 Apr
6 Apr
6:38 a.m.
On Friday 02 April 2010, Jasmin Schnatterbeck wrote:
I use the function sql_query() instead of avp_db_query
now, works
perfectly...
Hello Jasmin,
good. :)
Regarding the route specific AVPs the idea is to make
it possible to
have something like "private" variables (compared with e.g. c-code).
There are a number of different variables available, like the ones from
htable, the shared memory variable '$shv', the $var and of course the $avp.
The $var is specific to every process, so they have a smaller visibility
compared to the others, which are global or transactional usable.
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?
My explanation was probably a bit unclear. I think you could use AVPs as a
list, storing different values serially in in _one_ $avp, and then loop over
it, use and delete the head variable. Something as described here:
http://www.kamailio.org/dokuwiki/doku.php/tutorials:avpops#serial_forking
(avp_write was removed in the past, you can assign values directly in the cfg)
Regards,
Henning
5383
days inactive
5390
days old
4 comments
3 participants
participants (3)
-
Henning Westerholt -
Jasmin Schnatterbeck -
Klaus Darilion