Xtools\ArticleInfoRepository

Complexity

Total Complexity

4

Size/Duplication

Total Lines	91
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	getLogEvents()	0	16	1
A	getUsernamesFromIds()	0	10	1
A	getTextshares()	0	12	1
A	getBotData()	0	19	1

<?php
/**
 * This file contains only the ArticleInfoRepository class.
 */

namespace Xtools;

use GuzzleHttp;

/**
 * ArticleInfoRepository is responsible for retrieving data about a single
 * article on a given wiki.
 */
class ArticleInfoRepository extends Repository
{
    /**
     * Get the number of edits made to the page by bots or former bots.
     * @param  Page $page
     * @param  false|int $start
     * @param  false|int $end
     * @return \Doctrine\DBAL\Driver\Statement resolving with keys 'count', 'username' and 'current'.
     */
    public function getBotData(Page $page, $start, $end)
    {
        $project = $page->getProject();
        $userGroupsTable = $project->getTableName('user_groups');
        $userFormerGroupsTable = $project->getTableName('user_former_groups');

        $datesConditions = $this->createDatesConditions($start, $end);

        $sql = "SELECT COUNT(rev_user_text) AS count, rev_user_text AS username, ug_group AS current
                FROM " . $project->getTableName('revision') . "
                LEFT JOIN $userGroupsTable ON rev_user = ug_user
                LEFT JOIN $userFormerGroupsTable ON rev_user = ufg_user
                WHERE rev_page = :pageId AND (ug_group = 'bot' OR ufg_group = 'bot') $datesConditions
                GROUP BY rev_user_text";
        $pageId = $page->getId();
        $resultQuery = $this->getProjectsConnection()->prepare($sql);
        $resultQuery->bindParam('pageId', $pageId);
        $resultQuery->execute();
        return $resultQuery;
    }

    /**
     * Get prior deletions, page moves, and protections to the page.
     * @param Page $page
     * @param false|int $start
     * @param false|int $end
     * @return string[] each entry with keys 'log_action', 'log_type' and 'timestamp'.
     */
    public function getLogEvents(Page $page, $start, $end)
    {
        $loggingTable = $page->getProject()->getTableName('logging', 'logindex');

        $datesConditions = $this->createDatesConditions($start, $end, '', 'log_timestamp');

        $sql = "SELECT log_action, log_type, log_timestamp AS 'timestamp'
                FROM $loggingTable
                WHERE log_namespace = '" . $page->getNamespace() . "'
                AND log_title = :title AND log_timestamp > 1 $datesConditions
                AND log_type IN ('delete', 'move', 'protect', 'stable')";
        $title = str_replace(' ', '_', $page->getTitle());
        $resultQuery = $this->getProjectsConnection()->prepare($sql);
        $resultQuery->bindParam(':title', $title);
        $resultQuery->execute();
        return $resultQuery->fetchAll();
    }

    /**
     * Query the WikiWho service to get authorship percentages.
     * @see https://api.wikiwho.net/
     * @param Page $page
     * @return array[] Response from WikiWho.
     */
    public function getTextshares(Page $page)
    {
        $title = rawurlencode(str_replace(' ', '_', $page->getTitle()));
        $client = new GuzzleHttp\Client();

        $projectLang = $page->getProject()->getLang();

        $url = "https://api.wikiwho.net/$projectLang/api/v1.0.0-beta/rev_content/" .
            "$title/?o_rev_id=false&editor=true&token_id=false&out=false&in=false";

        $res = $client->request('GET', $url);
        return json_decode($res->getBody()->getContents(), true);
    }

    /**
     * Get a map of user IDs/usernames given the user IDs.
     * @param  Project $project
     * @param  int[]   $userIds
     * @return array
     */
    public function getUsernamesFromIds(Project $project, $userIds)
    {
        $userTable = $project->getTableName('user');
        $userIds = implode(',', $userIds);
        $sql = "SELECT user_id, user_name
                FROM $userTable
                WHERE user_id IN ($userIds)";
        $resultQuery = $this->getProjectsConnection()->prepare($sql);
        $resultQuery->execute();
        return $resultQuery->fetchAll();
    }
}