[SQLObject] My patch for CVS version, and a bug I've found in 0.4rc1

[G. <fra...@cl...>]

> > 
> > There's several things that have changed since 0.3 -- it would be
> > helpful to do this against CVS instead.

Done, see attached diff file

> > It's very helpful if you include a unit test for any new features --
> > this is more important to me than supporting all the databases.

I haven't yet include tests yet. I'm sorry about that, but I promise there will be some in the next days.

----------------------------------------------------------------------------------------

I also found a bug I hadn't with release 0.3 : on a table with multiple foreign keys from the same table, SQLObject raise a value at definition time, i.e while parsing the class :

Traceback (most recent call last):
  File "BDDGen.py", line 75, in ?
    class Demande(SQLObject):
  File "/usr/lib/python2.2/site-packages/SQLObject/SQLObject.py", line 233, in __new__
    newClass.addColumn(column)
  File "/usr/lib/python2.2/site-packages/SQLObject/SQLObject.py", line 503, in addColumn
    '_SO_class_%s' % column.foreignKey)
  File "/usr/lib/python2.2/site-packages/SQLObject/SQLObject.py", line 102, in addNeedSet
    getattr(obj, attr)(cls)
  File "/usr/lib/python2.2/site-packages/SQLObject/SQLObject.py", line 404, in __new__
    val._init(id, connection, selectResults)
  File "/usr/lib/python2.2/site-packages/SQLObject/SQLObject.py", line 662, in _init
    selectResults = (connection or self._connection)._SO_selectOne(self, dbNames)
  File "/usr/lib/python2.2/site-packages/SQLObject/DBConnection.py", line 266, in _SO_selectOne
    return self.queryOne("SELECT %s FROM %s WHERE %s = %s" %
  File "/usr/lib/python2.2/site-packages/SQLObject/SQLBuilder.py", line 126, in sqlRepr
    raise ValueError, "Unknown SQL builtin type: %s for %s" % \
ValueError: Unknown SQL builtin type: <class 'SQLObject.SQLObject.MetaSQLObject'> for <class '__main__.Labo'>

my cols are defined like this : 

	Col('userID', dbName='user', foreignKey='Labo'),
	Col('couserID', dbName='couser', foreignKey='Labo'),

I've to work around, but the only way I've found now is not to use the foreignKey :(