Django database router

Question

I'd like to route (change) the database based on the authenticated user. I've looked at the docs but I don't know how to do this upon user login...

I was thinking of adding a field with database_name to my custom UserProfile and then I'd like to pass this info to the database router which would make the switch...

I don't have any code to show because I simply don't know how to implement this.

This post somehow relates to my previous post.

So the schema would be like:

- Users (containing only the `UserProfile`)
 - user1 (containing the app database)
 - user2 (containing the app database)
 - ...

Could you point me to the right direction?

Thank you! BR

You will probably want to write a middleware function that checks every incoming request, gets the current user and checks a flag in their user profile, routing accordingly. — Timmy O'Mahony
– Timmy O'Mahony, Commented Mar 11, 2012 at 8:38
What's the relationship between databases and users? Is it a horizontal splitting of user table, or use different DB for model mapping for different users? — okm
– okm, Commented Mar 11, 2012 at 8:38
Refer to [this][1] post on how to play around with the routers [1]: stackoverflow.com/questions/12352360/… — karthikr
– karthikr, Commented Sep 22, 2012 at 23:13

ashwoods · Accepted Answer · 2012-03-12 10:00:48Z

1

Multitenancy in general is a little bit hard to do without twisting django a bit, even though it is a typical request in SaaS applications. Here is a link describing one approach, the one developed at a company I worked with was a little bit different, hacking the contrib.sites, but the database part is pretty similar.

In short, if you want database multitenancy you are going to have to hack Django ConnectionHandler to do what you want.

answered Mar 12, 2012 at 10:00

ashwoods

2,3091 gold badge23 silver badges36 bronze badges

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

1 Comment

Mission Over a year ago

This approach is nice... but I don't really need subdomains and I'm kinda new to Django so hacking is a bit of a problem.

Community · Accepted Answer · 2017-05-23 11:43:37Z

Refer to this post on how to play around with the routers

DATABASE_ROUTERS = ['CustomDatabaseRouter',] #a setting that Django understands.

class CustomDatabaseRouter(object):

  def db_for_read(self, model, **hints):
     site_name = get_current_site()
     if site_name  in ['site1']:
         return 'db1'
     if site_name in ['site2']:
        return 'db2'
     return 'default'

  def db_for_write(self, model, **hints):
     site_name = get_current_site()
     if site_name  in ['site1']:
         return 'db1'
     if site_name in ['site2']:
        return 'db2'
     return 'default'

  def allow_syncdb(self, model, **hints):
     site_name = get_current_site()
     if site_name in ['site1'] and db == 'db1':
         return True
     if site_name in ['site2'] and db == 'db2':
        return True
     return False

Collectives™ on Stack Overflow

Django database router

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related