Python使用sqlalchemy连接本地数据库

最新推荐文章于 2024-06-12 07:12:47 发布

是Yuthin吖

最新推荐文章于 2024-06-12 07:12:47 发布

阅读量621

点赞数 10

文章标签：数据库

本文链接：https://blog.csdn.net/qq_41693059/article/details/134832111

版权

创建引擎，初始化数据库连接
engine = create_engine('mysql+pymysq://用户名:口令@机器地址:端口号/数据库名')

from loguru import logger
from sqlalchemy import create_engine
from sqlalchemy.orm import DeclarativeBase, sessionmaker


# 创建引擎，初始化数据库连接
# engine = create_engine('mysql+pymysq://用户名:口令@机器地址:端口号/数据库名')
LOCALHOST_URI = ("mysql://root:123456@localhost:3306/"
                 "report_web?charset=utf8")

engine = create_engine(LOCALHOST_URI, pool_size=50, max_overflow=10, echo=False)
Session = sessionmaker(engine)



class Base(DeclarativeBase):
    pass


def init_db_report_web():
    logger.info("bill models connect db")
    Base.metadata.create_all(engine)
    logger.info("bill models db connect success")