Kinda lame I could not find that I should have known
Thanks!
On Dec 9, 2011, at 16:01 , Michael Bayer wrote:
>
> On Dec 9, 2011, at 5:28 AM, Martijn Moeling wrote:
>
>> Hi,
>>
>> I'm puzzled on how to get this working:
>>
>>
>> class User(base):
>> Id = Column (Integer, primarykey=true)
>> Name = Column(Unicode(100))
>>
>>
>> Session.query(User).filter(User.Name.like(query+"%")).all()
>>
>> is all fine.
>>
>> now I want to add an extension to the query, which does the same within Id
>> and returns all results where the Id field is searched as a string too
>>
>> like
>>
>> Session.query(User).filter(or_(User.Name.like("%"+query+"%"),
>> str(User.Id).like(query+"%")).all()
>>
>>
>> ^^^^
>> example data:
>>
>>
>> 1, "martijn 1"
>> 2, "martijn 2"
>> ….
>> 100,"martijn 100"
>>
>>
>>
>> searching for "1" will find all records with Id's -> 1,11,12…., 19, 100
>> and records with a "1" somewhere in the name.
>>
>> there must be a way, right?
>
> you'd use cast() for this, representing the SQL CAST expression:
>
> http://www.sqlalchemy.org/docs/core/expression_api.html?highlight=cast#sqlalchemy.sql.expression.cast
>
>
>
>
>>
>> Martijn
>>
>> --
>> 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.
>>
>
> --
> 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.
>
--
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.
