Skip to content

Instantly share code, notes, and snippets.

@russss
russss / paypal2ofx.py
Created August 7, 2011 22:15
Convert a paypal CSV export to an OFX file
import csv
import sys
from collections import namedtuple
rows = csv.reader(sys.stdin)
fields = [field.strip().lower().replace(' ', '_').replace('/', '_')
for field in rows.next() if field.strip() != '']
PaypalRecord = namedtuple('PaypalRecord', fields)
@mdellavo
mdellavo / sqlalchemy-typed-eav.py
Created March 23, 2011 21:45
A Typed Entity-Attribute-Value Pattern for SQLAlchemy
# CREATE TABLE foos (
# id INTEGER IDENTITY(1,1) NOT NULL PRIMARY KEY,
# );
# CREATE TABLE foo_data (
# foo_id INTEGER NOT NULL REFERENCES proposals(id),
# [key] VARCHAR(50) NOT NULL,
# [type] CHAR(1) NOT NULL DEFAULT 's' CHECK(type IN ('s', 'b', 'i', 'f'))