部署Docker时使用nonebot-plugin-orm，如何迁移数据库？

[trytodupe]

如题，运行nb docker generate && nb docker up后，
docker compose logs查看日志会得到：
nonebot_plugin_orm.exception.AutogenerateDiffsDetected: 检测到新的升级操作:
如如何在docker中正确运行 nb orm upgrade ？

[trytodupe]

我尝试过在stage-1运行 python -m pipx run --no-cache nb orm upgrade ，但是会出现 ModuleNotFoundError: No module named 'utils'

[yanyongyu]

这个看上去是你运行的地方不对，应该在项目目录下。另外，你可以修改下启动命令，在启动的时候执行。一般 migrate 都是在每次 startup 执行的。

[trytodupe]

感谢回复，直接使用pip安装nb-cli后可以运行nb orm指令了。
但是在docker中运行nb orm upgrade后运行nb orm check仍然提示需要升级

root@02ec4b52670b:/app# nb orm upgrade
05-24 15:53:40 [SUCCESS] nonebot | NoneBot is initializing...
05-24 15:53:40 [INFO] nonebot | Current Env: prod
05-24 15:53:40 [SUCCESS] nonebot | Succeeded to load plugin "echo" from "nonebot.plugins.echo"
05-24 15:53:41 [SUCCESS] nonebot | Succeeded to load plugin "nonebot_plugin_localstore"
05-24 15:53:41 [SUCCESS] nonebot | Succeeded to load plugin "citation_counter" from "src.plugins.citation_counter"
05-24 15:53:41 [SUCCESS] nonebot | Succeeded to load plugin "nonebot_plugin_chatrecorder"
05-24 15:53:41 [SUCCESS] nonebot | Succeeded to load plugin "nonebot_plugin_status"
05-24 15:53:41 [SUCCESS] nonebot | Succeeded to load plugin "nonebot_plugin_localstore"
05-24 15:53:41 [SUCCESS] nonebot | Succeeded to load plugin "nonebot_plugin_orm"
05-24 15:53:41 [SUCCESS] nonebot | Succeeded to load plugin "nonebot_plugin_uninfo"
root@02ec4b52670b:/app# nb orm check
05-24 15:53:45 [SUCCESS] nonebot | NoneBot is initializing...
05-24 15:53:45 [INFO] nonebot | Current Env: prod
05-24 15:53:45 [SUCCESS] nonebot | Succeeded to load plugin "echo" from "nonebot.plugins.echo"
05-24 15:53:45 [SUCCESS] nonebot | Succeeded to load plugin "nonebot_plugin_uninfo"
05-24 15:53:46 [SUCCESS] nonebot | Succeeded to load plugin "nonebot_plugin_localstore"
05-24 15:53:46 [SUCCESS] nonebot | Succeeded to load plugin "nonebot_plugin_orm"
05-24 15:53:46 [SUCCESS] nonebot | Succeeded to load plugin "nonebot_plugin_localstore"
05-24 15:53:46 [SUCCESS] nonebot | Succeeded to load plugin "nonebot_plugin_chatrecorder"
05-24 15:53:46 [SUCCESS] nonebot | Succeeded to load plugin "nonebot_plugin_status"
05-24 15:53:46 [SUCCESS] nonebot | Succeeded to load plugin "citation_counter" from "src.plugins.citation_counter"
Error: 检测到新的升级操作:
[('remove_constraint',
  UniqueConstraint(Column('self_id', NullType(), table=<nonebot_plugin_uninfo_botmodel>), Column('adapter', NullType(), table=<nonebot_plugin_uninfo_botmodel>))),
 ('add_constraint',
  UniqueConstraint(Column('self_id', NullType(), table=<nonebot_plugin_uninfo_botmodel>), Column('adapter', NullType(), table=<nonebot_plugin_uninfo_botmodel>))),
 ('remove_constraint',
  UniqueConstraint(Column('bot_persist_id', NullType(), table=<nonebot_plugin_uninfo_scenemodel>), Column('scene_id', NullType(), table=<nonebot_plugin_uninfo_scenemodel>), Column('scene_type', NullType(), table=<nonebot_plugin_uninfo_scenemodel>))),
 ('add_constraint',
  UniqueConstraint(Column('bot_persist_id', NullType(), table=<nonebot_plugin_uninfo_scenemodel>), Column('scene_id', NullType(), table=<nonebot_plugin_uninfo_scenemodel>), Column('scene_type', NullType(), table=<nonebot_plugin_uninfo_scenemodel>))),
 ('remove_constraint',
  UniqueConstraint(Column('bot_persist_id', NullType(), table=<nonebot_plugin_uninfo_sessionmodel>), Column('scene_persist_id', NullType(), table=<nonebot_plugin_uninfo_sessionmodel>), Column('user_persist_id', NullType(), table=<nonebot_plugin_uninfo_sessionmodel>))),
 ('add_constraint',
  UniqueConstraint(Column('bot_persist_id', NullType(), table=<nonebot_plugin_uninfo_sessionmodel>), Column('scene_persist_id', NullType(), table=<nonebot_plugin_uninfo_sessionmodel>), Column('user_persist_id', NullType(), table=<nonebot_plugin_uninfo_sessionmodel>))),
 ('remove_constraint',
  UniqueConstraint(Column('bot_persist_id', NullType(), table=<nonebot_plugin_uninfo_usermodel>), Column('user_id', NullType(), table=<nonebot_plugin_uninfo_usermodel>))),
 ('add_constraint',
  UniqueConstraint(Column('bot_persist_id', NullType(), table=<nonebot_plugin_uninfo_usermodel>), Column('user_id', NullType(), table=<nonebot_plugin_uninfo_usermodel>)))]

[yanyongyu]

@ProgramRipper 看看？

[ProgramRipper]

我在所有插件最新（nonebot-plugin-orm==0.7.7 nonebot-plugin-uninfo==0.7.4)、使用 SQLite 数据库的情况下没能复现这个问题。能否提供更详细一点的信息，例如 pip list 的输出、使用的数据库。

[trytodupe]

感谢测试，换成新版之后没有这个问题了。
之前用的是：

nonebot-plugin-orm==0.7.6
nonebot-plugin-uninfo==0.6.2

[he0119]

https://github.com/he0119/CoolQBot/blob/main/prestart.sh

你可以添加一个 prestart.sh，在运行 nb run 之前运行。

[trytodupe]

感谢回复，仓库很有参考价值