sqlalchemy_sample.py

import sqlalchemy
from sqlalchemy.orm import sessionmaker
from sqlalchemy import Column, Integer, String, Text, DateTime
from sqlalchemy.ext.declarative import declarative_base


engine = sqlalchemy.create_engine("sqlite:///foo.db", echo=True)

Base = declarative_base()


@contextmanager
def session_scope(session_maker):
    session = session_maker()
    try:
        yield session
        session.commit()
    except Exception as e:
        session.rollback()
    finally:
        session.close()


class Project(Base):
    __tablename__ = 'projects'
    id = Column(Integer, primary_key=True)
    url = Column(String(255))
    title = Column(String(255))
    description = Column(Text())
    created_at = Column(DateTime())

Base.metadata.create_all(engine)


session_maker = sessionmaker(bind=engine)


with session_scope(session_maker) as session:
    print(session.query(Project).all())