User:Abshirdheere/Codetest

1. !/usr/bin/python
2. Abbas (Ar:User:Elph), 2012
3. -*- coding: utf-8 -*-

import catlib ,pagegenerators import wikipedia,urllib,gzip,codecs,re import MySQLdb as mysqldb import config pagetop=u pagedown=u adress=u"user:Ibrahim.ID/EditCounts" message=u"Hagaajin" count=0 rowfa=' ' rowi=' ' rowravan=' ' rowravan2=' ' rowfia=' '

1. ---------------------------------------------- sql part--------------

site = wikipedia.getSite("so") query = "SELECT user_name, user_editcount FROM user WHERE user_name='Ibrahim.ID' "

wikipedia.output(u'Executing query:\n%s' % query) conn = mysqldb.connect("sowiki.labsdb", db = site.dbName(),

                      user = config.db_username,
                      passwd = config.db_password)

cursor = conn.cursor() query = query.encode(site.encoding()) cursor.execute(query) results = cursor.fetchall()

1. ---------------------------------------------- end of sql part---------

count=0 for row in results:

       rowi=unicode(str(row[0]),'UTF-8')
       rowi2=unicode(str(row[1]),'UTF-8')
       #rowi3=unicode(str(row[2]),'UTF-8')
       rowfa=rowi2#+u'|'+rowi3
       text=rowfa.strip()

text=pagetop+text+pagedown page = wikipedia.Page(site,adress) page.put(text,message)