Re: [sqlalchemy] How can I declare the 'row_format' and 'key_block_size' during table creation?

2014-02-16 Thread DoDo
Thank you very much for your reply. now, I find how to set these parameter correctly. So I place these parameter in __table_args__ and it works! __table_args__ = {'mysql_charset': 'utf8', 'mysql_engine': 'InnoDB', 'mysql_collate': 'utf8_general_ci', 'mysql_row_format': 'COM

Re: [sqlalchemy] How can I declare the 'row_format' and 'key_block_size' during table creation?

2014-02-15 Thread Michael Bayer
Guess this is MySQL. The MySQL dialect accepts open ended argument names within Table: t = Table('t', m, Column('q', Integer), mysql_key_block_size="50", mysql_row_format='COMPRESSED' ) e = create_engine("mysql://scott:tiger@localhost/test", echo=True) t.create(e) the doc

[sqlalchemy] How can I declare the 'row_format' and 'key_block_size' during table creation?

2014-02-15 Thread DoDo
Hello all, May I know the way to declare the 'row_foramt' and 'key_block_size' during table creation? The parameter I'd like to use: ROW_FORMAT=compressed KEY_BLOCK_SIZE=8 Thank you. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscr