CASCADE on delete removed from key foregin keys

1 files changed, 19 insertions, 19 deletions

diff --git a/core/models_survex.py b/core/models_survex.py
index 4f53993..d732130 100644
--- a/core/models_survex.py
+++ b/core/models_survex.py
@@ -9,8 +9,8 @@ from django.urls import reverse
 
 class SurvexDirectory(models.Model):
     path = models.CharField(max_length=200)
-    cave = models.ForeignKey('Cave', blank=True, null=True,on_delete=models.CASCADE)
-    primarysurvexfile = models.ForeignKey('SurvexFile', related_name='primarysurvexfile', blank=True, null=True,on_delete=models.CASCADE)
+    cave = models.ForeignKey('Cave', blank=True, null=True,on_delete=models.SET_NULL)
+    primarysurvexfile = models.ForeignKey('SurvexFile', related_name='primarysurvexfile', blank=True, null=True,on_delete=models.SET_NULL)
     # could also include files in directory but not referenced
     
     class Meta:
@@ -24,8 +24,8 @@ class SurvexDirectory(models.Model):
 
 class SurvexFile(models.Model):
     path = models.CharField(max_length=200)
-    survexdirectory = models.ForeignKey("SurvexDirectory", blank=True, null=True,on_delete=models.CASCADE)
-    cave = models.ForeignKey('Cave', blank=True, null=True,on_delete=models.CASCADE)
+    survexdirectory = models.ForeignKey("SurvexDirectory", blank=True, null=True,on_delete=models.SET_NULL)
+    cave = models.ForeignKey('Cave', blank=True, null=True,on_delete=models.SET_NULL)
     
     class Meta:
         ordering = ('id',)
@@ -64,8 +64,8 @@ class SurvexStationLookUpManager(models.Manager):
 
 class SurvexStation(models.Model):
     name        = models.CharField(max_length=100)   
-    block       = models.ForeignKey('SurvexBlock',on_delete=models.CASCADE)
-#   equate      = models.ForeignKey('SurvexEquate', blank=True, null=True,on_delete=models.CASCADE)
+    block       = models.ForeignKey('SurvexBlock', null=True,on_delete=models.SET_NULL)
+#   equate      = models.ForeignKey('SurvexEquate', blank=True, null=True,on_delete=models.SET_NULL)
     objects = SurvexStationLookUpManager()
     x = models.FloatField(blank=True, null=True)
     y = models.FloatField(blank=True, null=True)
@@ -99,17 +99,17 @@ class SurvexBlockLookUpManager(models.Manager):
 class SurvexBlock(models.Model):
     objects = SurvexBlockLookUpManager()
     name       = models.CharField(max_length=100)
-    parent     = models.ForeignKey('SurvexBlock', blank=True, null=True,on_delete=models.CASCADE)
-    cave       = models.ForeignKey('Cave', blank=True, null=True,on_delete=models.CASCADE)
+    parent     = models.ForeignKey('SurvexBlock', blank=True, null=True,on_delete=models.SET_NULL)
+    cave       = models.ForeignKey('Cave', blank=True, null=True,on_delete=models.SET_NULL)
     
     date       = models.DateField(blank=True, null=True)
-    expeditionday = models.ForeignKey("ExpeditionDay", null=True,on_delete=models.CASCADE)
-    expedition = models.ForeignKey('Expedition', blank=True, null=True,on_delete=models.CASCADE)
+    expeditionday = models.ForeignKey("ExpeditionDay", null=True,on_delete=models.SET_NULL)
+    expedition = models.ForeignKey('Expedition', blank=True, null=True,on_delete=models.SET_NULL)
         
-    survexfile = models.ForeignKey("SurvexFile", blank=True, null=True,on_delete=models.CASCADE)
+    survexfile = models.ForeignKey("SurvexFile", blank=True, null=True,on_delete=models.SET_NULL)
     survexpath = models.CharField(max_length=200)   # the path for the survex stations
     
-    scansfolder = models.ForeignKey("ScansFolder", null=True,on_delete=models.CASCADE)  
+    scansfolder = models.ForeignKey("ScansFolder", null=True,on_delete=models.SET_NULL)  
     
     legsall   = models.IntegerField(null=True)  # summary data for this block
     legssplay = models.IntegerField(null=True)  # summary data for this block
@@ -146,9 +146,9 @@ class SurvexBlock(models.Model):
         return list(self.expeditionday.survexblock_set.all()).index(self)
 
 class SurvexTitle(models.Model):
-    survexblock = models.ForeignKey('SurvexBlock',on_delete=models.CASCADE)
+    survexblock = models.ForeignKey('SurvexBlock',null=True, on_delete=models.SET_NULL)
     title       = models.CharField(max_length=200) # needed by svxcavesingle.html template
-    cave        = models.ForeignKey('Cave', blank=True, null=True,on_delete=models.CASCADE)
+    cave        = models.ForeignKey('Cave', blank=True, null=True,on_delete=models.SET_NULL)
 
 #
 # member of a SurvexBlock
@@ -170,10 +170,10 @@ class SurvexPersonRole(models.Model):
     nrole               = models.CharField(choices=ROLE_CHOICES, max_length=200, blank=True, null=True)
         # increasing levels of precision
     personname          = models.CharField(max_length=100)
-    person              = models.ForeignKey('Person', blank=True, null=True,on_delete=models.CASCADE)
-    personexpedition    = models.ForeignKey('PersonExpedition', blank=True, null=True,on_delete=models.CASCADE)
-    persontrip          = models.ForeignKey('PersonTrip', blank=True, null=True,on_delete=models.CASCADE)  
-    expeditionday       = models.ForeignKey("ExpeditionDay", null=True,on_delete=models.CASCADE)
+    person              = models.ForeignKey('Person', blank=True, null=True,on_delete=models.SET_NULL)
+    personexpedition    = models.ForeignKey('PersonExpedition', blank=True, null=True,on_delete=models.SET_NULL)
+    persontrip          = models.ForeignKey('PersonTrip', blank=True, null=True,on_delete=models.SET_NULL)  
+    expeditionday       = models.ForeignKey("ExpeditionDay", null=True,on_delete=models.SET_NULL)
     
     def __str__(self):
         return str(self.person) + " - " + str(self.survexblock) + " - " + str(self.nrole)
@@ -194,7 +194,7 @@ class ScansFolder(models.Model):
 class SingleScan(models.Model):
     ffile               = models.CharField(max_length=200)
     name                = models.CharField(max_length=200)
-    scansfolder   = models.ForeignKey("ScansFolder", null=True,on_delete=models.CASCADE)
+    scansfolder   = models.ForeignKey("ScansFolder", null=True,on_delete=models.SET_NULL)
     
     class Meta:
         ordering = ('name',)