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