On 9/8/15 9:32 AM, [email protected] wrote:
Hi there,
Is there any way I can set additional params on
alembic.op.create_index. We are using python and MYSQL.
Need to add :
algorithm=inplace
lock=none
trying to produce:
CREATEINDEX[index_name]ON[table_name]
([index_fields])*algorithm**=inplace lock=**none*;
NOTE: I have tried passing them in via **kwargs but was not able to
use mysql_algorithm or mysql_lock, did not recognize those keywords.
op.create_index( index_name, table_name, columns, schema=None,
unique=unique, quote=None, **kwargs)
Any assistance would be greatly appreciated.
simply render the text directly using op.execute():
op.execute("CREATE INDEX [index_name] ON [table_name] ([index_fields])
algorithm=inplace lock=none")
Cheers
Murray
--
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 http://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 http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.