migrations.RunSQL.noop for reversible SQL migrations#

migrations.RunSQL.noop provides an easy way to create “reversible” Django SQL migrations, where the reverse operation does nothing (but keeps it possible to reverse back to a previous migration state without being blocked by an irreversible migration).

1
from django.db import migrations
2

3

4
class Migration(migrations.Migration):
5

6
    dependencies = [
7
        ("app", "0114_last_migration"),
8
    ]
9

10
    operations = [
11
        migrations.RunSQL(
12
            sql="""
13
                update concordance_identifier
14
                set authority = replace(authority, ':', '_')
15
                where authority like '%:%'
16
            """,
17
            reverse_sql=migrations.RunSQL.noop,
18
        )
19
    ]