SQLObject

SQLObject is a widely used, freely distributed and open source ORM (Object Relational Manager), also known as database wrapper, implemented in Python and designed to be used as an object interface to a database, with tables as classes, columns as attributes and rows as instances.

The software comes with a Python-object-based query language, which will be used by develoopers to provide considerable database independence to all applications, as well as to make SQL more abstract.

Supports all major database servers/engines

Another interesting feature of the SQLObject project, is that it supports all major database servers and database engines, including the well known MySQL, PostgreSQL, Firebird, SQLite, Microsoft SQL Server, MaxDB (SAPDB), and Sybase. It is compatible with both Python 2.6 or 2.7 programming languages.

Mandatory example

The following lines of code will show Python/SQL developers who the SQLObject software works...

>>> from sqlobject import *

>>> Person.createTable()

...as well as how you should use the object...

>>> p = Person(fname="John", lname="Doe")

>>> p is p2

True

Runs on any operating system supported by Python

Being written in Python, SQLObject is cross-platform, supported on all operating systems where Python 2.6 and Python 2.7 are available, including all GNU/Linux distributions, as well as the Microsoft Windows and Mac OS X OSes.

It easy easily installable from either its source package, using the ‘sudo python setup.py install’ command in the root folder, or easy_install, using the ‘easy_install -U SQLObject’ command, in a terminal emulator application.

The software has been successfully tested with computers supporting either of the 32 or 64-bit instruction set architectures. For more details, please check its official website (see the homepage link below).

What is new in this release:

• Minor refactoring to pave the way to Python 3 was merged from SQLObject 1.6.7.

What is new in version 2.1.0:

• Minor features:
• In queries generated with SQLObject's tables columns are sorted in the order they are declared in the table.
• In queries generated with sqlbuilder's Insert/Update, if values are passed using dictionaries, columns are sorted alphabetically.
• Tables in SELECT...FROM clause are sorted alphabetically.
• MySQLConnection, PostgresConnection and SQLiteConnection have got a new method listDatabases() that lists databases in the connection and returns a list of names.
• MySQLConnection, PostgresConnection and SQLiteConnection have got a new method listTables() that returns a list of table names in the database.

What is new in version 1.5.0:

• Features & Interface:
• Helpers for class Outer were changed to lookup columns in table's declarations.
• Support for Python 2.4 is declared obsolete and will be removed in the next release.
• Minor features:
• When a PostgresConnection raises an exception the instance has code/error attributes copied from psycopg2's pgcode/pgerror attributes.
• Encode unicode enum values to str.
• Removed setDeprecationLevel from the list of public functions.
• A number of fixes for tests.
• Bugfixes:
• A bug was fixed in DBConnection.close(); close() doesn't raise an UnboundLocalError if connection pool is empty.
• Fixed parameters for pymssql.
• Documentation:
• GNU LGPL text was added as docs/LICENSE file.
• Old FSF address was changed to the new one.

What is new in version 1.4.0:

• PostgresConnection was optimized.
• SQLObject now uses INSERT...RETURNING id to get the autoincremented ID in one query instead of two (INSERT + SELECT id) (PostgreSQL 8.2 required).
• SQLObject now generates NCHAR/NVARCHAR and N''-quoted strings for MS SQL.

What is new in version 1.2.0:

• Strings are treated specially in Select to allow Select(['id, 'name'], where='value = 42').
• ForeignKey('Table', refColumn='refcol_id') allows ForeignKey to point to a non-id column.
• Support for PostgreSQL 7.* is dropped; the minimal supported version of PostgreSQL is 8.1.
• Quoting rules have changed for PostgreSQL: SQLObject uses the E'' escape string.
• A bug caused by psycopg2 recently adding a new Boolean non-callable autocommit attribute was fixed.
• sqlobject.__doc__ and main.__doc__ no longer contain the version number: use sqlobject.version or version_info.

What is new in version 1.1.2:

• A bug was fixed in SelectResults slicing that prevented you from slicing a slice (for example, my_results[:20][1:5]).

What is new in version 0.12.2:

• Bugfixes ported from SQLObject 0.11.4.

What is new in version 0.10.6:

• Better support for Python 2.6: do not import the deprecated sets module.
• A number of changes ported from SQLObject 0.9.11.

What is new in version 0.10.4:

• createSQL constrains generation has been fixed under MySQL when the table's name includes the database's name (contains a dot).

What is new in version 0.10.3:

• Changed interpretation of strings in the DB URI for boolean parameters: '0', 'no', 'off' and 'false' are now interpreted as False.
• Fixed a bug with incorrect handling of calls like connectionForURI(dburi, cache=False) when dburi already contains some parameters in the URI.
• Convert decimal.to_eng_string() to str to work around a bug in Python 2.5.2; see http://mail.python.org/pipermail/python-dev/2008-March/078189.html
• Added test_default_style.py.
• Fixed a minor bug in SQLiteConnection that fails to parse Enum columns.

Requirements:

• Python