On Thu, May 5, 2016 at 11:54 PM, Mike Bayer <mike...@zzzcomputing.com> 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 will ensure that we don't miss out on creating the indexes. I did find your post on Stackoverflow answering the same question http://stackoverflow.com/questions/14971619/proper-use-of-mysql-full-text-search-with-sqlalchemy Been querying like so session.query(myapp.models.Customer).filter(text("MATCH(name) AGAINST (\"[:value]\" IN BOOLEAN MODE)", bindparams=[bindparam("value", ["+Anomaly", "+soft"])])).all() Can I make this better or this should get me out of trouble for now? > > or add it as a table event > > > event.listen(table, "after_create", ddl) > > we can of course add an option to the MySQL dialect to allow > "mysql_fulltext=True" to Index as well. > > > Would love to see that added to SQLAlchemy :-) Be possible for you to provide a wrapper for the MATCH and AGAINST functions as well? Thanks heaps for sparing your time. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.