On Thu, May 5, 2016 at 11:54 PM, Mike Bayer <[email protected]>
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
