#!/usr/bin/python
from Tkinter import *
import sqlite3
#Witten by Steve Atchison 12/28/2013
def cleargui():
textwindow.delete("1.0",END)
parnumber.delete(0,END)
def connectdb():
connect = sqlite3.connect("mydata.db")
cur = connect.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS phonedata(parcelnum text, description text)")
def addtodatabase():
parnum=parnumber.get()
description=textwindow.get("1.0",END)
connect = sqlite3.connect("mydata.db")
cur=connect.cursor()
cur.execute("INSERT INTO phonedata VALUES(?,?)",([parnum,description]))
connect.commit()
cleargui()
def getdata():
connect = sqlite3.connect("mydata.db")
cur=connect.cursor()
thedata = cur.execute("SELECT * FROM phonedata")
cleargui()
for row in thedata:
textwindow.insert("100.0","\n"+row[0]+"\n"+row[1]+"\n---------------------------------------------------------")
def findpar():
cleargui()
parnum=findentry.get()
connect = sqlite3.connect("mydata.db")
cur=connect.cursor()
thedata = cur.execute("SELECT * FROM phonedata WHERE parcelnum = ?",([parnum]))
for row in thedata:
textwindow.insert("0.1",row[0]+'\n\n'+row[1])
parnumber.delete(0,END)
def delrecord():
parnum=findentry.get()
connect=sqlite3.connect("mydata.db")
cur=connect.cursor()
cur.execute("DELETE FROM phonedata WHERE parcelnum = ?",([parnum]))
connect.commit() #will not delete without this!
cleargui()
findentry.delete(0,END)
getdata()
connectdb()#creates a database if none exists.
root=Tk()
root.title("PARCEL INFO")
root.config(bg='dark blue')
lbl=Label(root,text="Parcel number").pack()
menu2=Toplevel(root)
menu2.config(bg="red")
parnumber=Entry(root,text="Deed number")
parnumber.pack()
textwindow=Text(root,background='white')
textwindow.pack()
btn=Button(root,text='Add to Database ',command=addtodatabase)
btn.pack()
btn2=Button(root,text="Show data",command=getdata)
btn2.pack()
btn3=Button(root,text="Clear window",command=cleargui)
btn3.pack()
findentry=Entry(menu2)
findentry.pack()
btn4=Button(menu2,text="Find parcel",command= findpar)
btn4.pack(padx=10,pady=10)
delbutton=Button(menu2,text='DELETE',command=delrecord)
delbutton.pack(padx=10,pady=10)
root.mainloop()
