Re: [SQLObject] Table parameters

2008-11-07 Thread Oleg Broytmann
On Fri, Nov 07, 2008 at 04:22:52PM -0500, Brian Long wrote: > On Fri, Nov 7, 2008 at 4:14 PM, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > > class MyTable(SQLObject): > > class sqlmeta: > > tableParamSQL = {'mysql': 'ENGINE InnoDB'} > > This looks like the right thing to add to SQLObject

Re: [SQLObject] Table parameters

2008-11-07 Thread Brian Long
On Fri, Nov 7, 2008 at 4:14 PM, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Sat, Nov 08, 2008 at 12:01:07AM +0300, Oleg Broytmann wrote: >> class MyTable(SQLObject): >>class sqlmeta: >> tableParamSQL = 'ENGINE InnoDB' > > Or adapting the idea from createSQL: > > class MyTable(SQLObje

Re: [SQLObject] Table parameters

2008-11-07 Thread Oleg Broytmann
On Sat, Nov 08, 2008 at 12:01:07AM +0300, Oleg Broytmann wrote: > class MyTable(SQLObject): >class sqlmeta: > tableParamSQL = 'ENGINE InnoDB' Or adapting the idea from createSQL: class MyTable(SQLObject): class sqlmeta: tableParamSQL = {'mysql': 'ENGINE InnoDB'} Oleg. --

Re: [SQLObject] Table parameters

2008-11-07 Thread Oleg Broytmann
On Fri, Nov 07, 2008 at 11:47:40PM +0300, Oleg Broytmann wrote: >IWBN for SQLObject to grow a concept of table > parameters. Now when I thought about it for a few minutes I see both the API and the implementation would be very simple: class MyTable(SQLObject): class sqlmeta: table

Re: [SQLObject] Table parameters (Cascade, MySQL, InnoDB)

2008-11-07 Thread Oleg Broytmann
On Fri, Nov 07, 2008 at 03:04:03PM -0500, Brian Long wrote: > Since the sqlmeta createSQL code gets run after table creation, > specifying "ALTER TABLE foo ENGINE InnoDB" runs after the foreign key > constraint was created. This means I have to re-construct / re-add > the constraint inside createS