I have started to use django to develop an application , i use the
Object-relational mapper from django because i develop a python-qt
application
i had a problem with many to many relation.
My models:
RoutePointLog:
----------------------------------
from django.db import models
from client import Client
from driver import Driver
from task import Task
from routelog import RouteLog
class BaseMeta:
app_label = 'main'
class RoutePointLog( models.Model ):
route = models.ForeignKey( RouteLog )
client = models.ForeignKey( Client )
comment = models.CharField( maxlength=100 )
tasks = models.ManyToManyField( Task )
Meta=BaseMeta
RouteLog:
---------------------------------------------
from django.db import models
from client import Client
from driver import Driver
from task import Task
class BaseMeta:
app_label = 'main'
class RouteLog( models.Model ):
date = models.DateTimeField( )
Meta=BaseMeta
tasks
---------------------------------
from django.db import models
from enterprise import *
class BaseMeta:
app_label = 'main'
class Task( models.Model ):
name = models.CharField(maxlength=200,unique=True)
enterprise = models.ForeignKey( Enterprise )
Meta=BaseMeta
Code i have problems:
for rp in self.routeLog.routepointlog_set.all():
print rp
html=html+"<tr>"+ rp.client.code +" <td></td>"
html=html+"<td>"+ rp.client.name +" </td>"
html=html+"<td>"+ rp.client.name +" </td>"
html=html+"<td>"+ rp.client.city +" </td>"
html=html+"<td>"+ rp.client.locality +"</td>"
for task in rp.tasks.all():
print task
html=html+"<td>"+ task.name +"</td>"
html = html + "</tr>"
and the output:
Traceback (most recent call last):
File "/home/angel/prog/track/main/routeadminui.py", line 165, in slotPrint
html = self.getHtml( )
File "/home/angel/prog/track/main/routeadminui.py", line 152, in getHtml
for task in rp.tasks.all():
File
"/usr/lib/python2.4/site-packages/Django-0.95.1-py2.4.egg/django/db/models/query.py",
line 103, in __iter__
return iter(self._get_data())
File
"/usr/lib/python2.4/site-packages/Django-0.95.1-py2.4.egg/django/db/models/query.py",
line 430, in _get_data
self._result_cache = list(self.iterator())
File
"/usr/lib/python2.4/site-packages/Django-0.95.1-py2.4.egg/django/db/models/query.py",
line 171, in iterator
select, sql, params = self._get_sql_clause()
File
"/usr/lib/python2.4/site-packages/Django-0.95.1-py2.4.egg/django/db/models/query.py",
line 444, in _get_sql_clause
joins2, where2, params2 = self._filters.get_sql(opts)
File
"/usr/lib/python2.4/site-packages/Django-0.95.1-py2.4.egg/django/db/models/query.py",
line 574, in get_sql
joins2, where2, params2 = val.get_sql(opts)
File
"/usr/lib/python2.4/site-packages/Django-0.95.1-py2.4.egg/django/db/models/query.py",
line 622, in get_sql
return parse_lookup(self.kwargs.items(), opts)
File
"/usr/lib/python2.4/site-packages/Django-0.95.1-py2.4.egg/django/db/models/query.py",
line 734, in parse_lookup
joins2, where2, params2 = lookup_inner(path, lookup_type, value, opts,
opts.db_table, None)
File
"/usr/lib/python2.4/site-packages/Django-0.95.1-py2.4.egg/django/db/models/query.py",
line 835, in lookup_inner
raise TypeError, "Cannot resolve keyword '%s' into field" % name
TypeError: Cannot resolve keyword 'routepointlog' into field
any idea?
thanks in advance
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
