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)
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.
On 05/05/2016 02:09 AM, Dev Mukherjee wrote:
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 found many Stackoverflow posts on partial solutions to this and
was wondering if there's a SQLAlchemy way? e.g using a function generator.
Any pointers would be appreciated.
Thanks for 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]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
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.
