#388 Multitenancy with Scopes pro

Oct 20, 2012 | 12 minutes | Active Record, Authorization

A multi-tenant application can be difficult to implement because the data for each tenant must be completely separate. Here I show how to do this using subdomains and default scopes in Active Record.

Click to Play Video ▶

Download:
source codeProject Files in Zip (71.8 KB)
mp4Full Size H.264 Video (25.9 MB)
m4vSmaller H.264 Video (12.8 MB)
webmFull Size VP8 Video (15.9 MB)
ogvFull Size Theora Video (28.3 MB)

Browse Source Code

Resources

          terminal
        
rails g model tenant name subdomain
rails g migration add_tenant_to_topics tenant_id:integer:index
rails g migration add_tenant_to_posts tenant_id:integer:index
rails g migration add_tenant_to_users tenant_id:integer:index
rake db:migrate

          rails console
        
Tenant.create! name: "Cheese", subdomain: "cheese"
Tenant.create! name: "Chunky Bacon", subdomain: "chunkybacon"
Topic.count
Topic.update_all(tenant_id: 1)
Topic.unscoped.count

          application_controller.rb
        
around_filter :scope_current_tenant

private

def current_tenant
  Tenant.find_by_subdomain! request.subdomain
end
helper_method :current_tenant

def scope_current_tenant
  Tenant.current_id = current_tenant.id
  yield
ensure
  Tenant.current_id = nil
end

          models/tenant.rb
        
def self.current_id=(id)
  Thread.current[:tenant_id] = id
end

def self.current_id
  Thread.current[:tenant_id]
end

          models/topic.rb
        
default_scope { where(tenant_id: Tenant.current_id) }

          models/post.rb
        
default_scope { where(tenant_id: Tenant.current_id) }

          models/user.rb
        
validates_uniqueness_of :email, scope: :tenant_id
default_scope { where(tenant_id: Tenant.current_id) }

          topics/index.html.erb
        
<%= current_tenant.name %>