import doesn't work as i want

[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()


-----------------------------------------