Clean up all foreign-key constraints

This patch cleans up the remaining possible foreign-key constraint. This
case seem to appear, when notes are deleted, but due to missing database
contraints not their authroships.

This function should clean that up as well and complete the preparation
for the new db contraints.

Signed-off-by: Sheogorath <sheogorath@shivering-isles.com>

1 files changed, 20 insertions, 0 deletions

diff --git a/bin/cleanup b/bin/cleanup
index 6ccbb07d..b77fdb4e 100755
--- a/bin/cleanup
+++ b/bin/cleanup
@@ -55,6 +55,26 @@ async function cleanup() {
     }
   })
 
+  await models.Author.findAll({
+    include: [{
+      model: models.Note,
+      as: 'note',
+      attributes: ['id']
+    }],
+    attributes: ['id', 'noteId']
+  }).then(async function(authors) {
+    for(let i =0, authorCount = authors.length; i< authorCount; i++) {
+      const item = authors[i]
+      if(item.noteId != null && !item.note) {
+        await models.Author.destroy({
+          where: {
+            id: item.id
+        }})
+        logger.info(`Deleted authorship ${item.id} from note ${item.noteId}`)
+      }
+    }
+  })
+
   await models.Revision.findAll({
     include: [{
       model: models.Note,