Friday, December 23, 2011

Some sqlite and python

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()

No comments:

Post a Comment

Followers

Blog Archive

About Me

My photo
Biking helps me to cope with life.