Django notes

slugs = {"ABL"} print(TranslationProject.objects.filter(tx_slug__isnull=True, short_code__in=slugs).query)

Will display

SELECT "core_translationproject"."id", "core_translationproject"."short_code", "core_translationproject"."long_code", "core_translationproject"."tx_slug", "core_translationproject"."deleted" FROM "core_translationproject" WHERE ("core_translationproject"."tx_slug" IS NULL AND "core_translationproject"."short_code" IN (ABL))

from django.db.models import F, sql qs = TranslationProject.objects.filter(tx_slug__isnull=True, short_code__in=slugs) q = qs.query.clone(sql.UpdateQuery) q.add_update_values({'tx_slug': F('short_code')}) print(q)

Will display

UPDATE "core_translationproject" SET "tx_slug" = "core_translationproject"."short_code" WHERE ("core_translationproject"."tx_slug" IS NULL AND "core_translationproject"."short_code" IN (ABL))