| Jar added a comment. |
my user-config.py
-*- coding: utf-8 -*-
mylang = 'ar'
family = 'wikipedia'
usernames['wikipedia']['ar'] = u'user'
usernames['wikipedia']['vi'] = u'user'
usernames['wikipedia']['ur'] = u'user'
usernames['wikipedia']['vec'] = u'user'
usernames['wiktionary']['ar'] = u'user'
usernames['wikidata']['wikidata'] = u'user'
and my script something like this
#!/usr/bin/python
-*- coding: utf-8 -*-
import MySQLdb as mysqldb
from pywikibot import pagegenerators
from pywikibot import config
import urllib,gzip,codecs,re
import pywikibot
import family
import sys
reload(sys)
sys.setdefaultencoding("utf-8")
pagetop=u'{{إحصاء}}\n'
pagedown=u'\n|}'
pagedown+=u'\n</center>'
pagedown+=u'\n</div>'
pagedown+=u'\n[[تصنيف:إحصاءات ويكيبيديا]] [[تصنيف:ويكيبيديا قائمة الويكيبيديين حسب عدد التعديلات]]'
pagedown+=u'\n</div>'
adress=u"%D9%85%D8%B3%D8%AA%D8%AE%D8%AF%D9%85%3A%D8%AC%D8%A7%D8%B1%20%D8%A7%D9%84%D9%84%D9%87%2F%D8%AA%D8%AC%D8%A7%D8%B1%D8%A8%20%D8%A8%D9%88%D8%AA"
message=u"test"
count=0
rowi,rowfia,rowfi,mytime,text,rowfa,line_items=' ',' ',' ',' ',' ',' ',' '
#---------------------------------------------- sql part--------------
site = pywikibot.getSite("ar")
query = '''SELECT user_name, user_editcount FROM user
WHERE user_name NOT IN
(SELECT user_name FROM user_groups
INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot')
AND user_name NOT IN
(Select pl_title from pagelinks where pl_from = 2803691)
ORDER BY user_editcount DESC LIMIT 500;'''
pywikibot.output(u'Executing query:\n%s' % query)
conn = mysqldb.connect("arwiki.labsdb", db = pywikibot.Site().dbName() + "_p", user = config.db_username, passwd = config.db_password)
cursor = conn.cursor()
query = query.encode(site.encoding())
cursor.execute(query)
results = cursor.fetchall()
#---------------------------------------------- end of sql part---------
count=0
for row in results:
count+=1
rowi=unicode(str(row[0]),'UTF-8') rowi2=unicode(str(row[1]),'UTF-8') rowfa+=u'\n|bgcolor="#808080"|'+str(count)+u'||bgcolor="#D3D3D3"|[[user:'+rowi+u'|'+rowi+u']]||' rowfa+='\n|-\n' text=rowfa.strip()
text=pagetop+text+pagedown
page = pywikibot.Page(site,adress)
page.put(text,message)
and the save page was like this [https://ar.wikipedia.org/w/index.php?title=%D9%85%D8%B3%D8%AA%D8%AE%D8%AF%D9%85:%D8%AC%D8%A7%D8%B1_%D8%A7%D9%84%D9%84%D9%87/%D8%AA%D8%AC%D8%A7%D8%B1%D8%A8_%D8%A8%D9%88%D8%AA&oldid=21743140]
Cc: Magul, Aklapper, pywikibot-bugs-list, Jar, MayS, Mdupont, JJMC89, jayvdb, Dalba, Masti, Alchimista, Rxy
_______________________________________________ pywikibot-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/pywikibot-bugs
