nm, solved
On Oct 14, 1:54 pm, Guy Nesher <nesher....@gmail.com> wrote:
> Hi DR,
>
> Thanks, I've just started developing in Python/Django so I do
> apologize for the bad naming convention (I'll fix this once everything
> works, don't want to add additional errors before I sort this).
>
> Having said that I assumed that if I define the foreignkey manually
> and specifically select an int field it will work.
>
> I've tried to add the _id to the update process (ResturantId to
> ResturantId_id) but I just get an error saying the field does not
> exist :
> Cannot resolve keyword 'RestaurantId_id' into field. Choices are:
> Date, PrizeId, Quantity, RestaurantId, id
>
> The new update line now looks like this:
> PrizetoRestaurant.objects.get_or_create(RestaurantId_id=int(row[0]),
> PrizeId=prizedict[2], Date = row[10], Quantity = row[2])
>
> I'm guessing I'm missing something, just not sure what
>
> On Oct 14, 1:24 pm, Daniel Roseman <dan...@roseman.org.uk> wrote:
>
>
>
>
>
>
>
> > On Friday, 14 October 2011 12:44:45 UTC+1, Guy Nesher wrote:
>
> > > Hi,
>
> > > I'm trying to populate a table with 2 foreign keys using a csv file
> > > and keep getting the following error :
> > > Cannot assign "238": "PrizetoRestaurant.RestauranttId" must be a
> > > "Restaurant" instance.
>
> > > I tried to manually define the primary keys in those tables, and I'm
> > > making sure I int() the data from the csv, but still now luck.
> > > I've also looked in the db and a restaurant with id 238 does exist in
> > > the Restaurant table.
>
> > > I'm attaching the relevant code bellow.
>
> > > Thanks!
>
> > > I have the following model:
>
> > > class Restaurant(models.Model):
> > > Id = models.IntegerField(unique=True, primary_key=True)
> > > Name = models.CharField(max_length=128)
> > > Address = models.CharField(max_length=128)
> > > Zip = models.CharField(max_length=128)
> > > City = models.CharField(max_length=128)
> > > Phone = models.CharField(max_length=128)
> > > Latitude = models.DecimalField(max_digits=11, decimal_places=9)
> > > Longitude = models.DecimalField(max_digits=11, decimal_places=9)
>
> > > class Prize(models.Model):
> > > Id = models.IntegerField(unique=True, primary_key=True)
> > > Name = models.CharField(max_length=128)
> > > GroupId = models.ForeignKey('PrizeGroup', to_field='Id')
>
> > > class PrizetoRestaurant(models.Model):
> > > RestaurantId = models.ForeignKey('Restaurant', to_field='Id')
> > > PrizeId = models.ForeignKey('Prize', to_field='Id')
> > > Date = models.DateField()
> > > Quantity = models.IntegerField()
>
> > > and the code is :
>
> > > import csv
> > > reader = csv.reader(open("/Users/guy.nesher/Work/tmsw/swiss/src/
> > > monopoly/static/csv/dailydatatest.csv", "rU"), dialect='excel')
> > > for row in reader:
>
> > > PrizetoRestaurant.objects.get_or_create(RestaurantId=int(row[0]),
> > > PrizeId=prizedict[2], Date = row[10], Quantity = row[2])
>
> > The error is quite clear: you're getting an integer from the CSV, but
> > Django's ForeignKey expects an actual instance of the related table. If
> > you'd called your field something sensible like "restaurant" this would be
> > more obvious.
>
> > You can actually assign the ID directly by postfixing _id to the field name
> > - so in your case, it would be RestaurantId_id
>
> > Please, also read PEP8 and don't give your fields InitialCaps names - they
> > should be lower_case_with_underscore.
> > --
> > DR.
--
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+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
