[OpenSIPS-Users] Sqlops in opensips ?

[Alex Massover]

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<mailto: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> [mailto: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<mailto: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<mailto: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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090528/d54a5712/attachment-0001.htm