O
Olivier Noblanc ATOUSOFT
Hello,
In the botom of this post you will see my source code.
The problem is when i launch main.py that doesn't make anything why ?
Thanks
olivier noblanc
Atousoft
http://www.logiciel-erp.fr
I have main.py :
---------------------------------
import wx
import inc.importlist
----------------------------------
inc/importlist.py
------------------------------------
import wx.grid
import getdata
import time
import sys
-----------------------------------
inc/wxgrid.py
-------------------------------------
# -*- coding: cp1252 -*-
#starta = time.time()
import wx
import getdata
class MyFrame(wx.Frame):
def __init__(self, *args, **kwds):
# begin wxGlade: MyFrame.__init__
kwds["style"] = wx.DEFAULT_FRAME_STYLE
wx.Frame.__init__(self, *args, **kwds)
self.grid_1 = wx.grid.Grid(self, -1, size=(1, 1))
self.__set_properties()
self.__do_layout()
# end wxGlade
def __set_properties(self):
# begin wxGlade: MyFrame.__set_properties
self.SetTitle("frame_1")
self.SetSize((400, 400))
# end wxGlade
self.grid_1.CreateGrid(len(db.data), len(db.fields))
# met les labels des colonnes
index = 0
for item in db.fields:
self.grid_1.SetColLabelValue(index, item[0])
index += 1
# remplissage des données.
for row in range(len(db.data)):
for col in range(len(db.data[row])):
values = db.data[row][col]
self.grid_1.SetCellValue(row,col,str(values))
# mise en forme et affichage
def __do_layout(self):
# begin wxGlade: MyFrame.__do_layout
sizer_1 = wx.BoxSizer(wx.VERTICAL)
sizer_1.Add(self.grid_1, 1, wx.EXPAND, 0)
self.SetAutoLayout(True)
self.SetSizer(sizer_1)
self.Layout()
# end wxGlade
# end of class MyFrame
if __name__ == "__main__":
app = wx.PySimpleApp(0)
wx.InitAllImageHandlers()
frame_1 = MyFrame(None, -1, "")
app.SetTopWindow(frame_1)
frame_1.Show()
#startb = time.time() - starta
#print startb
app.MainLoop()
---------------------------------------
inc/getdata.py
----------------------------------------------
import MySQLdb
class Eb_db:
def __init__(self):
try:
connection = MySQLdb.connect(host="dellced", user="ats",
passwd="", db="atsmedicdatabase" )
cursor = connection.cursor()
cursor.execute( "SELECT * FROM PATIENT " )
except MySQLdb.OperationalError, message:
errorMessage = "Error %d:\n%s" % ( message[ 0 ], message[ 1 ] )
return
else:
self.data = cursor.fetchall()
self.fields = cursor.description
cursor.close()
connection.close()
-----------------------------------------
In the botom of this post you will see my source code.
The problem is when i launch main.py that doesn't make anything why ?
Thanks
olivier noblanc
Atousoft
http://www.logiciel-erp.fr
I have main.py :
---------------------------------
import wx
import inc.importlist
----------------------------------
inc/importlist.py
------------------------------------
import wx.grid
import getdata
import time
import sys
-----------------------------------
inc/wxgrid.py
-------------------------------------
# -*- coding: cp1252 -*-
#starta = time.time()
import wx
import getdata
class MyFrame(wx.Frame):
def __init__(self, *args, **kwds):
# begin wxGlade: MyFrame.__init__
kwds["style"] = wx.DEFAULT_FRAME_STYLE
wx.Frame.__init__(self, *args, **kwds)
self.grid_1 = wx.grid.Grid(self, -1, size=(1, 1))
self.__set_properties()
self.__do_layout()
# end wxGlade
def __set_properties(self):
# begin wxGlade: MyFrame.__set_properties
self.SetTitle("frame_1")
self.SetSize((400, 400))
# end wxGlade
self.grid_1.CreateGrid(len(db.data), len(db.fields))
# met les labels des colonnes
index = 0
for item in db.fields:
self.grid_1.SetColLabelValue(index, item[0])
index += 1
# remplissage des données.
for row in range(len(db.data)):
for col in range(len(db.data[row])):
values = db.data[row][col]
self.grid_1.SetCellValue(row,col,str(values))
# mise en forme et affichage
def __do_layout(self):
# begin wxGlade: MyFrame.__do_layout
sizer_1 = wx.BoxSizer(wx.VERTICAL)
sizer_1.Add(self.grid_1, 1, wx.EXPAND, 0)
self.SetAutoLayout(True)
self.SetSizer(sizer_1)
self.Layout()
# end wxGlade
# end of class MyFrame
if __name__ == "__main__":
app = wx.PySimpleApp(0)
wx.InitAllImageHandlers()
frame_1 = MyFrame(None, -1, "")
app.SetTopWindow(frame_1)
frame_1.Show()
#startb = time.time() - starta
#print startb
app.MainLoop()
---------------------------------------
inc/getdata.py
----------------------------------------------
import MySQLdb
class Eb_db:
def __init__(self):
try:
connection = MySQLdb.connect(host="dellced", user="ats",
passwd="", db="atsmedicdatabase" )
cursor = connection.cursor()
cursor.execute( "SELECT * FROM PATIENT " )
except MySQLdb.OperationalError, message:
errorMessage = "Error %d:\n%s" % ( message[ 0 ], message[ 1 ] )
return
else:
self.data = cursor.fetchall()
self.fields = cursor.description
cursor.close()
connection.close()
-----------------------------------------