1 2 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