How to TRUNCATE TABLE using Django's ORM? How to TRUNCATE TABLE using Django's ORM? django django

How to TRUNCATE TABLE using Django's ORM?


python sql django orm truncate

The closest you'll get with the ORM is Book.objects.all().delete().

There are differences though: truncate will likely be faster, but the ORM will also chase down foreign key references and delete objects in other tables.

python sql django orm truncate

You can do this in a fast and lightweight way, but not using Django's ORM. You may execute raw SQL with a Django connection cursor:

from django.db import connectioncursor = connection.cursor()cursor.execute("TRUNCATE TABLE `books`")

python sql django orm truncate

You can use the model's _meta property to fill in the database table name:

from django.db import connectioncursor = connection.cursor()cursor.execute('TRUNCATE TABLE "{0}"'.format(MyModel._meta.db_table))

Important: This does not work for inherited models as they span multiple tables!

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last