User:DASHBot/Small Disambiguation Pages/Config

Code

import wikipedia
import MySQLdb
title = 'User:DASHBot/Small_Disambiguation_Pages'
db =  MySQLdb.connect(db='enwiki_p', host="enwiki-p.db.toolserver.org", read_default_file="~/.my.cnf")
preload = "This page consists of [[WP:DISAMBIG|disambiguation]] pages that have fewer than two links to articles. Report runs monthly, is limited to 500 entries, and was last updated ~~~~~"
print 'Getting list...'
q = """select Distinct concat('# [[',
concat(
replace(
page_title,'_',' ')
,']]')
)
from page
join templatelinks on tl_from = page_id and tl_namespace = 10 and tl_title = 'Disambiguation'
where page_namespace=0
and (select count(*) from pagelinks where pl_from = page_id and pl_namespace = 0) <=2 Limit 500;
"""
db.query(q)
del q
result = db.use_result().fetch_row(0)
result  = [p[0] for p in result]
result.sort()
preload = preload+ '\n'+'\n'.join(result)
preload = preload.decode('utf-8')
del result
wikipedia.Page(wikipedia.getSite(),title).put(preload,comment ='Updating list',botflag=False)

Crontab

 0 5 0 * * python pynew/pywikipedia/smalldisambig.py