On Wed, 2007-12-05 at 20:02 -0800, globophobe wrote: [...] > class Stack(models.Model): > title = models.CharField(max_length=100) > description = models.TextField() > > def __unicode__(self): > return self.title > > class Card(models.Model): > stack = models.ForeignKey(Stack) > front = models.TextField(core=True) > back = models.TextField(core=True) > > class Meta: > ordering = ['id'] > > def __unicode__(self): > return self.id > > class Study(models.Model): > user = models.ForeignKey(User) > stack = models.ForeignKey(Stack) > card = models.ForeignKey(Card) > total_correct = models.IntegerField() > total_incorrect = models.IntegerField() > average_correct = models.FloatField() > > def __unicode__(self): > return self.id > > Basically, the Study model is a record of a users study history for a > card. It doesn't have a ForeignKey to a stack
Yes it does. Right there in the second attribute (called "stack"). So what do you really mean? > as I only want rows to > be inserted after a study session i.e. I don't want to create a record > for each card for each user, even if it may be necessary eventually, > because the number of records in Study could quickly amount to the > tens or hundreds of thousands. > > A session has 20 or so cards which are sourced first from the Study > model and then from cards in the Stack that are not yet contained in > the Study model per user in question. I've tried to think about this for more than a few minutes and I don't understand what you're saying here. There seem to be a few problems with your models that just don't match what you're trying to do. Firstly, why is only one Card associated with each Study directly, but each Card can also belong to precisely one Stack and a Study can point to one Stack as well? That's a bit of an odd relationship pattern (after a while, most patterns of links between objects tend to fall into groups, so it might well be that you need this setup, but it looks a bit unusual). You also haven't explained what "study" is in your original query... it's something with a length, but it can't be a Study model instance (since they don't have lengths), so what is it? Malcolm -- Why be difficult when, with a little bit of effort, you could be impossible. http://www.pointy-stick.com/blog/ --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
