pip install pymysql

from sqlalchemy import create_engine

from sqlalchemy.ext.declarative import declarative_base

from sqlalchemy.orm import sessionmaker

SQLALCHEMY_DATABASE_URL = "mysql+pymysql://root:@127.0.0.1:3306/test"

engine = create_engine(

    SQLALCHEMY_DATABASE_URL, encoding='utf8', echo=True

)

TestingSessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)

Base = declarative_base()

from sqlalchemy import Boolean, Column, ForeignKey, Integer, String

from sqlalchemy.orm import relationship

from config import EVENT

if EVENT == "test":

    from models.testDatabase import Base, engine

else:

    from models.database import Base, engine

class User(Base):

    __tablename__ = "users"

    id = Column(Integer, primary_key=True, index=True)

    email = Column(String(length=252), unique=True, index=True)

    hashed_password = Column(String(length=252))

    is_active = Column(Boolean, default=True)

    items = relationship("Item", back_populates="owner")

class Item(Base):

    __tablename__ = "items"

    id = Column(Integer, primary_key=True, index=True)

    title = Column(String(length=252), index=True)

    description = Column(String(length=252), index=True)

    owner_id = Column(Integer, ForeignKey("users.id"))

    owner = relationship("User", back_populates="items")