IPy.IP instances with BigInt storage for django models
ipyfield provides a model field for django that allows the storage of an ip address as a “pretend” PositiveBigInt (currently varchar(39) until I can figure out how to get an unsigned 64bit integer column across all supported DBs) on the db side by using IPy to handle conversion to an IPy.IP instance (or None) on the python side.
In its way, it gives us a way to store both ipv4 and ipv6 consistently without having to throw them in long charfields. Also, it gives us an easy way to validate data as it comes in, while giving us access to additional meta information (basically everything that makes IPy so awesome).
Add this to your django project by installing with pip:
pip install django-ipyfield
or with easy_install:
In your models, do something like the following:
from django.db import models from ipyfield.models import IPyField class MyModel(models.Model): # the regular params should work well enough here ipaddr = IPyField() # ... and so on
From here, any assignments to obj.ipaddr can be considered a constructor argument to a new IPy.IP instance. Anything IP() can use to make a new object can be used.
When making queries, I added one extra piece of syntactical sugar. For __in (range) lookups, you can pass a CIDR notation address range, for example:
Currently you need to use this form of notation supported for this kind of query. For now, if you need to use a prefix-netmask style notation, pass it to IPy.IP yourself and use the resulting instance as your filter parameter.
- figure out how to build an appropriately sized integer field across all DBs.
- Added support for gt, gte, lt, and lte lookups.
- Added south support.
- IPy.IP instance raises exception when compared to a non-IP instance. This becomes an issue when you get into ModelForm validation (didn’t come up when only using the ORM) with regards to empty/null values. Fixed by subclassing (wrapping) IPy.IP.
- Basic field functionality in place.