def loadFromServer(self, art):
print 'LoadFormServer'
s = []
self.connectToBase()
try:
q = "SELECT * FROM article WHERE article = '%s';" % (art)
self.cur.execute(q)
while 1:
row = self.cur.fetchone()
if not row:
break
s.append(row)
return s
except Exception, e:
print e
def upDataToTable(self, art):
s = self.source.loadFromServer(art)
s = list(s)
i = 0
del s[0][10]
while i<= len(s[0]):
it = QtGui.QTableWidgetItem(fromUtf8(str(s[0][i])))
self.table.setItem(i, 1, it)
i = i + 1
Содержимое s
('2312324', ‘\xd0\x9f\xd1\x81\xd0\xb8\xd1\x85\xd0\xbe\xd0\xbb\xd0\xbe\xd0\xb3\xd0\xb8\xd1\x8f \xd0\xb1\xd0\xb5\xd1\x81\xd1\x81\xd0\xbe\xd0\xb7\xd0\xbd\xd0\xb0\xd1\x82\xd0\xb5\xd0\xbb\xd1\x8c\xd0\xbd\xd0\xbe\xd0\xb3\xd0\xbe’, ‘\xd0\x9a. \xd0\x93. \xd0\xae\xd0\xbd\xd0\xb3’, ‘01100811’, ‘9785883730022’, ‘2137’, ‘\xd0\x9a\xd0\xa2\xd0\x9a: 011’, 8.0, 319.0, ‘null’, 18.0, 250.0, 15.0, 150.0, 0.29999999999999999, ‘\xd0\x9a\xd1\x80\xd0\xb0\xd1\x81\xd0\xbd\xd1\x8b\xd0\xb9’, 8.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, ‘\xd0\xa8\xd1\x82\xd1\x83\xd0\xba\xd0\xb0’, 1.0, 319.0, None, None, None, 140.0, ‘X’, ‘26.06.2012’, ‘26.06.2012’, ‘26.06.2012’, ‘null’, ‘null’, ‘null’, ‘\xd0\xae\xd0\xbd\xd0\xb3. \xd0\x9f\xd1\x81\xd0\xb8\xd1\x85\xd0\xbe\xd0\xbb \xd0\x91\xd0\xb5\xd1\x81\xd1\x81\xd0\xbe\xd0\xb7\xd0\xbd.’, ‘null’, None, ‘null’, ‘RU’)
Вывод по коду:
Traceback (most recent call last):
File “/home/serbis/Prog/python/b3/sources/createa/head.py”, line 95, in slot_ok
tb.changeArticle(self.art_edit.text())
File “/home/serbis/Prog/python/b3/sources/createa/table.py”, line 149, in changeArticle
self.upDataToTable(art)
File “/home/serbis/Prog/python/b3/sources/createa/table.py”, line 374, in upDataToTable
del s
TypeError: ‘tuple’ object doesn't support item deletion