[Serusers] Avpops'exported function

[Greger V. Teigre]

Yes, I know :-) We also use avpops for everything, and I still don't 
quite get the logic behind avpops...
Avpops will not likely disappear in the future; we know people used it 
for 0.9 (out of lack of something better). And if somebody using it 
wants to step forward and maintain it, I don't see why not.

Selects is not really that hard to understand, it is just a notation 
where a SIP message is seen as C/C++ struct called @ and where each 
header is the key. In addition, there are selects that can give you 
access to stuff not found in the SIP message, but that you cannot change.
What is missing is a good reference so you can quickly look up the 
select you need. As you may have seen, there is a project ongoing that 
will create a searchable documentation tool...
g-)

sip wrote:
> You know, Greger... it's statements like that that absolutely terrify 
> me away from trying to migrate our production setup to the new SER. :)
>
> We use avpops for just about EVERYthing. :)  And I still don't 
> understand the selects, though I've looked at them.
>
> Daunting, I tell you.
>
> N.
> *
> On Thu, 12 Apr 2007 21:09:59 +0200, Greger V. Teigre wrote*
> > Note that avpops is deprecated in upcoming SER 2.0  (still present, 
> but not maintained). Selects, avps and a couple of more powerful 
> modules take over.
> > See docs:
> > http://www.iptel.org/ser/doc/modules/avpops
> > You need an attribute column defined (in your dbscheme), which 
> should be identified in the second param to avp_db_delete.
> > g-)
> >
> > chungyu wrote:
>>
>> > Dear all:
>> >  avpops module' exported function avp_db_delete() can do delete one 
>> record?
>> >  
>> > example:
>> >            I use "test" as default table that has two fields.
>> >  
>> > username |  number
>> > -------------------
>> > bob      |  1
>> > alice    |  1
>> > bob      |  2
>> >  
>> > my configuration:
>> > modparam("avpops", "avp_url", "mysql://ser:heslo@localhost/ser")
>> > modparam("avpops", "avp_table", "test")
>> > modparam("avpops", "username_column", "username")
>> > modparam("avpops", "avp_aliases", "num=i:55")
>> > modparam("avpops", "db_scheme", 
>> "number_scheme:table=test;value_col=number;value_type=string")
>> >  
>> > if (method=="INVITE"){
>> >    avp_db_load("$from/username", "$num/$number_scheme");   //load 
>> from table "test" ,number column as string value into AVP name '$num'
>> >    avp_db_delete("$from/username", "s:test")      //delete all bob' 
>> record
>> > };
>> >  
>> > if bob calling then bob'record has deleted
>> >  
>> > username  |  number
>> > --------------------
>> > alice     |  1
>> >  
>> > But i want delete a record.
>> > ex: delete number value is 1 for bob
>> >  
>> > username  |  number
>> > --------------------
>> > alice     |   1
>> > ---------------------
>> > bob       |   2
>> >  
>> > avp_db_delete() can do delete one record?
>> >  
>> > Another question is avp_db_store() can do insert new data in table?
>> >  
>> > ex:  insert into test (username,number) values ("mary","3")
>> >  
>> > username  |  number
>> > -------------------
>> > alice     |    1
>> > -------------------
>> > bob       |    2
>> > -------------------
>> > mary      |    3
>> >  
>> > avp_db_store() can do it?
>> >  
>> > sorry,I still can't understand what it mean about avp_db_store() 
>> and avp_db_delete().
>> > Can tell me?
>> > Thanks a lot in advance
>> >  
>> > Chungyu
>> >  
>> >
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Serusers mailing 
>> list
>> Serusers at lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>>   
>>     
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20070413/7c18fda7/attachment.htm>