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)