[SQL-CVS] SQLObject/docs News.txt,1.8,1.9

[<ian...@us...>]

Update of /cvsroot/sqlobject/SQLObject/docs
In directory sc8-pr-cvs1:/tmp/cvs-serv13345

Modified Files:
	News.txt 
Log Message:
Added notes for 0.5


Index: News.txt
===================================================================
RCS file: /cvsroot/sqlobject/SQLObject/docs/News.txt,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** News.txt	26 Jun 2003 08:34:38 -0000	1.8
--- News.txt	1 Nov 2003 19:54:28 -0000	1.9
***************
*** 8,11 ****
--- 8,67 ----
  .. _start:
  
+ SQLObject 0.5
+ =============
+ 
+ Features
+ --------
+ 
+ * Firebird_ support.
+ 
+ * Database-specific literal quoting (motivation: MySQL and Postgres
+   use backslashes, Firebird and SQLite do not).
+ 
+ * Generic conversion/validation can be added to columns.
+ 
+ * BoolCol for portable boolean columns (BOOL on Postgres, INT on
+   MySQL, etc.)
+ 
+ * Non-integer IDs.  (Automatic table creation is not supported for
+   non-integer IDs)
+ * Explicit IDs for new instances/rows (required for non-integer IDs).
+ * Instances can be synced with the database (in case there have been
+   updates to the object since it was first fetched).
+ * Instances can be expired, so that they will be synced when they are
+   next accessed.
+ 
+ .. _Firebird: http://firebird.sourceforge.net/
+ 
+ Bugs
+ ----
+ 
+ * Released all locks with ``finally:``, so that bugs won't cause
+   frozen locks.
+ * Tons of transaction fixes.  Transactions pretty much work.
+ * A class can have multiple foreign keys pointing to the same table
+   (e.g., ``spouse = ForeignKey("Person"); supervisor =
+   ForeignKey("Person")``)
+ 
+ Changed Usage Notes
+ -------------------
+ 
+ * `SQLBuilder.sqlRepr` renamed to `SQLBuilder.sqlrepr`, signature
+   changed to ``sqlrepr(value, databaseName)`` to quote ``value``,
+   where ``databaseName`` is one of ``"mysql"``, ``"postgres"``,
+   ``"sqlite"``, ``"firebird"``.
+ 
+ * ``sqlRepr`` magic method renamed to ``__sqlrepr__``, and takes new
+   ``databaseName`` argument.
+ 
+ * When using explicit booleans, use ``Col.TRUE`` and ``Col.FALSE`` for
+   backward compatibility with Python 2.2.  This is not required for
+   ``BoolCol``, however (which converts all true values to TRUE and
+   false values to FALSE)
+ 
+ * SQLObject has a ``sqlrepr`` method, so you can construct queries
+   with something like ``"WHERE last_name = %s" %
+   Person.sqlrepr('Bob')``
+ 
  SQLObject 0.4
  =============