Re: Problem creating foreign key on a model created by inspectdb

On Tue, Feb 28, 2012 at 3:24 PM, Joel Goldstick
<joel.goldstick@gmail.com> wrote:
> I have a legacy database from which I created a model called 'LandSupplier'
>
>    class LandSupplier(models.Model):
>        landsupplierid = models.AutoField(primary_key=True,
> db_column='LandSupplierId') # Field name made lowercase.
>        ...
>        class Meta:
>            db_table = u'LandSupplier'
>            ordering = ("name",)
>
> I have a second model called LandOffer:
>
>    class LandOffer(models.Model):
>        id = models.AutoField(primary_key=True)
>        name = models.CharField(max_length=300, db_column='Name') #
> Field name made lowercase.
>        supplier = models.ForeignKey('LandSupplier', db_column='landsupplierid')
>
> I get this error:
>
> Request Method: GET
> Request URL:    http://localhost:8000/admin/land/landoffer/
> Django Version: 1.3.1
> Exception Type: OperationalError
> Exception Value:        (1054, "Unknown column
> 'land_landoffer.landsupplierid' in 'field list'")
>
> It seems to take my fieldname, but not my table name.  I'm wondering
> how to fix this.  I could rename the table to 'land_landoffer' but
> that would mess up a lot of other code, and I would rather learn what
> I am doing wrong here
>
> --
> Joel Goldstick

Nothing like posting to clear the problem. I put this in my model,
and then added supplier_id to my table by hand. Problem solved

supplier = models.ForeignKey('LandSupplier')

--
Joel Goldstick

--
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 django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.