blocks|key|5027807|text|删除数据库中表alembic_version中的特定记录。只有一个名为version_num的varchar列，所以这个表达式应该可以工作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5027808|delete+from+alembic_version+where+version_num='470572fac7a1';|offset|length|style|CODE|5027809|entityMap^0|0|0|1P|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Delete that particular record in the table alembic_version that's in your database. There's only one varchar column called version_num, so this expression should work:

<code>delete from alembic_version where version_num='470572fac7a1';</code>

blocks|key|167327|text|删除/migrations目录并重命名/复制您的应用程序数据库。然后从头开始。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|167328|flask+db+init
flask+db+migrate
flask+db+upgrade|code-block|syntax|javascript|167329|现在用备份中的数据重新填充新的空数据库。|167330|entityMap^0|2|B|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

Delete the <code>/migrations</code> directory and rename/replicate your applications database. Then start from scratch.

<pre><code>flask db init
flask db migrate
flask db upgrade
</code></pre>

Now repopulate your new empty database with data from your backup.

blocks|key|5027941|text|您必须删除数据库中的alembic_version表。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|5027942|连接到您的数据库，并执行：|5027943|DROP+TABLE+alembic_version;|code-block|syntax|javascript|5027944|有关此https://stackoverflow.com/a/32356600的更多详细信息，请检查以下答案|5027945|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/32356600^0|A|F|0|0|0|3|10|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Z|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|10|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|11|8|@]|D|@$9|12|A|13|1|14]]|E|$]]|$1|O|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]]]

You must delete alembic_version table in your database.
Connect to your database, and execute:
<pre><code>DROP TABLE alembic_version;
</code></pre>
Please check the following answer for more details about this <a href="https://stackoverflow.com/a/32356600">https://stackoverflow.com/a/32356600</a>

blocks|key|165054|text|转到migrations/中的versions/。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|165055|如果看不到文件夹versions/或文件夹versions/中没有修订版，请键入以下命令以创建修订版：|165056|flask+db+revision|code-block|syntax|javascript|165057|您将在versions/文件夹中获得一个修订版。打开它并将修订id替换为'470572fac7a1'：|165058|revision+=+"470572fac7a1"|165059|再次键入flask+db+migrate。|165060|应该行得通。|165061|entityMap^0|2|B|F|9|0|8|9|L|9|0|0|3|9|0|0|4|G|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|11|8|@$9|12|A|13|B|C]|$9|14|A|15|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|16|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|17|8|@$9|18|A|19|B|C]]|D|@]|E|$]]|$1|O|3|P|5|J|7|1A|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|1B|8|@$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|S|3|T|5|6|7|1E|8|@]|D|@]|E|$]]|$1|U|3|-4|5|6|7|1F|8|@]|D|@]|E|$]]]|V|$]]

Go to <code>versions/</code> inside <code>migrations/</code>.
If you do not see the folder <code>versions/</code> or there is not a revision inside the folder <code>versions/</code>, type the following command to create a revision:
<pre><code>flask db revision
</code></pre>
You'll get a revision inside the <code>versions/</code> folder. Open it and replace the revision id with '470572fac7a1':
<pre><code>revision = &quot;470572fac7a1&quot;
</code></pre>
Type <code>flask db migrate</code> again.
Should work.

blocks|key|2079077|text|从github拉取最新版本。然后备份你的prod数据库。然后恢复你的本地数据库。删除您的alembic表(带级联)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2079078|打开你的终端(用venv)，写下面的代码：|2079079|rm+-+rf+migrations
python+manage.py+db+init|code-block|syntax|javascript|2079080|并打开迁移文件夹。右键单击alembic.ini并选择git>rollback>ok。|2079081|python+manage.py+db+migrate
python+manage.py+db+upgrade|2079082|或|2079083|python+manage.py+db+stamp+head
python+manage.py+db+migrate
python+manage.py+db+upgrade|2079084|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

pull last version from github.
And then backup your prod db. Then restore your local db.
Delete your alembic table (with cascade).
Open your terminal (with venv)
write code below:
<pre><code>rm - rf migrations
python manage.py db init
</code></pre>
and open migrations folder. Right click on alembic.ini and choose git&gt;rollback&gt;ok.
<pre><code>python manage.py db migrate
python manage.py db upgrade
</code></pre>
or
<pre><code>python manage.py db stamp head
python manage.py db migrate
python manage.py db upgrade
</code></pre>

I accidentally deleted my migrations folder. So I ran <code>flask db init</code>, and everything ran smoothly. But when I ran <code>flask db migrate</code>, it gave me this error:

<pre><code>INFO [alembic.runtime.migration] Context impl SQLiteImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
ERROR [root] Error: Can't locate revision identified by '470572fac7a1'
</code></pre>

From what I understand, it's looking for my other migration folder which is long gone. How can I solve this?

Reset Alembic after deleting migration folder

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我不小心删除了我的迁移文件夹。所以我运行了flask db init，一切都运行得很顺利。但是当我运行flask db migrate时，它给出了这个错误：INFO  [alembic.runtime.migration] Context impl SQLiteImpl.INFO  [alembic.runtime.migration] Will assume non-transactional 

问删除迁移文件夹后重置Alembic
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问删除迁移文件夹后重置AlembicEN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问删除迁移文件夹后重置Alembic
EN