Author: ianb
Date: 2005-08-28 07:57:01 +0000 (Sun, 28 Aug 2005)
New Revision: 964
Modified:
SQLObject/trunk/docs/News.txt
Log:
Updated news for 0.7 release
Modified: SQLObject/trunk/docs/News.txt
===================================================================
--- SQLObject/trunk/docs/News.txt 2005-08-28 04:44:45 UTC (rev 963)
+++ SQLObject/trunk/docs/News.txt 2005-08-28 07:57:01 UTC (rev 964)
@@ -10,13 +10,69 @@
SQLObject 0.7.0
===============
-Features
---------
+Features & Interface
+--------------------
* Inheritance. See Inheritance.html_
.. _Inheritance.html: Inheritance.html
+* Date/time validators, converters, tests.
+
+* Both `mxDateTime
+ <http://www.egenix.com/files/python/mxDateTime.html>`_ and `datetime
+ <http://python.org/doc/current/lib/module-datetime.html>`_ supported
+ for ``DateTimeCol``.
+
+* Added ``BLOBCol``, for binary data.
+
+* Added ``PickleCol``, to transparently pickle and unpickle data from
+ column.
+
+* New `documented reflection interface
+ <http://sqlobject.org/docs/interface.py.html>`_, using the new
+ ``.sqlmeta`` class/instance. Most special attributes that started
+ with ``_`` were moved into ``sqlmeta`` (with leading underscore
+ removed).
+
+* New aggregate functions for select results, like
+ ``cls.select().max(columnName)``: ``.max()``, ``.min()``,
+ ``.avg()``.
+
+* ``ConnectionHub`` aka ``sqlhub`` (@@: Needs documentation)
+
+* Command-line client `sqlobject-admin
+ <http://sqlobject.org/docs/sqlobject-admin.html>`_.
+
+* ``StringCol`` has ``char_binary`` attribute, for explicit case
+ handling in MySQL.
+
+* Various joins now supported (LEFT, RIGHT, STRAIGHT, INNER, OUTER,
+ CROSS): see `documentation
+ <http://sqlobject.org/docs/SQLObject.html#left-join-and-other-joins>`_.
+ Aliases for joining a table with itself.
+
+* Subqueries/subselects (`see docs
+ <http://sqlobject.org/docs/SQLObject.html#subqueries-subselects>`_).
+
+* Select results support ``.filter(extra_query)``
+
+* ``SQLMultipleJoin`` and ``SQLRelatedJoin``, like ``MultipleJoin``
+ and ``RelatedJoin``, except return select results (@@: Document).
+
+* `SingleJoin
+ <http://sqlobject.org/docs/SQLObject.html#singlejoin-one-to-one>`_.
+
+* Columns retain their order from the class definition to table
+ creation.
+
+* SQLObject now depends on the `FormEncode <http://formencode.org>`_
+ library, and internal conversion/validation is done through
+ FormEncode (was previously using old fork of FormEncode).
+
+* Column instances can have attributes set on them (generally for
+ annotating columns with extra data).
+
Other Changes
-------------
@@ -27,6 +83,72 @@
the method ``lazyIter``, used like ``for obj in
MyClass.select().lazyIter(): ...``.
+* Test framework now uses `py.test
+ <http://codespeak.net/py/current/doc/test.html>`_.
+
+* SQLObject now uses a simpler metaclass
+ (``sqlobject.declarative.DeclarativeMeta``).
+
+* autoCommit and queryIns ?? (@@: expand)
+
+* Deprecation (@@: document)
+
+* Use `setuptools
+ <http://peak.telecommunity.com/DevCenter/setuptools>`_ for packaging
+ and installation.
+
+Small Features
+--------------
+
+* ``IntValidator`` for testing ``IntCol`` inputs.
+
+* Base style (``sqlobject.styles.Style``) is now a usable no-op style.
+
+* SQLite in-memory databases allowed with ``sqlite:/:memory:``
+
+* Keyword parameters allowed to ``connectionForURI`` (like
+ ``debug=True``).
+
+* More parameters passed to MySQL connections (unix_socket,
+ named_pipe, init_command, read_default_file, read_default_group,
+ connect_time, compress, named_pipe, use_unicode, client_flag,
+ local_infile).
+
+* ``DateTimeCol.now`` is a function for producing the current date,
+ using whatever date/time module you are using (good for use as a
+ default).
+
+* Inherited classes fetched more efficiently (fewer queries).
+
+* Decimal converter to create `decimal objects
+ <http://python.org/doc/current/lib/module-decimal.html>`_.
+
+* Repository rearranged (now in
+ ``http://svn.colorstudy.com/SQLObject/trunk``).
+
+Bug Fixes
+---------
+
+* Tables with no columns can work. Why would you have a table without
+ a column? We do not know, we try only to serve.
+
+* Sybase ``_fromDatabase`` fixed.
+
+* Various fixes to support most recent ``MySQLdb`` adapter, and
+ ``pysqlite`` adapters.
+
+* URI parsing improved, including Windows paths (for use with SQLite).
+
+* ``selectBy(column=None)`` creates ``IS NULL`` query.
+
+* ``selectBy(foreignKey=value)`` now supported (not just selecting by
+ foreign key ID).
+
+* ``cascade='null'`` wasn't working properly (was cascading all
+ deletes, not nullifying!).
+
+* Lots of other bug fixes.
+
SQLObject 0.6.1
===============
|