From ec2ef1a59c01d79d0341545b92a07a60dee6321d Mon Sep 17 00:00:00 2001 From: Étienne Loks Date: Mon, 30 Jan 2023 17:32:49 +0100 Subject: Add "created" field on main items in order to facilitate queries --- ishtar_common/utils_migrations.py | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'ishtar_common/utils_migrations.py') diff --git a/ishtar_common/utils_migrations.py b/ishtar_common/utils_migrations.py index 44eae940e..ec0b46509 100644 --- a/ishtar_common/utils_migrations.py +++ b/ishtar_common/utils_migrations.py @@ -185,3 +185,18 @@ def set_uuid_helper(module, model_name): migrate_uuid(model) return set_uuid + + +def migrate_created_field(apps, app_name, model_names): + for model_name in model_names: + model = apps.get_model(app_name, model_name) + try: + model_history = apps.get_model(app_name, "Historical" + model_name) + except: + continue + for item in model.objects.all(): + q = model_history.objects.filter(id=item.pk).order_by("history_date") + if not q.count(): + continue + history_date = q.all()[0].history_date + item.__class__.objects.filter(pk=item.pk).update(created=history_date) -- cgit v1.2.3