SQLite example

sqlite_example.py

import sqlite3

created_db = sqlite3.connect('test.db')
cursor = created_db.cursor()

def create_table():
    cursor.execute("""CREATE TABLE IF NOT EXISTS Scores
    (id INTEGER PRIMARY KEY, Name TEXT, Class TEXT, Score INTERGER)""")

def add_pupil(name, klass, score):
    cursor.execute("""INSERT INTO Scores (Name, Class, Score)
    VALUES(?,?,?)""",(name, klass, score,))

def main():
    create_table()
    
    name = "John Doe"
    klass = "Math"
    score = 100
    
    add_pupil(name, klass, score)
    created_db.commit()

    cursor.execute("SELECT * FROM Scores ORDER BY Score DESC")

    title = ["id","Name", "Class", "Score"]
    k = 0
    
    for i in cursor:
        print "\n"
        for j in i:
            print title[k],
            print j
            if k < 3: k += 1
            else: k = 0

    cursor.close()

if __name__ == '__main__':
    main()