Django 1.6: Clear data in one table

Question

I've a table name UGC and would like to clear all the data inside that table. I don't want to reset the entire app which would delete all the data in all the other models as well. Is it possible to clear only one single model? I also have South configured with my app, if that would help.

Answer 1

You could use raw SQL :

 cursor.execute(“DROP TABLE UGC”)

or you could just use the ORM directly inside a Django shell :

UGCModel.objects.all().delete()

That would erase the data (not the table, though), so you have to be careful :)

Another way (for completeness and to make use of South) would be to comment out the model in your models declaration, migrate and then put it back again (assuming there are no models with a reference to it.)

HTH

Answer 2

In the admin interface, you can go to the list page for that model, then you can select all models and use the Delete selected ... action at the top of the table.

Remember that, in whatever way you delete the data, foreign keys default to ON DELETE CASCADE, so any model with a foreign key to a model you want to delete will be deleted as well. The admin interface will give you a complete overview of models that will be deleted.