Styjun

I have a domain, static IP address and many devices I'd like to access outside my house. How do I route them?

Wiring IKEA light fixture into old fixture

Revolutionaries' fleet armed with kinetic weapons defeats government fleet armed with missiles

Can we have too many dialogue tags and follow up actions?

Is it possible to access the complete command line including pipes in a bash script?

What kind of anatomy does a centaur have?

What's the 1 inch size square knob sticking out of wall?

Metaphysical Contemplation and Speculation

Does Impedance Matching Imply any Practical RF Transmitter Must Waste >=50% of Energy?

Get the next element of list in Python

Do Dragonborns get unarmored defense?

Ultraproduct of Dividing Lines

Adding gears to my grandson's 12" bike

Why can't a country print its own money to spend it only abroad?

How am I supposed to put out fires?

How can I indicate that what I'm saying is not sarcastic online?

Why did NASA use Imperial units?

What is the best word describing the nature of expiring in a short amount of time, connoting "losing public attention"?

Do I care if the housing market has gone up or down, if I'm moving from one house to another?

How to plot a crossection of a ParametricPlot3D?

German phrase for 'suited and booted'

Found more old paper shares from broken up companies

Strange LED behavior: Why is there a voltage over the LED with only one wire connected to it?

My current job follows "worst practices". How can I talk about my experience in an interview without giving off red flags?

Django 2.1/PostgreSQL - can I prevent deleting model objects?

How can I drop all the tables in a PostgreSQL database?Safely deleting a Django model from the database using a transactionDjango script to access model objects without using manage.py shellCorrect Way to Validate Django Model Objects?Django: deleted model objects regenerate themselves in postgresalDjango migration strategy for renaming a model and relationship fieldsHow to prevent django from loading objects in memory when using `delete()`?How to delete the Django model but not the database?How to add “ON DELETE” rules to existing column in a PostgreSQL database table?Trouble with adding rules before deletion of object model

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

3

1

There were some questions in the past about this but as Django grows, there are many new database functions.

I'm looking for a way to prevent model to be deleted from anywhere by anyone.

I have a model Product and I don't want product to be deleted from database ever.

I understand that overriding delete is sometimes a good way but I would like to do it on database level so there is no chance to delete it from shell_plus or any other source.

In Postgres, I think, there is a way:

CREATE RULE product_del_protect AS ON DELETE TO product DO INSTEAD NOTHING;

But I would like to do it through Django so every migrated database will be affected.

There may be a way to do that in model or custom migration.

And better would be to raise an error.

django database postgresql django-models

share|improve this question

asked Mar 26 at 14:01

MilanoMilano

4,8621414 gold badges5050 silver badges151151 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I don't think a native django solution exists for this, but you can always use raw sql: docs.djangoproject.com/en/2.1/topics/db/sql
  
  – Stargazer
  Mar 26 at 14:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Stargazer Yes I think combining raw query and migrations.RunPython would be the best way.
  
  – Milano
  Mar 26 at 14:22
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  I agree. Just write a migration for that docs.djangoproject.com/pt-br/2.1/howto/writing-migrations
  
  – Stargazer
  Mar 26 at 14:23
  

  
  
  
  

add a comment | 

3

1

There were some questions in the past about this but as Django grows, there are many new database functions.

I'm looking for a way to prevent model to be deleted from anywhere by anyone.

I have a model Product and I don't want product to be deleted from database ever.

I understand that overriding delete is sometimes a good way but I would like to do it on database level so there is no chance to delete it from shell_plus or any other source.

In Postgres, I think, there is a way:

CREATE RULE product_del_protect AS ON DELETE TO product DO INSTEAD NOTHING;

But I would like to do it through Django so every migrated database will be affected.

There may be a way to do that in model or custom migration.

And better would be to raise an error.

django database postgresql django-models

share|improve this question

asked Mar 26 at 14:01

MilanoMilano

4,8621414 gold badges5050 silver badges151151 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I don't think a native django solution exists for this, but you can always use raw sql: docs.djangoproject.com/en/2.1/topics/db/sql
  
  – Stargazer
  Mar 26 at 14:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Stargazer Yes I think combining raw query and migrations.RunPython would be the best way.
  
  – Milano
  Mar 26 at 14:22
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  I agree. Just write a migration for that docs.djangoproject.com/pt-br/2.1/howto/writing-migrations
  
  – Stargazer
  Mar 26 at 14:23
  

  
  
  
  

add a comment | 

There were some questions in the past about this but as Django grows, there are many new database functions.

I'm looking for a way to prevent model to be deleted from anywhere by anyone.

I have a model Product and I don't want product to be deleted from database ever.

I understand that overriding delete is sometimes a good way but I would like to do it on database level so there is no chance to delete it from shell_plus or any other source.

In Postgres, I think, there is a way:

CREATE RULE product_del_protect AS ON DELETE TO product DO INSTEAD NOTHING;

But I would like to do it through Django so every migrated database will be affected.

There may be a way to do that in model or custom migration.

And better would be to raise an error.

django database postgresql django-models

share|improve this question

asked Mar 26 at 14:01

MilanoMilano

4,8621414 gold badges5050 silver badges151151 bronze badges

CREATE RULE product_del_protect AS ON DELETE TO product DO INSTEAD NOTHING;

share|improve this question

asked Mar 26 at 14:01

MilanoMilano

4,8621414 gold badges5050 silver badges151151 bronze badges

share|improve this question

asked Mar 26 at 14:01

MilanoMilano

4,8621414 gold badges5050 silver badges151151 bronze badges

asked Mar 26 at 14:01

MilanoMilano

4,8621414 gold badges5050 silver badges151151 bronze badges

asked Mar 26 at 14:01

MilanoMilano

4,8621414 gold badges5050 silver badges151151 bronze badges