I'm working on a legacy mysql db (under Mac OS X with Django 1.4.3) whose
structure I cannot modify because other applications are already happily
referring to it (FileMaker pro, PHP,etc.).
After issuing the 'python manage.py inspectdb' I created the first tentative
models.py that I'm now refining specifically to take into account foreign keys.
Now, manage.py both syncdb and runserver don't signal anything abnormal but
when I browse the table articoli as admin the following two tables and classes
are arising a problem because
(1054, "Unknown column 'articoli.categoria_id_id' in 'field list'")
<SNIP models.py>
................
...............
class Categorie(models.Model):
idCategoria = models.IntegerField(primary_key=True)
descrizione = models.CharField(max_length=150, db_column='Descrizione') #
Field name made lowercase.
def __unicode__(self):
return self.descrizione
class Meta:
db_table = u'Categorie'
verbose_name_plural='categorie'
ordering=['descrizione']
class Articoli(models.Model):
id = models.IntegerField(primary_key=True)
categoria_id = models.ForeignKey(Categorie)
codice = models.CharField(max_length=90, unique=True, db_column='Codice')
...............................
...............................
</SNIP>
How can I specify in categoria_id of class Articoli that the key field to refer
to is idCategoria of Categorie?
Ciao
Vittorio
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
