diff options
author | Bernhard Posselt <dev@bernhard-posselt.com> | 2015-03-21 11:18:20 +0100 |
---|---|---|
committer | Bernhard Posselt <dev@bernhard-posselt.com> | 2015-03-21 13:36:50 +0100 |
commit | f6bf8ce402ed43c6a42354e64dda7b3cc081196f (patch) | |
tree | 8d3a7dd298d456d51516688824f2b08b4dc682cf /db/itemmapper.php | |
parent | 35550fe42e36868be1a3ac471bea6dc89b8b6200 (diff) |
add migrate command, fix #185
Diffstat (limited to 'db/itemmapper.php')
-rw-r--r-- | db/itemmapper.php | 14 |
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(); + } + + } |