Change table name in apartment.rb

[laerciocrestani]

Hello.

My question would be:
Today I have the following tanant:
Subdomain: itsmileacademia.pidia.com.br
Database I need connection: itsmileacademi (without the "a")
But I can not set the database in config.tenant_names

Notice that it searches the database for the subdomain and I have this for many clients, however I now have an external connection to another HOST and they can not rename the base.

Look at the attachments.

Someone could help me how I should proceed. Thank you very much.

[mikecmpbll]

thanks for the report, i'll be looking into this over the coming days

[mikecmpbll]

i think i'll be focusing on the rewrite of connection switching that i'm working on atm in #438 . you should be able to hack around this for now by calling your tenant "itsmileacademi" and then handling translating this specific case in your subdomain elevator.

i'd be happy to review an MR though.

[laerciocrestani]

@mikecmpbll
I did not understand how I should do to be able to suppress it.
Can you kindly give me an example?
Tanks

[mikecmpbll]

presumably you're using some kind of subdomain elevator? maybe the one that ships with apartment? that elevator would take the subdomain 'itsmileacademia', and try to connect to tenant 'itsmileacademia'. the problem is, the hash configuration overrides the database name with the tenant name, so if your database is really called 'itsmileacademi' that's what your tenant will have to be called.

sooo.. with that said, you can change your tenant names config to have 'itsmileacademi' as the tenant name, then you can write your own apartment connection middleware which is the same as what you're currently using, but which has something like:

subdomain = 'itsmileacademi' if subdomain == 'itsmileacademia'

# apartment will then connect to tenant 'itsmileacademi'

[laerciocrestani]

@mikecmpbll
Sorry for my ignorance, but I saw here about the generic elevator, but when I tribute it I lose the subdomain, see below if I should use it this way?

Rails.application.config.middleware.use 'SiteBake::SiteElevator'
require 'apartment/elevators/generic'

module SiteBake
  # SiteBake::SiteElevator
  class SiteElevator < Apartment::Elevators::Generic
    def parse_tenant_name(request)
      domain = Domain.find_by_host request.host

      return domain.site.token unless domain.nil?

      fail StandardError, "Domain with host #{request.host} not found"
    end
  end
end

[mikecmpbll]

no problem! i suggest subclassing the subdomain elevator if that's what you need: https://github.com/influitive/apartment/blob/development/lib/apartment/elevators/subdomain.rb

you can then override parse_tenant_name with your custom behaviour.

if you have other questions you can find me at #apartment irc on freenode