1 | <?php |
||
30 | use OCP\AppFramework\Db\QBMapper; |
||
31 | use OCP\DB\QueryBuilder\IQueryBuilder; |
||
32 | use OCP\IDBConnection; |
||
33 | |||
34 | class VaultMapper extends QBMapper { |
||
35 | const TABLE_NAME = 'passman_vaults'; |
||
36 | private Utils $utils; |
||
|
|||
37 | |||
38 | public function __construct(IDBConnection $db, Utils $utils) { |
||
39 | parent::__construct($db, self::TABLE_NAME); |
||
40 | $this->utils = $utils; |
||
41 | } |
||
42 | |||
43 | |||
44 | /** |
||
45 | * @param int $vault_id |
||
46 | * @param string $user_id |
||
47 | * @return Entity[] |
||
48 | */ |
||
49 | public function find(int $vault_id, string $user_id) { |
||
50 | $qb = $this->db->getQueryBuilder(); |
||
51 | $qb->select('*') |
||
52 | ->from(self::TABLE_NAME) |
||
53 | ->where($qb->expr()->eq('id', $qb->createNamedParameter($vault_id, IQueryBuilder::PARAM_INT))) |
||
54 | ->andWhere($qb->expr()->eq('user_id', $qb->createNamedParameter($user_id, IQueryBuilder::PARAM_STR))); |
||
55 | |||
56 | return $this->findEntities($qb); |
||
57 | } |
||
58 | |||
59 | /** |
||
60 | * @param string $vault_guid |
||
61 | * @param string $user_id |
||
62 | * @return Entity |
||
63 | * @throws DoesNotExistException |
||
64 | * @throws MultipleObjectsReturnedException |
||
65 | */ |
||
66 | public function findByGuid(string $vault_guid, string $user_id) { |
||
67 | $qb = $this->db->getQueryBuilder(); |
||
68 | $qb->select('*') |
||
69 | ->from(self::TABLE_NAME) |
||
70 | ->where($qb->expr()->eq('guid', $qb->createNamedParameter($vault_guid, IQueryBuilder::PARAM_STR))) |
||
71 | ->andWhere($qb->expr()->eq('user_id', $qb->createNamedParameter($user_id, IQueryBuilder::PARAM_STR))); |
||
72 | |||
73 | return $this->findEntity($qb); |
||
74 | } |
||
75 | |||
76 | |||
77 | /** |
||
78 | * @param string $user_id |
||
79 | * @return Entity[] |
||
80 | */ |
||
81 | public function findVaultsFromUser(string $user_id) { |
||
82 | $qb = $this->db->getQueryBuilder(); |
||
83 | $qb->select('*') |
||
84 | ->from(self::TABLE_NAME) |
||
85 | ->where($qb->expr()->eq('user_id', $qb->createNamedParameter($user_id, IQueryBuilder::PARAM_STR))); |
||
86 | |||
87 | return $this->findEntities($qb); |
||
88 | } |
||
89 | |||
90 | /** |
||
91 | * Creates a vault |
||
92 | * |
||
93 | * @param string $vault_name |
||
94 | * @param string $user_id |
||
95 | * @return Vault|Entity |
||
96 | */ |
||
97 | public function create(string $vault_name, string $user_id) { |
||
98 | $vault = new Vault(); |
||
99 | $vault->setName($vault_name); |
||
100 | $vault->setUserId($user_id); |
||
101 | $vault->setGuid($this->utils->GUID()); |
||
102 | $vault->setCreated($this->utils->getTime()); |
||
103 | $vault->setLastAccess(0); |
||
104 | return parent::insert($vault); |
||
105 | } |
||
106 | |||
107 | /** |
||
108 | * Update last access time of a vault |
||
109 | * |
||
110 | * @param int $vault_id |
||
111 | * @param string $user_id |
||
112 | * @return Vault|Entity |
||
113 | */ |
||
114 | public function setLastAccess(int $vault_id, string $user_id) { |
||
115 | $vault = new Vault(); |
||
116 | $vault->setId($vault_id); |
||
117 | $vault->setUserId($user_id); |
||
118 | $vault->setLastAccess(Utils::getTime()); |
||
119 | return $this->update($vault); |
||
120 | } |
||
121 | |||
122 | /** |
||
123 | * Update vault |
||
124 | * |
||
125 | * @param Vault $vault |
||
126 | * @return Vault|Entity |
||
127 | */ |
||
128 | public function updateVault(Vault $vault) { |
||
129 | return $this->update($vault); |
||
130 | } |
||
131 | |||
132 | /** |
||
158 |