| 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
 
 |  
import threading
import pygtk
import MySQLdb
pygtk.require('2.0')
import gtk
from time import sleep
 
 
 
class Code:
    def __init__(self):
        self.conn=MySQLdb.connect('localhost','root','','presence')
        self.cursor=self.conn.cursor()
        self.fen=gtk.Window(gtk.WINDOW_TOPLEVEL)
        self.boite=gtk.VBox(False,0)
        self.fen.add(self.boite)
        self.boite.show()
        self.saisie=gtk.Entry(max=50)
        self.boite.pack_start(self.saisie,True,True,0)
        self.saisie.show()
        self.bouton = gtk.Button(stock=gtk.STOCK_CLOSE)
        self.bouton.connect_object("clicked", self.fermer, self.fen)
        self.boite.pack_start(self.bouton, True, True, 0)
        self.bouton.set_flags(gtk.CAN_DEFAULT)
        self.bouton.grab_default()
        self.bouton.show()
        self.infobulle=gtk.Tooltips()
        self.fen.show()
 
 
    def fermer(self):
        self.cursor.close()
        self.conn.close()
        self.gtk.main_quit()
 
 
    def MyTimer(self,arg):
        if self.saisie.get_text()=='':
            print "attentes"
            sleep(arg)
 
            self.MyTimer(arg)
            gtk.main()
            #threading.Timer(arg,self.MyTimer,[arg]).start()
            print clock()
            pass
        else:
            self.cursor.execute("select * from nom")
            auto=cursor.fetchall()
            if auto==():
                self.cursor.execute("insert into nom values ('"+self.saisie.get_text()+"')")
            else:
                for tune in auto:
 
                    if tune==(str(self.saisie.get_text()),):
 
                        self.cursor.execute("delete from nom where prenom="+"'"+self.saisie.get_text()+"'")
                        break
                    elif( not (str(self.saisie.get_text()),) in auto):
                        self.cursor.execute("insert into nom values ('"+self.saisie.get_text()+"')")
                        break
            self.saisie.set_text('')
            self.cursor.execute("select * from nom")
            nombre=len(cursor.fetchall())
            self.infobulle.set_tip(self.bouton,str(nombre))
            #threading.Timer(arg,self.MyTimer,[arg]).start()
            sleep(arg)
 
            self.MyTimer(arg)
 
 
 
c=Code()
c.MyTimer(2.0)
gtk.main() | 
Partager