What's new in SQLObject 2.1.3
Jul 27, 2015
- Minor refactoring to pave the way to Python 3 was merged from SQLObject 1.6.7.
New in SQLObject 2.1.0 (Jan 16, 2015)
- 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.
New in SQLObject 1.5.0 (Oct 7, 2013)
- 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.
New in SQLObject 1.4.0 (May 18, 2013)
- 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.
New in SQLObject 1.2.0 (Nov 21, 2011)
- 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.
New in SQLObject 1.1.2 (Aug 9, 2011)
- A bug was fixed in SelectResults slicing that prevented you from slicing a slice (for example, my_results[:20][1:5]).
New in SQLObject 0.12.2 (Mar 4, 2010)
- Bugfixes ported from SQLObject 0.11.4.
New in SQLObject 0.10.6 (May 19, 2009)
- Better support for Python 2.6: do not import the deprecated sets module.
- A number of changes ported from SQLObject 0.9.11.
New in SQLObject 0.10.4 (Dec 9, 2008)
- createSQL constrains generation has been fixed under MySQL when the table's name includes the database's name (contains a dot).
New in SQLObject 0.10.3 (Dec 1, 2008)
- 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.