[Serusers] Avpops'exported function

[Greger V. Teigre]

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/20070412/fca6044b/attachment.htm>