thanks Michael, exactly the path I took ... cheers
On Tuesday, September 8, 2015 at 12:04:58 PM UTC-4, Michael Bayer wrote:
>
>
>
> On 9/8/15 9:32 AM, murray...@lightspeedretail.com <javascript:> 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:
>
> CREATE INDEX [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 sqlalchemy+...@googlegroups.com <javascript:>.
> To post to this group, send email to sqlal...@googlegroups.com
> <javascript:>.
> 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 sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
