Hello, 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 maintain.
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 methods. Jamie _______________________________________________ DB-SIG maillist - [email protected] http://mail.python.org/mailman/listinfo/db-sig
