Miscellany

from sqlalchemy import *from sqlalchemy.orm import sessionmaker, relation, eagerload, scoped_sessionfrom sqlalchemy.ext.declarative import declarative_baseimport datetimeengine = create_engine('sqlite:///:memory:', echo=True)Session = sessionmaker(bind=engine)()metadata = MetaData()Declarative = declarative_base(metadata=metadata)class Test(Declarative):    __tablename__ = 'test'    id = Column(Integer, primary_key=True)    val = Column(Unicode(255), index=True)    date = Column(DateTime)        def __init__(self, val):        self.val = val        self.date = datetime.datetime.now()        Session.add(self)        Session.commit()    def __repr__(self):        return "<Test({0.id}, {0.val}, {0.date})>".format(self)metadata.create_all(bind=engine)