blob: a69f8be4501dc292197bfef76aef53c0cd552673 (
plain)
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
|
<?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);
}
}
|
