Module ezsqlobject

A Convenience layer for SQLObject

Provides easy access to existing databases, without having to creats python classes mimicking the database schema.

Abstracts a database into an object with an attribute called 'tables', and which on accessing any existing table as an attribute, returns an SQLObject subclass for that table (with an attribute 'columns', listing the table's columns).

 >>> import sqlobj
 >>> db = sqlobj.mysqlobj(db='test', user='test', passwd='test')
 >>> print db.tables
 ['address', 'people']
 >>> addr = db.address
 >>> print addr.columns
 ['street', 'suburb', 'city', 'phone']
 >>> pps = db.people.select()
 >>> for p in pps: print p
 <people 1 first='fred' last='daggg' age=34L>
 <people 2 first='mary' last='smith' age=27L>
 <people 3 first='adam' last='jones' age=42L>
 <people 4 first='jane' last='doe' age=35L>