1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
<?php
/**
* Nextcloud - News
*
* This file is licensed under the Affero General Public License version 3 or
* later. See the COPYING file.
*
* @author Alessandro Cosentino <cosenal@gmail.com>
* @author Bernhard Posselt <dev@bernhard-posselt.com>
* @copyright 2012 Alessandro Cosentino
* @copyright 2012-2014 Bernhard Posselt
*/
namespace OCA\News\Db;
use OCA\News\Utility\Time;
use OCP\AppFramework\Db\Entity;
use OCP\IDBConnection;
/**
* Class FolderMapper
*
* @package OCA\News\Db
*/
class FolderMapperV2 extends NewsMapperV2
{
const TABLE_NAME = 'news_folders';
/**
* FolderMapper constructor.
*
* @param IDBConnection $db
* @param Time $time
*/
public function __construct(IDBConnection $db, Time $time)
{
parent::__construct($db, $time, Folder::class);
}
/**
* Find all feeds for a user.
*
* @param string $userId The user identifier
* @param array $params Filter parameters
*
* @return Folder[]
*/
public function findAllFromUser(string $userId, array $params = []): array
{
$builder = $this->db->getQueryBuilder();
$builder->select('*')
->from($this->tableName)
->where('user_id = :user_id')
->andWhere('deleted_at = 0')
->setParameter('user_id', $userId);
return $this->findEntities($builder);
}
/**
* Find all items
*
* @return Folder[]
*/
public function findAll(): array
{
$builder = $this->db->getQueryBuilder();
$builder->select('*')
->from($this->tableName)
->where('deleted_at = 0');
return $this->findEntities($builder);
}
/**
* Find a single feed for a user
*
* @param string $userId The user identifier
* @param int $id The feed ID
*
* @return Folder
* @throws \OCP\AppFramework\Db\DoesNotExistException
* @throws \OCP\AppFramework\Db\MultipleObjectsReturnedException
*/
public function findFromUser(string $userId, int $id): Entity
{
$builder = $this->db->getQueryBuilder();
$builder->select('*')
->from($this->tableName)
->where('user_id = :user_id')
->andWhere('id = :id')
->andWhere('deleted_at = 0')
->setParameter('user_id', $userId)
->setParameter('id', $id);
return $this->findEntity($builder);
}
/**
* @param string $userId
* @param int $id
* @param int|null $maxItemID
*
* @return void
*/
public function read(string $userId, int $id, ?int $maxItemID = null): void
{
$builder = $this->db->getQueryBuilder();
$builder->update(ItemMapperV2::TABLE_NAME, 'items')
->innerJoin('items', FeedMapperV2::TABLE_NAME, 'feeds', 'items.feed_id = feeds.id')
->setValue('unread', 0)
->andWhere('feeds.user_id = :userId')
->andWhere('feeds.folder_id = :folderId')
->setParameter('userId', $userId)
->setParameter('folderId', $id);
if ($maxItemID !== null) {
$builder->andWhere('items.id =< :maxItemId')
->setParameter('maxItemId', $maxItemID);
}
$this->db->executeUpdate($builder->getSQL());
}
}
|