CODEWITHSUNDEEP
pythondjangodjango-queryset
zjm1126
zjm1126

Reputation: 35680

How to remove all of the data in a table using Django

I have two questions:

  1. How do I delete a table in Django?
  2. How do I remove all the data in the table?

This is my code, which is not successful:

Reporter.objects.delete()

Upvotes: 188

Views: 267069

Answers (10)

Mohawo
Mohawo

Reputation: 817

I know the question is for a long time ago, but just for the record, because this saved me:

python manage.py flush

The above will delete all the data on your database (PostgreSQL in my case). Even the superuser.

If you want to delete all the rows of a specific table, then:

python manage.py shell
>> from app.models import SomeTable
>> SomeTable.objects.all().delete()

Upvotes: 5

May
May

Reputation: 1

Actually, I un-register the model (the table data that I want to delete) from the admin.py. Then I migrate.

python manage.py makemigrations
python manage.py migrate
python runserver

Then I register the model in the admin.py and do migration again. :) Now, the table is empty. This might not be a professional answer, but it helped me.

Upvotes: -4

Arghya Bhattacharya
Arghya Bhattacharya

Reputation: 159

Use this syntax to delete the rows also to redirect to the homepage (To avoid page load errors) :

def delete_all(self):
  Reporter.objects.all().delete()
  return HttpResponseRedirect('/')

Upvotes: 5

Mahbub Ul Islam
Mahbub Ul Islam

Reputation: 1059

You can use the Django-Truncate library to delete all data of a table without destroying the table structure.

Example:

  1. First, install django-turncate using your terminal/command line:
pip install django-truncate
  1. Add "django_truncate" to your INSTALLED_APPS in the settings.py file:
INSTALLED_APPS = [
    ...
    'django_truncate',
]
  1. Use this command in your terminal to delete all data of the table from the app.
python manage.py truncate --apps app_name --models table_name

Upvotes: 3

Kumar Mangalam
Kumar Mangalam

Reputation: 776

Using shell,

1) For Deleting the table:

python manage.py dbshell
>> DROP TABLE {app_name}_{model_name}

2) For removing all data from table:

python manage.py shell
>> from {app_name}.models import {model_name}
>> {model_name}.objects.all().delete()

Upvotes: 42

Ash
Ash

Reputation: 1714

As per the latest documentation, the correct method to call would be:

Reporter.objects.all().delete()

Upvotes: 153

Ashish Gupta
Ashish Gupta

Reputation: 1239

There are a couple of ways:

To delete it directly:

SomeModel.objects.filter(id=id).delete()

To delete it from an instance:

instance1 = SomeModel.objects.get(id=id)
instance1.delete()

// don't use same name

Upvotes: 2

Rohit Dhankar
Rohit Dhankar

Reputation: 1644

Django 1.11 delete all objects from a database table - 

Entry.objects.all().delete()  ## Entry being Model Name.

Refer the Official Django documentation here as quoted below - https://docs.djangoproject.com/en/1.11/topics/db/queries/#deleting-objects

Note that delete() is the only QuerySet method that is not exposed on a Manager itself. This is a safety mechanism to prevent you from accidentally requesting Entry.objects.delete(), and deleting all the entries. If you do want to delete all the objects, then you have to explicitly request a complete query set:

I myself tried the code snippet seen below within my somefilename.py 

    # for deleting model objects
    from django.db import connection
    def del_model_4(self):
        with connection.schema_editor() as schema_editor:
            schema_editor.delete_model(model_4)

and within my views.py i have a view that simply renders a html page ... 

  def data_del_4(request):
      obj = calc_2() ## 
      obj.del_model_4()
      return render(request, 'dc_dash/data_del_4.html') ##

it ended deleting all entries from - model == model_4 , but now i get to see a Error screen within Admin console when i try to asceratin that all objects of model_4 have been deleted ...

ProgrammingError at /admin/dc_dash/model_4/
relation "dc_dash_model_4" does not exist
LINE 1: SELECT COUNT(*) AS "__count" FROM "dc_dash_model_4"

Do consider that - if we do not go to the ADMIN Console and try and see objects of the model - which have been already deleted - the Django app works just as intended.

django admin screencapture

Upvotes: 6

user2817997
user2817997

Reputation: 627

If you want to remove all the data from all your tables, you might want to try the command python manage.py flush. This will delete all of the data in your tables, but the tables themselves will still exist.

See more here: https://docs.djangoproject.com/en/1.8/ref/django-admin/

Upvotes: 55

Tiago
Tiago

Reputation: 9558

Inside a manager:

def delete_everything(self):
    Reporter.objects.all().delete()

def drop_table(self):
    cursor = connection.cursor()
    table_name = self.model._meta.db_table
    sql = "DROP TABLE %s;" % (table_name, )
    cursor.execute(sql)

Upvotes: 219

Related Questions