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.

Reply via email to