[DB-SIG] pygresql class field auto-generation

James Saker jsaker at americanrelay.com
Fri Jul 29 22:28:55 CEST 2005


I've been working with pygresql succesfully through a project that has a need 
for classes to mirror my postgresql tables while operating (it's a customer 
billing project). To this point, I've manually created classes like customer, 
product, subscription all manually by mirroring the structure of the 
postgresql table in a static class definition of the same name. Then I've 
built methods to initialize the objects after testing for valid criteria 
(e.g. valid integer value customer ID of ten digits before querying the 
database and populating the customer object). The real downside is that this 
takes forever, is terribly static and rather time consuming to build and 

Having read some of pg.DB's capabilities like get_attnames(table), and looking 
at a psycopg recipe with some similar capabilities, I was curious if anyone 
knew if a good pygresql class recipe I can inherit from that would provide 
this mechanism of getting all the attributes and automatically generating the 
object's attributes to match, along with other useful insertion/query 


More information about the DB-SIG mailing list