Re: Inner Join perhaps?

[The Danny Bos]

Actually, that's no good as it craps out if there's no matching
records in CollectionUser.
Back to the drawing board ... Any better ideas?



d

- - -


On Oct 22, 9:01 pm, The Danny Bos  wrote:
> Hey there, I want to loop through all items in CollectionItem
> (models.py below), build a list of the items, then get
> CollectionUser.grade if that exists where (user=request.user) and it's
> associated with the item in CollectionItem list.
>
> eg:
>
> "Item 1" - ""
> "Item 2" - "Grade = 89"
> "Item 3" - ""
> "Item 4" - "Grade = 5"
> "Item 5" - "Grade = 34"
> "Item 5" - ""
>
> Here's my models.py
>
> class Collection(models.Model):
>         title = models.CharField(max_length=50, unique=True)
>         description = models.TextField(blank=True)
>
> class CollectionItem(models.Model):
>         collection = models.ForeignKey(Collection)
>         image = models.ImageField(blank=True, upload_to='temp/')
>
> class CollectionUser(models.Model):
>         user = models.ForeignKey(User)
>         collection_item = models.ForeignKey(CollectionItem, blank=True)
>         grade = models.CharField(max_length=10)
>
> Know what I mean?
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

Re: Inner Join perhaps?

[The Danny Bos]

I think I've got it.
Does the below look right and would it run ok with 1000 Items on a
page?

test_sql = ((t, t.collectionuser_set.get(user=request.user)) for t in
CollectionItem.objects.filter(collection=collection))

for item, useritems in test_sql:
print 'Test: %s - %s' % (item.title, useritems.grade)





On Oct 22, 9:01 pm, The Danny Bos  wrote:
> Hey there, I want to loop through all items in CollectionItem
> (models.py below), build a list of the items, then get
> CollectionUser.grade if that exists where (user=request.user) and it's
> associated with the item in CollectionItem list.
>
> eg:
>
> "Item 1" - ""
> "Item 2" - "Grade = 89"
> "Item 3" - ""
> "Item 4" - "Grade = 5"
> "Item 5" - "Grade = 34"
> "Item 5" - ""
>
> Here's my models.py
>
> class Collection(models.Model):
>         title = models.CharField(max_length=50, unique=True)
>         description = models.TextField(blank=True)
>
> class CollectionItem(models.Model):
>         collection = models.ForeignKey(Collection)
>         image = models.ImageField(blank=True, upload_to='temp/')
>
> class CollectionUser(models.Model):
>         user = models.ForeignKey(User)
>         collection_item = models.ForeignKey(CollectionItem, blank=True)
>         grade = models.CharField(max_length=10)
>
> Know what I mean?
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

Inner Join perhaps?

[The Danny Bos]

Hey there, I want to loop through all items in CollectionItem
(models.py below), build a list of the items, then get
CollectionUser.grade if that exists where (user=request.user) and it's
associated with the item in CollectionItem list.

eg:

"Item 1" - ""
"Item 2" - "Grade = 89"
"Item 3" - ""
"Item 4" - "Grade = 5"
"Item 5" - "Grade = 34"
"Item 5" - ""

Here's my models.py

class Collection(models.Model):
title = models.CharField(max_length=50, unique=True)
description = models.TextField(blank=True)

class CollectionItem(models.Model):
collection = models.ForeignKey(Collection)
image = models.ImageField(blank=True, upload_to='temp/')

class CollectionUser(models.Model):
user = models.ForeignKey(User)
collection_item = models.ForeignKey(CollectionItem, blank=True)
grade = models.CharField(max_length=10)


Know what I mean?

--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---