Transactions and afterDelete

Question

Transactions and afterDelete

EPauli Dec '15

Created Dec '15	Last Reply Dec '15	Replies 1	Views 335	Votes 1

EPauli 1.0k

Dec '15

I want to use transactions to avoid data loss on (for example) SQL fails. This works good with:

$this->db->begin();
if($user->delete() == false) {
    $this->db->rollback();
}

.. other SQL statements ..

$this->db->commit();

When one of the queries failed, the record is still in the database, as expected. But there is one problem. The model I want to delete has a relation. The related model has an afterDelete() function that delete files from the server. The files are also deleted when the transaction failed and is rolled back, so the afterDelete function is also called when the transaction failed. How can I avoid this?

1

Boris Delev · Answer 1 · 2015-12-16T15:09:23-07:00

Interesting... i was thinking rollback do all needs and didnt go to afterDelete method. I will check and reply. (can u give mi an example what sql fail could be?)

EPauli · Answer 2 · 2015-12-25T13:34:15-07:00

I didn't work on this project for some days. It can be hard to test a SQL transaction in a framework I think. So I did a test with a syntax error in one of the queries.

$this->db->begin();
if($user->delete() == false) {
    $this->db->rollback();
}

$robots = $this->db->fetchAll("UPDATE robots SET field = value WHERE id 9");
if(!$robots) {
    $this->db->rollback();
}

$this->db->commit();

The robots query failed and everything is rolled back. So the database is ok, but the afterDelete function is executed. Or is this a bad test?