src/if_ole.cpp

<?php
/**
 * Nextcloud - News
 *
 * This file is licensed under the Affero General Public License version 3 or
 * later. See the COPYING file.
 *
 * @author    Alessandro Cosentino <cosenal@gmail.com>
 * @author    Bernhard Posselt <dev@bernhard-posselt.com>
 * @copyright 2020 Sean Molenaar
 */

namespace OCA\News\Db;

use OC\DB\QueryBuilder\Literal;
use OCA\News\Service\Exceptions\ServiceValidationException;
use Doctrine\DBAL\FetchMode;
use OCA\News\Utility\Time;
use OCP\AppFramework\Db\DoesNotExistException;
use OCP\AppFramework\Db\Entity;
use OCP\AppFramework\Db\MultipleObjectsReturnedException;
use OCP\DB\Exception as DBException;
use OCP\DB\QueryBuilder\IQueryBuilder;
use OCP\IDBConnection;

/**
 * Class ItemMapper
 *
 * @package OCA\News\Db
 */
class ItemMapperV2 extends NewsMapperV2
{
    const TABLE_NAME = 'news_items';

    /**
     * ItemMapper constructor.
     *
     * @param IDBConnection $db
     * @param Time          $time
     */
    public function __construct(IDBConnection $db, Time $time)
    {
        parent::__construct($db, $time, Item::class);
    }

    /**
     * Find all feeds for a user.
     *
     * @param string $userId The user identifier
     * @param array  $params Filter parameters
     *
     * @return Entity[]
     */
    public function findAllFromUser(string $userId, array $params = []): array
    {
        $builder = $this->db->getQueryBuilder();
        $builder->select('items.*')
                ->from($this->tableName, 'items')
                ->innerJoin('items', FeedMapperV2::TABLE_NAME, 'feeds', 'items.feed_id = feeds.id')
                ->where('(feeds.user_id = :user_id AND items.shared_by = \'\') OR items.shared_with = :shared_with')
                ->andWhere('feeds.deleted_at = 0')
                ->setParameter('user_id', $userId, IQueryBuilder::PARAM_STR)
                ->setParameter('shared_with', $userId, IQueryBuilder::PARAM_STR);

        foreach ($params as $key => $value) {
            $builder->andWhere("${key} = " . $builder->createNamedParameter($value));
        }

        return $this->findEntities($builder);
    }

    /**
     * Find all items
     *
     * @return Entity[]
     */
    public function findAll(): array
    {
        $builder = $this->db->getQueryBuilder();
        $builder->select('*')
            ->from($this->tableName)
            ->innerJoin('items', FeedMapperV2::TABLE_NAME, 'feeds', 'items.feed_id = feeds.id')
            ->andWhere('feeds.deleted_at = 0');

        return $this->findEntities($builder);
    }

    /**
     * @inheritDoc
     */
    public function findFromUser(string $userId, int $id): Entity
    {
        $builder = $this->db->getQueryBuilder();
        $builder->select('items.*')
            ->from($this->tableName, 'items')
            ->innerJoin('items', FeedMapperV2::TABLE_NAME, 'feeds', 'items.feed_id = feeds.id')
            ->where('(feeds.user_id = :user_id AND items.shared_by = \'\') OR items.shared_with = :shared_with')
            ->andWhere('items.id = :item_id')
            ->andWhere('feeds.deleted_at = 0')
            ->setParameter('user_id', $userId, IQueryBuilder::PARAM_STR)
            ->setParameter('shared_with', $userId, IQueryBuilder::PARAM_STR)
            ->setParameter('item_id', $id, IQueryBuilder::PARAM_INT);

        return $this->findEntity($builder);
    }

    /**
     * Find an item by a GUID hash.
     *
     * @param int    $feedId   ID of the feed
     * @param string $guidHash hash to find with
     *
     * @return Item|Entity
     *
     * @throws DoesNotExistException
     * @throws MultipleObjectsReturnedException
     */
    public function findByGuidHash(int $feedId, string $guidHash): Entity
    {
        $builder = $this->db->getQueryBuilder();
        $builder->select('*')
            ->from($this->tableName)
            ->andWhere('feed_id = :feed_id')
            ->andWhere('guid_hash = :guid_hash')
            ->setParameter('feed_id', $feedId, IQueryBuilder::PARAM_INT)
            ->setParameter('guid_hash', $guidHash, IQueryBuilder::PARAM_STR);

        return $this->findEntity($builder);
    }

    /**
     * Find a user item by a GUID hash.
     *
     * @param string $userId
     * @param int    $feedId   ID of the feed
     * @param string $guidHash hash to find with
     *
     * @return Item
     *
     * @throws DoesNotExistException
     * @throws MultipleObjectsReturnedException
     */
    public function findForUserByGuidHash(string $userId, int $feedId, string $guidHash): Entity
    {
        $builder = $this->db->getQueryBuilder();
        $builder->select('items.*')
            ->from($this->tableName, 'items')
            ->innerJoin('items', FeedMapperV2::TABLE_NAME, 'feeds', 'items.feed_id = feeds.id')
            ->andWhere('(feeds.user_id = :user_id AND items.shared_by = \'\') OR items.shared_with = :shared_with')
            ->andWhere('feeds.id = :feed_id')
            ->andWhere('items.guid_hash = :guid_hash')
            ->setParameter('user_id', $userId, IQueryBuilder::PARAM_STR)
            ->setParameter('shared_with', $userId, IQueryBuilder::PARAM_STR)
            ->setParameter('feed_id', $feedId, IQueryBuilder::PARAM_INT)
            ->setParameter('guid_hash', $guidHash, IQueryBuilder::PARAM_STR);

        return $this->findEntity($builder);
    }

    /**
     * @param int $feedId
     *
     * @return array
     */
    public function findAllForFeed(int $feedId): array
    {
        $builder = $this->db->getQueryBuilder();
        $builder->select('*')
            ->from($this->tableName)
            ->where('feed_id = :feed_identifier')
            ->setParameter('feed_identifier', $feedId, IQueryBuilder::PARAM_INT);

        return $this->findEntities($builder);
    }

    /**
     * Delete items from feed that are over the max item threshold
     *
     * @param int  $threshold    Deletion threshold
     * @param bool $removeUnread If unread articles should be removed
     *
     * @return int|null Removed items
     *
     * @throws \Doctrine\DBAL\Exception
     */
    public function deleteOverThreshold(int $threshold, bool $removeUnread = false): ?int
    {
        $feedQb = $this->db->getQueryBuilder();
        $feedQb->select('feed_id', $feedQb->func()->count('*', 'itemCount'))
               ->selectAlias($feedQb->func()->max('feeds.articles_per_update'), 'articlesPerUpdate')
               ->from($this->tableName, 'items')
               ->innerJoin('items', FeedMapperV2::TABLE_NAME, 'feeds', 'items.feed_id = feeds.id')
               ->groupBy('feed_id');

        $feeds = $this->db->executeQuery($feedQb->getSQL())
                          ->fetchAll(FetchMode::ASSOCIATIVE);

        if ($feeds === []) {
            return null;
        }

        $rangeQuery = $this->db->getQueryBuilder();
        $rangeQuery->select('id')
            ->from($this->tableName)
            ->where('feed_id = :feedId')
            ->andWhere('starred = false')
            ->orderBy('last_modified', 'DESC')
            ->addOrderBy('id', 'DESC');

        if ($removeUnread === false) {
            $rangeQuery->andWhere('unread = false');
        }
Age	Commit message (Expand)	Author
2023-08-11	patch 9.0.1687: mapset() not properly handling script IDv9.0.1687	zeertzjq
2023-04-14	patch 9.0.1453: typos in source code and testsv9.0.1453	Dominique Pelle
2022-10-01	patch 9.0.0634: evaluating "expr" options has more overhead than neededv9.0.0634	Bram Moolenaar
2022-01-24	patch 8.2.4199: MS-Windows: Support for MSVC 2003 is not usefulv8.2.4199	K.Takata
2020-12-18	patch 8.2.2160: various typosv8.2.2160	Bram Moolenaar
2020-06-24	patch 8.2.1049: Vim9: leaking memory when using continuation linev8.2.1049	Bram Moolenaar
2019-10-13	patch 8.1.2145: cannot map <C-H> when modifyOtherKeys is enabledv8.1.2145	Bram Moolenaar
2019-05-25	patch 8.1.1393: unnecessary type castsv8.1.1393	Bram Moolenaar
2019-05-09	patch 8.1.1306: Borland support is outdated and doesn't workv8.1.1306	Bram Moolenaar
2019-02-18	patch 8.1.0949: MS-windows defines GUI macros different than other systemsv8.1.0949	Bram Moolenaar
2019-02-17	patch 8.1.0941: macros for MS-Windows are inconsistentv8.1.0941	Bram Moolenaar
2018-07-11	patch 8.1.0178: warning for passing pointer to non-pointer argumentv8.1.0178	Bram Moolenaar
2016-08-29	patch 7.4.2293v7.4.2293	Bram Moolenaar
2016-03-19	patch 7.4.1610v7.4.1610	Bram Moolenaar
2016-02-27	patch 7.4.1442v7.4.1442	Bram Moolenaar
2013-05-06	updated for version 7.3.925v7.3.925	Bram Moolenaar
2010-08-02	Take OLE registration back to 32 bit registry, the unregister wasn't working	Bram Moolenaar
2010-08-02	Workaround for missing RegDeleteKeyEx() method.	Bram Moolenaar
2010-08-01	Define the WOW64 key when needed.	Bram Moolenaar
2010-08-01	Add the WOW64 flag back to OLE registration. (untested)	Bram Moolenaar
2010-07-31	Fix that uninstaller isn't found on 64-bit Windows.	Bram Moolenaar
2010-07-31	Possibly make OLE work on Windows 64 bit. (untested)	Bram Moolenaar
2010-05-26	Fix definition of UINT_PTR for 64 bit systems.	Bram Moolenaar
2009-01-28	updated for version 7.2-089v7.2.089	Bram Moolenaar
2008-03-16	updated for version 7.1-282v7.1.282	Bram Moolenaar
2006-08-16	updated for version 7.0-057v7.0.057	Bram Moolenaar
2006-08-08	updated for version 7.0-045v7.0.045	Bram Moolenaar
2006-05-03	updated for version 7.0g02	Bram Moolenaar
2006-03-06	updated for version 7.0216v7.0216	Bram Moolenaar
2005-07-03	updated for version 7.0101v7.0101	Bram Moolenaar
2005-07-01	updated for version 7.0099	Bram Moolenaar
2005-06-13	updated for version 7.0084	Bram Moolenaar
2004-06-13	updated for version 7.0001v7.0001	Bram Moolenaar