On 11/22/05 11:40, Klaus Darilion wrote:
To do not forget this issue:
We need a way to split the openserctl functionality into fifo commans
and direct DB commands.
- fifo comands are identical to all version
- DB commands need to be adopted to the database
Further, the DB part should be splitted into:
- SQL queries: here we should have identical SQL queries for all DBs.
Thus, having "standard" SQL queries (shouldn't be that hard)
- DB interface: This is the only part which differs. The respective
tools (psql, mysql ...) must be used and some functions require to
parse the output of the QSL queries.
Once we have the design, we can start to split the code.
Any proposals for the design?
Maybe the part with SQL queries and the functions required to parse the
output must be placed in the same file for specific database.
I am not sure if it works to make all these by including files or just
based on a Makefile to generate specific scripts for certain database.
Cheers,
Daniel
regards
klaus
Klaus Darilion wrote:
Daniel-Constantin Mierla wrote:
On 11/19/05 00:09, Klaus Darilion wrote:
do we have a postgres and dbtext version of serctl?
the dbtext version (sc.dbtext) has no support for fifo commands. For
postgres, there is a script in module's directory, but it might not
be functional. I think these scripts have to be modularized so
common parts to be reused.
Yes. But I do not know how this can be done easily. It is always a
mess. I ported serctl to postgres once, but keeping track with
changes in either of the files.
klaus
Cheers,
Daniel
klaus
Bogdan-Andrei Iancu wrote:
Hi Klaus,
should we have same change applied to postgres and dbtext version?
Just to keep consistency.....
regards,
bogdan
Klaus Darilion wrote:
User: klaus_darilion
Date: 2005/11/18 07:28:13 PST
OpenSER CVS - Commit Details
Modified files:
scripts sc Commit Log:
- added selective deleting of a contact:
ul rm <username> [<contact URI>].... delete user's UsrLoc entries
- fixed typo
Revision Changes Path
1.7 +24 -12 sip-server/scripts/sc
[
http://cvs.sourceforge.net/viewcvs.py/openser/sip-server/scripts/sc?r1=1.6&r2=1.7
]
_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel
_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel
_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel
_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel