From 4ce35659094ed4df43ad41a198a2944aeced9784 Mon Sep 17 00:00:00 2001
From: Alessandro Cosentino <cosenal@gmail.com>
Date: Tue, 17 Jul 2012 21:49:38 -0400
Subject: update feeds works; need to be polished

---
 lib/feedmapper.php | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

(limited to 'lib')

diff --git a/lib/feedmapper.php b/lib/feedmapper.php
index c43ff47a5..80afcb481 100644
--- a/lib/feedmapper.php
+++ b/lib/feedmapper.php
@@ -16,6 +16,27 @@
 class OC_News_FeedMapper {
 
 	const tableName = '*PREFIX*news_feeds';
+
+	/**
+	 * @brief 
+	 * @param userid 
+	 * @returns  
+	 */
+	public function findAll($userid){
+		$stmt = OCP\DB::prepare('SELECT * FROM ' . self::tableName . 
+					' JOIN ' . OC_News_FolderMapper::tableName . 
+					' ON ' . self::tableName. '.folder_id=' . OC_News_FolderMapper::tableName . '.id' .
+					' WHERE user_id = ?');
+		$result = $stmt->execute(array($userid));
+		$feeds = array();
+		while ($row = $result->fetchRow()) {
+			$url = $row['url'];
+			$id = $row['id'];
+			$folderid = $row['folder_id'];
+			$feeds[] = array("url" => $url, "id" => $id, "folderid" => $folderid);
+		}
+		return $feeds;
+	}
 	
 	/**
 	 * @brief Retrieve a feed from the database
-- 
cgit v1.2.3