import pywikibot
site = pywikibot.Site('test', 'wikipedia')
site
import mwviews
from mwviews.api import PageviewsClient
pip install mwviews
import mwviews
from mwviews.api import PageviewsClient
p = PageviewsClient()
p.article_views('en.wikipedia', ['Selfie', 'Cat', 'Dog'])
p.project_views(['ro.wikipedia', 'de.wikipedia', 'commons.wikimedia'])
p.top_articles('en.wikipedia', limit=10)
import requests
import os
import pymysql
conn = pymysql.connect(
host=os.environ['MYSQL_HOST'],
user=os.environ['MYSQL_USERNAME'],
password=os.environ['MYSQL_PASSWORD'],
database='enwiki_p',
charset='utf8'
)
with conn.cursor() as cur:
cur.execute('use enwiki_p')
cur.execute("""SELECT * from user where user_name = 'Jtmorgan'""")
jtmorgan = cur.fetchall()
cur.execute("""SELECT * from user where user_name = 'HostBot'""")
hostbot = cur.fetchall()
print(jtmorgan)
print(hostbot)