from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from sqlalchemy import Column,Integer,String,DateTime,Boolean

engine = create_engine('mysql+pymysql://root:root@localhost:3306/news?charset=utf8')
Session = sessionmaker(bind=engine)
Base = declarative_base()


class News(Base):
    # 表名
    __tablename__ = 'news'
    id = Column(Integer, primary_key=True, autoincrement=True)
    title = Column(String(200), nullable=False)
    content = Column(String(2000), nullable=False, default='新闻内容')
    types = Column(String(20), nullable=False)
    image = Column(String(300), default="")
    author = Column(String(20), default="")
    view_count = Column(Integer, default=0)
    created_at = Column(DateTime)
    is_valid = Column(Boolean, default=True)


class MysqlOrmTest(object):
    def __init__(self):
        self.session = Session()

    def add_one(self):
        # 添加一条数据
        news_obj = News(
            title='ORM',
            types='时事新闻'
        )
        self.session.add(news_obj)
        self.session.commit()
        return news_obj


def main():
    obj = MysqlOrmTest()
    result = obj.add_one()
    print(result)


if __name__ == "__main__":
    main()

不知道什么原因总是创建表失败，找不到表
报错信息

sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'news.news' doesn't exist") [SQL: 'INSERT INTO news (title, content, types, image, author, view_count, created_at, is_valid) VALUES (%(title)s, %(content)s, %(types)s, %(image)s, %(author)s, %(view_count)s, %(created_at)s, %(is_valid)s)'] [parameters: {'image': '', 'view_count': 0, 'title': '', 'author': '', 'created_at': None, 'content': '新闻内容', 'is_valid': 1, 'types': '时事新闻'}]