I guess socket.inet_ntoa is enough for what you need.
On Sun, Jan 23, 2011 at 7:06 AM, Phillip Bailey <phil...@bailey.st> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
>
> Dear All,
>
> I've started playing around with Django in the last few days, and I'm
> enjoying the speed
> and the power of such framework. I'm writing a small application to
> display and sort
> ip addresses stored in a Postgresql database, right now I'm stuck with
> 32-bit integers
> IP address translated to 4-octet IP address .
>
> Here's the the class of the ip address.
>
> class Iphdr(models.Model):
> sid = models.IntegerField(primary_key=True)
> cid = models.BigIntegerField(primary_key=True)
> ip_src = models.BigIntegerField()
> ip_dst = models.BigIntegerField()
> ip_ver = models.SmallIntegerField()
> ip_hlen = models.SmallIntegerField()
> ip_tos = models.SmallIntegerField()
> ip_len = models.IntegerField()
> ip_id = models.IntegerField()
> ip_flags = models.SmallIntegerField()
> ip_off = models.IntegerField()
> ip_ttl = models.SmallIntegerField()
> ip_proto = models.SmallIntegerField()
> ip_csum = models.IntegerField()
> class Meta:
> db_table = u'iphdr'
>
>
> As the IP addresses are stored in the database as unsigned 32-bit
> integers, so when I
> run ip = Iphdr.objects.values("ip_src") the result is in 32-bit integers,
>
> {'ip_src': 3251031814L}{'ip_src': 3251031816L}{'ip_src': 3251031816L}
> {'ip_src': 3251031816L}{'ip_src': 3251031814L}{'ip_src': 3251031816L}
>
> There's any elegant solution that can translate 32-bit integers to
> 4-octet IP address (192.168.1.88) ?
>
> Thanks in advance.
>
> Phillip
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (GNU/Linux)
>
> iQEcBAEBAgAGBQJNO++eAAoJENNBJKHbaDgTM0cH/0/QjdPTi53tJG4YhjVpt6oj
> cJk6rAEHwFha//Vby4lH2sT+ZyKmv+UAjSVmvBCptXBOcm5LuedMmMCVeInfuliQ
> GeOPlQ4nvrZSbcdXirLu9Jqa+Yqj6nalGF7i0WetqvdsdrkQQdrcx1D814DSZKGq
> qQWpdyVEmdrRSfiOUvrYbnXDCnTwCXZdUhcpDNmD+5h9S2/uiMzP5cM2wtfMg1hO
> swYS9B7h/6vAd1ekOZh+ij2X4mszUfp5rQzFjCXtYnQma8pN+58UMpWwYVKj2FzA
> tgRaWC1Qz4hWsXRvwirqo/ZtyJMWxkOdwVaxl3iug/NCGW/yDCMa97zweYOHKCs=
> =W+IC
> -----END PGP SIGNATURE-----
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to django-users@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
>
--
[ ]'s
Aledr - Alexandre
"OpenSource Solutions for SmallBusiness Problems"
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
