thoas

#!/usr/bin/env python

import getopt
import sys
from sqlalchemy import create_engine, MetaData, Table
from sqlalchemy.dialects.mysql.base import TINYINT
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.exc import ProgrammingError

russss

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

# 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'))