Merge pull request #9 from nupplaphil/dependabot/composer/guzzlehttp/guzzle-6.5.8

[friendica.git] / src / Model / Post.php

diff --git a/src/Model/Post.php b/src/Model/Post.php
index 902525f9922415b738ef85ae3bfdffbdc1dc45f1..56898e3b2961d4c20119fd9512add03d18ad02ad 100644 (file)
--- a/src/Model/Post.php
+++ b/src/Model/Post.php
@@ -1,6 +1,6 @@
 <?php
 /**
- * @copyright Copyright (C) 2010-2021, the Friendica project
+ * @copyright Copyright (C) 2010-2022, the Friendica project
  *
  * @license GNU AGPL version 3 or any later version
  *
@@ -39,7 +39,7 @@ class Post
         * @return int    ID of inserted post
         * @throws \Exception
         */
-       public static function insert(int $uri_id, array $data = [])
+       public static function insert(int $uri_id, array $data = []): int
        {
                if (empty($uri_id)) {
                        throw new BadMethodCallException('Empty URI_id');
@@ -107,8 +107,10 @@ class Post
         * @param object $stmt statement object
         * @param bool   $do_close
         * @return array Data array
+        * @todo Find proper type-hint for $stmt and maybe avoid boolean
         */
-       public static function toArray($stmt, $do_close = true) {
+       public static function toArray($stmt, bool $do_close = true)
+       {
                if (is_bool($stmt)) {
                        return $stmt;
                }
@@ -131,7 +133,8 @@ class Post
         * @return boolean Are there rows for that condition?
         * @throws \Exception
         */
-       public static function exists($condition) {
+       public static function exists(array $condition): bool
+       {
                return DBA::exists('post-user-view', $condition);
        }
 
@@ -151,11 +154,32 @@ class Post
         * $count = Post::count($condition);
         * @throws \Exception
         */
-       public static function count(array $condition = [], array $params = [])
+       public static function count(array $condition = [], array $params = []): int
        {
                return DBA::count('post-user-view', $condition, $params);
        }
 
+       /**
+        * Counts the post-thread-user-view records satisfying the provided condition
+        *
+        * @param array        $condition array of fields for condition
+        * @param array        $params    Array of several parameters
+        *
+        * @return int
+        *
+        * Example:
+        * $condition = ["uid" => 1, "network" => 'dspr'];
+        * or:
+        * $condition = ["`uid` = ? AND `network` IN (?, ?)", 1, 'dfrn', 'dspr'];
+        *
+        * $count = Post::count($condition);
+        * @throws \Exception
+        */
+       public static function countThread(array $condition = [], array $params = []): int
+       {
+               return DBA::count('post-thread-user-view', $condition, $params);
+       }
+
        /**
         * Counts the post-view records satisfying the provided condition
         *
@@ -172,7 +196,7 @@ class Post
         * $count = Post::count($condition);
         * @throws \Exception
         */
-       public static function countPosts(array $condition = [], array $params = [])
+       public static function countPosts(array $condition = [], array $params = []): int
        {
                return DBA::count('post-view', $condition, $params);
        }
@@ -188,7 +212,7 @@ class Post
         * @throws \Exception
         * @see   DBA::select
         */
-       public static function selectFirst(array $fields = [], array $condition = [], $params = [])
+       public static function selectFirst(array $fields = [], array $condition = [], array $params = [])
        {
                $params['limit'] = 1;
 
@@ -213,7 +237,7 @@ class Post
         * @throws \Exception
         * @see   DBA::select
         */
-       public static function selectFirstPost(array $fields = [], array $condition = [], $params = [])
+       public static function selectFirstPost(array $fields = [], array $condition = [], array $params = [])
        {
                $params['limit'] = 1;
 
@@ -238,7 +262,7 @@ class Post
         * @throws \Exception
         * @see   DBA::select
         */
-       public static function selectFirstThread(array $fields = [], array $condition = [], $params = [])
+       public static function selectFirstThread(array $fields = [], array $condition = [], array $params = [])
        {
                $params['limit'] = 1;
 
@@ -263,7 +287,7 @@ class Post
         * @return array
         * @throws \Exception
         */
-       public static function selectToArray(array $fields = [], array $condition = [], $params = [])
+       public static function selectToArray(array $fields = [], array $condition = [], array $params = [])
        {
                $result = self::select($fields, $condition, $params);
 
@@ -291,7 +315,7 @@ class Post
         * @return boolean|object
         * @throws \Exception
         */
-       private static function selectView(string $view, array $selected = [], array $condition = [], $params = [])
+       private static function selectView(string $view, array $selected = [], array $condition = [], array $params = [])
        {
                if (empty($selected)) {
                        $selected = array_merge(Item::DISPLAY_FIELDLIST, Item::ITEM_FIELDLIST);
@@ -316,7 +340,7 @@ class Post
         * @return boolean|object
         * @throws \Exception
         */
-       public static function select(array $selected = [], array $condition = [], $params = [])
+       public static function select(array $selected = [], array $condition = [], array $params = [])
        {
                return self::selectView('post-user-view', $selected, $condition, $params);
        }
@@ -331,7 +355,7 @@ class Post
         * @return boolean|object
         * @throws \Exception
         */
-       public static function selectPosts(array $selected = [], array $condition = [], $params = [])
+       public static function selectPosts(array $selected = [], array $condition = [], array $params = [])
        {
                return self::selectView('post-view', $selected, $condition, $params);
        }
@@ -346,7 +370,7 @@ class Post
         * @return boolean|object
         * @throws \Exception
         */
-       public static function selectThread(array $selected = [], array $condition = [], $params = [])
+       public static function selectThread(array $selected = [], array $condition = [], array $params = [])
        {
                return self::selectView('post-thread-user-view', $selected, $condition, $params);
        }
@@ -363,7 +387,7 @@ class Post
         * @return boolean|object
         * @throws \Exception
         */
-       private static function selectViewForUser(string $view, $uid, array $selected = [], array $condition = [], $params = [])
+       private static function selectViewForUser(string $view, int $uid, array $selected = [], array $condition = [], array $params = [])
        {
                if (empty($selected)) {
                        $selected = Item::DISPLAY_FIELDLIST;
@@ -404,7 +428,7 @@ class Post
         * @return boolean|object
         * @throws \Exception
         */
-       public static function selectForUser($uid, array $selected = [], array $condition = [], $params = [])
+       public static function selectForUser(int $uid, array $selected = [], array $condition = [], array $params = [])
        {
                return self::selectViewForUser('post-user-view', $uid, $selected, $condition, $params);
        }
@@ -420,7 +444,7 @@ class Post
         * @return boolean|object
         * @throws \Exception
         */
-       public static function selectPostsForUser($uid, array $selected = [], array $condition = [], $params = [])
+       public static function selectPostsForUser(int $uid, array $selected = [], array $condition = [], array $params = [])
        {
                return self::selectViewForUser('post-view', $uid, $selected, $condition, $params);
        }
@@ -436,7 +460,7 @@ class Post
         * @return boolean|object
         * @throws \Exception
         */
-       public static function selectThreadForUser($uid, array $selected = [], array $condition = [], $params = [])
+       public static function selectThreadForUser(int $uid, array $selected = [], array $condition = [], array $params = [])
        {
                return self::selectViewForUser('post-thread-user-view', $uid, $selected, $condition, $params);
        }
@@ -452,7 +476,7 @@ class Post
         * @throws \Exception
         * @see   DBA::select
         */
-       public static function selectFirstForUser($uid, array $selected = [], array $condition = [], $params = [])
+       public static function selectFirstForUser(int $uid, array $selected = [], array $condition = [], array $params = [])
        {
                $params['limit'] = 1;
 
@@ -467,39 +491,6 @@ class Post
                }
        }
 
-       /**
-        * Select pinned rows from the post-thread-user table for a given user
-        *
-        * @param integer $uid       User ID
-        * @param array   $selected  Array of selected fields, empty for all
-        * @param array   $condition Array of fields for condition
-        * @param array   $params    Array of several parameters
-        *
-        * @return boolean|object
-        * @throws \Exception
-        */
-       public static function selectPinned(int $uid, array $selected = [], array $condition = [], $params = [])
-       {
-               $postthreaduser = DBA::select('post-thread-user', ['uri-id'], ['uid' => $uid, 'pinned' => true]);
-               if (!DBA::isResult($postthreaduser)) {
-                       return $postthreaduser;
-               }
-
-               $pinned = [];
-               while ($useritem = DBA::fetch($postthreaduser)) {
-                       $pinned[] = $useritem['uri-id'];
-               }
-               DBA::close($postthreaduser);
-
-               if (empty($pinned)) {
-                       return [];
-               }
-
-               $condition = DBA::mergeConditions(['uri-id' => $pinned, 'uid' => $uid, 'gravity' => GRAVITY_PARENT], $condition);
-
-               return self::selectForUser($uid, $selected, $condition, $params);
-       }
-
        /**
         * Update existing post entries
         *
@@ -652,7 +643,7 @@ class Post
         * @return boolean was the delete successful?
         * @throws \Exception
         */
-       public static function delete(array $conditions, array $options = [])
+       public static function delete(array $conditions, array $options = []): bool
        {
                return DBA::delete('post', $conditions, $options);
        }