News¶
Contents:
SQLObject 3.3.0¶
Released 7 May 2017.
Features¶
- Support for Python 2.6 is declared obsolete and will be removed in the next release.
Minor features¶
- Convert scripts repository to devscripts subdirectory. Some of thses scripts are version-dependent so it’s better to have them in the main repo.
- Test for __nonzero__ under Python 2, __bool__ under Python 3 in BoolCol.
Drivers (work in progress)¶
- Add support for PyODBC and PyPyODBC (pure-python ODBC DB API driver) for
MySQL, PostgreSQL and MS SQL. Driver names are
pyodbc
,pypyodbc
orodbc
(trypyodbc
andpypyodbc
). There are some problems with pyodbc and many problems with pypyodbc.
Documentation¶
- Stop updating http://sqlobject.readthedocs.org/ - it’s enough to have http://sqlobject.org/
Tests¶
- Run tests at Travis CI and AppVeyor with Python 3.6, x86 and x64.
- Stop running tests at Travis with Python 2.6.
- Stop running tests at AppVeyor with pymssql - too many timeouts and problems.
SQLObject 3.2.0¶
Released 11 Mar 2017.
Minor features¶
- Drop table name from
VACUUM
command in SQLiteConnection: SQLite doesn’t vacuum a single table and SQLite 3.15 uses the supplied name as the name of the attached database to vacuum. - Remove
driver
keyword from RdbhostConnection as it allows one driverrdbhdb
. - Add
driver
keyword for FirebirdConnection. Allowed values are ‘fdb’, ‘kinterbasdb’ and ‘pyfirebirdsql’. Default is to test ‘fdb’ and ‘kinterbasdb’ in that order. pyfirebirdsql is supported but has problems. - Add
driver
keyword for MySQLConnection. Allowed values are ‘mysqldb’, ‘connector’, ‘oursql’ and ‘pymysql’. Default is to test for mysqldb only. - Add support for MySQL Connector (pure python; binary packages are not at PyPI and hence are hard to install and test).
- Add support for oursql MySQL driver (only Python 2.6 and 2.7 until oursql author fixes Python 3 compatibility).
- Add support for PyMySQL - pure python mysql interface).
- Add parameter
timeout
for MSSQLConnection (usable only with pymssql driver); timeouts are in seconds. - Remove deprecated ez_setup.py.
Drivers (work in progress)¶
- Extend support for PyGreSQL driver. There are still some problems.
- Add support for py-postgresql PostgreSQL driver. There are still problems with the driver.
- Add support for pyfirebirdsql.There are still problems with the driver.
Bug fixes¶
- Fix MSSQLConnection.columnsFromSchema: remove ( and ) from default value.
- Fix MSSQLConnection and SybaseConnection: insert default values into a table with just one IDENTITY column.
- Remove excessive NULLs from
CREATE TABLE
for MSSQL/Sybase. - Fix concatenation operator for MSSQL/Sybase (it’s
+
, not||
). - Fix MSSQLConnection.server_version() under Py3 (decode version to str).
Documentation¶
- The docs are now generated with Sphinx.
- Move
docs/LICENSE
to the top-level directory so that Github recognizes it.
Tests¶
- Rename
py.test
->pytest
in tests and docs. - Great Renaming: fix
pytest
warnings by renamingTestXXX
classes toSOTestXXX
to preventpytest
to recognize them as test classes. - Fix
pytest
warnings by converting yield tests to plain calls: yield tests were deprecated inpytest
. - Tests are now run at CIs with Python 3.5.
- Drop
Circle CI
. - Run at Travis CI tests with Firebird backend (server version 2.5; drivers fdb and firebirdsql). There are problems with tests.
- Run tests at AppVeyor for windows testing. Run tests with MS SQL, MySQL, Postgres and SQLite backends; use Python 2.7, 3.4 and 3.5, x86 and x64. There are problems with MS SQL and MySQL.
SQLObject 3.1.0¶
Released 16 Aug 2016.
Features¶
- Add UuidCol.
- Add JsonbCol. Only for PostgreSQL. Requires psycopg2 >= 2.5.4 and PostgreSQL >= 9.2.
- Add JSONCol, a universal json column.
- For Python >= 3.4 minimal FormEncode version is now 1.3.1.
- If mxDateTime is in use, convert timedelta (returned by MySQL) to mxDateTime.Time.
Documentation¶
- Developer’s Guide is extended to explain SQLObject architecture and how to create a new column type.
- Fix URLs that can be found; remove missing links.
- Rename reStructuredText files from *.txt to *.rst.
Source code¶
- Fix all import * using https://github.com/zestyping/star-destroyer.
Tests¶
- Tests are now run at Circle CI.
- Use pytest-cov for test coverage. Report test coverage via coveralls.io and codecov.io.
- Install mxDateTime to run date/time tests with it.
SQLObject 3.0.0¶
Released 1 Jun 2016.
Features¶
- Support for Python 2 and Python 3 with one codebase! (Python version >= 3.4 currently required.)
Minor features¶
- PyDispatcher (>=2.0.4) was made an external dependency.
Development¶
- Source code was made flake8-clean.