another wx python question I want after the thread is done getting my
data to run the populate module i keep getting :
[code]Traceback (most recent call last):
File "C:\Python26\sign\OCTOBER 12_SERVER_syncthread.py", line 494,
in populate
self.lb1.DeleteAllItems()
AttributeError: 'ThreadClass' object has no attribute 'lb1'[/code]
why am I getting it and how do i fix it ?
[code]class InsertData(wx.Frame):
def __init__(self, parent, id, title):
def populate(self):
try:
#load database contents'''
self.lb1.DeleteAllItems()
conn = lite.connect("specialeventms2011a.sqlite")
c = conn.cursor()
c.execute('select * from ptrecords')
for i in c:
index = str(i[1])
index = self.lb1.InsertStringItem(sys.maxint, str(i[1]))
self.lb1.SetStringItem(index, 1, str(i[2]))
self.lb1.SetStringItem(index, 2, str(i[3]))
self.lb1.SetStringItem(index, 3, str(i[4]))
self.lb1.SetStringItem(index, 4, str(i[5]))
self.lb1.SetStringItem(index, 5, str(i[6]))
self.lb1.SetStringItem(index, 6, str(i[7]))
self.lb1.SetStringItem(index, 7, str(i[8]))
self.lb1.SetStringItem(index, 8, str(i[9]))
self.lb1.SetStringItem(index, 9, str(i[10]))
self.lb1.SetStringItem(index, 10, str(i[11]))
self.lb1.SetStringItem(index, 11, str(i[12]))
self.lb1.SetStringItem(index, 12, str(i[13]))
class ThreadClass(threading.Thread,InsertData):
def run(self):
host = ''
port = 51269
backlog = 5
size = 1000000
addr = (socket.gethostname(), port)
s = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
s.bind((addr))
s.listen(backlog)
while 1:
client, addr= s.accept()
data = client.recv(size)
#print client
if data:
client.send(data)
sqlite_file_to_write = open("recieved_dataII.txt", "ab" )
sqlite_file_to_write.write(data)
sqlite_file_to_write.close()
client.close()
fname="recieved_dataII.txt"
f = open(fname, 'rb') # notice the binary mode again
reader = csv.reader(f)
for row in reader:
(Incident_number,Last_Name,First_Name,Age,Gender,Address,City,State,Zip,Ailment,Treatment,Patient_reprt,Initial_contact,Hospital,
Destination,Inservice,Provider_1,Provider_2,Sys,Dia,Pulse,Resp,Weather,Temp,Humid,Wind,TimeStamp,Refusal)
=row
Actual_Incident_number=None
con = lite.connect('specialeventms2011a.sqlite')
cur = con.cursor()
cur.execute('insert into ptrecords
values(?,?,?,?,?,?,?,?,?,?,?,?, ?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
0)',
(Actual_Incident_number,Incident_number, Last_Name, First_Name,
Age,Gender,Address,City,State,Zip
,Ailment,Treatment,Patient_reprt,Initial_contact,Hospital,Destination,Inservice,
Provider_1,Provider_2,Sys,Dia,Pulse,Resp,Weather,
Temp,Humid,Wind,TimeStamp,Refusal))
con.commit()
cur.close()
con.close()
f.close()
os.remove('recieved_dataII.txt')
self.repopulate()
def repopulate(self):
InsertData.populate(self)
ThreadClass().start()