python - 替换 Alembic 基本修订会引发 KeyError

Question

我正在尝试替换 Flask 应用程序中的 Alembic 基本版本。原因是没有为这个项目正确创建 Alembic 修订版，我想按照正确的顺序从初始数据库到最新版本。为此，我必须创建一个初始修订版并将其替换为树中的当前基本修订版。这是树在进行任何更改之前的样子：

>> alembic history
20b081e106eb -> f6b6d50b4012 (head), revision 6
604059d119b3 -> 1f6f72cb12a9, revision 5
fa56f5d34a18 -> 604059d119b3, revision 4
4e8f28c411ea -> fa56f5d34a18, revision 3
8494e6010c15 -> 4e8f28c411ea, revision 2
37b8265891db -> 8494e6010c15, revision 1
<base> -> 37b8265891db, previous base

我将down_revision生成的修订版更改为并将先前基础的None设置为生成的. 当我检查历史记录时，我看到一切都井井有条，并且我的新基础修订版已替换为以前的基础版本，并且之前的基础版本修改了生成的基础：down_revisionrevision_ID

>> alembic history
20b081e106eb -> f6b6d50b4012 (head), revision 6
604059d119b3 -> 1f6f72cb12a9, revision 5
fa56f5d34a18 -> 604059d119b3, revision 4
4e8f28c411ea -> fa56f5d34a18, revision 3
8494e6010c15 -> 4e8f28c411ea, revision 2
37b8265891db -> 8494e6010c15, revision 1
47f0eb12e6b5 -> 37b8265891db, previous base
<base> -> 47f0eb12e6b5, initial database (new)

现在，当我运行时alembic upgrade head，我收到了这个错误：

 File "/export/content/lid/apps/sec-assistant/dev-i001/libexec/sec-assistant_5a281323-d247-4339-afcf-79b88f9fab38/site-packages/alembic/script/base.py", line 329, in _upgrade_revs
        revs = list(revs)
      File "/export/content/lid/apps/sec-assistant/dev-i001/libexec/sec-assistant_5a281323-d247-4339-afcf-79b88f9fab38/site-packages/alembic/script/revision.py", line 652, in _iterate_revisions
        uppers = util.dedupe_tuple(self.get_revisions(upper))
      File "/export/content/lid/apps/sec-assistant/dev-i001/libexec/sec-assistant_5a281323-d247-4339-afcf-79b88f9fab38/site-packages/alembic/script/revision.py", line 300, in get_revisions
        resolved_id, branch_label = self._resolve_revision_number(id_)
      File "/export/content/lid/apps/sec-assistant/dev-i001/libexec/sec-assistant_5a281323-d247-4339-afcf-79b88f9fab38/site-packages/alembic/script/revision.py", line 433, in _resolve_revision_number
        self._revision_map
      File "/export/content/lid/apps/sec-assistant/dev-i001/libexec/sec-assistant_5a281323-d247-4339-afcf-79b88f9fab38/site-packages/alembic/util/langhelpers.py", line 240, in __get__
        obj.__dict__[self.__name__] = result = self.fget(obj)
      File "/export/content/lid/apps/sec-assistant/dev-i001/libexec/sec-assistant_5a281323-d247-4339-afcf-79b88f9fab38/site-packages/alembic/script/revision.py", line 151, in _revision_map
        down_revision = map_[downrev]
    KeyError: '47f0eb12e6b5'

有什么方法可以解决这个问题，而无需删除并重新生成从基础到头部的所有修订？

标签： pythonsqlalchemyalembic