Setting models to specific database in django

Question

I would like to ask how to set models to specific database . I'm still new to django and read about the Database Routing in the Django website, I have 2 models, userMod and adminMod.
userMod should go to database userDB.
adminMod should go to database adminDB.
But when I migrated it, both table exist in both database. I already have included app_label on meta, but its still not working. I am using django 1.8

EDIT: I am just trying it on userDB for a while and eventually will use it with adminDB. This is my code:

routers.py

class router(object):

def db_for_read(self, model, **hints):
    if model._meta.app_label == 'userDB':
        return 'userDB'
    return None

def db_for_write(self, model, **hints):
    if model._meta.app_label == 'userDB':
        return 'userDB'
    return None

def allow_relation(self, obj1, obj2, **hints):
    if obj1._meta.app_label == 'userDB' or\
        obj2._meta.app_label == 'userDB':
            return True
        return None

def allow_migrate(self, db, app_label, model=None, **hints):
    if app_label == 'userDB':
        return db == 'userDB'
    return None

Hi, please insert your code for more clarity. Read this to improve your question so that we can help you better. stackoverflow.com/help/mcve — Edwin Lunando
– Edwin Lunando, Commented Jul 21, 2015 at 4:18

Geo Jacob · Accepted Answer · 2015-07-21 05:04:19Z

1

Try this:

class userMod(models.Model):
   name = models.CharField(max_length=120)

   class Meta:
      db_table='userDB'

answered Jul 21, 2015 at 5:04

Geo Jacob

6,0291 gold badge39 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

predator Over a year ago

Hi @Geo Jacob. Thank you for the suggestion but unfortunately this didn't work. Both tables still exist in userDB

Geo Jacob Over a year ago

I didn't tried this, but this may help you. stackoverflow.com/questions/18547468/…

Tony Dare · Accepted Answer · 2015-07-21 07:38:56Z

1

Remember to tell django about your database router in the settings.py

https://docs.djangoproject.com/en/1.8/topics/db/multi-db/

Search for DATABASE_ROUTERS setting

answered Jul 21, 2015 at 7:38

Tony Dare

3013 silver badges6 bronze badges

Collectives™ on Stack Overflow

Setting models to specific database in django

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related