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