Add migration script to add sort field to checklists and their items

1 files changed, 26 insertions, 0 deletions

diff --git a/server/migrations.js b/server/migrations.js
index 99125976..2a99f564 100644
--- a/server/migrations.js
+++ b/server/migrations.js
@@ -130,3 +130,29 @@ Migrations.add('add-member-isactive-field', () => {
     Boards.update(board._id, {$set: {members: newMemberSet}}, noValidate);
   });
 });
+
+Migrations.add('add-sort-checklists', () => {
+  Checklists.find().forEach((checklist, index) => {
+    if (!checklist.hasOwnProperty('sort')) {
+      Checklists.direct.update(
+        checklist._id,
+        {
+          $set: {
+            sort: index,
+            newItemIndex: checklist.items.length,
+          }
+        },
+        noValidate
+      );
+    }
+    checklist.items.forEach(function(item, index) {
+      if (!item.hasOwnProperty('sort')) {
+        Checklists.direct.update(
+          { _id: checklist._id, "items._id": item._id },
+          { $set: { "items.$.sort": index } },
+          noValidate
+        );
+      }
+    });
+  });
+});