blob: a0ecb348ba41992c013169028f68397841cf75c2 (
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
|
<?php
declare(strict_types=1);
/**
* SPDX-FileCopyrightText: 2023 Nextcloud GmbH and Nextcloud contributors
* SPDX-License-Identifier: AGPL-3.0-or-later
*/
namespace OCA\DAV\Db;
use OCP\AppFramework\Db\QBMapper;
use OCP\IDBConnection;
/**
* @template-extends QBMapper<Property>
*/
class PropertyMapper extends QBMapper {
private const TABLE_NAME = 'properties';
public function __construct(IDBConnection $db) {
parent::__construct($db, self::TABLE_NAME, Property::class);
}
/**
* @return Property[]
*/
public function findPropertyByPathAndName(string $userId, string $path, string $name): array {
$selectQb = $this->db->getQueryBuilder();
$selectQb->select('*')
->from(self::TABLE_NAME)
->where(
$selectQb->expr()->eq('userid', $selectQb->createNamedParameter($userId)),
$selectQb->expr()->eq('propertypath', $selectQb->createNamedParameter($path)),
$selectQb->expr()->eq('propertyname', $selectQb->createNamedParameter($name)),
);
return $this->findEntities($selectQb);
}
}
|
