On Saturday 17 May 2008 17:53:42 Eric Abrahamsen wrote:
> Hi there,
>
> I'm new to this, so please be patient if I'm a little slow... I'm
> trying to filter Article objects by a datetime field ('pubdate'),
> and expected that I would be able to do something like this:
>
> arts = sess.query(Article).filter(and_(Article.pubdate.year==year,
> Article.pubdate.month==month, Article.id==id)).one()
>
> This gives me:
> AttributeError: 'InstrumentedAttribute' object has no attribute
> 'year'
>
> Apparently methods on attributes are reserved for sqlalchemy
> internals, and I'm not working with a straight Python object, as
> I'd thought. That makes sense, but can anyone suggest a simple
> substitute for what I'm trying to do here?
it's SQL that is not working with python objects, and the column
pubdate (associated with type DateTime on python side) has no
attr .year or .month.
lookup the messages in the group, there were some sugestions long time
ago, but AFAIremember one was something with strings, another with
separate columns.
wishlist suggestion: how about type-related attributes on columns,
using which will autogenerate some expr off that column?
e.g. select( mytable.c.mydate.year == '1998') to automagicaly yield
something like func.substr(mytable.c.mydate,1,4)) == '1998'
(supposing the type of mydate stores datetime as yyyymmdd string)
ciao
svil
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
