SQLObject 0.8.3

[Oleg Broytmann]

Hello!

I'm pleased to announce the 0.8.3 release of SQLObject.


What is SQLObject
=============== ==

SQLObject is an object-relational mapper. Your database tables are described
as classes, and rows are instances of those classes. SQLObject is meant to be
easy to use and quick to get started with.

SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite, and
Firebird. It also has newly added support for Sybase, MSSQL and MaxDB (also
known as SAPDB).


Where is SQLObject
=============== ===

Site:

http://sqlobject.org

Development:

http://sqlobject.org/devel/

Mailing list:

https://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss

Archives:

http://news.gmane.org/gmane.comp.python.sqlobject

Download:

http://cheeseshop.python.org/pypi/SQLObject/0.8.3

News and changes:

http://sqlobject.org/News.html

What's New
==========

News since 0.8.2
----------------

Bug Fixes
---------

* Fixed a longstanding bug with .select() ignoring 'limit' parameter.

* Fixed a bug with absent comma in JOINs.

* Fixed sqlbuilder - .startswith(), .endswith() and .contains() assumed
their parameter must be a string; now you can pass an SQLExpression:
Table.q.name.co ntains(func.upp er('a')), for example.

* Fixed a longstanding bug in sqlbuilder.Sele ct() with groupBy being a
sequence.

* Fixed a bug with Aliases in JOINs.

* Yet another patch to properly initialize MySQL connection encoding.

* Fixed a minor comparison problem in test_decimal.py .

Docs
----

* Added documentation about 'validator' Col constructor option.

* Added an answer and examples to the FAQ on how to use sqlmeta.createS QL.

* More documentation about orderBy.

For a more complete list, please see the news:

http://sqlobject.org/News.html

Oleg.
--
Oleg Broytmann http://phd.pp.ru/ phd@phd.pp.ru
Programmers don't die, they just GOSUB without RETURN.

[Jorge Godoy]

Re: SQLObject 0.8.3

Oleg Broytmann <phd@phd.pp.ruw rites:

* Fixed sqlbuilder - .startswith(), .endswith() and .contains() assumed
their parameter must be a string; now you can pass an SQLExpression:
Table.q.name.co ntains(func.upp er('a')), for example.

Oleg,


this made me think: is it possible to call a function in a schema other
than public in PostgreSQL? For example if I had myschema.myfunc tion and
wanted to use it I can't do "func.myschema. myfunction"... Is there
something like a "dbName" for func? :-)


--
Jorge Godoy <jgodoy@gmail.c om>