Why doesn't Ghost use CASCADE DELETE for has many relations?

Dexter_Leng · December 4, 2018, 10:58am

TryGhost/Ghost/blob/bf295a96a849f10609ea6ae489f718914034ca24/core/server/api/v2/users.js#L122


      
              'id'
          ],
          validation: {
              options: {
                  id: {
                      required: true
                  }
              }
          },
          permissions: true,
          query(frame) {
              return models.Base.transaction((t) => {
                  frame.options.transacting = t;
          
          
        return Promise.all([
                      models.Accesstoken.destroyByUser(frame.options),
                      models.Refreshtoken.destroyByUser(frame.options),
                      models.Post.destroyByAuthor(frame.options)
                  ]).then(() => {
                      return models.User.destroy(Object.assign({status: 'all'}, frame.options));
                  }).return(null);

I was wondering why the child has the be deleted manually before the parent, instead of just using cascade delete.

system · December 18, 2018, 10:58am

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
I am adding Mongoose support to Ghost Using Ghost	6	791	August 3, 2021
Deleting the Ghost user spits out a JSON file Developer help	2	284	November 8, 2020
Ghost Install on DirectAdmin VPS -- Upload works, Put/Delete fails, uses vhosts on nginx [SOLVED] Migrations	1	1093	July 23, 2021
Transferring ghost between vps Developer help	0	284	January 24, 2021
Delete Old Logs / Backups? Using Ghost	0	186	August 29, 2023

Why doesn't Ghost use CASCADE DELETE for has many relations?

Related Topics