from sqlalchemy import *
from sqlalchemy.orm import sessionmaker, relation, eagerload, scoped_session
from sqlalchemy.ext.declarative import declarative_base
import datetime
engine = 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)