SQLObject

Randall Smith wrote:
> I have something working, though now at easy as I would have liked.  It
> involves explicitly creating a class for the intermediate table.  The
> unit_models method looks like this:
> 
> Sorry my email client is wrapping lines.
> 
> ComplexGroup(SQLObject):
>     ...
>     def _get_unit_models(self):
>         join1 = INNERJOINOn(None, ComplexUnitModel,
>                             UnitModel.q.id ==
> ComplexUnitModel.q.unit_modelID)
>         join2 = INNERJOINOn(None, Complex,
>                             Complex.q.id == ComplexUnitModel.q.complexID)
>         join3 = INNERJOINOn(None, ComplexGroup,
>                             Complex.q.complex_groupID == ComplexGroup.q.id)
>         join = (join1, join2, join3)
>         return UnitModel.select(ComplexGroup.q.id == self.id, join=join)
> 
> I'm having to use the current dev version of SQLObject because version 7
> puts commas between the INNER JOIN statements.
> 
> If you've got a better way, especially one that does not explicitly
> reference the intermediate table, let me know.

If you look inside the join itself you can use intermediateTable to get
the table name.

In 0.8 with the new joins you can almost do:

class ComplexGroup(SQLObject):
    complexes = OneToMany('Complex')
    def _get_unit_models(self):
        q = self.complexes & Complex.unit_models
        return UnitModel.select(q)

class Complex(SQLObject):
    unit_models = ManyToMany('UnitModel')


But Complex.unit_models doesn't work right.  I think I have to add a
__sqlrepr__ method to SOManyToMany and SOOneToMany joins.  I've been
meaning to try this out, so I'm going to write up a test on this and see
if I can make it work.

-- 
Ian Bicking  |  ianb@...  |  http://blog.ianbicking.org

Hi,

I've developped a script working pretty fine on my laptop using Apache
1.x and Postgres 7.4 with sqlobject 7-RC1 and psycopg 1.1.21-3
(Debian/Sid).

The following line does working on my laptop does not work on another
computer running Apache 2.x, Postgres 8 with sqlobject 7-RC1 and psycopg
1.1.21-2 (Debian/Etch).


self.data =3D self.table.select()
if filterCol:
  logger.debug(filterCol)
  logger.debug(filterString)
  self.data =3D self.data.filter(getattr(self.table.q,filterCol) =3D=3D
filterString)
  logger.debug(self.data.count())

I'm just filtering my result dataset on a column.

The error output is the following when calling with filterCol=3Dposte and
filterString=3DLibramont from my web application :

Template traceback (most recent call last):

Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/albatross/app.py", line 284, in ru=
n
    self.display_response(ctx)
  File "/usr/lib/python2.3/site-packages/albatross/app.py", line 520, in di=
splay_response
    func(ctx)
  File "/var/www/pameseb/webapp.py", line 81, in page_display
    self.dbobject.getAll(sort=3Dctx.locals._sort,filterCol=3Dgetattr(ctx.lo=
cals, 'filter_col', None),filterString=3Dgetattr(ctx.locals, 'filter_string=
', None))
  File "/var/www/pameseb/config/webconfig.py", line 65, in getAll
    logger.debug(self.data.count())
  File "/var/www/pameseb/sqlobject/sresults.py", line 182, in count
    count =3D self.accumulate('COUNT(*)')
  File "/var/www/pameseb/sqlobject/sresults.py", line 166, in accumulate
    return conn.accumulateSelect(self, *expressions)
  File "/var/www/pameseb/sqlobject/dbconnection.py", line 379, in accumulat=
eSelect
    q =3D self._addWhereClause(select, q, limit=3D0, order=3D0)
  File "/var/www/pameseb/sqlobject/dbconnection.py", line 451, in _addWhere=
Clause
    q =3D self.sqlrepr(q)
  File "/var/www/pameseb/sqlobject/dbconnection.py", line 644, in sqlrepr
    return sqlrepr(v, self.dbName)
  File "/var/www/pameseb/sqlobject/converters.py", line 215, in sqlrepr
    return reprFunc(db)
  File "/var/www/pameseb/sqlobject/sqlbuilder.py", line 228, in __sqlrepr__
    return "(%s %s %s)" % (sqlrepr(self.expr1, db), self.op, sqlrepr(self.e=
xpr2, db))
  File "/var/www/pameseb/sqlobject/converters.py", line 215, in sqlrepr
    return reprFunc(db)
  File "/var/www/pameseb/sqlobject/sqlbuilder.py", line 228, in __sqlrepr__
    return "(%s %s %s)" % (sqlrepr(self.expr1, db), self.op, sqlrepr(self.e=
xpr2, db))
  File "/var/www/pameseb/sqlobject/converters.py", line 211, in sqlrepr
    raise ValueError, "Unknown SQL builtin type: %s for %s" % \
ValueError: Unknown SQL builtin type: <class 'mod_python.util.StringField'>=
 for 'Libramont'


It must be a problem of version but what problem ?

Do someone have an idea on that ?

Thank you very much in advance.

Didrik