FastAPI之连接数据库
1.databases.py
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
SQLALCHEMY_DATABASE_URL = 'mysql+pymysql://username:password@localhost/fastapi_demo'
# 数据库链接：mysql+pymysql://用户名:密码@ip/库名
engine = create_engine(SQLALCHEMY_DATABASE_URL)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
Base = declarative_base(
2.models.py
from sqlalchemy import Column, Integer, String, Boolean, DateTime, ForeignKey, Text, Float
from database import Base, engine
class User(Base):
__tablename__ = 'user'
id = Column(Integer, primary_key=True)
username = Column(String(100), unique=True, nullable=False)
password = Column(String(100), nullable=False)
3.main.py
from database import engine
import models
models.Base.metadata.create_all(engine)