AppBundle\Repository\LargestPagesRepository

Complexity

Total Complexity

10

Size/Duplication

Total Lines	75
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
B	getData()	0	41	6
A	getLikeSql()	0	17	4

<?php
declare(strict_types = 1);

namespace AppBundle\Repository;

use AppBundle\Model\Page;
use AppBundle\Model\Project;

/**
 * A LargestPagesRepository is responsible for retrieving information from the database for the LargestPages tool.
 * @codeCoverageIgnore
 */
class LargestPagesRepository extends Repository
{
    /** @var int Max rows to display. */
    public const MAX_ROWS = 500;

    private function getLikeSql(string &$includePattern, string &$excludePattern): string
    {
        $sql = '';

        if ($includePattern) {
            $sql .= "page_title LIKE :include_pattern ";
            $includePattern = str_replace(' ', '_', $includePattern);
        }
        if ($excludePattern) {
            if ($includePattern) {
                $sql .= ' AND ';
            }
            $sql .= "page_title NOT LIKE :exclude_pattern ";
            $excludePattern = str_replace(' ', '_', $excludePattern);
        }

        return $sql;
    }

    /**
     * Fetches the largest pages for the given project.
     * @param Project $project
     * @param int|string $namespace Namespace ID or 'all' for all namespaces.
     * @param string $includePattern Either regular expression (starts/ends with forward slash),
     *   or a wildcard pattern with % as the wildcard symbol.
     * @param string $excludePattern Either regular expression (starts/ends with forward slash),
     *   or a wildcard pattern with % as the wildcard symbol.
     * @return array Results with keys 'page_namespace', 'page_title', 'page_len' and 'pa_class'
     */
    public function getData(Project $project, $namespace, string $includePattern, string $excludePattern): array
    {
        $pageTable = $project->getTableName('page');

        $where = '';
        $likeCond = $this->getLikeSql($includePattern, $excludePattern);
        $namespaceCond = '';
        if ('all' !== $namespace) {
            $namespaceCond = 'page_namespace = :namespace';
            if ($likeCond) {
                $namespaceCond .= ' AND ';
            }
        }
        if ($likeCond || $namespaceCond) {
            $where = 'WHERE ';
        }

        $sql = "SELECT page_namespace, page_title, page_len
                FROM $pageTable
                $where $namespaceCond
                $likeCond
                ORDER BY page_len DESC
                LIMIT ".self::MAX_ROWS;

        $rows = $this->executeProjectsQuery($project, $sql, [
            'namespace' => $namespace,
            'include_pattern' => $includePattern,
            'exclude_pattern' => $excludePattern,
        ])->fetchAll();

        $pageRepo = new PageRepository();
        $pageRepo->setContainer($this->container);
        $pages = [];

        foreach ($rows as $row) {
            $page = Page::newFromRow($project, $row);
            $page->setRepository($pageRepo);
            $pages[] = $page;
        }

        return $pages;
    }
}