update django database to reflect changes in existing models

by

As of Django 1.7+, built-in migrations support, allows for database schema migrations that preserve data. That’s probably a better approach than the solution below.

Another option, not requiring additional apps, is to use the built in manage.py functions to export your data, clear the database and restore the exported data.

The methods below will update the database tables for your app, but will completely destroy any data that existed in those tables. If the changes you made to your app model do not break your old schema (for instance, you added a new, optional field) you can simply dump the data before and reload it afterwards, like so:

Django 1.4.15 and earlier

python manage.py dumpdata <your_app> > temp_data.json
python manage.py reset <your_app>
python manage.py loaddata temp_data.json

Django 1.5 and newer

python manage.py dumpdata <your_app> > temp_data.json
python manage.py sqlclear <your_app> | python manage.py dbshell
python manage.py syncdb
python manage.py loaddata temp_data.json

(The reset command was deprecated and then removed in Django 1.5)

If your changes break your old schema this won’t work – in which case tools like South or Django Evolution are great.

More Related Contents:

  1. ValueError: invalid literal for int() with base 10:
  2. What is the difference between null=True and blank=True in Django?
  3. Django. Override save for model
  4. How to pull a random record using Django’s ORM?
  5. Django – how to create a file and save it to a model’s FileField?
  6. How do I do a not equal in Django queryset filtering?
  7. Python script for Django app to access models without using manage.py shell
  8. Django rest framework serializing many to many field
  9. Django signals vs. overriding save method
  10. How do I restrict foreign keys choices to related objects only in django
  11. django template system, calling a function inside a model
  12. Custom ordering in Django
  13. Django Model MultipleChoice
  14. How do I extend the Django Group model?
  15. Django values_list vs values
  16. ‘NOT NULL constraint failed’ after adding to models.py
  17. Why doesn’t django’s model.save() call full_clean()?
  18. “_set” in a queryset object in Django
  19. Nested inlines in the Django admin?
  20. What is the best way to access stored procedures in Django’s ORM
  21. QuerySet, Object has no attribute id – Django
  22. Good ways to sort a queryset? – Django
  23. Resize fields in Django Admin
  24. Get the latest record with filter in Django
  25. Django DoesNotExist
  26. Generic many-to-many relationships
  27. python_2_unicode_compatible error
  28. How to validate uniqueness constraint across foreign key (django)
  29. How to properly use the “choices” field option in Django
  30. Django admin – inline inlines (or, three model editing at once)

Leave a Comment