Re: [Gnumed-devel] gmPG2

[Syan Tan]

what I remember of tomcat , web frameworks tend to 
pool database connection objects , and you can get a remote
proxy to a connection object through use of 
a Directory Service , like ldap; 
is there a way of setting the business of pycommon gmPG2
with an external acquired dbapi compliant connection, before using the
business objects ? (does the business objects depend on psycopg2 special
api ? I'm supposing psycopg2 doesn't allow for remote referenced connection
objects , or does it ?)


On Mon Feb  5 15:30 , Karsten Hilbert  sent:

>On Tue, Feb 06, 2007 at 12:47:54AM +1100, syan tan wrote:
>
>> what I was thinking, was to use an xmlrpcserver wrapped wrapper to hold 
>> a token keyed dictionary of connections. Whenever a method is called on
>> the server, e.g. find_patients( token, frag_names),  get_patient(token,
>> pat_id) would give a read-only  serializable recursed dict
>> object representing cPatient, and then have various update functions
>> on the server  e.g. update_item( token, pat_id, itempath, value);
>> another client runs as a separate process, that periodically calls 
>> an expire() function on server, which makes it checks the connection
>> dictionary, which is also stored with a last used time, and if the
>> current time - last used time exceeds a certain value, then 
>> the connection would be closed and the token removed from the
>> dictionary.
>> tokens are stored on the mod_python side , on any type of session
>> object, as they aren't active objects.
>> a logout, will also call expire(token), 
>Sounds quite involved.
>
>> I suppose all this stuff is probably why people shortcut and try to
>> fit in with  a web framework.
>Likely so.
>
>Karsten
>-- 
>GPG key ID E4071346 @ wwwkeys.pgp.net
>E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
>
>
>_______________________________________________
>Gnumed-devel mailing list
>address@hidden
>http://lists.gnu.org/mailman/listinfo/gnumed-devel