Hashes in python

hases in python are called dictionaries.
Dictionary are key,value pairs where key should be unique.

• Initialize Dict:
  test = {}
  test = dict()

• Add values to Dict:
  test[‘one’] = 1

• Remove values from Dict:
  del test[‘one’]

• Sorting a dict on keys:
  sorted – function is used to sort dictionaries
  By default it will sort on keys
  Example:
  sorted(test)

SQLite in python

import sqlite3 module provides CURD capabilities using sql lite databases

• Open a database

db = sqlite3.connect("test.sql3")

• Initialize a cursor

db.row_factory = sqlite3.Row
cursor = db.cursor()

• Create and execute query to database

query = "select * from testtable"
cursor.execute(query)

• Grab result into a list

rows = cursor.fetchall()

• Prepared statements
  ? tells SQLite to substiute a passed in value.

quert = "select * from testtable where name=?"
t=(petname,)
cursor.execute(query,t)

• Creating Databases
  To create a new database run:

sqlite3 newDatabaseName.sql
sqlite3> .schema
sqlite3> CREATE TABLE states (id varchar(1),
abbreviation varchar(2), name varchar(20));