add migrate command, fix #185

1 files changed, 13 insertions, 1 deletions

diff --git a/db/itemmapper.php b/db/itemmapper.php
index ef86e551a..d68b1fbec 100644
--- a/db/itemmapper.php
+++ b/db/itemmapper.php
@@ -13,7 +13,7 @@
 
 namespace OCA\News\Db;
 
-use \OCP\IDBConnection;
+use OCP\IDBConnection;
 
 
 class ItemMapper extends NewsMapper {
@@ -328,4 +328,16 @@ class ItemMapper extends NewsMapper {
     }
 
 
+    /**
+     * Returns a list of ids and userid of all items
+     */
+    public function findAllItemIdsAndUsers() {
+        $sql = 'SELECT `items`.`id`, `feeds`.`user_id` ' .
+                'FROM `*PREFIX*news_items` `items` ' .
+                'JOIN `*PREFIX*news_feeds` `feeds` ' .
+                    'ON `items`.`feed_id` = `feeds`.`id`';
+        return $this->execute($sql)->fetchAll();
+    }
+
+
 }