Hello there,
Getting started with Django (v. 0.95 and postgres), I'm trying to make a
first application, and I encounter some problems:
I have a database with 2 tables: addresses_network and addresses_ip,
both having among others a column "ip_addr" (of type inet, thank you
postgres). I want the application to list the networks, and when
selecting one, I would like to see the different IP addresses in the
selected network, but I can not seem to find a filter for this. Am I
missing something, or does Django?
The workaround I found, is using an function (getNetworkIPIDs) I defined
in models.py, but this is not elegant at all. Do you have any better
idea on how to do it?
Thanks for any feedback.
tom
Here are my models.py and views.py:
models.py
============================================================
from django.db import models
# Create your models here.
class Network(models.Model):
ip_addr = models.IPAddressField(unique=True)
description = models.CharField(maxlength=50, blank=True)
def __str__(self):
return self.ip_addr
# def __str__
class Admin:
list_display = ('ip_addr', 'description')
list_per_page = 100
ordering = ('ip_addr')
# class Admin
# class Network
class IP(models.Model):
ip_addr = models.IPAddressField(unique=True, core=True)
mac_addr = models.CharField(maxlength=32, blank=True)
name = models.CharField(maxlength=50, blank=True)
description = models.CharField(maxlength=100, blank=True)
def __str__(self):
return self.ip_addr
# def __str__
class Admin:
list_display = ('ip_addr', 'name', 'mac_addr')
list_per_page = 100
ordering = ('ip_addr', 'name', 'mac_addr')
# class Admin
# class IP
def getNetworkIPIDs(network_id):
from django.db import connection
cursor = connection.cursor()
cursor.execute('SELECT ip.id, ip.ip_addr, ip.mac_addr, ip.name,
ip.description FROM addresses_network nw, addresses_ip ip WHERE (nw.id =
%s) AND (nw.ip_addr >> ip.ip_addr) ORDER BY ip.ip_addr' %(network_id))
result_list = []
for row in cursor.fetchall():
ip = IP(id=row[0], ip_addr=row[1], mac_addr=row[2], name=row[3],
description=row[4])
result_list.append(ip)
# for
return result_list
# def getNetworkIPIDs
============================================================
views.py
============================================================
# Create your views here.
from django.http import HttpResponse
from django.template import Context, loader
from django.shortcuts import get_object_or_404, render_to_response
from ip_test.addresses.models import Network, IP, getNetworkIPIDs
def networks(request):
networks_list = Network.objects.all()
templ = loader.get_template('networks.html')
c = Context({'networks_list': networks_list, })
return HttpResponse(templ.render(c))
# def networks
def network(request, network_id):
n = get_object_or_404(Network, pk=network_id)
ips_list = getNetworkIPIDs(network_id)
# I WOULD LIKE TO USE SOMETHING LIKE THIS INSTEAD OF THE ABOVE:
#network = Network.objects.get(id=network_id)
#ips_list = IP.objects.filter(ip_addr__XXXXXXXX=network.ip_addr)
templ = loader.get_template('network.html')
c = Context({'network_id': network_id, 'ips_list': ips_list, })
return HttpResponse(templ.render(c))
# def network
def ips(request):
ips_list = IP.objects.all().order_by('ip_addr')
templ = loader.get_template('ips.html')
c = Context({'ips_list': ips_list, })
return HttpResponse(templ.render(c))
# def ips
============================================================
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---
