I have a legacy database that I used inspectdb to create the models.
I cleaned up the models, set primary keys, foriegn keys etc. But when
I tried to create a view I get an "unknown column activity.fp_id_id
in field list". I'm not sure why its appending an extra id to the end
of a foriegnkey field. Here are the two models in question:
class Clients(models.Model):
fp_id = models.CharField(max_length=10, primary_key=True)
fp_name = models.CharField(max_length=200, blank=True)
slug = models.CharField(max_length=200, blank=True)
reg_date = models.CharField(max_length=20, blank=True)
termination_date = models.CharField(max_length=20, blank=True)
address_is_foreign = models.CharField(max_length=2, blank=True)
address_1 = models.CharField(max_length=100, blank=True)
city = models.CharField(max_length=50, blank=True)
state = models.CharField(max_length=10, blank=True)
country = models.CharField(max_length=2, blank=True)
zipcode = models.CharField(max_length=10, blank=True)
foreign_cntry_represented = models.ForeignKey(Country,
max_length=2, blank=True)
class Meta:
db_table = u'clients'
def __unicode__(self):
return self.country
def get_absolute_url(self):
return 'lobby/client/%s/' % self.slug
class Activity(models.Model):
activity_id = models.CharField(max_length=10, primary_key=True)
fp_id = models.ForeignKey(Clients, max_length=10, blank=True)
reg_id = models.ForeignKey(Lobbyist, max_length=10, blank=True)
supp_id = models.CharField(max_length=10, blank=True)
period_start_date = models.DateTimeField(null=True, blank=True)
period_end_date = models.DateTimeField(null=True, blank=True)
activity_type=models.ForeignKey
(Lobbytype,max_length=50,related_name="activity_type", blank=True)
slug = models.CharField(max_length=765, blank=True)
activity_desc = models.TextField(blank=True)
financial_amount = models.FloatField(null=True, blank=True)
financial_desc = models.TextField(blank=True)
country = models.CharField(max_length=2, primary_key=True)
year = models.CharField(max_length=5, blank=True)
class Meta:
db_table = u'activity'
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
