fixed in r6134.
On Jul 16, 2009, at 11:35 PM, mviamari wrote:
>
> I upgrade to 0.5.5 from 0.5.2 the other day and it broke a working
> query. I was simply querying the maximum year in my table, by
> extracting from the date column:
>
> query = session.query(extract('year', Order.date).label
> ('year')).distinct().subquery() <-- Exception raised here
>
> min = int(func.min(query.c.year).scalar())
> max = int(func.max(query.c.year).scalar())
>
> This worked exactly as I wanted when I ran it 0.5.2, however it broke
> when I upgraded to 0.5.5. I tried a couple of other releases, and it
> works in 0.5.3 but fails in 0.5.4 and above. Below is the stack trace
> and exception I get. BTW, I'm using postgres.
>
> db.queries.minMaxYr()
> Traceback (most recent call last):
> File "<stdin>", line 1, in <module>
> File "db/queries.py", line 96, in minMaxYr
> query = session.query(extract('year', Order.date).label
> ('year')).distinct().subquery()
> File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
> python2.6/site-packages/SQLAlchemy-0.5.5-py2.6.egg/sqlalchemy/orm/
> scoping.py", line 123, in do
> return getattr(self.registry(), name)(*args, **kwargs)
> File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
> python2.6/site-packages/SQLAlchemy-0.5.5-py2.6.egg/sqlalchemy/orm/
> session.py", line 895, in query
> return self._query_cls(entities, self, **kwargs)
> File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
> python2.6/site-packages/SQLAlchemy-0.5.5-py2.6.egg/sqlalchemy/orm/
> query.py", line 91, in __init__
> self._set_entities(entities)
> File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
> python2.6/site-packages/SQLAlchemy-0.5.5-py2.6.egg/sqlalchemy/orm/
> query.py", line 98, in _set_entities
> entity_wrapper(self, ent)
> File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
> python2.6/site-packages/SQLAlchemy-0.5.5-py2.6.egg/sqlalchemy/orm/
> query.py", line 2047, in __init__
> for elem in visitors.iterate(column, {})
> File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
> python2.6/site-packages/SQLAlchemy-0.5.5-py2.6.egg/sqlalchemy/
> util.py", line 762, in __init__
> self.update(d)
> File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
> python2.6/site-packages/SQLAlchemy-0.5.5-py2.6.egg/sqlalchemy/
> util.py", line 800, in update
> for i in iterable:
> File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
> python2.6/site-packages/SQLAlchemy-0.5.5-py2.6.egg/sqlalchemy/orm/
> query.py", line 2048, in <genexpr>
> if 'parententity' in elem._annotations
> AttributeError: 'str' object has no attribute '_annotations'
>
> Any help would be greatly appreciated.
>
> Thanks,
>
> Mike
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
