fix referential integrity

1 files changed, 12 insertions, 0 deletions

diff --git a/db/feedmapper.php b/db/feedmapper.php
index 22f71d7a3..05fa729b4 100644
--- a/db/feedmapper.php
+++ b/db/feedmapper.php
@@ -27,6 +27,8 @@ namespace OCA\News\Db;
 
 use \OCA\AppFramework\Core\API;
 use \OCA\AppFramework\Db\Mapper;
+use \OCA\AppFramework\Db\Entity;
+
 
 class FeedMapper extends Mapper implements IMapper {
 
@@ -95,7 +97,17 @@ class FeedMapper extends Mapper implements IMapper {
 		$feed->fromRow($row);
 
 		return $feed;
+	}
+
+
+	public function delete(Entity $entity){
+		parent::delete($entity);
 
+		// someone please slap me for doing this manually :P
+		// we needz CASCADE + FKs please
+		$sql = 'DELETE FROM `*PREFIX*news_items` WHERE `feed_id` = ?';
+		$params = array($entity->getId());
+		$this->execute($sql, $params);
 	}
 
 }
\ No newline at end of file