On Nov 7, 2011, at 9:16 AM, Paul wrote:
> Michael Bayer <mike_mp <at> zzzcomputing.com> writes:
>>
>> 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)
>
> Thanks for the quick reply!
>
> One more quick question, how would I combine two of these like statements, if
> I
> just use 'and' between them I get 'TypeError: Boolean value of this clause is
> not defined'.
you'd use and_() :
http://www.sqlalchemy.org/docs/core/expression_api.html?highlight=and_#sqlalchemy.sql.expression.and_
>
>
>> 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 sqlalchemy <at> googlegroups.com.
>>> To unsubscribe from this group, send email to sqlalchemy+unsubscribe <at>
> 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 [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.
