Solved

[python - GUI] how do I associate the checkbuttons and radio buttons to the database?

Posted on 2009-04-01
2
498 Views
Last Modified: 2012-05-06
I made a database file and I made several entries into it. Now I wanna use GUI to enter data in the database (by associating the GUI file with the database file).

In the GUI file, I have some entries like "Name", "student number" etc. and some checkbutons, I want to write a code so that if I click the submit button, the entries I made (also the checkbuttons) get stored in the database,

I want to add another button "clear", which should clear the content of the data entry fields in the GUI window, (also unselects the checkbuttons I might have)
here is my code for the GUI file: 
 
from Tkinter import *
 
def run_analyse(db):
    window = Tk()
    window.title('Database')
    
    frame = Frame(window)
    frame.pack()
    
    q1_prompt = Label(frame, text="Name:")
    q1_prompt.grid(row=0, column=0)
    q1_data = Entry(frame)
    q1_data.grid(row=0, column=1)
     
    q2_prompt = Label(frame, text="Student number:")
    q2_prompt.grid(row=2, column=0)
    q2_data = Entry(frame)
    q2_data.grid(row=2, column=1)
    
    q3_prompt = Label(frame, text="Field of study:")
    q3_prompt.grid(row=4, column=0)
    q3_data = Entry(frame)
    q3_data.grid(row=4, column=1)   
    
    q3_prompt2 = Label(frame, text="Course load")
    q3_prompt2.grid(row=5, column=0)
    
    #first check button
    x1=StringVar()
    one_course = Checkbutton(frame, text="1", variable = x1, onvalue ="1", offvalue ="")
    one_course.grid(row=6, column=1)
    
    x2=StringVar()
    two_course = Checkbutton(frame, text="2", variable = x2, onvalue ="2", offvalue ="")
    two_course.grid(row=7, column=1)
    
    x3=StringVar()
    three_course = Checkbutton(frame, text="3", variable = x3, onvalue ="3", offvalue ="")
    three_course.grid(row=8, column=1)
    
    
    x4=StringVar()
    four_course = Checkbutton(frame, text="4", variable = x4, onvalue ="4", offvalue ="")
    four_course.grid(row=9, column=1)
    
    x5=StringVar()
    five_course = Checkbutton(frame, text="5", variable = x5, onvalue ="5", offvalue ="")
    five_course.grid(row=10, column=1)
    
    window.mainloop()
    
if __name__=="__main__":
    run_analyse('testing.txt')

Open in new window

0
Comment
Question by:Student_101
2 Comments
 
LVL 39

Accepted Solution

by:
Roger Baklund earned 500 total points
ID: 24045206
You did not explain the layout of your database.txt file, the below example assumes it is comma separated. I put all the data in a global variable named "data". The name of the database is also in a global variable "db", so that it is accessible from the do_create() function.  If you define a class for your gui this can be done without using global variables.
from Tkinter import *
 
data = {}
db = 'testing.txt'
 
def run_analyse():
    global data
    window = Tk()
    window.title('Database')
    
    frame = Frame(window)
    frame.pack()
    
    q1_prompt = Label(frame, text="Name:")
    q1_prompt.grid(row=0, column=0)
    data['name'] = Entry(frame)
    data['name'].grid(row=0, column=1)
     
    q2_prompt = Label(frame, text="Student number:")
    q2_prompt.grid(row=2, column=0)
    data['nbr'] = Entry(frame)
    data['nbr'].grid(row=2, column=1)
    
    q3_prompt = Label(frame, text="Field of study:")
    q3_prompt.grid(row=4, column=0)
    data['field'] = Entry(frame)
    data['field'].grid(row=4, column=1)   
    
    q3_prompt2 = Label(frame, text="Course load")
    q3_prompt2.grid(row=5, column=0)
    
    #first check button
    data['x1']=StringVar()
    one_course = Checkbutton(frame, text="1", variable = data['x1'], onvalue ="1", offvalue ="")
    one_course.grid(row=6, column=1)
    
    data['x2']=StringVar()
    two_course = Checkbutton(frame, text="2", variable = data['x2'], onvalue ="2", offvalue ="")
    two_course.grid(row=7, column=1)
    
    data['x3']=StringVar()
    three_course = Checkbutton(frame, text="3", variable = data['x3'], onvalue ="3", offvalue ="")
    three_course.grid(row=8, column=1)
    
    
    data['x4']=StringVar()
    four_course = Checkbutton(frame, text="4", variable = data['x4'], onvalue ="4", offvalue ="")
    four_course.grid(row=9, column=1)
    
    data['x5']=StringVar()
    five_course = Checkbutton(frame, text="5", variable = data['x5'], onvalue ="5", offvalue ="")
    five_course.grid(row=10, column=1)
    
    submitbtn = Button(frame, text="Create", command=do_create)
    submitbtn.grid(row=11, column=0)
    
    clearbtn = Button(frame, text="Clear", command=do_clear)
    clearbtn.grid(row=11, column=1)
    
    window.mainloop()
 
def do_clear():
    global data
    data['name'].delete(0,END)
    data['nbr'].delete(0,END)
    data['field'].delete(0,END)
    data['x1'].set('')
    data['x2'].set('')
    data['x3'].set('')
    data['x4'].set('')
    data['x5'].set('')
 
def do_create():
    global db,data
    print 'Writing to file',db,'...'
    f=open(db,'a')
    f.write(data['name'].get()+','+
            data['nbr'].get()+','+
            data['field'].get()+','+
            data['x1'].get()+','+
            data['x2'].get()+','+
            data['x3'].get()+','+
            data['x4'].get()+','+
            data['x5'].get()+'\n')
    f.close()
    print 'Record was written!'
  
if __name__=="__main__":
    run_analyse()

Open in new window

0

Featured Post

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The really strange introduction Once upon a time there were individuals who intentionally put the grass seeds to the soil with anticipation of solving their nutrition problems. Or they maybe only played with seeds and noticed what happened... Som…
Introduction On September 29, 2012, the Python 3.3.0 was released; nothing extremely unexpected,  yet another, better version of Python. But, if you work in Microsoft Windows, you should notice that the Python Launcher for Windows was introduced wi…
Learn the basics of modules and packages in Python. Every Python file is a module, ending in the suffix: .py: Modules are a collection of functions and variables.: Packages are a collection of modules.: Module functions and variables are accessed us…
Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question