import sqlite3
from Tkinter import *
def addData():
conn=sqlite3.connect('deedinfo.db')
cur=conn.cursor()
cur.execute("create table if not exists deedtrack(bkpage text,grantor text,grantee text,action text)")
#Get data from user
bookpage=raw_input("Book & Page? ")
seller=raw_input("Grantor? ")
buyer=raw_input("Grantee?")
action=raw_input("Do what? ")
#Inserts data into table
cur.execute("insert into deedtrack values (?,?,?,?)",(bookpage,seller,buyer,action))
conn.commit() #Saves the data
myrows=cur.execute("select * from deedtrack")
for row in myrows:
print("---------------------------")
print row[0]
print row[1]
print row[2]
print row[3]
def listData():
conn=sqlite3.connect('deedinfo.db')
cur=conn.cursor()
myrows=cur.execute("select * from deedtrack")
for row in myrows:
print("---------------------------")
print row[0]
print row[1]
print row[2]
print row[3]
root=Tk()
btn=Button(root,text="List table",command=listData)
btn.pack()
btn2=Button(root,text="Add to table",command=addData)
btn2.pack()
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.
Subscribe to:
Post Comments (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)
No comments:
Post a Comment