Hello
What I want to achieve is the equivalent of this:
select * from server, backup where backup.serverid=server.id and
servername={backupserver}
To do that the django way is proving challenging, maybe because the
database was an existing one (not created the django way), or maybe
because I'm misunderstanding something.
My view:
def detail(request, backupserver):
output =
Backup.objects.filter(server__servername__exact=backupserver)
return HttpResponse(output)
If I pass the backupserver in the URL, it returns:
FieldError: Cannot resolve keyword 'server' into field. Choices are:
backupdate, backupresult, bytecount, checkuser, id, jobname,
logfilename, verdict
My models.py:
class Server(models.Model):
def __unicode__(self):
return self.servername
servername = models.CharField(max_length=192)
ip = models.CharField(max_length=48)
domainname = models.CharField(max_length=96, blank=True)
os = models.CharField(max_length=96, blank=True)
av_file = models.CharField(max_length=768, blank=True)
backedupto = models.CharField(max_length=192, blank=True)
purpose = models.CharField(max_length=384, blank=True)
comment = models.CharField(max_length=768, blank=True)
siteid = models.IntegerField(null=True, blank=True)
authid = models.IntegerField(null=True, blank=True)
exchange = models.CharField(max_length=3, blank=True)
status = models.CharField(max_length=3, blank=True)
backupserver = models.CharField(max_length=12, blank=True)
backuppath = models.CharField(max_length=384, blank=True)
backupowners = models.CharField(max_length=254, default='no-one')
class Meta:
db_table = u'server'
class Backup(models.Model):
def __unicode__(self):
return self.jobname
jobname = models.CharField(max_length=64)
logfilename = models.CharField(max_length=64, blank=True)
backupresult = models.CharField(max_length=255, blank=True)
checkuser = models.CharField(max_length=64, blank=True)
backupdate = models.DateTimeField()
verdict = models.CharField(max_length=255, blank=True)
bytecount = models.IntegerField()
class Meta:
db_table = u'backup'
Any help would be appreciated.
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
