| 12
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 
 |  
import wx,psycopg
class Bonjour(wx.Frame):
    ID_IMPORT = 100
    ID_WORK = 101
    ID_EXPORT = 102
    ID_DELETE = 103
    ID_INITIALISATION = 201
    ID_HELP = 301
 
    def __init__(self, titre):
        wx.Frame.__init__(self,parent= None,id = -1,title = titre, size = (400, 400))
        self.conteneur = wx.Panel(self, -1,size = self.GetClientSize())
        self.etiquette = wx.StaticText(self.conteneur, -1,"Bonjour tout le monde !",style = wx.ALIGN_CENTRE)
        self.etiquette.CentreOnParent()
        wx.EVT_SIZE(self,self.OnSize)
        menuBase = wx.Menu()
        menuBase.Append(self.ID_IMPORT, "&Importer un Fichier \tctrl+i")
        menuBase.Append(self.ID_WORK, "&Travailler sur une base \tctrl+t")
        menuBase.Append(self.ID_EXPORT, "&Exporter une base \tctrl+e")
        menuBase.Append(self.ID_DELETE, "&Detruire une base \tctrl+d")
        menuDouchette = wx.Menu()
        menuDouchette.Append(self.ID_INITIALISATION, "&Initialiser\tctrl+N")
        menuAide = wx.Menu()
        menuAide.Append(self.ID_HELP, "&Afficher la Doc\tctrl+A")
        menuBarre = wx.MenuBar()
        menuBarre.Append(menuBase,"&Base")
        menuBarre.Append(menuDouchette,"&Douchette")
        menuBarre.Append(menuAide,"&?")
        self.SetMenuBar(menuBarre)
        wx.EVT_MENU(self,self.ID_IMPORT,self.OnImport)
        wx.EVT_MENU(self,self.ID_WORK,self.OnWork)
        wx.EVT_MENU(self,self.ID_DELETE,self.OnDelete)
    def OnImport(self,evt):
        dlg = wx.FileDialog(self, message="choisissez un fichier .csv", defaultDir=".",defaultFile="",wildcard="*.csv",style=wx.OPEN)
        if dlg.ShowModal() == wx.ID_OK:
            self.fliename = dlg.GetPath()
        dlg.Destroy()
    def OnWork(self,evt):
         requete = "select id,NomOperation,Date from operations"
         conn = psycopg.connect("user=i password=l6 host=192.168 dbname=i")
         curs = conn.cursor()
         curs.execute(requete)
         rows = curs.fetchall()
         conn.close()
         liste = []
         for i in range(len(rows)):
             liste.append("""Numero : %s Operation : %s Date : %s""" %(rows[i][0],rows[i][1],rows[i][2]))
         self.listBox = wx.ListBox(self.conteneur,-1,(20,20),(300,80),liste,wx.LB_SINGLE)
         self.listBox.CentreOnParent()
 
    def OnDelete(self,evt):
         requete = "select id,NomOperation,Date from operations"
         conn = psycopg.connect("user=o password=y host=192.168 dbname=i")
         curs = conn.cursor()
         curs.execute(requete)
         rows = curs.fetchall()
         conn.close()
         liste = []
         for i in range(len(rows)):
             liste.append("""Numero : %s Operation : %s Date : %s""" %(rows[i][0],rows[i][1],rows[i][2]))
         self.listBox = wx.ListBox(self.conteneur,-1,(20,20),(300,80),liste,wx.LB_SINGLE)
         self.listBox.CentreOnParent()
         self.button = wx.Button(self.conteneur,-1,"Detruire",pos=(50,300))
         self.listBox.SetSelection(1)
         print self.listBox.GetStringSelection()
    def OnSize(self,evt):
        self.SetTitle("Exemple 3 %s " % evt.GetSize() )
        self.conteneur.SetSize(self.GetClientSize())
        self.etiquette.CentreOnParent()
class MonApp(wx.App):
    def OnInit(self):
         fen = Bonjour("Exemple 1")
         fen2 = Bonjour("Exemple 2")
         fen.Show(True)
         fen2.Show(True)
         self.SetTopWindow(fen)
         return True
app = MonApp()
app.MainLoop() | 
Partager