Django flush vs sqlclear & syncdb

Question

Can anyone tell if there is a difference between

>manage.py flush  # or reset

and

>manage.py sqlclear appname | python manage.py dbshell
>manage.py syncdb

https://docs.djangoproject.com/en/dev/ref/django-admin/ – cetver Sep 29 '11 at 13:34 — cetver, Sep 29 '11 at 13:34

score 19 · Answer 1 · edited Jun 20 '17 at 07:29

19

flush will truncate (delete data)

sqlclear will drop (delete table, thus data too)

=> if you have structural modifications in your db, you have to do sqlclear (but better use south)

Update:

South has been deprecated.

From Django 1.7 upwards, migrations are built into the core of Django. If you are running a previous version, you can use South.

edited Jun 20 '17 at 07:29

Jeril

7,858
3
52
69

answered Oct 22 '12 at 18:50

lajarre

4,910
6
42
69

https://docs.djangoproject.com/en/1.5/ref/django-admin/#sqlclear-appname-appname says: "Prints the DROP TABLE SQL statements for the given app name(s).". Seems to me it doesn't actually drop the tables. – peetasan May 22 '15 at 10:30
Read "will print statements to drop" then. Refer to the OP question to see how to actually apply the statements. – lajarre May 22 '15 at 11:00

score 5 · Answer 2 · edited Jul 30 '14 at 15:02

5

Official docs for

flush and sqlclear

Flush carries out the SQL Drops on the entire db, sqlflush only prints out the SQL that flush would actual run (again on the entire db). sqlclear prints out SQL Drops for a particular app or apps. Both flush and sqlflush/dbshell/syncdb will install fixtures.

edited Jul 30 '14 at 15:02

akki

2,021
1
24
35

answered Sep 29 '11 at 13:36

Timmy O'Mahony

53,000
18
155
177

1

by running sqlflush, looks like flush would only truncate tables rather than drop them. – Bobo Oct 02 '12 at 15:25

Django flush vs sqlclear & syncdb

2 Answers2

Linked