惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

云风的 BLOG
云风的 BLOG
M
MIT News - Artificial intelligence
Recent Announcements
Recent Announcements
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
Stack Overflow Blog
Stack Overflow Blog
J
Java Code Geeks
Microsoft Azure Blog
Microsoft Azure Blog
罗磊的独立博客
博客园 - 【当耐特】
H
Help Net Security
腾讯CDC
大猫的无限游戏
大猫的无限游戏
GbyAI
GbyAI
Last Week in AI
Last Week in AI
Jina AI
Jina AI
博客园 - 聂微东
Blog — PlanetScale
Blog — PlanetScale
A
About on SuperTechFans
Apple Machine Learning Research
Apple Machine Learning Research
P
Proofpoint News Feed
Y
Y Combinator Blog
C
Check Point Blog
博客园 - 司徒正美
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知

博客园 - 干炸小黄鱼

timex 处理时间戳 gorm-gen go 雪花算法 golang每日一库--协程池库ants golang每日一库--json解析库gjson python高级编程-asyncio python高级编程-condition python高级编程-event python装饰器-自动重试 EAP系统 go实现实现 SECS/GEM 协议 设备通信协议 SECS go项目使用Jenkins进行CICD go操作ES mongo db聚合查询 go如何使用mongodb Apache ShardingSphere paxos and raft (分布式一致性算法) go使用zookeeper分布式锁以及和redis差异 go使用 seata 示例 Alibaba 分布式事务 Seata go中使用saga go中使用TCC示例 分布式事务TCC 熔断器 Hystrix OR Sentinel k8s下部署consul and etcd Consul OR Etcd 【力扣hot100】双指针-盛水最多的容器 【力扣hot100】滑动窗口-最小覆盖子串 shell脚本合集
flask migrate时报错 Can't locate revision identified by '...
干炸小黄鱼 · 2024-07-25 · via 博客园 - 干炸小黄鱼

flask 迁移数据库时可能会遇到找不到版本的问题

export FLASK_APP=run.py 
flask db migrate

执行上述命令时正常会提示加了哪些字段,删除了哪些字段
但是有时候会提示:
ERROR [flask_migrate] Error: Can't locate revision identified by '3d80e4c025df'
修复方法: 给指定一个版本号
flask db revision --rev-id 3d80e4c025df
然后执行迁移 flask db migrate

flask db migrate
INFO  [alembic.runtime.migration] Context impl MySQLImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
INFO  [alembic.autogenerate.compare] Detected removed column 'asset_IP.province_name'
INFO  [alembic.autogenerate.compare] Detected removed column 'asset_IP.province'
INFO  [alembic.autogenerate.compare] Detected removed column 'asset_IP.city_name'
INFO  [alembic.autogenerate.compare] Detected removed column 'asset_IP.city'
INFO  [alembic.autogenerate.compare] Detected added column 'organization.province'
INFO  [alembic.autogenerate.compare] Detected added column 'organization.province_name'
INFO  [alembic.autogenerate.compare] Detected added column 'organization.city'
INFO  [alembic.autogenerate.compare] Detected added column 'organization.city_name'

再执行升级 flask db upgrade

 flask db upgrade
INFO  [alembic.runtime.migration] Context impl MySQLImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 3d80e4c025df -> 87a8d47a7d0a, empty message