Bruno, *samurai *is a Japanese word that has been brought into English. The
only accepted spelling in English is *samurai* (according to the Oxford
English Dictionary), and this covers both singular and plural. It's
interesting to note that in Japanese the plural is *samurai*. They do not
have a way of denoting plural versus singular except by counting (2 samurai
vs 1 samurai). I think English borrowed this convention for this word. The
spelling *samourai *is French and may very well include an s for the plural.
Incidentally, *Le samourai* is an excellent French movie from 1967. It has
nothing to do with Japan, however.
Alex and Bruno, thank you for the explicit example of using the double
underscore. It wasn't clear to me from the Django Query Documentation when
it was supposed to be used. I think I have a better idea now.
Using the double underscore, the page now loads in about 1 seconds, but a
lot of that is probably template rendering. The database queries are much
faster!
Daniel, your blog looks very relevant and interesting. I will spend some
time reading through your various optimization posts. Thank you for tooting
your own (relevant) blog! Hopefully I can learn how to optimize my query
even more and also get a better understanding of database query theory.
Thank you all!
-Tim
On Wed, Feb 24, 2010 at 9:40 AM, bruno desthuilliers <
bruno.desthuilli...@gmail.com> wrote:
> On Feb 24, 9:08 am, Timothy Kinney <timothyjkin...@gmail.com> wrote:
> > I have models which describe a game. There are 61 provinces with 9
> > rooms in each province, for a total of 549 locations. There are
> > several hundred samurai, each assigned to a particular room id.
> >
> > Province(name, id, exits)
> > Room(id, name, foreignkey('Province'))
> > Samurai(id, name, foreignkey('Room'))
> >
> > I want to display a list of samurai (by id) for each province on the
> > admin/change_list.html.
> >
> > I created a method in the Province model:
> >
> > def samurai(self):
>
> Since a province will have many samourais, this should probably be a
> plural.
>
> > r = self.room_set.filter(province = self.pk).all()
>
> This could be simply written as:
>
> r = self.room_set.all()
>
> > output = []
> > for i in r:
> > output.extend(i.samurai())
>
>
> Not tested, but what about:
> samourais = Samourai.objects.filter(room__province=self)
>
> Oh, wait, Alex already mentioned this :-)
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to django-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users+unsubscr...@googlegroups.com<django-users%2bunsubscr...@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@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.
