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

I updated my deed tracker program

from Tkinter import *
import webbrowser

def openWebDox():
    webbrowser.open('http://snintraweb/rod/gis.aspx')
  
def ListFile():
    result_f=open('Deedinfo.txt')
    for eachline in result_f:
        print eachline
    result_f.close()
  

def DataSave():
    fob=open('Deedinfo.txt','a')
    fob.write('---------------------------------------------------------\n')
    fob.write('Book Page: '+ deed.get()+'\n')
    fob.write('Deed date\: '+ deeddate.get()+'\n')
    fob.write('GRANTOR: ' + grantor.get()+'\nGRANTEE: ' + grantee.get()+'\n')
    #fob.write('Grantee: ' + grantee.get()+'\n')
    fob.write('PIN :'+pin.get()+'\n')
    fob.write('Action taken: '+ theAction.get()+'\n')
    fob.close
    #clears entry boxes inside of root
    deed.delete(0,END)
    deeddate.delete(0,END)
    grantor.delete(0,END)
    grantee.delete(0,END)
    pin.delete(0,END)

def newwin():  #Opens a new window with a text widget. cool!
    top= Toplevel(root)
  
    textwin=Text(top)
    textwin.pack()
    f=open("Deedinfo.txt")
    for eachline in f:
        textwin.insert(END, eachline)
    f.close()

  
    top.mainloop()

    aline.close()

root = Tk()
#root.geometry('200x450')
root.config(bg='limegreen')

Label(text = 'Book & Page').pack()
deed = Entry(root)
deed.pack(padx=5,pady=5)

Label(text='Deed Date').pack()
deeddate=Entry(root)
deeddate.pack(padx=5,pady=5)

Label(text='Grantor ').pack()
grantor =Entry(root)
grantor.pack(padx=5,pady=5)

Label(text='Grantee').pack()
grantee=Entry(root)
grantee.pack(padx=5,pady=5)

Label(text='Parcel ID').pack()
pin=Entry(root)
pin.pack(padx=5,pady=5)

#Radio button widgets
theAction=StringVar()
theAction.set(None)
Radiobutton(root,text='Map work card',value='Map work card',bg='limegreen',variable=theAction).pack()
Radiobutton(root,text='Split',value='Split',bg='limegreen',variable=theAction).pack()
Radiobutton(root,text='Combination',value='Combination',bg='limegreen',variable=theAction).pack()
Radiobutton(root,text='Split/Combo',value='Split/Combo',bg='limegreen',variable=theAction).pack()
Radiobutton(root,text='Not in title',value='Not in title',bg='limegreen',variable=theAction).pack()
Radiobutton(root,text='Name change',value='Name change',bg='limegreen',variable=theAction).pack()

saveBtn=Button(root,text='Save ', command=DataSave)
saveBtn.pack(padx=2,pady=2)

win1Btn=Button(root,text='New win',command=newwin)
win1Btn.pack()

listBtn=Button(root,text='List Deed File',command=ListFile)
listBtn.pack(padx=2,pady=2)

WebDoxBtn=Button(root,text='Web Dox',command=openWebDox)
WebDoxBtn.pack(padx=2,pady=2)
root.mainloop()

Some more C

#include
#include

int main()
{
char name[100];
printf("What is your name?");
fgets(name,100,stdin);

printf("your name is %s", name);
}

Installed a new Operating Sysytem

I downloaded Trisquel, and then burned it to a CD using xburn. Worked very well. Then I used the ISO disk to install it on my laptop.

I deleted my Grub Boot Loader!

I created a USB drive with CrunchBang on it, and I deleted my Grub boot loader from my laptop! I fixed it by typing sudo grub-install /dev/sda. It worked, and now my laptop boots just fine!

Updated my Gas calc program

 I installed CrunchBang 10 Linux and I love it. I wrote an updated gas mileage calculator and added it the CrunchBang menu using the GUI Menu Editor!  I like openbox better than Gnome!


from Tkinter import *
import tkMessageBox


def gmcalc():
    Gallons = float(gallons.get())
    Miles = float(odometer.get())
    mpg = float(Miles)/float(Gallons)
    tkMessageBox.showinfo("Gas miles", mpg)

root = Tk()
Label(root,text='Gallons used').pack()
gallons=Entry(root)
gallons.pack()

Label(root,text='Odometer miles').pack()
odometer=Entry(root)
odometer.pack()

btn = Button(root,text='calc',command=gmcalc)
btn.pack()

List manipulation at the command line.

>>> alist = ['one','two','three']
>>> alist
['one', 'two', 'three']
>>> alist.pop[2]
Traceback (most recent call last):
  File "", line 1, in
TypeError: 'builtin_function_or_method' object is not subscriptable
>>> alist
['one', 'two', 'three']
>>> alist.append('four')
>>> alist
['one', 'two', 'three', 'four']
>>> alist.pop([3])
Traceback (most recent call last):
  File "", line 1, in
TypeError: an integer is required
>>> alist.pop(3)
'four'
>>> alist
['one', 'two', 'three']
>>>