SQLObject

SQLObject was built around a custom Python query language that provides an easy to use and easy to understand syntax for running various SQL commands.

The SQLObject query language is basically a set of ready-made Python functions that abstract basic SQL commands.

These functions allow developers to use a Python-like markup when writing their database operations, making it easier to embed in their native Python without exposing sensitive database information via the used raw SQL commands.

Using SQLObject forces a developer to use Python-only commands when interacting with its database, greatly improving the security of database operations.

Because of this flexible syntax, SQLObject can also abstract the underlying database engine, using the same syntax for multiple databases and handling the differences in the background.

This makes it super easy to write cross-database compatible applications that can easily be ported or scaled from one database to another with the change of only a few settings.

What is new in this release:

• DateTimeCol and TimeCol can read and write values with microseconds.

What is new in version 2.1.0:

• DateTimeCol and TimeCol can read and write values with microseconds.

What is new in version 1.5.0:

• 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.

What is new in version 1.3.1:

• Two bugfixes from bugs ported from `SQLObject 1.2.3`_.

What is new in version 1.2.2:

• A bugfix was ported from `SQLObject 1.1.5`_.

What is new in version 1.2.0:

• Strings are treated specially in Select to allow Select(['id, 'name'], where='value = 42'). Update allows a string in WHERE.
• ForeignKey('Table', refColumn='refcol_id') to allow ForeignKey to point to a non-id column; the referred column must be a unique integer column.
• delColumn now accepts a ForeignKey's name without 'ID'.
• Support for PostgreSQL 7.* is dropped. The minimal supported version of PostgreSQL is 8.1 now.
• Quoting rules changed for PostgreSQL: SQLObject uses E'' escape string if the string contains characters escaped with backslash.
• A bug caused by psycopg2 recently added a new boolean not callable autocommit attribute was fixed.
• sqlobject.__doc__ and main.__doc__ no longer contain version number. Use sqlobject.version or version_info.

What is new in version 1.1.3:

• A bugfix was ported from `SQLObject 1.0.3`_.

What is new in version 1.1.1:

• Parsing sqlobject.__doc__ for version number is declared obsolete. Use sqlobject.version or version_info.
• Documented sqlmeta.dbEncoding and connection.dbEncoding.

What is new in version 1.0.1:

• A syntax incompatibility was fixed in SQLiteConnection that prevented SQLObject to be used with Python 2.4.

What is new in version 1.0.0:

• Major API change: DB URI parser was changed to use urllib.split*() and unquote(). This means any username/password/path are allowed in DB URIs if they are properly %-encoded, and DB URIs are automatically unquoted.
• A new module ``__version__.py`` was added. New variables ``version`` (string) and ``version_info`` (5-tuple: major, minor, micro, release level, serial) are imported into ``sqlobject`` namespace.
• In SQLite, id columns are made AUTOINCREMENT.
• Parameter ``backend`` in DB URI is no longer supported, use parameter ``driver``.