summaryrefslogtreecommitdiffstats
path: root/lib/feedmapper.php
diff options
context:
space:
mode:
authorGregor Tätzner <gregor@freenet.de>2012-08-03 18:25:46 +0200
committerGregor Tätzner <gregor@freenet.de>2012-08-03 18:25:46 +0200
commitfbcac103cf685326f5a873760998672c7f93f039 (patch)
tree5fcdf361a0e90bf2195e9fed5352e80ebfa9bd7d /lib/feedmapper.php
parent58824771f2bc86f912d39e6485a70ee489bc262a (diff)
Fixed several issues in delete folder functions
Diffstat (limited to 'lib/feedmapper.php')
-rw-r--r--lib/feedmapper.php56
1 files changed, 28 insertions, 28 deletions
diff --git a/lib/feedmapper.php b/lib/feedmapper.php
index 6e3f6080d..274b28bb8 100644
--- a/lib/feedmapper.php
+++ b/lib/feedmapper.php
@@ -4,10 +4,10 @@
*
* @author Alessandro Cosentino
* Copyright (c) 2012 - Alessandro Cosentino <cosenal@gmail.com>
-*
+*
* This file is licensed under the Affero General Public License version 3 or later.
* See the COPYING-README file
-*
+*
*/
/**
@@ -26,7 +26,7 @@ class OC_News_FeedMapper {
}
/**
- * @brief
+ * @brief
* @param row a row from the feeds table of the database
* @returns an object of the class OC_News_Feed
*/
@@ -34,9 +34,9 @@ class OC_News_FeedMapper {
}
/**
- * @brief
- * @param userid
- * @returns
+ * @brief
+ * @param userid
+ * @returns
*/
public function findAll(){
$stmt = OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE user_id = ?');
@@ -50,11 +50,11 @@ class OC_News_FeedMapper {
}
return $feeds;
}
-
+
/**
* @brief Retrieve a feed from the database
* @param id The id of the feed in the database table.
- * @returns
+ * @returns
*/
public function findById($id){
$stmt = OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE id = ?');
@@ -69,7 +69,7 @@ class OC_News_FeedMapper {
/**
* @brief Retrieve a feed from the database
* @param id The id of the feed in the database table.
- * @returns
+ * @returns
*/
public function findByFolderId($folderid){
$stmt = OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE folder_id = ?');
@@ -81,17 +81,17 @@ class OC_News_FeedMapper {
$id = $row['id'];
$feed = new OC_News_Feed($url, $title, null, $id);
$favicon = $row['favicon_link'];
- $feed->setFavicon($favicon);
+ $feed->setFavicon($favicon);
$feeds[] = $feed;
}
return $feeds;
}
-
+
/**
* @brief Retrieve a feed and all its items from the database
* @param id The id of the feed in the database table.
- * @returns
+ * @returns
*/
public function findWithItems($id){
$stmt = OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE id = ?');
@@ -101,19 +101,19 @@ class OC_News_FeedMapper {
$title = $row['title'];
$feed = new OC_News_Feed($url, $title, null,$id);
$favicon = $row['favicon_link'];
- $feed->setFavicon($favicon);
+ $feed->setFavicon($favicon);
$itemMapper = new OC_News_ItemMapper();
$items = $itemMapper->findAll($id);
$feed->setItems($items);
-
+
return $feed;
}
/**
* @brief Find the id of a feed and all its items from the database
* @param url url of the feed
- * @return id of the feed corresponding to the url passed as parameters
- * null - if there is no such feed
+ * @return id of the feed corresponding to the url passed as parameters
+ * null - if there is no such feed
*/
public function findIdFromUrl($url){
$stmt = OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' WHERE url = ?');
@@ -125,7 +125,7 @@ class OC_News_FeedMapper {
}
return $id;
}
-
+
public function mostRecent(){
//FIXME: does something like SELECT TOP 1 * exists in pear/mdb2 ??
$stmt = OCP\DB::prepare('SELECT * FROM ' . self::tableName . ' ORDER BY lastmodified');
@@ -179,21 +179,21 @@ class OC_News_FeedMapper {
$this->userid
);
$query->execute($params);
-
+
$feedid = OCP\DB::insertid(self::tableName);
}
$feed->setId($feedid);
$itemMapper = new OC_News_ItemMapper();
-
+
$items = $feed->getItems();
foreach($items as $item){
$itemMapper->save($item, $feedid);
}
-
+
return $feedid;
}
-
+
public function deleteById($id){
if ($id == null) {
return false;
@@ -201,31 +201,31 @@ class OC_News_FeedMapper {
$stmt = OCP\DB::prepare('DELETE FROM ' . self::tableName .' WHERE id = ?');
$result = $stmt->execute(array($id));
-
+
$itemMapper = new OC_News_ItemMapper();
//TODO: handle the value that the execute returns
$itemMapper->deleteAll($id);
-
+
return true;
}
public function delete(OC_News_Feed $feed){
$id = $feed->getId();
return deleteById($id);
}
-
+
//it's more complicated tan this...recursive delete, or delete with a join
- public function deleteAll($folderdid){
+ public function deleteAll($folderid){
if ($folderid == null) {
return false;
}
$stmt = OCP\DB::prepare('DELETE FROM ' . self::tableName .' WHERE folder_id = ?');
$result = $stmt->execute(array($folderid));
-
+
$itemMapper = new OC_News_ItemMapper();
//TODO: handle the value that the execute returns
- $itemMapper->deleteAll($id);
-
+ $itemMapper->deleteAll($folderid);
+
return true;
}
} \ No newline at end of file
602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873