[OpenSIPS-Users] Sqlops in opensips ?

[Brett Nemeroff]

It's been a while since I've needed this but I think gflags + avpops might
be slightly more elegant. YMMV.
I'm not sure what the overheard to calling a perl function is (however i
hear with the perl mod, it's very fast). I'd love to hear feedback on
this....

-Brett


On Thu, May 28, 2009 at 1:42 AM, Alex Massover <alex at jajah.com> wrote:

>  Not exactly, but something like this is possible – the script will run on
> every INVITE transaction, but it will do a query only once at first run
> (once per every process/child).
>
>
>
> You run a perl script for example on every INVITE, inside the script you
> have something like:
>
>
>
>
>
> our $query_result;
>
> unless(defined($query_result))
>
> {
>
>                 $query_result=………  #run your query here
>
> }
>
> #pass your query result to avp values or whatever
>
>
>
>
>
>
>
> The $query_result will be stored in the memory.
>
>
>
> --
>
> Best Regards,
>
> Alex Massover
>
> VoIP R&D TL
>
> Jajah Inc.
>
> *From:* Sharath [mailto:sharath.kumar79 at gmail.com]
> *Sent:* Thursday, May 28, 2009 1:38 AM
> *To:* Alex Massover
> *Cc:* users at lists.opensips.org
> *Subject:* Re: [OpenSIPS-Users] Sqlops in opensips ?
>
>
>
> Is it possible to load *custom values from a database from a custom table
> during init time. Am I correct in assuming the AVPops module is scoped only
> for a call within a transaction ? Can the perl module be used to make a db
> query at init time ?
>
> thanks for answering.
> -Sharath
>
> On Wed, May 27, 2009 at 7:46 AM, Alex Massover <alex at jajah.com> wrote:
>
>
>
> I think perl module is most practical for you.
>
>
>
> --
>
> Best Regards,
>
> Alex Massover
>
> VoIP R&D TL
>
> Jajah Inc.
>
> *From:* users-bounces at lists.opensips.org [mailto:
> users-bounces at lists.opensips.org] *On Behalf Of *Sharath
> *Sent:* Wednesday, May 27, 2009 12:42 AM
> *To:* users at lists.opensips.org
> *Subject:* [OpenSIPS-Users] Sqlops in opensips ?
>
>
>
> hello,
>
>
> Is there any module equivalent to sqlops of openser in opensips ? Basically
> I want to run sql queries from proprietary tables and use them in the route
> script file.
>
> thank you
> -Sharath
>
> This mail was received via Mail-SeCure System.
>
>
>
> This mail was sent via Mail-SeCure System.
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>
>
>
> This mail was received via Mail-SeCure System.
>
>
> This mail was sent via Mail-SeCure System.
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090528/221ddc8c/attachment.htm