How to properly manage a cascade delete

[FacuRiccardi]

Im currently working with Keystonejs 6 and I want to know how to properly manage a cascade delete.

I have a this list called Lot:

import { list } from '@keystone-6/core'
import { timestamp, relationship } from '@keystone-6/core/fields'
import { userAccess } from '../lib/auth'

export default list({
  access: userAccess(),
  fields: {
    createdAt: timestamp({
      defaultValue: { kind: 'now' },
      db: { map: 'created_at' },
      ui: { createView: { fieldMode: 'hidden' } }
    }),
    kmzFiles: relationship({ ref: 'Kmz', many: true })
  }
})

And I this other called kmz

import { list } from '@keystone-6/core'
import { file, timestamp } from '@keystone-6/core/fields'
import { userAccess } from '../lib/auth'

export default list({
  access: userAccess(),
  fields: {
    createdAt: timestamp({
      defaultValue: { kind: 'now' },
      db: { map: 'created_at' },
      ui: { createView: { fieldMode: 'hidden' } }
    }),
    file: file({ storage: 'kmzFiles' })
  }
})

This relationship creates a table on my db called Lot_kmzFiles, and it doesn't actually creates any field with information about the reference so I'm not able to delete the Kmzs related to the Lot on the Lot delete.

I tryed with various differents ways of doing this, but I don't get it to work, so I don't know if I'm missing something from the documentation of it isn't a feature of keystone yet.

I would love any help with this problem! Thanks.

[TheRealFlyingCoder]

Hey @FacuRiccardi I feel your frustration I went through the same problem... you have to write a custom relationship wrapper to handle extending the prisma schema

export const relationshipCascadeDelete: typeof relationship = config => {
	function addCascadeDelete(line: string) {
		return line.replace(')', ', onDelete: Cascade)');
	}
	return relationship({
		...config,
		many: false,
		db: {
			foreignKey: true,
			extendPrismaSchema: schema => {
				if (schema.startsWith('from')) return config.db?.extendPrismaSchema ? config.db?.extendPrismaSchema(schema) : schema;
				return config.db?.extendPrismaSchema ? config.db?.extendPrismaSchema(addCascadeDelete(schema)) : addCascadeDelete(schema);
			},
		},
	} as RelationshipFieldConfig<SessionListTypeInfo>);
};

Should definitely just be a config option though it's wild that it's not