python - 在运行记录器之前对表进行查询。迁移(django_migrations)？

Question

我需要在表django_migrations中写入我正在使用的内容:

fix_migration.py

from django.db import connection
from django.db.migrations import recorder
    recorder.MigrationRecorder(connection).record_applied("registro_movimientos", "0001_initial")

我通过python manage.py runscript fix_migration.py

应用它

但我需要首先检查之前是否应用过迁移，例如:

query = django_migrations.filter(name=0001_initial, app="registro_movimientos")

if not query:
    recorder.M ....

谢谢。

Answer 1

我找到一个解决方案

first:执行搜索依赖迁移的sql

之后:执行sql来验证当前迁移是否已应用

from django.db import connection
from django.db.migrations import recorder

cursor = connection.cursor()
depends = cursor.execute(
    'SELECT name FROM django_migrations WHERE name = "0001_initial" AND app = "registro_movimientos"')

re = cursor.execute('SELECT name FROM django_migrations WHERE name = "0002_auto_20171205_1645" AND app = "registro_movimientos"')


if depends and not re:
    print("applying migration 0002_auto_20171205_1645 ... ")
    recorder.MigrationRecorder(connection).record_applied("registro_movimientos", "0002_auto_20171205_1645")

有效。