Association Deletion is not working as expected.

[AmitKarnam]

Your Question

I have models as follows,

type MuscleGroup struct {
	gorm.Model         // Embedding gorm.Model
	MuscleGroup string `json:"muscle_group"`
	Description string `json:"description"`
}

type Exercise struct {
	gorm.Model                // Embedding gorm.Model
	Name          string      `json:"name"`
	Description   string      `json:"description"`
	MuscleGroupID uint        `json:"muscle_group_id"`                                                                      // Foreign key for MuscleGroup
	MuscleGroup   MuscleGroup `gorm:"foreignKey:MuscleGroupID;references:ID;constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"` // Association
}

Now I have an endpoint to delete a particular musclegroup, since my models follow a has-one relationship, When I delete a muscle group, I need the exercises using this muscle group as reference to be deleted. I've gone though the docs on soft delete and using select statement during delete. I added the clause.Associations now , but still the record for the exercise is present in the database. The referencing muscle group data shows empty when I query the exercise, but the muscle group is present. I was expecting the associated exercise to undergo a soft delete. Delete Query

	// Delete the muscle group from the database
	if err := dbConn.Select(clause.Associations).Delete(&muscleGroup).Error; err != nil {
		c.JSON(http.StatusInternalServerError, gin.H{"error": "error deleting muscle group"})
		return
	}

##Related Issue I've gone through
#3702

The document you expected this should be explained

1. https://gorm.io/docs/associations.html#Delete-with-Select
2. https://gorm.io/docs/delete.html

Expected answer

How can I delete the associated records in exercise table as a part of cascade delete , when I delete the muscle group.