sqla_intro.py

"""
Tutorial at http://docs.sqlalchemy.org/en/rel_0_8/orm/tutorial.html
Data at http://pastie.org/5659260

Key Points:
 - requires: sqlalchemy, psycopg2
 - Setting up new database and user
 - Difference between sql, postgres, sqlite
 - Sqlite and timezones
 - Connecting to the DB and DSNs
 - Postegres, templates, unicode issues
 - Adding and retrieving data

 - install postgres
"""

from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
import urllib2
import csv

#engine = create_engine('postgresql://localhost/pyclass1', echo=True)
#Base = declarative_base()
#Base.metadata.create_all(engine)
#Session = sessionmaker(bind=engine)


#class TaxReturns(Base):
#    __tablename__ = 'movies'


def add_stuff():
    pass


def get_stuff():
    pass


def get_csv():
    """
    Get csv from the file system and make a list/dictionary
     ... whatever makes sense
    """

    field_names = ["RecordNumber","Zipcode","ZipCodeType","City","State","LocationType","Lat","Long","Xaxis","Yaxis","Zaxis","WorldRegion","Country","LocationText","Location","Decommisioned","TaxReturnsFiled","EstimatedPopulation","TotalWages","Notes"]
    
    with open('pastie-5659260.txt', 'rb') as csvfile:
        spamreader = csv.DictReader(csvfile, fieldnames=field_names,  delimiter=',', quotechar='"')
        import pdb; pdb.set_trace()
        for row in spamreader.values():
            print spamreader.next()


if __name__ == '__main__':
    get_csv()
    #add_stuff()
    #get_stuff()