Breaking News: Grepper is joining You.com. Read the official announcement!

django on-delete options

Add Answer

Smiling Starling answered on December 12, 2020 Popularity 9/10 Helpfulness 1/10

answer django on-delete options

related on_delete options django

related django on_delete options

django on-delete options

Comment

There are seven possible actions to take when such event occurs:

CASCADE: When the referenced object is deleted, also delete the objects that have references to it 
  (when you remove a blog post for instance, you might want to delete comments as well). 
  SQL equivalent: CASCADE.
      
PROTECT: Forbid the deletion of the referenced object. 
  To delete it you will have to delete all objects that reference it manually. 
  SQL equivalent: RESTRICT.
    
RESTRICT: (introduced in Django 3.1) Similar behavior as PROTECT that matches SQL's RESTRICT more accurately. (See django documentation example)
SET_NULL: Set the reference to NULL (requires the field to be nullable). 
  For instance, when you delete a User, you might want to keep the comments he posted on blog posts, 
  but say it was posted by an anonymous (or deleted) user. 
  SQL equivalent: SET NULL.
    
SET_DEFAULT: Set the default value. SQL equivalent: SET DEFAULT.
    
SET(...): Set a given value. This one is not part of the SQL standard and is entirely handled by Django.
  
DO_NOTHING: Probably a very bad idea since this would create integrity issues in your database 
  (referencing an object that actually doesn't exist). SQL equivalent: NO ACTION.

Popularity 9/10 Helpfulness 1/10 Language python

Source: www.codepins.net

Tags: django python

Link to this answer
Share Copy Link

Contributed on Apr 24 2022

Smiling Starling

0 Answers Avg Quality 2/10

Closely Related Answers

on_delete options django

Comment

There are seven possible actions to take when such event occurs:

CASCADE: When the referenced object is deleted, also delete the objects that have references to it 
  (when you remove a blog post for instance, you might want to delete comments as well). 
  SQL equivalent: CASCADE.
      
PROTECT: Forbid the deletion of the referenced object. 
  To delete it you will have to delete all objects that reference it manually. 
  SQL equivalent: RESTRICT.
    
RESTRICT: (introduced in Django 3.1) Similar behavior as PROTECT that matches SQL's RESTRICT more accurately. (See django documentation example)
SET_NULL: Set the reference to NULL (requires the field to be nullable). 
  For instance, when you delete a User, you might want to keep the comments he posted on blog posts, 
  but say it was posted by an anonymous (or deleted) user. 
  SQL equivalent: SET NULL.
    
SET_DEFAULT: Set the default value. SQL equivalent: SET DEFAULT.
    
SET(...): Set a given value. This one is not part of the SQL standard and is entirely handled by Django.
  
DO_NOTHING: Probably a very bad idea since this would create integrity issues in your database 
  (referencing an object that actually doesn't exist). SQL equivalent: NO ACTION.

Popularity 10/10 Helpfulness 6/10 Language python

Source: stackoverflow.com

Tags: python py

Link to this answer
Share Copy Link

Contributed on Dec 12 2020

0 Answers Avg Quality 2/10

django on_delete options

Comment

#ONDELETE CASCADE
your_foreign_key_field = models.ForeignKey(Your_Reference_Model, on_delete=models.CASCADE)

#ONDELETE SET_NULL
your_foreign_key_field = models.ForeignKey(Your_Reference_Model, on_delete=models.SET_NULL)

Popularity 10/10 Helpfulness 4/10 Language python

Source: Grepper

Tags: django dj

Link to this answer
Share Copy Link

Contributed on Jun 18 2022

serge kalaga

0 Answers Avg Quality 2/10

django on-delete options

Contents

More Related Answers

django on-delete options

Closely Related Answers

on_delete options django

django on_delete options

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.