Hi Marks,
Ok, I would use `prefetch_related` method then.
https://docs.djangoproject.com/en/2.0/ref/models/querysets/#prefetch-related
you should override `get_queryset` with something like that:
def get_queryset(self, request):
return super().get_queryset(request).prefetch_related('document')
> In your model you specified `document` not `documents` that is why I used
`document`
With this all related document would be already in memory.
In your methods you can do something like this:
def get_field_1(self, obj):
return ''.join([q.field_1 for q in obj.document.all()])
And use the same approach for second method
Does it make any sense?
Regards,
Constantine C.
On Sat, Dec 9, 2017 at 11:32 AM, Mark Phillips <m...@phillipsmarketing.biz>
wrote:
> should have been
>
> class CollectionAdmin(admin.ModelAdmin)
> in the above post.
>
> Mark
>
> On Sat, Dec 9, 2017 at 9:16 AM, Mark Phillips <m...@phillipsmarketing.biz>
> wrote:
>
>> Hit send by accident...
>>
>> Constantine,
>>
>> Thanks for the link and update! However, I am not sure how to make two
>> columns in the CollectionsAdmin table without two functions.
>>
>> class CollectionAdmin(self, obj):
>> list_display = ('get_field_1', 'get_field_2', )
>>
>> def get_field_1(self, obj):
>> tempstr = ""
>> documents = obj.document.all()
>> for d in documents:
>> tempstr = tempstr + d.field_1
>> return tempstr
>>
>> def get_field_2(self, obj):
>> tempstr = ""
>> documents = obj.document.all()
>> for d in documents:
>> tempstr = tempstr + d.field_2
>> return tempstr
>>
>> Mark
>>
>> On Sat, Dec 9, 2017 at 9:14 AM, Mark Phillips <m...@phillipsmarketing.biz
>> > wrote:
>>
>>> Constantine,
>>>
>>> Thanks for the link and update! However, I am not sure how to make two
>>> columns in the CollectionsAdmin table without two functions.
>>>
>>> class COllectionAdmin(self, obj):
>>> list_display =
>>>
>>> On Sat, Dec 9, 2017 at 8:53 AM, Constantine Covtushenko <
>>> constantine....@gmail.com> wrote:
>>>
>>>> Hi Mark,
>>>>
>>>> You should not create 2 methods.
>>>> Just change that first to be like:
>>>>
>>>> return obj.document.all().values_list('field_1', 'field_2')
>>>>
>>>> With this you will get QuerySet of tuples, like
>>>> <QuerySet [(obj1_field_1_value, obj1_field_2_value), ...]>
>>>>
>>>> I believe it should solve your problem.
>>>>
>>>> Also for more references about values_list, check following
>>>> documentation page:
>>>> https://docs.djangoproject.com/en/2.0/ref/models/querysets/#values-list
>>>>
>>>> Regards,
>>>> Constantine C.
>>>>
>>>> On Sat, Dec 9, 2017 at 12:41 AM, Mark Phillips <
>>>> m...@phillipsmarketing.biz> wrote:
>>>>
>>>>> The point of the queries is to get information about the underlying
>>>>> Documents in each Collection, and display it in the admin page. For
>>>>> example, title is one attribute, but there are also other that I want to
>>>>> display.
>>>>>
>>>>> Your idea obj.document.all().values_list('title', flat=True) makes a
>>>>> lot of sense - Thanks!
>>>>>
>>>>> Now, a bigger question. Say I have two fields in Documents that I want
>>>>> to display side by side in a table in the Collection admin page. I would
>>>>> have two entries in the list_display:
>>>>>
>>>>> list_display = ('get_field_1', 'get_field_2', )
>>>>>
>>>>> and two functions, and each one calls obj.document.all(), which
>>>>> returns a query set of Documents in this particular Collection.
>>>>>
>>>>> def get_field_1(self, obj):
>>>>> tempstr = ""
>>>>> documents = obj.document.all()
>>>>> for d in documents:
>>>>> tempstr = tempstr + d.field_1
>>>>> return tempstr
>>>>>
>>>>> def get_field_2(self, obj):
>>>>> tempstr = ""
>>>>> documents = obj.document.all()
>>>>> for d in documents:
>>>>> tempstr = tempstr + d.field_2
>>>>> return tempstr
>>>>>
>>>>> These two "list of fields" from the Documents are displayed side by
>>>>> side. Will the first entry in the field_1 list always correspond to the
>>>>> first entry in the field_2 list? In other words, I am concerned about the
>>>>> order of the documents returned in the query set obj.document.all().
>>>>> Will it always be the same?
>>>>>
>>>>> Perhaps a picture will help (I hope it comes through). Note the
>>>>> ordered lists of file names and thumbnails. I used the code above (with a
>>>>> few modifications) to generate the table. My concern is if the file name
>>>>> in
>>>>> the first list (a field in the Document model) will always correspond to
>>>>> the thumbnail in the second column (another field in the Document model).
>>>>>
>>>>> Thanks!
>>>>>
>>>>> On Fri, Dec 8, 2017 at 7:56 PM, Constantine Covtushenko <
>>>>> constantine....@gmail.com> wrote:
>>>>>
>>>>>> Hi Mark,
>>>>>>
>>>>>> Answering on your question I would do in your `get_documents` method:
>>>>>>
>>>>>> return obj.document.all().values_list('title', flat=True)
>>>>>>
>>>>>> this will get list of all document titles.
>>>>>>
>>>>>> But at the same time why do you need get_documents method? How do you
>>>>>> use it?
>>>>>> May be it is better to optimize `get_queryset` of CollecionAdmin
>>>>>> instead?
>>>>>>
>>>>>> Regards,
>>>>>> Constantine C.
>>>>>>
>>>>>> On Fri, Dec 8, 2017 at 8:07 PM, Mark Phillips <
>>>>>> m...@phillipsmarketing.biz> wrote:
>>>>>>
>>>>>>> I have two models -
>>>>>>>
>>>>>>> class Document(models.Model):
>>>>>>> document_id = models.AutoField(primary_key=True)
>>>>>>> title = models.CharField('title', max_length=200)
>>>>>>>
>>>>>>> class Meta:
>>>>>>> ordering = ['title']
>>>>>>>
>>>>>>> def __str__(self):
>>>>>>> return "%s" % (self.title)
>>>>>>>
>>>>>>> class Collection(models.Model):
>>>>>>> collection_id = models.AutoField(primary_key=True)
>>>>>>> name = models.CharField('title', max_length=200)
>>>>>>> description = models.TextField('description')
>>>>>>> document = models.ManyToManyField(Document,)
>>>>>>>
>>>>>>> In admin.py, I am trying to show the documents that are in a
>>>>>>> collection. I have this:
>>>>>>>
>>>>>>> class CollectionAdmin(admin.ModelAdmin):
>>>>>>> filter_horizontal = ('document',)
>>>>>>> list_display = ('name', 'description', 'get_documents')
>>>>>>>
>>>>>>> def get_documents(self, obj):
>>>>>>> documents = Collection.objects.filter(coll
>>>>>>> ection_id=obj.collection_id).values('document')
>>>>>>> templist = []
>>>>>>> for doc in documents:
>>>>>>> d = Document.objects.get(document_
>>>>>>> id=doc['document']).title
>>>>>>> templist.append(d)
>>>>>>> return templist
>>>>>>>
>>>>>>> My question is, I getting the titles of the documents in the
>>>>>>> collection correctly? Is there some way to get a queryset to look up the
>>>>>>> Document fields directly, or do I have to make two queries as I am
>>>>>>> doing?
>>>>>>>
>>>>>>> Thanks!
>>>>>>>
>>>>>>> Mark
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> You received this message because you are subscribed to the Google
>>>>>>> Groups "Django users" group.
>>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>>> send an email to django-users+unsubscr...@googlegroups.com.
>>>>>>> To post to this group, send email to django-users@googlegroups.com.
>>>>>>> Visit this group at https://groups.google.com/group/django-users.
>>>>>>> To view this discussion on the web visit
>>>>>>> https://groups.google.com/d/msgid/django-users/CAEqej2NmUSH-
>>>>>>> W2_Fd9WkmPjZzj5krk2Qmw4DyaWBkj5_mj46Kw%40mail.gmail.com
>>>>>>> <https://groups.google.com/d/msgid/django-users/CAEqej2NmUSH-W2_Fd9WkmPjZzj5krk2Qmw4DyaWBkj5_mj46Kw%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>>>> .
>>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Sincerely yours,
>>>>>> Constantine C
>>>>>>
>>>>>> --
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "Django users" group.
>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>> send an email to django-users+unsubscr...@googlegroups.com.
>>>>>> To post to this group, send email to django-users@googlegroups.com.
>>>>>> Visit this group at https://groups.google.com/group/django-users.
>>>>>> To view this discussion on the web visit
>>>>>> https://groups.google.com/d/msgid/django-users/CAK52boUqUyLU
>>>>>> uMutsnQrxDGDspqJ0fd7RZfTGLxauHDWqUAroA%40mail.gmail.com
>>>>>> <https://groups.google.com/d/msgid/django-users/CAK52boUqUyLUuMutsnQrxDGDspqJ0fd7RZfTGLxauHDWqUAroA%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>>> .
>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>
>>>>>
>>>>> --
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "Django users" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to django-users+unsubscr...@googlegroups.com.
>>>>> To post to this group, send email to django-users@googlegroups.com.
>>>>> Visit this group at https://groups.google.com/group/django-users.
>>>>> To view this discussion on the web visit
>>>>> https://groups.google.com/d/msgid/django-users/CAEqej2OQmm-w
>>>>> 9xv%2B5AFHeShUggEjx2y2PFFNi3DKNYW3W%2BYhDA%40mail.gmail.com
>>>>> <https://groups.google.com/d/msgid/django-users/CAEqej2OQmm-w9xv%2B5AFHeShUggEjx2y2PFFNi3DKNYW3W%2BYhDA%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>> .
>>>>>
>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Sincerely yours,
>>>> Constantine C
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Django users" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to django-users+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to django-users@googlegroups.com.
>>>> Visit this group at https://groups.google.com/group/django-users.
>>>> To view this discussion on the web visit https://groups.google.com/d/ms
>>>> gid/django-users/CAK52boWUgJ45-aVo4SUSo%2BUKr6QrY1GtXgffNBsv
>>>> RD8CwWukQg%40mail.gmail.com
>>>> <https://groups.google.com/d/msgid/django-users/CAK52boWUgJ45-aVo4SUSo%2BUKr6QrY1GtXgffNBsvRD8CwWukQg%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>
>>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/django-users/CAEqej2MaP7LdjQ5s46k5RGY%3DeSNyQG90MtpnGiu%3De%3Drgpt__
> jQ%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAEqej2MaP7LdjQ5s46k5RGY%3DeSNyQG90MtpnGiu%3De%3Drgpt__jQ%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
> For more options, visit https://groups.google.com/d/optout.
>
--
Sincerely yours,
Constantine C
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAK52boUxke70DHWChk7uOHEqOS33o95xPkxZbGULKcpPDbwM%2Bw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
