3 * @copyright Copyright (C) 2010-2021, the Friendica project
5 * @license GNU AGPL version 3 or any later version
7 * This program is free software: you can redistribute it and/or modify
8 * it under the terms of the GNU Affero General Public License as
9 * published by the Free Software Foundation, either version 3 of the
10 * License, or (at your option) any later version.
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU Affero General Public License for more details.
17 * You should have received a copy of the GNU Affero General Public License
18 * along with this program. If not, see <https://www.gnu.org/licenses/>.
22 namespace Friendica\Model;
24 use Friendica\Database\DBA;
26 use Friendica\Util\Crypto;
31 * Select a subscription record exists
33 * @param int $applicationid
35 * @param array $fields
37 * @return bool Does it exist?
39 public static function select(int $applicationid, int $uid, array $fields = [])
41 return DBA::selectFirst('subscription', $fields, ['application-id' => $applicationid, 'uid' => $uid]);
45 * Check if a subscription record exists
47 * @param int $applicationid
50 * @return bool Does it exist?
52 public static function exists(int $applicationid, int $uid)
54 return DBA::exists('subscription', ['application-id' => $applicationid, 'uid' => $uid]);
58 * Update a subscription record
60 * @param int $applicationid
62 * @param array $fields subscription fields
64 * @return bool result of update
66 public static function update(int $applicationid, int $uid, array $fields)
68 return DBA::update('subscription', $fields, ['application-id' => $applicationid, 'uid' => $uid]);
72 * Insert or replace a subscription record
74 * @param array $fields subscription fields
76 * @return bool result of replace
78 public static function replace(array $fields)
80 return DBA::replace('subscription', $fields);
84 * Delete a subscription record
86 * @param int $applicationid
90 public static function delete(int $applicationid, int $uid)
92 return DBA::delete('subscription', ['application-id' => $applicationid, 'uid' => $uid]);
100 public static function getVapidKey(): string
102 $keypair = DI::config()->get('system', 'ec_keypair');
103 if (empty($keypair)) {
104 $keypair = Crypto::newECKeypair();
105 DI::config()->set('system', 'ec_keypair', $keypair);
107 return $keypair['vapid'];