split openserctl (was: Re: [Devel] CVS commitlog: sip-server/scripts sc)

[Daniel-Constantin Mierla]

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
>>>>>> Devel at openser.org
>>>>>> http://openser.org/cgi-bin/mailman/listinfo/devel
>>>>>>
>>>>>>  
>>>>>>
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> Devel mailing list
>>>> Devel at openser.org
>>>> http://openser.org/cgi-bin/mailman/listinfo/devel
>>>>
>>>
>>>
>>
>>
>> _______________________________________________
>> Devel mailing list
>> Devel at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/devel
>>
>>
>
>