python数据库ORM sqlalchemy配置

from sqlalchemy import create_engine, Column, Integer, Text, String, DATETIME
from sqlalchemy.orm import sessionmaker, declarative_base

url = 'mysql+pymysql://root:123456@localhost/P833'
engine = create_engine(url)
DBSession = sessionmaker(bind=engine)
Base = declarative_base()


class Article(Base):
    __tablename__ = 'article'

    id = Column(Integer, primary_key=True, autoincrement=True)
    article_id = Column(String(255))
    title = Column(String(255))
    content = Column(Text)
    stock_list = Column(String(255))
    subject_list = Column(String(255))
    create_time = Column(String(255))
    update_time = Column(String(255))

Base.metadata.create_all(engine)

posted @ 2025-04-03 02:24  zqxLonely  阅读(21)  评论(0)    收藏  举报