[sqlalchemy] Re: RLIKE, REGEXP

2007-10-21 Thread Michael Bayer
On Oct 21, 2007, at 7:20 PM, iain duncan wrote: > > On Sun, 2007-21-10 at 17:12 -0400, Michael Bayer wrote: >> >> On Oct 21, 2007, at 4:36 PM, Paul Johnston wrote: >> >>> >>> Hi, >>> Resource.select_by( foo="bar" ) >>> Untested, but I reckon this will work: >>> >>> Resource.query.

[sqlalchemy] Re: RLIKE, REGEXP

2007-10-21 Thread iain duncan
On Sun, 2007-21-10 at 17:12 -0400, Michael Bayer wrote: > > On Oct 21, 2007, at 4:36 PM, Paul Johnston wrote: > > > > > Hi, > > > >> Resource.select_by( foo="bar" ) > >> > >> > > Untested, but I reckon this will work: > > > > Resource.query.filter(Resource.foo.op('rlike')('bar')) > > > > might

[sqlalchemy] Re: RLIKE, REGEXP

2007-10-21 Thread Michael Bayer
On Oct 21, 2007, at 4:36 PM, Paul Johnston wrote: > > Hi, > >> Resource.select_by( foo="bar" ) >> >> > Untested, but I reckon this will work: > > Resource.query.filter(Resource.foo.op('rlike')('bar')) > might need to call op() off the Table instance for now, might not have added op() to the c

[sqlalchemy] Re: RLIKE, REGEXP

2007-10-21 Thread Paul Johnston
Hi, >Resource.select_by( foo="bar" ) > > Untested, but I reckon this will work: Resource.query.filter(Resource.foo.op('rlike')('bar')) Paul --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To

[sqlalchemy] Re: RLIKE, REGEXP

2007-10-21 Thread iain duncan
On Wed, 2007-10-10 at 16:41 -0700, jason kirtland wrote: > Jim Musil wrote: > > I don't see support for RLIKE, NOT RLIKE, or REGEXP anywhere. > > > > Is there support for this? > > Yes, you can use these operators and any others via the .op() method: > >table.c.col1.op('rlike')('re') >n

[sqlalchemy] Re: vote for Python - PLEASE!

2007-10-21 Thread iain duncan
On Fri, 2007-19-10 at 17:06 -0700, Monty Taylor wrote: > Daniel Haus wrote: > > Looks like you're frighteningly successful. You're right, python could > > use much more love, but look at this! Obviously the poll is not > > representative anymore, is it... > > Yeah - a little skewed there. > > On