Opened 18 years ago
Last modified 13 years ago
#6233 closed
fixture fails to load on inet field — at Initial Version
| Reported by: | Owned by: | nobody | |
|---|---|---|---|
| Component: | Core (Serialization) | Version: | 0.96 |
| Severity: | Normal | Keywords: | |
| Cc: | Triage Stage: | Accepted | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
Using the admin interface I entered a couple of records for my model.
class TugInstance(models.Model):
"""This class represents a single instance of TUG in the multi-instance
case."""
enabled = models.BooleanField(default=False)
public_ip = models.IPAddressField(unique=True)
wan_ip = models.IPAddressField(unique=True, blank=True, null=True)
lan_ip = models.IPAddressField(unique=True)
ready_for_calls = models.BooleanField(default=True)
calls_in_progress = models.PositiveIntegerField()
default_icp = models.ForeignKey(Icp)
def __str__(self):
return str(self.id)
class Admin:
pass
I am using postgresql-7.4.13-2.RHEL4.1 on CentOS 4.4.
I used the json serializer to dump json format of these records.
[root@vmware-espresso teleworker]# cat sample_data.json
[{"pk": "1", "model": "top.tuginstance", "fields": {"default_icp": 1,
"wan_ip": "", "ready_for_calls": true, "lan_ip": "192.168.1.55", "enabled":
true, "public_ip": "216.191.234.111", "calls_in_progress": 5}}, {"pk": "2",
"model": "top.tuginstance", "fields": {"default_icp": 2, "wan_ip":
"216.191.234.112", "ready_for_calls": true, "lan_ip": "10.33.15.145",
"enabled": false, "public_ip": "216.191.234.112", "calls_in_progress": 0}}]
I then cleared the table manually, and tried to load this json as a fixture.
[root@vmware-espresso teleworker]# python manage.py --pythonpath=.. loaddata sample_data.json
Loading 'sample_data.json' fixtures...
Installing json fixture 'sample_data' from absolute path.
Problem installing fixture 'sample_data.json': invalid input syntax for type inet: ""
Seems that there are issues translating the json to sql that postgres will accept.