From 3cf9484644dc5002b396eb31a2065456ce0de5b7 Mon Sep 17 00:00:00 2001
From: Frederic Guillot <fred@kanboard.net>
Date: Fri, 12 May 2017 16:26:11 -0400
Subject: Ensure project tags are removed when the project is removed (PR
 #3250)

---
 app/Model/ProjectModel.php | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'app/Model')

diff --git a/app/Model/ProjectModel.php b/app/Model/ProjectModel.php
index 7f489c75..7f55a9fb 100644
--- a/app/Model/ProjectModel.php
+++ b/app/Model/ProjectModel.php
@@ -462,7 +462,13 @@ class ProjectModel extends Base
      */
     public function remove($project_id)
     {
-        return $this->db->table(self::TABLE)->eq('id', $project_id)->remove();
+        $this->db->startTransaction();
+
+        $this->db->table(TagModel::TABLE)->eq('project_id', $project_id)->remove();
+        $result = $this->db->table(self::TABLE)->eq('id', $project_id)->remove();
+
+        $this->db->closeTransaction();
+        return $result;
     }
 
     /**
-- 
cgit v1.2.3