Problems with contenttypes when loading a fixture in Django

by

manage.py dumpdata --natural will use a more durable representation of foreign keys. In django they are called “natural keys”. For example:

  • Permission.codename is used in favour of Permission.id
  • User.username is used in favour of User.id

Read more: natural keys section in “serializing django objects”

Some other useful arguments for dumpdata:

  • --indent=4 make it human readable.
  • -e sessions exclude session data
  • -e admin exclude history of admin actions on admin site
  • -e contenttypes -e auth.Permission exclude objects which are recreated automatically from schema every time during syncdb. Only use it together with --natural or else you might end up with badly aligned id numbers.

More Related Contents:

  1. How can I temporarily disable a foreign key constraint in MySQL?
  2. How to use django models with foreign keys in different DBs?
  3. Django : Table doesn’t exist
  4. Django – installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3
  5. Django MySQL full text search
  6. GROUP_CONCAT equivalent in Django
  7. What’s the best way to migrate a Django DB from SQLite to MySQL?
  8. How to drop all tables from the database with manage.py CLI in Django?
  9. Database returned an invalid value in QuerySet.dates()
  10. Error installing mysqlclient for python on Ubuntu 18.04
  11. django cannot connect mysql in docker-compose
  12. Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’
  13. Complex Count in MySQL
  14. Convert Django Model object to dict with all of the fields intact
  15. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  16. Cannot delete or update a parent row: a foreign key constraint fails
  17. Remove HTML tags from record
  18. Dynamic File Path in Django
  19. Adding multiple columns AFTER a specific column in MySQL
  20. MySQL varchar index length
  21. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  22. Ruby on Rails 3 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ on OSX
  23. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  24. MySQL – Fetching lowest value
  25. Django: Why do some model fields clash with each other?
  26. How to alias a field or column in MySQL?
  27. How do I alter a mysql table column defaults?
  28. Calling an url from a trigger in mysql
  29. update django database to reflect changes in existing models
  30. How to count date difference excluding weekend and holidays in MySQL

Leave a Comment