[Devel] [ openser-Feature Requests-1581172 ] table names for ACC module

[SourceForge.net]

Feature Requests item #1581172, was opened at 2006-10-20 13:54
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743023&aid=1581172&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Victor Gamov (vitspec)
Assigned to: Nobody/Anonymous (nobody)
Summary: table names for ACC module

Initial Comment:
ACC module utilize only one table `acc' to save
accounting info now.

But it's may be very useful in some situations (to
produce CDR-records periodically for example) if we can
write accounting info into different tables changed
periodically by the time principle.

I propose to use meta-characters in table-name
parameter for this purpose. We can use meta-characters
like strftime() for example, so if we have something like 

modparam("acc", "db_table_acc", "myacc_table-%Y-%m-%d")

in config file then we will get one accounting table
per day.

One complexity which I see now -- we must have CREATE
TABLE statement in OpenSER.  But if OpenSER write
accounting into some external database.table (not
default openser.acc) external process can create this
table or (more correctly) we can have one more ACC
module parameter like "db_table_acc_create" and use it
as SQL statement to create table.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743023&aid=1581172&group_id=139143