multiple databases and multiple models in django

by

I fully agree with @alecxe on using the database router. I am currently using a single admin interface to manage multiple databases. Note that authentication for all databases are stored in the default database, so when you do the syncdb (with no arguments).

Generic Database Router

I found this implementation to be extremely flexible and useful.

Settings.py 

# Define the database manager to setup the various projects
DATABASE_ROUTERS = ['manager.router.DatabaseAppsRouter']
DATABASE_APPS_MAPPING = {'mux_data': 't29_db', 
                         'T50_VATC':'t50_db'}

DATABASES = {
    'default': {
            'ENGINE': 'django.db.backends.postgresql_psycopg2', 
            'NAME': 'fail_over',                    
            'USER': 'SomeUser',                      
            'PASSWORD': 'SomePassword',                  
            'HOST': '127.0.0.1',                     
            'PORT': '',                      
    },

    't29_db': {
            'ENGINE': 'django.db.backends.postgresql_psycopg2', 
            'NAME': 'mux_stage',                    
            'USER': 'SomeUser',                      
            'PASSWORD': 'SomePassword',                  
            'HOST': '127.0.0.1',                      
            'PORT': '',                      
    },

    't50_db': {
            'ENGINE': 'django.db.backends.postgresql_psycopg2', 
            'NAME': 't50_vatc',                    
            'USER': 'SomeUser',                      
            'PASSWORD': 'SomePassword',                 
            'HOST': '127.0.0.1',                     
            'PORT': '',                      
    },
}

Sample Models 

# Create your models here.
class Card_Test(models.Model):
    name = models.TextField(max_length=100)
    description = models.TextField(max_length=200)
    units = models.TextField(max_length=500)
    result_tags = models.TextField(max_length=500)

    class Meta:
        app_label="mux_data"

    def __unicode__(self):
        return self.name

class Status_Type(models.Model):
    status = models.CharField(max_length=25)

    class Meta:
        app_label="mux_data"

    def __unicode__(self):
        return self.status

More Related Contents:

  1. Django dynamic model fields
  2. Django set default form values
  3. What’s the difference between select_related and prefetch_related in Django ORM?
  4. Can “list_display” in a Django ModelAdmin display attributes of ForeignKey fields?
  5. Django – No such table: main.auth_user__old
  6. How to create an object for a Django model with a many to many field?
  7. django abstract models versus regular inheritance
  8. Django Unique Together (with foreign keys)
  9. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  10. Django : Table doesn’t exist
  11. Get all related Django model objects
  12. Django Rest Framework and JSONField
  13. Django Blob Model Field
  14. How do you join two tables on a foreign key field using django ORM?
  15. Django Many-to-Many (m2m) Relation to same model
  16. How to see the raw SQL queries Django is running?
  17. Writing a __init__ function to be used in django model
  18. How to change the file name of an uploaded file in Django?
  19. Easiest way to rename a model using Django/South?
  20. Customize/remove Django select box blank option
  21. Duplicating model instances and their related objects in Django / Algorithm for recusrively duplicating an object
  22. Identify the changed fields in django post_save signal
  23. How can I set two primary key fields for my models in Django?
  24. Django 2.1.3 Error: __init__() takes 1 positional argument but 2 were given
  25. Django foreign key relation in template
  26. django makemigrations and migrate on heroku server don’t create tables
  27. Django get_profile() method not working on extended User model
  28. Django ModelForm to have a hidden input
  29. How to delete a record in Django models?
  30. Django cannot import name x [duplicate]

Leave a Comment