Could not reflect: requested table(s) not available in Engine

来源：16-3 申请免费https证书和上程序送审步骤

一打哥哥

2020-04-19

创建一个数据表
DROP TABLE IF EXISTS work_list;
CREATE TABLE work_list (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
name varchar(100) NOT NULL DEFAULT ‘’ COMMENT ‘姓名’,
mobile varchar(11) NOT NULL DEFAULT ‘’ COMMENT ‘手机号码’,
updated_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘最后一次更新时间’,
created_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘插入时间’,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=‘工作表’;

然后通过flask-sqlacodegen生成ORM对象
flask-sqlacodegen ‘mysql://root:123456@127.0.0.1/food_db’ --tables work_list --outfile “common/models/hooker.py” --flask
出现以下错误
Traceback (most recent call last):
File “/Users/zhangyi/.pyenv/versions/imooc/bin/flask-sqlacodegen”, line 11, in
sys.exit(main())
File “/Users/zhangyi/.pyenv/versions/3.6.4/envs/imooc/lib/python3.6/site-packages/sqlacodegen/main.py”, line 55, in main
metadata.reflect(engine, args.schema, not args.noviews, tables)
File “/Users/zhangyi/.pyenv/versions/3.6.4/envs/imooc/lib/python3.6/site-packages/sqlalchemy/sql/schema.py”, line 3957, in reflect
(bind.engine, s, ', '.join(missing)))
sqlalchemy.exc.InvalidRequestError: Could not reflect: requested table(s) not available in Engine(mysql://root:***@127.0.0.1/food_db): (work_list)
图片描述