Python-сообщество

#coding:utf-8
import sys
import MySQLdb as mdb
from PyQt4 import QtGui, QtCore, QtSql
from MySQLdb import connections
class combo(QtGui.QWidget):
    def __init__(self, *args):
    	global combo1
        QtGui.QWidget.__init__(self,*args)
        conn = mdb.connect('localhost', 'root', '', 'test',use_unicode=True, charset='utf8');
    	cursor = conn.cursor()
	conn.set_character_set('utf8')
    	cursor.execute('SET NAMES utf8')
	cursor.execute('SET CHARACTER SET utf8')
	cursor.execute('SET character_set_connection=utf8')
	cursor.execute('select tarname from tarifs ')
    	
        combo1 = QtGui.QComboBox()
        for row in cursor.fetchall():
    		combo1.addItem(str(row[0].encode('utf8')))
    		#text1=combo1.currentText()
    	#return text1
    		
 	conn.commit()
        cursor.close ()
        conn.close()
        
        layout = QtGui.QHBoxLayout()
        layout.addWidget(combo1)
        self.setLayout(layout)

#coding:utf-8
..........
class MyTableModel(QtCore.QAbstractTableModel):
    def __init__(self, parent = None, *args):
        QtCore.QAbstractTableModel.__init__(self, parent, *args)
        self.colLabels = [u"Название",u"Download",u"Upload",u"Абонплата"] # Заголовки столбцов
        
	conn = mdb.connect('localhost', 'root', '', 'test',use_unicode=True, charset='utf8');
    	cursor = conn.cursor()
    	conn.set_character_set('utf8')
    	cursor.execute('SET NAMES utf8')
	cursor.execute('SET CHARACTER SET utf8')
	cursor.execute('SET character_set_connection=utf8')
    	
    	cursor.execute('select * from tarifs ')
    	a = []
        for row in cursor.fetchall():
                a += [row[1], row[2], row[3], row[4]],
        conn.commit()
        cursor.close ()
        conn.close()
        self.dataCached = a