Re: [sqlalchemy] MySQL server has gone away

On Wed, Jun 15, 2016 at 7:27 AM, Jeffrey Yunes wrote: > Hi all, > After successful queries and a 10 minute wait, I'm getting the popular > "MySQL server has gone away." I have a single-threaded app and my > pool_recycle is way less than my wait_timeout. > > Do I need to create a

Re: [sqlalchemy] MySQL defining full text indexes and using MATCH AGAINST, SQLAlchemy way

On Sun, May 8, 2016 at 12:35 AM, Mike Bayer <mike...@zzzcomputing.com> wrote: > > > On Saturday, May 7, 2016, Dev Mukherjee <dev...@gmail.com> wrote: > >> >>> >>> >> If I create the full text and include multiple fields in the index >> &

Re: [sqlalchemy] MySQL defining full text indexes and using MATCH AGAINST, SQLAlchemy way

On Sat, May 7, 2016 at 12:48 AM, Mike Bayer <mike...@zzzcomputing.com> wrote: > > > On 05/06/2016 02:31 AM, Dev Mukherjee wrote: > >> On Thu, May 5, 2016 at 11:54 PM, Mike Bayer <mike...@zzzcomputing.com >> <mailto:mike...@zzzcomputing.com>> wrote: &g

Re: [sqlalchemy] MySQL defining full text indexes and using MATCH AGAINST, SQLAlchemy way

On Thu, May 5, 2016 at 11:54 PM, Mike Bayer wrote: > most expedient way would be to use CREATE INDEX and specify it within > DDL(): > > ddl = DDL("CREATE FULLTEXT INDEX some_idx ON table(colname)") > > you can then just invoke it: > > > conn.execute(ddl) > > Ah OK. That

[sqlalchemy] MySQL defining full text indexes and using MATCH AGAINST, SQLAlchemy way

Hi everyone, Is there a way of defining a MySQL FullText index via SQLAlchemy. We use the ORM layer to define all of our tables and use the *create_all* method provided by calling *declarative_base *to create our schema; and it would be nice to store it as part of the model definition. I have