Understanding type mapping in Psycopg2

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi

I am just starting to look at how to port the GeoTypes package to Psycopg2. 

I have read the explanation on the wiki about MicroProtocols and had a look at 
the adaptor PEP. I think I understand what is going on but I don't see how 
new adaptors are registered. The example "examples/useradapter.py" does not 
appear to be in psycopg-1.99.3.

The GeoTypes package makes use of the "psycopg.register_type()" mechanism to 
provide 'readers' for the PostGIS types and then uses classes for each of the 
PostGIS types that have __str__() methods that provide 'writers' when used as 
bound variables.

Presumably I would need to make my PostGIS python classes implement the 
ISQLQuote interface for them to work well in Psycopg2. I think is quite 
straightforward. But this only covers the 'writer' side, i.e. passing objects 
to execute() as bound variables. 

Are there any changes to the 'reader' side i.e. the nature of the parameters 
passed to "psycopg.register_type()"?

Many thanks

Richard



- -- 
QinetiQ                                  
B009 Woodward Building
St. Andrews Road
Malvern
Worcs WR14 3PS
Jabber: RichardTaylor-/eSpBmjxGS4dnm+yROfE0A@xxxxxxxxxxxxxxxx
PGPKey: http://search.keyserver.net:11371/pks/lookup?op=get&search=0xA7DA9FD9
Key fingerprint = D051 A121 E7C3 485F 3C0E  1593 ED9E D868 A7DA 9FD9
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFAdPrU7Z7YaKfan9kRAsAKAKCFcsS7Ck3s8Yylr39BkUJaRiJHcwCdE+N1
O29l7pH2hawxK7BEThbqlQU=
=qMln
-----END PGP SIGNATURE-----