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
|
#construction du treeview
lstalarme = Treeview(fen1,selectmode='browse')
lstalarme['columns'] = ('User', 'Message')
lstalarme.heading('#0',text='Heure', anchor='w')
lstalarme.column('#0',anchor='w')
lstalarme.heading('User', text='User')
lstalarme.column('User', anchor='w', width=100)
lstalarme.column('User', stretch=tkinter.YES)
lstalarme.heading('Message', text='Message')
lstalarme.column('Message', anchor='w', width=668)
lstalarme.grid(sticky=(N,S,W,E))
lstalarme.grid_rowconfigure(0, weight = 1)
lstalarme.grid_columnconfigure(0, weight = 1)
yscrollbar=Scrollbar(fen1,command=lstalarme.yview)
yscrollbar.grid(row=0,column=1,sticky=(N,S))
lstalarme['yscrollcommand'] = yscrollbar.set
#requete SQL
requete="SELECT date, long_desc, emet, dest FROM message WHERE dest='Tous' OR dest='"+usr+"' OR emet='"+usr+"';"
db=pymysql.connect(host,user,password,database)
query=db.cursor()
query.execute(requete)
db.close
for j in querry:
lstalarme.insert('','end', text=j[0],values=(j[2],j[1]))
lstalarme.see(j[0]) |
Partager