How do I restrict foreign keys choices to related objects only in django

by

I just came across ForeignKey.limit_choices_to in the Django docs.
Not sure yet how this works, but it might just be the right thing here.

Update: ForeignKey.limit_choices_to allows to specify either a constant, a callable or a Q object to restrict the allowable choices for the key. A constant obviously is of no use here, since it knows nothing about the objects involved.

Using a callable (function or class method or any callable object) seems more promising. However, the problem of how to access the necessary information from the HttpRequest object remains. Using thread local storage may be a solution.

2. Update: Here is what has worked for me:

I created a middleware as described in the link above. It extracts one or more arguments from the request’s GET part, such as “product=1”, and stores this information in the thread locals.

Next there is a class method in the model that reads the thread local variable and returns a list of ids to limit the choice of a foreign key field.

@classmethod
def _product_list(cls):
    """
    return a list containing the one product_id contained in the request URL,
    or a query containing all valid product_ids if not id present in URL

    used to limit the choice of foreign key object to those related to the current product
    """
    id = threadlocals.get_current_product()
    if id is not None:
        return [id]
    else:
        return Product.objects.all().values('pk').query

It is important to return a query containing all possible ids if none was selected so that the normal admin pages work ok.

The foreign key field is then declared as:

product = models.ForeignKey(
    Product,
    limit_choices_to={
        id__in=BaseModel._product_list,
    },
)

The catch is that you have to provide the information to restrict the choices via the request. I don’t see a way to access “self” here.

More Related Contents:

  1. Django dynamic model fields
  2. Django set default form values
  3. How to create an object for a Django model with a many to many field?
  4. django abstract models versus regular inheritance
  5. Django post_save() signal implementation
  6. difference between filter with multiple arguments and chain filter in django
  7. LEFT JOIN Django ORM
  8. django.db.migrations.exceptions.InconsistentMigrationHistory
  9. Is this the way to validate Django model fields?
  10. Django Blob Model Field
  11. Django – How to rename a model field using South?
  12. Django Many-to-Many (m2m) Relation to same model
  13. How to have a Python script for a Django app that accesses models without using the manage.py shell?
  14. How to display uploaded images in “Change List” page in Django Admin?
  15. How to change the file name of an uploaded file in Django?
  16. Easiest way to rename a model using Django/South?
  17. models.py getting huge, what is the best way to break it up?
  18. matching query does not exist Error in Django
  19. Django admin file upload with current model id
  20. one-to-many inline select with django admin
  21. Good ways to sort a queryset? – Django
  22. Resize fields in Django Admin
  23. Get the latest record with filter in Django
  24. Django DoesNotExist
  25. python_2_unicode_compatible error
  26. How to validate uniqueness constraint across foreign key (django)
  27. How to store a dictionary on a Django Model?
  28. How to properly use the “choices” field option in Django
  29. update django database to reflect changes in existing models
  30. Django admin – inline inlines (or, three model editing at once)

Leave a Comment