Add "created" field on main items in order to facilitate queries

1 files changed, 15 insertions, 0 deletions

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)