sqlalchemy.py

import pdb
import sqlalchemy as sa
from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()
engine = sa.create_engine("sqlite:///:memory:", echo=True)

class Item(Base):
    __tablename__ = 'items'

    id = Column(Integer, primary_key=True)
    name = Column(String)

    def __init__(self, name):
        self.name = name

    def __repr__(self):
        return "<Item #%d: %s>" % (self.id, self.name)
Base.metadata.create_all(engine)

DB = sessionmaker(bind=engine)
db1 = DB()
db2 = DB()

for name in ["Alice", "Bob", "Cathy", "Dave"]:
    db1.add(Item(name))
db1.flush()

for item in db2.query(Item):
    print item