I updated my gas miles program, and it now Stores data to an SQLite3 database.
from Tkinter import *
import tkMessageBox
import sqlite3
def createdb():
#Create a database if it does not exist.
## conn=sqlite3.connect('mygasmiles.db')
conn=sqlite3.connect('mygasmilesTest.db')
#Create a Cursor object
cur=conn.cursor()
#Create a table using the cursor object
cur.execute("CREATE TABLE IF NOT EXISTS mpgtable(gals real,odometer real,mpg real)")
#Get data from GUI
Gallons = float(gallons.get())
Miles = float(odometer.get())
mpg =round( float(Miles)/float(Gallons),2)
tkMessageBox.showinfo("Gas miles", mpg)
clearGUI()
#Add data to table.
cur.execute("INSERT INTO mpgtable values(?,?,?)",([Gallons,Miles,mpg]))
conn.commit()
listData()
def clearGUI():
gallons.delete(0,END)
odometer.delete(0,END)
def listData():
## conn=sqlite3.connect("mygasmiles.db")
conn=sqlite3.connect("mygasmilesTest.db")
cur=conn.cursor()
myrows=cur.execute("select * from mpgtable")
for row in myrows:
print'--------------------------------'
print'Gallons = ',row[0]
print 'Odometer = ',row[1]
print'MPG = ', row[2]
root = Tk()
aframe = Frame(root)
aframe.pack(side=RIGHT)
Label(aframe,text='Gallons used').pack()
gallons=Entry(aframe)
gallons.pack()
Label(aframe,text='Odometer miles').pack()
odometer=Entry(aframe)
odometer.pack()
btn =Button(aframe,text='calc',command=createdb)
btn.pack(side=LEFT)
btn2=Button(aframe,text='List table',command=listData)
btn2.pack(side=LEFT)
root.mainloop()
This is a personal record of my python programming experiences. It will allow me to see how I am progressing as I learn a new language.
Saturday, July 14, 2012
Subscribe to:
Posts (Atom)
Followers
Blog Archive
- June (1)
- March (3)
- February (1)
- July (3)
- May (1)
- April (1)
- March (1)
- January (1)
- December (1)
- November (4)
- July (3)
- May (2)
- April (1)
- March (6)
- February (2)
- December (1)
- November (1)
- September (3)
- August (3)
- July (1)
- March (3)
- January (1)
- December (5)
- November (2)
- October (1)
- September (2)
- August (1)
- July (4)
- May (3)
- February (1)
- January (1)
- December (1)
- November (2)
- October (2)
- September (9)
- August (2)
- May (1)
- April (1)
- March (6)
- February (5)
- January (3)
- August (2)