Login

ForeignKey dropdown selector

Author:
rubic
Posted:
February 28, 2007
Language:
Python
Version:
Pre .96
Score:
4 (after 6 ratings)

Most of the time when you want a dropdown selector based on a ForeignKey, you'll want to use snippet #26

Here's an alternative approach, perhaps useful when you want to define choices once and reuse it in different views without overriding Form __init__.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
from django import newforms as forms
from django.db import models

################ models ####################

class BillCode(models.Model):
    description = models.CharField(maxlength=20)

class Payment(models.Model):
    billCode = models.ForeignKey(BillCode)

################# views ####################

class Choices:
    def _choices(self):
        return [(e.id, e.description) for e in BillCode.objects.all()]
    choices = property(_choices)

class PaymentForm(forms.Form):
    billCode_id = forms.ChoiceField(label="Bill Code",
        choices=[('','')]+Choices().choices)

More like this

  1. Template tag - list punctuation for a list of items by shapiromatron 2 months, 2 weeks ago
  2. JSONRequestMiddleware adds a .json() method to your HttpRequests by cdcarter 2 months, 3 weeks ago
  3. Serializer factory with Django Rest Framework by julio 9 months, 2 weeks ago
  4. Image compression before saving the new model / work with JPG, PNG by Schleidens 10 months, 1 week ago
  5. Help text hyperlinks by sa2812 11 months ago

Comments

dballanc (on March 2, 2007):

Choices seems to be calculated at the time the module is loaded, and not dynamically (that seems to be what snippet #26 is for). So if you add a new billcode to the database, the select is not updated until the server is restarted.

#

rubic (on March 4, 2007):

No, that's not correct. To illustrate the way Python properties work:

<blockquote>
    >>> from random import random
    >>> class Random:
    ...     def _random(self):
    ...         return random()
    ...     myrandom = property(_random)
    ... 
    >>> r = Random()
    >>> r.myrandom
    0.49401656652962789
    >>> r.myrandom
    0.29781862434091533
    >>> 
</blockquote>

#

robbie (on March 6, 2007):

While I haven't tried with newforms, this approach certainly doesn't work with oldforms...

I spent some time trying to setup a field that listed its 5 most common choices at the top, but it would not update to reflect new records until a forced server reload. I can't remember exactly where the problem lay, but I have a vague memory that it was related to the method currying that Django does behind the scenes when models are loaded.

#

rubic (on March 6, 2007):

robbie: I don't have any experience with oldforms, but the first line of code should make it clear that this applies to newforms, where it's been tested and used.

#

bloodpet (on July 9, 2009):

Why not just create a function? Something like this:

def get_choices():
    return [(e.id, e.description) for e in BillCode.objects.all()]

So instead of:

    choices=[('','')]+Choices().choices

You'll only have to use:

    choices=[('','')]+get_choices()

#

jagdeepmalhi (on January 14, 2012):

Instead of:

  choices=[('','')]+Choices().choices

Only use:

  choices=get_choices()

Otherwise one blank option is shown in dropbox.

#

Please login first before commenting.