sqlalchemy.py

from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, Sequence, create_engine


engine = create_engine('sqlite:///:memory:')
Base = declarative_base()


class User(Base):
    __tablename__ = 'users'

    id = Column(Integer, Sequence('user_id_seq'), primary_key=True)
    name = Column(String(50))
    fullname = Column(String(50))
    nickname = Column(String(50))
    
    def __repr__(self):
        return f"User({self.name}, {self.fullname}, {self.nickname})"


Base.metadata.create_all(engine)

Session = sessionmaker(bind=engine)
session = Session()

edward = User(name='ed', fullname='Ed Jones', nickname='big_daddy')
session.add(edward)
# sesssion.commit()

session.query(User).all()