SQLObject
SQLObject is an object-relational mapper, i.e., a library that will wrap your database tables in Python classes, and your rows in Python instances. It currently supports MySQL through the 'MySQLdb' package, PostgreSQL through the 'psycopg' package, SQLite, Firebird, MaxDB (SAP DB), MS SQL, and Sybase. It should support Python versions back to 2.2.
| Tags | Database Software Development Libraries Python Modules |
|---|---|
| Licenses | LGPL |
| Operating Systems | OS Independent |
| Implementation | Python |
Recent releases
- 18 May 2009 20:55
Changes: Better support for Python 2.6: this release does not import the deprecated sets module. Two bugs in SQLiteConnection.columnsFromSchema() were fixed: using sqlmeta.idName instead of 'id'; and converting the default 'NULL' to None. sqlmeta.idName is used instead of 'id' in all connection classes. A bug that prevented overriding per-class _connection if there is an sqlhub.processConnection has been fixed.
- 18 May 2009 20:55
Changes: Two bugs in SQLiteConnection.columnsFromSchema() were fixed: this release uses sqlmeta.idName instead of 'id'; and converts the default 'NULL' to None. It uses sqlmeta.idName instead of 'id' in all connection classes. It fixes a bug that prevented it from overriding per-class _connection if there was an sqlhub.processConnection.
- 06 May 2009 16:01
Changes: SQLObject now requires FormEncode version 1.1.1+. A Unicode-related tweak was made in MySQLConnection. A minor bug was fixed in creating a DecimalValidator. A bug was fixed in InheritableIteration. A bug was fixed in PostgresConnection.columnsFromSchema(): foreign keys are now created as ForeignKeys. Bugs in PostgresConnection and MSSQLConnection related to properties were fixed. Transaction instances now explicitly raise TypeError on close(). A bug in SQLiteConnection.columnsFromSchema() that led to an infinite loop was fixed. A bug where limit doesn't work in sqlbuilder.Select was fixed.
- 06 May 2009 15:59
Changes: SQLObject now requires FormEncode version 1.1.1+. Another Unicode-related tweak was made in MySQLConnection. A minor bug was fixed in creating a DecimalValidator. A bug was fixed in InheritableIteration. A bug was fixed in PostgresConnection.columnsFromSchema(): foreign keys are now created as ForeignKeys. Bugs in PostgresConnection and MSSQLConnection related to properties were fixed. Transaction instances now explicitly raise TypeError on close(). A bug in SQLiteConnection.columnsFromSchema() that led to an infinite loop was fixed.
- 08 Dec 2008 19:13
Changes: createSQL constrains generation has been fixed under MySQL when the table's name includes the database's name (contains a dot).
