Re: [sqlalchemy] Many to many association record orphaned when deleting parent of parent of relation

2014-02-15 Thread Jay Pipes
Thank you Michael. Yes, that is indeed the case if I delete an object via session.delete(). Unfortunately, it seems that if I execute the DELETE manually against the table in question, that the delete does not cascade, as shown by this code: http://paste.openstack.org/show/66005/ Does this mea

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

[sqlalchemy] Announcement: SQLAlchemy dialect for EXASOL available on github

2014-02-15 Thread jank
I just released a dialect for the EXASOL database on github: https://github.com/BY-jk/sqlalchemy_exasol under 2-clause BSD license. I have not done an upload to PyPi yet, still waiting for feedback on three minor issues. Jan -- You received this message because you are subscribed to the Googl