Greetings, I used inspectdb to create my models and then tried editing
the generated models in order to define the ForeignKey relationships,
and I'm getting an error.
Here's what I have. Note: I commented out the original category field
and tried adding my own ForeignKey
class MdlCourseCategories(models.Model):
id = models.IntegerField(primary_key=True)
name = models.CharField(max_length=765)
description = models.TextField(blank=True)
parent = models.IntegerField()
class Meta:
db_table = u'mdl_course_categories'
class MdlCourse(models.Model):
id = models.IntegerField(primary_key=True)
#category = models.IntegerField()
category = models.ForeignKey(MdlCourseCategories, to_field='id')
sortorder = models.IntegerField()
password = models.CharField(max_length=150)
fullname = models.CharField(max_length=762)
shortname = models.CharField(max_length=300)
class Meta:
db_table = u'mdl_course'
Using these models I do the following in the manage.py shell
>>> from cca.moodle.models import *
>>> cs = MdlCourse.objects.all()
>>> cs
OperationalError: (1054, "Unknown column 'mdl_course.category_id' in
'field list'")
to_field doesn't work quite like I expected. Does anyone know a way to
make models.ForeignKey to at a specific table.column?
Humblest Thanks and Kind Regards
--
matthew
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
