sqlalchemy-example.py

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

# Create model
Base = declarative_base()
class User(Base):
  __tablename__ = 'users'
  
  id = Column(Integer, primary_key=True)
  name = Column(String)
  fullname = Column(String)
  nickname = Column(String)
  
# Create tables
engine = create_engine('postgresql+psycopg2://scott:tiger@localhost/mydatabase')
Base.metadata.create_all(engine)

# Create session
Session = sessionmaker(bind=engine)

# Create user
ed_user = User(name='ed', fullname='Ed Jones', nickname='edsnickname')
session.add(ed_user)

# Read user
session.query(User).filter_by(name='ed').first() 
# <User(name='ed', fullname='Ed Jones', nickname='edsnickname')>