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.
