djangodjango-fixtures

Load Django fixtures with nullable foreign key fields


I made a set of fixtures with two nullable foreign key fields, but for some reason when I try loaddata I get complaints that the fields have to be integers.

model (deleted some stuff for brevity):

class Network(models.Model):
    network     = models.GenericIPAddressField()
    mask        = models.CharField(max_length=2)
    description = models.CharField(max_length=2000)
    designation = models.CharField(choices=DESIGNATION_CHOICES, max_length=10)
    site        = models.CharField(choices=SITE_CHOICES, max_length=5)
    category    = models.CharField(choices=CATEGORY_CHOICES, max_length=10)
    vlan        = models.CharField(max_length=5, blank=True, null=True)
    vrf         = models.ForeignKey(Vrf,on_delete=models.CASCADE, blank=True, null=True)
    parent      = models.ForeignKey('self', on_delete=models.CASCADE, related_name='supernet', blank=True, null=True)

fixture block:

<django-objects version="1.0">
    <object model="ipmanager.network" pk="459124212">
        <field name="mask" type="CharField">30</field>
        <field name="site" type="CharField">place</field>
        <field name="network" type="CharField">1.1.1.1</field>
        <field name="category" type="CharField">category</field>
        <field name="description" type="CharField">enum amun set ra</field>
        <field name="vlan" type="CharField" />
        <field name="designation" type="CharField">supernet</field>
        <field name="parent" rel="ManyToOneRel" to="networks.id"></field>
        <field name="vrf" rel="ManyToOneRel" to="vrfs.id"></field>
    </object>

I've tried Null, None, empty string, and a space and django won't accept any of them. Here's the error I get:

>python manage.py loaddata ipmanager/net
works_fixture.xml
Traceback (most recent call last):
  File "C:\Users\dchadwell.CORP\AppData\Local\Programs\Python\Python35\lib\site-
packages\django\db\models\fields\__init__.py", line 955, in to_python
    return int(value)
ValueError: invalid literal for int() with base 10: ''

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File                 "C:\Users\dchadwell.CORP\AppData\Local\Programs\Python\Python35\lib\site-
packages\django\core\management\__init__.py", line 353, in     execute_from_command_
line
    utility.execute()
  File     "C:\Users\dchadwell.CORP\AppData\Local\Programs\Python\Python35\lib\site-
packages\django\core\management\__init__.py", line 345, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
File     "C:\Users\dchadwell.CORP\AppData\Local\Programs\Python\Python35\lib\site-
packages\django\core\management\base.py", line 348, in run_from_argv
    self.execute(*args, **cmd_options)
  File     "C:\Users\dchadwell.CORP\AppData\Local\Programs\Python\Python35\lib\site-
packages\django\core\management\base.py", line 399, in execute
    output = self.handle(*args, **options)
  File     "C:\Users\dchadwell.CORP\AppData\Local\Programs\Python\Python35\lib\site-
packages\django\core\management\commands\loaddata.py", line 60, in handle
    self.loaddata(fixture_labels)
  File     "C:\Users\dchadwell.CORP\AppData\Local\Programs\Python\Python35\lib\site-
packages\django\core\management\commands\loaddata.py", line 100, in loaddata
    self.load_label(fixture_label)
  File     "C:\Users\dchadwell.CORP\AppData\Local\Programs\Python\Python35\lib\site-
packages\django\core\management\commands\loaddata.py", line 152, in load_label
    for obj in objects:
  File     "C:\Users\dchadwell.CORP\AppData\Local\Programs\Python\Python35\lib\site-
packages\django\core\serializers\xml_serializer.py", line 177, in __next__
    return self._handle_object(node)
  File     "C:\Users\dchadwell.CORP\AppData\Local\Programs\Python\Python35\lib\site-
packages\django\core\serializers\xml_serializer.py", line 218, in     _handle_object

    data[field.attname] = self._handle_fk_field_node(field_node, field)
  File     "C:\Users\dchadwell.CORP\AppData\Local\Programs\Python\Python35\lib\site-
packages\django\core\serializers\xml_serializer.py", line 258, in _han    dle_fk_fie
ld_node
    return     model._meta.get_field(field.remote_field.field_name).to_python(field_
value)
  File     "C:\Users\dchadwell.CORP\AppData\Local\Programs\Python\Python35\lib\site-
packages\django\db\models\fields\__init__.py", line 960, in to_python
    params={'value': value},
django.core.exceptions.ValidationError: ["'' value must be an integer."]

What am I doing wrong here?


Solution

  • Remove the foreign keys which you don't need, rather than trying to find the empty value, i.e. your fixture block should look something like this instead:

    <django-objects version="1.0">
        <object model="ipmanager.network" pk="459124212">
            <field name="mask" type="CharField">30</field>
            <field name="site" type="CharField">place</field>
            <field name="network" type="CharField">1.1.1.1</field>
            <field name="category" type="CharField">category</field>
            <field name="description" type="CharField">enum amun set ra</field>
            <field name="vlan" type="CharField" />
            <field name="designation" type="CharField">supernet</field>
        </object>