3 * @copyright Copyright (C) 2010-2023, 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\Post;
24 use Friendica\Database\Database;
25 use Friendica\Database\DBA;
26 use Friendica\Util\DateTimeFormat;
31 * Insert a new post-activity entry
33 * @param integer $uri_id
34 * @param array $fields
36 * @return bool success
38 public static function insert(int $uri_id, string $source): bool
40 // Additionally assign the key fields
43 'activity' => $source,
44 'received' => DateTimeFormat::utcNow()
47 return DBA::insert('post-activity', $fields, Database::INSERT_IGNORE);
51 * Retrieves activity of the given uri-id
57 public static function getByURIId(int $uriId): array
59 $activity = DBA::selectFirst('post-activity', [], ['uri-id' => $uriId]);
60 return json_decode($activity['activity'] ?? '', true) ?? [];
64 * Checks if the given uridid has a stored activity
66 * @param integer $uriId
70 public static function exists(int $uriId): bool
72 return DBA::exists('post-activity', ['uri-id' => $uriId]);