[sqlalchemy] mysql dialect and contains

2013-04-17 Thread Randy Shults
Can't seem to find any reference to anyone else having this issue, so it must be something I'm doing incorrectly. In Mysql, the contains operator doesnt seem to be translated properly by the dialect. Docs state the following: contains(other, **kwargs)¶ Implement the ‘contains’

Re: [sqlalchemy] mysql dialect and contains

2013-04-17 Thread Randy Shults
t.c.x.contains(test).compile(dialect=mysql.dialect()) t.x LIKE '%%' || :x_1 || '%%' t.x LIKE concat(concat('%%', %s), '%%') On Apr 17, 2013, at 2:28 PM, Randy Shults randy.c...@gmail.comjavascript: wrote: Can't seem to find any reference to anyone else having this issue, so it must

Re: [sqlalchemy] mysql dialect and contains

2013-04-17 Thread Randy Shults
Thank you. That makes sense. On Wednesday, April 17, 2013 at 4:27 PM, Michael Bayer wrote: On Apr 17, 2013, at 3:37 PM, Randy Shults randy.c.shu...@gmail.com (mailto:randy.c.shu...@gmail.com) wrote: Awesome thank you. So even though the Table object is attached to the metadata

Re: [sqlalchemy] connecting to redshift

2013-02-26 Thread Randy Shults
Any reason this wouldnt work? (Disclaimer: Redshift is my first intro to postgre -- and I've never had a reason to use sqlalchemy before -- so this could be a really dumb question). Seems to connect and query fine...if this doesn't work -- please let me know why: def get_conn(): conn =

Re: [sqlalchemy] connecting to redshift

2013-02-26 Thread Randy Shults
sqlalchemy.sql.text() statements at the moment if that is at all relevant). On Tuesday, February 26, 2013 5:26:00 PM UTC-5, Michael Bayer wrote: On Feb 26, 2013, at 4:58 PM, Randy Shults randy.c...@gmail.comjavascript: wrote: Any reason this wouldnt work? (Disclaimer: Redshift is my