diff options
Diffstat (limited to 'db/foldermapper.php')
-rw-r--r-- | db/foldermapper.php | 23 |
1 files changed, 12 insertions, 11 deletions
diff --git a/db/foldermapper.php b/db/foldermapper.php index 017ccd0db..62ca09747 100644 --- a/db/foldermapper.php +++ b/db/foldermapper.php @@ -13,12 +13,13 @@ namespace OCA\News\Db; -use \OCA\News\Core\Db; - +use \OCP\IDb; +use \OCP\AppFramework\Db\Mapper; +use \OCP\AppFramework\Db\Entity; class FolderMapper extends Mapper implements IMapper { - public function __construct(Db $db) { + public function __construct(IDb $db) { parent::__construct($db, 'news_folders', '\OCA\News\Db\Folder'); } @@ -27,7 +28,7 @@ class FolderMapper extends Mapper implements IMapper { 'WHERE `id` = ? ' . 'AND `user_id` = ?'; - return $this->findEntity($sql, array($id, $userId)); + return $this->findEntity($sql, [$id, $userId]); } @@ -35,7 +36,7 @@ class FolderMapper extends Mapper implements IMapper { $sql = 'SELECT * FROM `*PREFIX*news_folders` ' . 'WHERE `user_id` = ? ' . 'AND `deleted_at` = 0'; - $params = array($userId); + $params = [$userId]; return $this->findEntities($sql, $params); } @@ -45,7 +46,7 @@ class FolderMapper extends Mapper implements IMapper { $sql = 'SELECT * FROM `*PREFIX*news_folders` ' . 'WHERE `name` = ? ' . 'AND `user_id` = ?'; - $params = array($folderName, $userId); + $params = [$folderName, $userId]; return $this->findEntities($sql, $params); } @@ -57,7 +58,7 @@ class FolderMapper extends Mapper implements IMapper { // someone please slap me for doing this manually :P // we needz CASCADE + FKs please $sql = 'DELETE FROM `*PREFIX*news_feeds` WHERE `folder_id` = ?'; - $params = array($entity->getId()); + $params = [$entity->getId()]; $this->execute($sql, $params); $sql = 'DELETE FROM `*PREFIX*news_items` WHERE `feed_id` NOT IN '. @@ -76,18 +77,18 @@ class FolderMapper extends Mapper implements IMapper { public function getToDelete($deleteOlderThan=null, $userId=null) { $sql = 'SELECT * FROM `*PREFIX*news_folders` ' . 'WHERE `deleted_at` > 0 '; - $params = array(); + $params = []; // sometimes we want to delete all entries if ($deleteOlderThan !== null) { $sql .= 'AND `deleted_at` < ? '; - array_push($params, $deleteOlderThan); + $params[] = $deleteOlderThan; } // we need to sometimes only delete feeds of a user if($userId !== null) { $sql .= 'AND `user_id` = ?'; - array_push($params, $userId); + $params[] = $userId; } return $this->findEntities($sql, $params); @@ -100,7 +101,7 @@ class FolderMapper extends Mapper implements IMapper { */ public function deleteUser($userId) { $sql = 'DELETE FROM `*PREFIX*news_folders` WHERE `user_id` = ?'; - $this->execute($sql, array($userId)); + $this->execute($sql, [$userId]); } |