{"id":25095,"date":"2016-10-03T11:33:27","date_gmt":"2016-10-03T11:33:27","guid":{"rendered":"https:\/\/dev.railscarma.com\/multi-tenant-architecture-postgresql-schemas\/"},"modified":"2022-08-30T11:53:26","modified_gmt":"2022-08-30T11:53:26","slug":"multi-tenant-arkitektur-postgresql-scheman","status":"publish","type":"post","link":"https:\/\/www.railscarma.com\/sv\/blogg\/tekniska-artiklar\/multi-tenant-arkitektur-postgresql-scheman\/","title":{"rendered":"Arkitektur f\u00f6r flera hyresg\u00e4ster med PostgreSQL-scheman"},"content":{"rendered":"
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tI multi-tenant-arkitektur genom att anv\u00e4nda en enda instans tj\u00e4nar den flera konton. Varje konto kallas hyresg\u00e4st. Det finns s\u00e5 m\u00e5nga olika tillv\u00e4gag\u00e5ngss\u00e4tt f\u00f6r att implementera arkitektur med flera hyresr\u00e4tter med traditionella eller genom att anv\u00e4nda alla \u00e4delstenar. Genom att j\u00e4mf\u00f6ra alla dessa hittade jag det enklaste s\u00e4ttet att implementera Multi-tenancy, det \u00e4r med "Aktera som hyresg\u00e4st" p\u00e4rla representation av Gem\n
p\u00e4rla "fungerar_som_hyresg\u00e4st"<\/code><\/pre>\nEfter att ha placerat detta i din gem-fil, k\u00f6r paketet f\u00f6r att installera detta.\n\nAnv\u00e4ndande:<\/strong>\n\nIt sets the current tenant by  using subdomain and adds the ability to scope models to a tenant.\nFor setting current tenant place the below code in your application controller\n\nCreating Tenant Account Model\n
class AddcolumnsToAccounts < ActiveRecord::Migration def up add_column :accounts, :sub_domain, :string end end\n<\/code><\/pre>\nset_current_tenant_by_subdomain(:account, :subdomain)\n\nManuell metod f\u00f6r att st\u00e4lla in aktuell hyresg\u00e4st<\/strong>\n
class ApplicationController < ActionController::Bas set_current_tenant_through_filter before_filter :find_the_current_tenant def find_the_current_tenant current_account = Account.find_by_subdomain(subdomain: 'subdomain') set_current_tenant(current_account) end\n<\/code><\/pre>\nAvgr\u00e4nsa dina modeller<\/strong>\n
class AddAccountToColleges < ActiveRecord::Migration\ndef up\nadd_column :colleges, :account_id, :integer\nadd_index  :colleges, :account_id\nend\nend\n\nclass College < ActiveRecord::Base\nacts_as_tenant(:account)\nend\n<\/code><\/pre>\nActs as tenant adds a method to validate uniqueness,  validates_uniqueness_to_tenant\nIf you need to validate for uniqueness, you can do by using following code:\n
validates_uniqueness_to_tenant :title<\/code><\/pre>\nOch fler \u00f6ver standardskenor validates_uniqueness_of \u00e4r ocks\u00e5 tillg\u00e4ngliga. Anv\u00e4nd f\u00f6ljande syntax f\u00f6r att ange fr\u00e4mmande nyckel\n
acts_as_tenant(:account, :foreign_key => 'Konto-ID')<\/code><\/pre>\nsom standard tar den account_id\n\nKonfiguration<\/strong>\nEn initialiserare kan skapas f\u00f6r att styra alternativ i ActsAsTenant. Du kan \u00e4ndra konfigurationsalternativen i config\/initializers\/acts_as_tenant.rb\n
ActsAsTenant.configure g\u00f6r |config| config.require_tenant = falskt slut\n<\/code><\/pre>\nconfig.require_tenant n\u00e4r den \u00e4r inst\u00e4lld p\u00e5 true kommer att uppst\u00e5 ett ActsAsTenant::NoTenant-fel n\u00e4r en fr\u00e5ga g\u00f6rs utan en klientupps\u00e4ttning.\n
K\u00e4lla: https:\/\/github.com\/ErwinM\/acts_as_tenant<\/code><\/pre>\n \t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
Prenumerera f\u00f6r de senaste uppdateringarna<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\t\t\t\t\t