Re: [sqlalchemy] finding sqlalchemy jobs?

2013-09-27 Thread Iain Duncan
Thanks Michael, much appreciated! Iain On Fri, Sep 27, 2013 at 7:43 AM, Michael Bayer wrote: > I'll keep my ears open.Where I work we've taken on remote contractors > in the past but at the moment it's pretty tight. > > > On Sep 25, 2013, at 6:49 PM, Iain Duncan > wrote: > > Hi folks, apol

Re: [sqlalchemy] timing / profiling object loading ?

2013-09-27 Thread Jonathan Vanasco
funny- I never noticed the time column in pyramid_debugtoolbar -- I use it all the time ! i ended up doing a lot of my profiling outside of pyramid though. that's something i really love about sqlalchemy (and pyramid) - once the models were built, I could just import them into test scripts and

Re: [sqlalchemy] textcolumn.contains() escaping, the lack of icontains(), and possible bug?

2013-09-27 Thread Michael Bayer
On Sep 27, 2013, at 12:39 PM, Jonathan Vanasco wrote: > Any progress on considering: > > * icontains > * istartswith > * iendswith > > I ran into this again ( i had posted a similar request about a year or so ago > ) > > re "But then what do we do on a backend that doesn't have "ilike"? do w

RE: [sqlalchemy] timing / profiling object loading ?

2013-09-27 Thread Jeff Peck
On Thursday, September 26, 2013 11:58:26 AM UTC-4, Michael Bayer wrote: That's why I don't have a caching function included with SQLAlchemy. Because then I'd be debugging it, not you :) Ha! My caching is pretty lightweight. I do need to figure out a better system though -- that's for post

Re: [sqlalchemy] textcolumn.contains() escaping, the lack of icontains(), and possible bug?

2013-09-27 Thread Jonathan Vanasco
Any progress on considering: * icontains * istartswith * iendswith I ran into this again ( i had posted a similar request about a year or so ago ) re "But then what do we do on a backend that doesn't have "ilike"? do we raise an error? " would this be possible: .filter( User.name.icontain

Re: [sqlalchemy] Re: Sqlalchemy sintax for a query with "not like" operator

2013-09-27 Thread Ofir Herzas
Hi Luca, Keep in mind that contains will not map to 'like'. Hence if you want your query to have a 'like' clause, you'll have to use the 'like' method (the end result of 'contains' will be the same though as 'like' beginning and ending with a percent sign). On Sep 27, 2013 5:06 PM, "pyArchInit Arc

Re: [sqlalchemy] finding sqlalchemy jobs?

2013-09-27 Thread Michael Bayer
I'll keep my ears open.Where I work we've taken on remote contractors in the past but at the moment it's pretty tight. On Sep 25, 2013, at 6:49 PM, Iain Duncan wrote: > Hi folks, apologies for sounding spammy. I'm wondering if anyone has > suggestions on how to find remote work doing SQLA

[sqlalchemy] Re: Sqlalchemy sintax for a query with "not like" operator

2013-09-27 Thread pyArchInit ArcheoImagineers
Thanks a lot...sorry for my prevous post that I delete beacause I didn't undestand I must to use this ~ def test_not_like(self): Session = sessionmaker(bind=self.engine, autoflush=True, autocommit=True) session = Session() res = session.query(MAPPER).filter(and_(~MAPPER.field.contains('Value1'),

Re: [sqlalchemy] Sqlalchemy sintax for a query with "not like" operator

2013-09-27 Thread pyArchInit ArcheoImagineers
Sorry...I found my mistake: .c.sito.like.contains !!! I rewrote the function in this way: def test_not_like(self): Session = sessionmaker(bind=self.engine, autoflush=True, autocommit=True) session = Session() res = session.query(SITE).filter(SITE.sito.like('Sito%')) return res This return me pro

Re: [sqlalchemy] Sqlalchemy sintax for a query with "not like" operator

2013-09-27 Thread pyArchInit ArcheoImagineers
Hi, and thanks for reply. I try to use it but I make for sure a mistake: def test_not_like(self): self.table_name = 'site_table' Session = sessionmaker(bind=self.engine, autoflush=True, autocommit=True) session = Session() query = session.query(SITE) table = Table(self.table_name,self.metadata, a