django dumpdata unable to serialize database

This prevents most dumpdata/loaddata cycles unless the dump order falls so that referenced models are dumped before models that depend on them. InnoDB tables within MySQL have no ability to defer reference checking until after a transaction is complete. Otherwise do a dump of model 1 and a dump of model 2. I would try doing a dump of everything (ainful as it might be) and see if it has data. Do you know why it would show the field as empty in the first case though? Same reason? 10 years, 3 months ago There is not enough information here to say. 10 years, 3 months ago Ok that is a very high likelihood possibility. Ensure that all the ids in the many-to-many relationship exist in their relevant tables? SQLite really doesn't validate your data much.

10 years, 3 months ago I think this means that some value you've entered for your Category model doesn't exist. Now you have a class call Membership for your many-to-many relationship, so you can use it same as before like this, python manage.py dumpdata catalogue.Membershipġ0 years ago Related Topics python django Comments 10 years, 3 months ago What version of Django are you using? What backend db? 10 years, 3 months ago I updated the post with this info. Invite_reason = models.CharField(max_length=64) Person = models.ForeignKey(Person, on_delete=models.CASCADE) Group = models.ForeignKey(Group, on_delete=models.CASCADE) If you've created many-to-many table using ManyToManyField.through, ManyToManyField.through_fields, for an example (directly took it from Django Official Documentation), from django.db import models Based on that my command should be, python manage.py dumpdata catalogue.AggregationFunctions_aggregation_category So my app name is catalogue and the third table name is AggregationFunctions_aggregation_category. So you can dump the data in third table like this, python manage.py dumpdata. Yes, you can see all three tables in below picture. Based on that my additional table should be AggregationFunctions_aggregation_category. So according to my example model name is AggregationFunctions and the field name is aggregation_category. When you create many-to-many relationships, you'll get additional table the structure of _. Related_name='aggregationfunctions_aggregationcategories' I have two tables like below, from django.db import modelsĬlass AggregationCategories(models.Model):Ĭlass AggregationFunctions(models.Model):Īggregation_category = models.ManyToManyField(

Django dumpdata unable to serialize database