It works!
Thanks,
Godfryd
On Friday, July 26, 2013 4:31:54 PM UTC+2, Michael Bayer wrote:
>
> these keywords aren't built into the mysql options at the moment so here
> is a @compiles recipe:
>
> from sqlalchemy import *
> from sqlalchemy.schema import CreateTable
> from sqlalchemy.ext.compiler import compiles
>
> @compiles(CreateTable, "mysql")
> def add_partition_scheme(element, compiler, **kw):
> table = element.element
> partition_by = table.kwargs.pop("mysql_partition_by", None)
> partitions = table.kwargs.pop("mysql_partitions", None)
>
> ddl = compiler.visit_create_table(element, **kw)
> ddl = ddl.rstrip()
>
> if partition_by:
> ddl += "\nPARTITION BY %s" % partition_by
> table.kwargs['mysql_partition_by'] = partition_by
> if partitions:
> ddl += "\nPARTITIONS %s" % partitions
> table.kwargs['mysql_partitions'] = partitions
>
> return ddl
>
> m = MetaData()
>
> t = Table('ti', m,
> Column('id', Integer),
> Column('amount', DECIMAL(7, 2)),
> Column('tr_date', Date),
> mysql_engine='InnoDB',
> mysql_partition_by='HASH( MONTH(tr_date) )',
> mysql_partitions='6'
> )
>
> e = create_engine("mysql://scott:tiger@localhost/test", echo=True)
> t.create(e)
>
>
>
> On Jul 26, 2013, at 7:00 AM, Michal Nowikowski
> <[email protected]<javascript:>>
> wrote:
>
> Hello,
>
> MySQL supports partitioning:
> http://dev.mysql.com/doc/refman/5.5/en/partitioning-overview.html
> It requires special CREATE TABLE statement.
>
> Is it possible to make use of this partitioning in SA?
> How to do this?
>
> Regards,
> Godfryd
>
>
> --
> 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] <javascript:>.
> To post to this group, send email to [email protected]<javascript:>
> .
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>
--
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/groups/opt_out.
