[sqlalchemy] Re: Searching in all fields

2008-06-27 Thread Bobby Impollonia
If you do them as double percent signs ( '%%') then the python string formatting will replace them with single percent signs. On Fri, Jun 27, 2008 at 9:12 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi. I want to do robust algorithm for searching in tables...the simplest example is with

[sqlalchemy] Re: Searching in all fields

2008-06-27 Thread az
what is multisearch? sort of patternmatching? http://www.sqlalchemy.org/docs/05/ormtutorial.html#datamapping_querying_common query(A).filter( or_( A.c1.startswith(), A.c2.endswith(), A.c3.like('%alabal%'), ... )) u can generate the arguments of or_(...) On Friday 27 June

[sqlalchemy] Re: Searching in all fields

2008-06-27 Thread [EMAIL PROTECTED]
1) multisearch... I meant, that i want to create piece of code, that will automaticly search in all columns of a table So if I can use this function (or whatever it will be) for different tables with no change.. for example: I have a client(table) with address(related table one-to-one) and

[sqlalchemy] Re: Searching in all fields

2008-06-27 Thread az
On Friday 27 June 2008 16:55:22 [EMAIL PROTECTED] wrote: 1) multisearch... I meant, that i want to create piece of code, that will automaticly search in all columns of a table So if I can use this function (or whatever it will be) for different tables with no change.. for example: I