What is the easiest way to clear a database from the CLI with manage.py in Django?

If you don’t care about data:

Best way would be to drop the database and run syncdb again. Or you can run:

For Django >= 1.5

python manage.py flush

For Django < 1.5

python manage.py reset appname

(you can add --no-input to the end of the command for it to skip the interactive prompt.)

If you do care about data:

From the docs:

syncdb will only create tables for models which have not yet been installed. It will never issue ALTER TABLE statements to match changes made to a model class after installation. Changes to model classes and database schemas often involve some form of ambiguity and, in those cases, Django would have to guess at the correct changes to make. There is a risk that critical data would be lost in the process.

If you have made changes to a model and wish to alter the database tables to match, use the sql command to display the new SQL structure and compare that to your existing table schema to work out the changes.

https://docs.djangoproject.com/en/dev/ref/django-admin/

Reference: FAQ – https://docs.djangoproject.com/en/dev/faq/models/#if-i-make-changes-to-a-model-how-do-i-update-the-database

People also recommend South ( http://south.aeracode.org/docs/about.html#key-features ), but I haven’t tried it.

Related Posts:

  1. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  2. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  3. Setting Django up to use MySQL
  4. Error loading MySQLdb module: No module named ‘MySQLdb’
  5. Where does pip install its packages?
  6. Where does pip install its packages?
  7. django: TypeError: ‘tuple’ object is not callable
  8. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  9. Can’t fix “zipimport.ZipImportError: can’t decompress data; zlib not available” when I type in “python3.6 get-pip.py”
  10. No module named ‘psycopg2’
  11. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  12. No module named MySQLdb
  13. No module named MySQLdb
  14. How to check Django version
  15. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  16. is not JSON serializable
  17. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  18. Install mysql-python (Windows)
  19. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  20. No module named pkg_resources
  21. Django upgrading to 1.9 error “AppRegistryNotReady: Apps aren’t loaded yet.”
  22. Can’t compare naive and aware datetime.now() <= challenge.datetime_end
  23. django import error – No module named core.management
  24. Forbidden (403) CSRF verification failed. Request aborted. Even using the {% csrf_token %}
  25. Python: tuple indices must be integers, not str when selecting from mysql table
  26. Django 2.1.3 Error: __init__() takes 1 positional argument but 2 were given
  27. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  28. OSError – Errno 13 Permission denied
  29. Pylint “unresolved import” error in Visual Studio Code
  30. Django – no such table exception
  31. django MultiValueDictKeyError error, how do I deal with it
  32. Django – no such table exception
  33. ImportError: No module named MySQLdb
  34. Is there a list of Pytz Timezones?
  35. Django – “no module named django.core.management”
  36. Error: “dictionary update sequence element #0 has length 1; 2 is required” on Django 1.4
  37. NumPy array is not JSON serializable
  38. You are trying to add a non-nullable field ‘new_field’ to userprofile without a default
  39. pip install -r requirements.txt [Errno 2] No such file or directory: ‘requirements.txt’
  40. super(type, obj): obj must be an instance or subtype of type
  41. Django Rest Framework — no module named rest_framework
  42. Error: “dictionary update sequence element #0 has length 1; 2 is required” on Django 1.4
  43. Python Django: You’re using the staticfiles app without having set the STATIC_ROOT setting
  44. sqlite3.OperationalError: unable to open database file
  45. TypeError: int() argument must be a string, a bytes-like object or a number, not ‘list’
  46. Django reverse lookup of foreign keys
  47. ImportError: No module named ‘django.core.urlresolvers’
  48. ImportError: No module named mysql.connector using Python2
  49. How to fix error “ERROR: Command errored out with exit status 1: python.” when trying to install django-heroku using pip
  50. How to set environment variables in PyCharm?
  51. ImportError: No module named ‘MySQL’
  52. H14 error in heroku – “no web processes running”
  53. What does this Django regular expression mean? `?P`
  54. OperationalError: database is locked
  55. Is it better to use path() or url() in urls.py for django 2.0?
  56. What is a “slug” in Django?
  57. TemplateDoesNotExist at /
  58. No module named django but it is installed
  59. What does on_delete do on Django models?
  60. Check if an object exists
  61. Find object in list that has attribute equal to some value (that meets any condition)
  62. How to check if a user is logged in (how to properly use user.is_authenticated)?
  63. The view didn’t return an HttpResponse object. It returned None instead
  64. CSV new-line character seen in unquoted field error
  65. gunicorn.errors.HaltServer: django
  66. coercing to Unicode: need string or buffer, NoneType found when rendering in django admin
  67. coercing to Unicode: need string or buffer, NoneType found when rendering in django admin
  68. How to query as GROUP BY in django?
  69. What is related_name used for?
  70. TypeError: ManyRelatedManager object is not iterable
  71. What is the most efficient way to store a list in the Django models?
  72. Line is too long. Django PEP8
  73. __init__() got an unexpected keyword argument ‘user’
  74. How to groupby based on two columns in pandas?
  75. How do I append one string to another in Python?
  76. Python Progress Bar
  77. How to correct TypeError: Unicode-objects must be encoded before hashing?
  78. Python: list of lists
  79. How can I split and parse a string in Python?
  80. ImportError: No module named PIL
  81. Maximum and Minimum values for ints
  82. How do I list all files of a directory?
  83. How to display text in pygame?
  84. Python Nested Loops To Print Rectangle With Asterisks
  85. How to fix this strange error: “RuntimeError: CUDA error: out of memory”
  86. Generate random sentences in python
  87. Combine two columns of text in pandas dataframe
  88. Asyncio.gather vs asyncio.wait
  89. Loop backwards using indices in Python?
  90. Why do I get a “referenced before assignment” error when assigning to a global variable in a function?
  91. Printing variables in Python 3.4
  92. Meaning of @classmethod and @staticmethod for beginner?
  93. Haversine Formula in Python (Bearing and Distance between two GPS points)
  94. Replacing a character from a certain index
  95. TypeError: decoding str is not supported
  96. Is there a math nCr function in python?
  97. How to do a Sigma in python 3
  98. Python IOError: File not open for reading
  99. Strange Exception in Tkinter callback
  100. How to resolve “ImportError: DLL load failed:” on Python?

Leave a Comment