Example that throws exception.

gistfile1.txt

# Created to illustrate an example for:
# https://github.com/sqlalchemy/sqlalchemy/issues/6102

from typing import List

from sqlalchemy import (Column, Integer, String)
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import Session

Base = declarative_base()


class Example(Base):

  __tablename__ = "examples"

  id = Column(Integer, primary_key=True)
  name = Column(String, nullable=False)

  @classmethod
  def get_data_by_name(
      cls, session: Session, name: str
  ) -> List["Example"]:
      return session.execute(
          select(cls).where(cls.name == name)
      ).scalars().all()