Re: [sqlalchemy] alembic.op.create_index algorithm=inplace lock=none

[murray . wasley]

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  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 .
> To post to this group, send email to sqlal...@googlegroups.com 
> .
> 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.

Re: [sqlalchemy] alembic.op.create_index algorithm=inplace lock=none

[Mike Bayer]

On 9/8/15 9:32 AM, murray.was...@lightspeedretail.com 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 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.


--
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.