Is it possible to wrap a mapper insert in a transaction?

[Matt Darby]

Hello

I'm using the SQL mapper to insert a number of records that I want to wrap in a single commit scope. However the mapper actions seem to ignore the rollback in my test code:

$db->begin();

$f3->set('mapper',new mapper($db,'my_table'));

$f3->get('mapper')->copyFrom($someData);

$f3->get('mapper')->insert();

$db->rollback();

Running snipper above a record is inserted. 

Does the mapper support a transaction scope?

Matt

[ved]

Try it like this:

$f3->set('mapper',new mapper($db,'my_table'));

$db->begin();

[Matt Darby]

Thanks for the response but the result is still the same.

[ved]

Hi,

Does it work as intended if you replace the mapper calls with equivalent exec(raw sql)?

Not exactly sure if the data mappers support transactions but I was under the impression that they did.

[xfra35]

Hi,

The mapper does support transactions. But not all engines support it.

For example, if you're using MySQL, MyISAM storage engine doesn't support transactions, while InnoDB does.

[Matt Darby]

Many thanks for that - spot on.