创建一个数据表
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)
macos系统,帮忙看一下为什么会有这个错误,谢谢