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

Question

I have two questions    How do I delete a table in Django  How do I remove all the data in the table    This is my code  which is not successful   Reporter objects delete

User · Answer

As per the latest documentation  the correct method to call would be   Reporter objects all   delete

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

You can use the Django-Truncate library to delete all data of a table without destroying the table structure  Example   First  install django-turncate using your terminal command line   pip install django-truncate   Add  quot django truncate quot  to your INSTALLED APPS in the settings py file   INSTALLED APPS                  django truncate       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

User · Answer

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

User · Answer

Using shell   1  For Deleting the table   python manage py dbshell  gt  gt  DROP TABLE  app name   model name    2  For removing all data from table   python manage py shell  gt  gt  from  app name  models import  model name   gt  gt   model name  objects all   delete

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

Examples related to python

Examples related to django

Examples related to django-queryset