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
|
from tkinter import *
import sqlite3
root = Tk()
conn = sqlite3.connect("test.sqlite")
c = conn.cursor()
Label(text= "Couleurs:",font=("Helvetica", 14)).grid(sticky =NW)
c.execute("select ROWID, * from couleurs order by tri,couleur")
resultats = c.fetchall()
ctxt = StringVar()
cbg = StringVar()
cfg = StringVar()
for lig in resultats:
label_couleur = Label(root,text= ""+lig[1]+"",bg=lig[2],fg=lig[3], width=10)
label_couleur.grid(sticky =NW)
ctxt.set(str(lig[1]))# pb garde la dernière valeur en mémoire
cbg.set(str(lig[2]))
cfg.set(str(lig[3]))
text_couleur = Entry(root, width = 10, textvariable=ctxt)
text_couleur.grid(row = lig[0], column=2)
text_bg = Entry(root, width = 10, textvariable=cbg)
text_bg.grid(row = lig[0], column=3)
text_fg = Entry(root, width = 10, textvariable=cfg)
text_fg.grid(row = lig[0], column = 4 )
c.close()
conn.close()
root.mainloop()
root.destroy() |
Partager