Thursday, September 29, 2011

Re: Sampling of the two models by matching fields.

Anybody?

On 27 сен, 18:53, Satan Study Django
<satan.come.and.kill.your.family.an...@gmail.com> wrote:
> Good day.
> To the case.
> There are some models (simplified form):
>
> class Group (models.Model):
>      name = models.CharField ()
>
> class Person (models.Model):
>      name = models.CharField ()
>      groups = models.ManyToManyField (Group)
>
> class Event (models.Model):
>      name = models.CharField ()
>      groups = models.ManyToManyField (Group)
>
> The task is to choose the names of all users and events having the
> same group. For example:
>
> Bob - Learning python
> Bob - Writing hello world
> Peter - Study python
> Peter - Writing billing system
>
> with
>
> "Learning python" - Groups: 'Students'
> "Writing a hello world" - Groups: 'Junior'
> "Writing the billing system" - Groups: 'Experienced'
>
> Bob - Groups: 'Students', 'Junior'
> Peter - Groups: 'Students', 'Experienced'
>
> If we'll try to solve the problem database way, groups would be easier
> to store in the form of, for example, char fields, and select with a
> simple condition:
>
> where p.groups = e.groups
>
> and then it becomes trivial (that is what happened in the past
> implementation of the interface).
>
> At the current moment that logic of the objects must implement to
> django, and, faced with a problem I do not see how to solve it any
> other way but commonplace 'for'.
> I would be glad of any clue, including possible ways to change the
> database structure.
>
> Thanks for your attention.

--
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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

No comments:

Post a Comment