CakePHP 2.0 - Testing InnoDB transactions while using schema importing - is this possible?

Hey everyone,

I'm trying to run some model tests using MySQL transactions. My model
uses an InnoDB table, so transactions are supported and do work in the
default database configuration. However, if I use the "schema
importing" feature for my test fixtures (very practical as schemas
change a lot during development), the table generated by the test
suite uses the "MEMORY" engine, which doesn't support transactions.
And obviously my tests fail.

If I disable schema importing by redefining all my fields in the
fixture specifying the "tableParameters" key, it does use InnoDB and
transactions do work as expected.

Is there a way to use schema importing but still specifying the InnoDB
engine?

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php