nettrom

Examining the number of pages created in the Draft namespace between 2017-09-15 and 2018-02-15 that currently (2018-03-14) exists
as pages in the article (Main) namespace.

1: Get a dataset of creations in the Draft namespace between those dates from the `log` database:
SELECT page_id
FROM mediawiki_page_create_2
WHERE `database`='enwiki'
AND rev_timestamp >= '2017-09-15 00:00:00'
AND rev_timestamp < '2018-02-15 00:00:00'
AND page_namespace = 118

nettrom

Host *.eqiad.wmflabs
    ProxyCommand ssh -a -W %h:%p -v [email protected]
Host *.wmflabs
    User nettrom
    IdentityFile %d/.ssh/wmcloud
    ServerAliveInterval 60
Host * !gerrit.wikimedia.org
    Ciphers [email protected],[email protected],[email protected],aes256-ctr,aes192-ctr,aes128-ctr
    KexAlgorithms [email protected],diffie-hellman-group-exchange-sha256

nettrom

## Excerpt from the class, showing the method that calls the Wikidata API,
## approach is the same for other MediaWiki APIs with maxlag parameter available

    def make_api_request(self, items, http_session):
        '''
        Make an HTTP request to the Wikidata API for info on the given list
        of items using the given HTTP session.

        :param items: the QIDs of the items we'll be getting data about
        :type items: list