FastAPI Connect FastAPI to MySQL - 62

 

1. pymysql 설치

버전 - 1.0.2

pip install pymysql

 

2. database.py 수정

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

#SQLALCHEMY_DATABASE_URL = "sqlite:///./todos.db"
#SQLALCHEMY_DATABASE_URL = "postgresql://{사용자이름}:{사용자패스워드}@{host}/{database}"
SQLALCHEMY_DATABASE_URL = "mysql+pymysql://{사용자이름}:{사용자패스워드}@{host}/{database}"

#engine = create_engine(
#	SQLALCHEMY_DATABASE_URL, connect_args={"check_same_thread": False}
#)
engine = create_engine(
	SQLALCHEMY_DATABASE_URL
)

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


Base = declarative_base()

 

3. POST API로 2개의 사용자 생성

 

4. Mysql에서 사용자 데이터 생성 확인