[Devel] CVS commitlog: sip-server/scripts sc

[Klaus Darilion]

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?

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
> 
>