RevisionSelectQueryBuilder.php

Go to the documentation of this file.

<?php
namespace MediaWiki\Revision;
 
use Wikimedia\Rdbms\IReadableDatabase;
use Wikimedia\Rdbms\SelectQueryBuilder;
 
class RevisionSelectQueryBuilder extends SelectQueryBuilder {
 
    public function __construct( IReadableDatabase $db ) {
        parent::__construct( $db );
 
        $this->select( [
            'rev_id',
            'rev_page',
            'rev_timestamp',
            'rev_minor_edit',
            'rev_deleted',
            'rev_len',
            'rev_parent_id',
            'rev_sha1',
            'rev_user' => 'actor_rev_user.actor_user',
            'rev_user_text' => 'actor_rev_user.actor_name',
            'rev_actor' => 'rev_actor'
        ] )
            ->from( 'revision' )
            ->join( 'actor', 'actor_rev_user', 'actor_rev_user.actor_id = rev_actor' );
    }
 
    public function joinUser() {
        $this->field( 'user_name' )
            ->leftJoin(
                'user',
                null,
                [ $this->db->expr( 'actor_rev_user.actor_user', '!=', 0 ), "user_id = actor_rev_user.actor_user" ]
            );
 
        return $this;
    }
 
    public function joinPage() {
        $this->fields( [
            'page_namespace',
            'page_title',
            'page_id',
            'page_latest',
            'page_is_redirect',
            'page_len',
        ] )
        ->join( 'page', null, 'page_id = rev_page' );
 
        return $this;
    }
 
    public function joinComment() {
        $this->fields( [
            'rev_comment_text' => 'comment_rev_comment.comment_text',
            'rev_comment_data' => 'comment_rev_comment.comment_data',
            'rev_comment_cid' => 'comment_rev_comment.comment_id',
        ] );
        $this->join( 'comment', "comment_rev_comment", 'comment_rev_comment.comment_id = rev_comment_id' );
        return $this;
    }
}