cur = con.cursor()
cur.execute("SELECT ProjectId,ProjectName FROM Projects")
data = row = cur.fetchall()
projects_id = {}
global projects
projects = []
for i in data:
projects.append(str(i[1]))
projects_id[str(i[0])]=str(i[1])
#~ print data
#~ print projects_id
mypdfcreate = generate_pdf_file.create_pdf()
class Example(wx.Frame):
def __init__(self, *args, **kw):
super(Example, self).__init__(*args, **kw)
self.InitUI()
global projects
def InitUI(self):
pnl = wx.Panel(self)
cur.execute("SELECT ProjectId,ProjectName FROM Projects")
data = row = cur.fetchall()
project_data = []
projects_id = {}
projects = []
for i in data:
projects.append(str(i[1]))
projects_id[str(i[0])]=str(i[1])
#~ print data
#~ print projects_id
mypdfcreate = generate_pdf_file.create_pdf()
myHTML = ""
htmlAppend = """ <p><br>
</p>
</body>
</html>"""
class AboutDlg(wx.Frame):
def __init__(self, parent):
wx.Frame.__init__(self, parent, wx.ID_ANY, title="About", size=(900,1000))