what result do you get with :

>>> [obj.my_column for obj in
Session.query(Model).filter_by(my_column=123).all()]

?

Le 25/07/2012 07:17, Amos a écrit :
>
> I've defined a column declaratively like so
>
> my_column = Column(Unicode(30), index=True, unique=True)
>
> If I pass in an integer instead of a string, it will actually return
> all records that start with the string representation of that integer
>
> >>> [obj.code for obj in
> Session.query(Model).filter_by(my_column=123).all()]
>
> [u'123ad', u'123lpb', u'123xd8', u'123za0']
>
> I would expect no results as no column exactly matches the string
> representation of my number
>
> -- 
> You received this message because you are subscribed to the Google
> Groups "sqlalchemy" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/sqlalchemy/-/mGMKZ0NB9_AJ.
> 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.


-- 
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.

Reply via email to