Django – how to specify a database for a model?

by

You can’t specify a database for a model, but you can define it in a custom DB router class.

# app/models.py
class SomeModel(models.Model):
    ...

# app/dbrouters.py
from app.models import SomeModel
...
class MyDBRouter(object):

    def db_for_read(self, model, **hints):
        """ reading SomeModel from otherdb """
        if model == SomeModel:
            return 'otherdb'
        return None

    def db_for_write(self, model, **hints):
        """ writing SomeModel to otherdb """
        if model == SomeModel:
            return 'otherdb'
        return None


# app/settings.py
DATABASE_ROUTERS = ('app.dbrouters.MyDBRouter',)
...
DATABASES = {
    ...
    'otherdb': {
        ....
    }
}

More Related Contents:

  1. Django: dynamic database file
  2. What’s the difference between django OneToOneField and ForeignKey?
  3. How to set a Django model field’s default value to a function call / callable (e.g., a date relative to the time of model object creation)
  4. Django: Get model from string?
  5. Django: Get list of model fields?
  6. How to filter empty or NULL names in a QuerySet?
  7. How do I get Django Admin to delete files when I remove an object from the database/model?
  8. How to view corresponding SQL query of the Django ORM’s queryset?
  9. In a django model custom save() method, how should you identify a new object?
  10. Unique fields that allow nulls in Django
  11. Using a UUID as a primary key in Django models (generic relations impact)
  12. Django ManyToMany filter()
  13. Django multiple and dynamic databases
  14. ImageField overwrite image file with same name
  15. How do I add a Foreign Key Field to a ModelForm in Django?
  16. Django: Validate file type of uploaded file
  17. django dynamically filtering with q objects
  18. How to limit queryset/the records to view in Django admin site?
  19. How to assign currently logged in user as default value for a model field?
  20. Django: implementing JOIN using Django ORM?
  21. Django – Simple custom template tag example
  22. Django user profile
  23. How can I restrict Django’s GenericForeignKey to a list of models?
  24. Django ManyToMany model validation
  25. Django – Overriding the Model.create() method?
  26. Multiple images per Model
  27. Can Django automatically create a related one-to-one model?
  28. Limit number of model instances to be created – django
  29. django most efficient way to count same field values in a query
  30. Sharing models between Django apps

Leave a Comment