sure it does, if you convert it to a SQL token first:
literal("C:\test\testfile.txt").like(Table.path + "%")
or even
literal("C:\test\testfile.txt").startswith(Table.path)
On Nov 7, 2011, at 8:40 AM, Paul wrote:
> I'm trying to do a like statement in a query filter. I'm fine doing it one way
> for instance
>
> session.query(Table).filter(Table.path.like("C:\Test\%"))
>
> which would hopefully return all folders and files in the folder Test
>
> but what if I want to do it the other way around and pass
> "C:\Test\testfile.txt"
> and return all the folders. I want something like
> "C:\Test\testfile.txt".like(Table.path+"%") but obviously a string wont have
> the
> method like.
>
> is there a function I can import that takes 2 arguements or another method I
> can
> use to achieve this?
>
> Thanks!
>
> Paul
>
>
>
> --
> 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.
>
--
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.
