connection_handling.rb 9.3 KB
Newer Older
1 2
# frozen_string_literal: true

3 4
module ActiveRecord
  module ConnectionHandling
5
    RAILS_ENV   = -> { (Rails.env if defined?(Rails.env)) || ENV["RAILS_ENV"].presence || ENV["RACK_ENV"].presence }
6 7
    DEFAULT_ENV = -> { RAILS_ENV.call || "default_env" }

8 9
    # Establishes the connection to the database. Accepts a hash as input where
    # the <tt>:adapter</tt> key must be specified with the name of a database adapter (in lower-case)
10
    # example for regular databases (MySQL, PostgreSQL, etc):
11 12
    #
    #   ActiveRecord::Base.establish_connection(
R
Ryuta Kamizono 已提交
13
    #     adapter:  "mysql2",
A
AvnerCohen 已提交
14 15 16 17
    #     host:     "localhost",
    #     username: "myuser",
    #     password: "mypass",
    #     database: "somedatabase"
18 19 20 21 22
    #   )
    #
    # Example for SQLite database:
    #
    #   ActiveRecord::Base.establish_connection(
J
Julian Simioni 已提交
23
    #     adapter:  "sqlite3",
24
    #     database: "path/to/dbfile"
25 26 27 28 29
    #   )
    #
    # Also accepts keys as strings (for parsing from YAML for example):
    #
    #   ActiveRecord::Base.establish_connection(
J
Julian Simioni 已提交
30
    #     "adapter"  => "sqlite3",
31
    #     "database" => "path/to/dbfile"
32 33 34 35 36 37 38 39
    #   )
    #
    # Or a URL:
    #
    #   ActiveRecord::Base.establish_connection(
    #     "postgres://myuser:mypass@localhost/somedatabase"
    #   )
    #
40 41
    # In case {ActiveRecord::Base.configurations}[rdoc-ref:Core.configurations]
    # is set (Rails automatically loads the contents of config/database.yml into it),
42 43 44 45 46
    # a symbol can also be given as argument, representing a key in the
    # configuration hash:
    #
    #   ActiveRecord::Base.establish_connection(:production)
    #
47
    # The exceptions AdapterNotSpecified, AdapterNotFound and +ArgumentError+
48
    # may be returned on an error.
49
    def establish_connection(config_or_env = nil)
50 51
      db_config = resolve_config_for_connection(config_or_env)
      connection_handler.establish_connection(db_config)
52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
    end

    # Connects a model to the databases specified. The +database+ keyword
    # takes a hash consisting of a +role+ and a +database_key+.
    #
    # This will create a connection handler for switching between connections,
    # look up the config hash using the +database_key+ and finally
    # establishes a connection to that config.
    #
    #   class AnimalsModel < ApplicationRecord
    #     self.abstract_class = true
    #
    #     connects_to database: { writing: :primary, reading: :primary_replica }
    #   end
    #
    # Returns an array of established connections.
    def connects_to(database: {})
      connections = []

      database.each do |role, database_key|
72
        db_config = resolve_config_for_connection(database_key)
73 74
        handler = lookup_connection_handler(role.to_sym)

75
        connections << handler.establish_connection(db_config)
76 77 78 79 80 81 82 83 84 85 86 87
      end

      connections
    end

    # Connects to a database or role (ex writing, reading, or another
    # custom role) for the duration of the block.
    #
    # If a role is passed, Active Record will look up the connection
    # based on the requested role:
    #
    #   ActiveRecord::Base.connected_to(role: :writing) do
88
    #     Dog.create! # creates dog using dog writing connection
89 90 91 92 93 94
    #   end
    #
    #   ActiveRecord::Base.connected_to(role: :reading) do
    #     Dog.create! # throws exception because we're on a replica
    #   end
    #
95
    #   ActiveRecord::Base.connected_to(role: :unknown_role) do
96 97
    #     # raises exception due to non-existent role
    #   end
98
    def connected_to(database: nil, role: nil, prevent_writes: false, &blk)
99 100 101 102
      if database
        ActiveSupport::Deprecation.warn("The database key in `connected_to` is deprecated. It will be removed in Rails 6.2.0 without replacement.")
      end

103
      if database && role
104
        raise ArgumentError, "connected_to can only accept a `database` or a `role` argument, but not both arguments."
105
      elsif database
106 107 108 109 110
        if database.is_a?(Hash)
          role, database = database.first
          role = role.to_sym
        end

111
        db_config = resolve_config_for_connection(database)
112
        handler = lookup_connection_handler(role)
113

114
        handler.establish_connection(db_config)
115 116

        with_handler(role, &blk)
117
      elsif role
118 119 120 121
        prevent_writes = true if role == reading_role

        with_handler(role.to_sym) do
          connection_handler.while_preventing_writes(prevent_writes, &blk)
122
        end
123 124 125 126 127
      else
        raise ArgumentError, "must provide a `database` or a `role`."
      end
    end

J
John Hawthorn 已提交
128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150
    # Returns true if role is the current connected role.
    #
    #   ActiveRecord::Base.connected_to(role: :writing) do
    #     ActiveRecord::Base.connected_to?(role: :writing) #=> true
    #     ActiveRecord::Base.connected_to?(role: :reading) #=> false
    #   end
    def connected_to?(role:)
      current_role == role.to_sym
    end

    # Returns the symbol representing the current connected role.
    #
    #   ActiveRecord::Base.connected_to(role: :writing) do
    #     ActiveRecord::Base.current_role #=> :writing
    #   end
    #
    #   ActiveRecord::Base.connected_to(role: :reading) do
    #     ActiveRecord::Base.current_role #=> :reading
    #   end
    def current_role
      connection_handlers.key(connection_handler)
    end

151
    def lookup_connection_handler(handler_key) # :nodoc:
152
      handler_key ||= ActiveRecord::Base.writing_role
153 154 155 156 157 158 159 160
      connection_handlers[handler_key] ||= ActiveRecord::ConnectionAdapters::ConnectionHandler.new
    end

    def with_handler(handler_key, &blk) # :nodoc:
      handler = lookup_connection_handler(handler_key)
      swap_connection_handler(handler, &blk)
    end

161 162 163 164 165 166 167 168 169
    # Clears the query cache for all connections associated with the current thread.
    def clear_query_caches_for_current_thread
      ActiveRecord::Base.connection_handlers.each_value do |handler|
        handler.connection_pool_list.each do |pool|
          pool.connection.clear_query_cache if pool.active_connection?
        end
      end
    end

170 171 172 173 174 175 176
    # Returns the connection currently associated with the class. This can
    # also be used to "borrow" the connection to do database work unrelated
    # to any of the specific Active Records.
    def connection
      retrieve_connection
    end

177
    attr_writer :connection_specification_name
A
Arthur Neves 已提交
178

J
Jon Moss 已提交
179
    # Return the specification name from the current class or its parent.
180
    def connection_specification_name
181
      if !defined?(@connection_specification_name) || @connection_specification_name.nil?
182
        return self == Base ? Base.name : superclass.connection_specification_name
A
Arthur Neves 已提交
183
      end
184
      @connection_specification_name
A
Arthur Neves 已提交
185 186
    end

187 188 189 190
    def primary_class? # :nodoc:
      self == Base || defined?(ApplicationRecord) && self == ApplicationRecord
    end

191 192 193
    # Returns the configuration of the associated connection as a hash:
    #
    #  ActiveRecord::Base.connection_config
A
AvnerCohen 已提交
194
    #  # => {pool: 5, timeout: 5000, database: "db/development.sqlite3", adapter: "sqlite3"}
195 196 197
    #
    # Please use only for reading.
    def connection_config
198
      connection_pool.db_config.configuration_hash
199
    end
J
John Crepezzi 已提交
200 201 202 203 204 205
    deprecate connection_config: "Use connection_db_config instead"

    # Returns the db_config object from the associated connection:
    #
    #  ActiveRecord::Base.connection_db_config
    #    #<ActiveRecord::DatabaseConfigurations::HashConfig:0x00007fd1acbded10 @env_name="development",
206
    #      @name="primary", @config={pool: 5, timeout: 5000, database: "db/development.sqlite3", adapter: "sqlite3"}>
J
John Crepezzi 已提交
207 208 209 210 211
    #
    # Use only for reading.
    def connection_db_config
      connection_pool.db_config
    end
212 213

    def connection_pool
214
      connection_handler.retrieve_connection_pool(connection_specification_name) || raise(ConnectionNotEstablished)
215 216 217
    end

    def retrieve_connection
218
      connection_handler.retrieve_connection(connection_specification_name)
219 220
    end

221
    # Returns +true+ if Active Record is connected.
222
    def connected?
223
      connection_handler.connected?(connection_specification_name)
224 225
    end

226 227
    def remove_connection(name = nil)
      name ||= @connection_specification_name if defined?(@connection_specification_name)
228
      # if removing a connection that has a pool, we reset the
229 230 231 232 233 234
      # connection_specification_name so it will use the parent
      # pool.
      if connection_handler.retrieve_connection_pool(name)
        self.connection_specification_name = nil
      end

235
      connection_handler.remove_connection_pool(name)
236 237
    end

J
Jon Leighton 已提交
238 239 240 241
    def clear_cache! # :nodoc:
      connection.schema_cache.clear!
    end

242
    delegate :clear_active_connections!, :clear_reloadable_connections!,
M
Matthew Draper 已提交
243
      :clear_all_connections!, :flush_idle_connections!, to: :connection_handler
244 245

    private
246 247 248 249
      def resolve_config_for_connection(config_or_env)
        raise "Anonymous class is not allowed." unless name

        config_or_env ||= DEFAULT_ENV.call.to_sym
250
        pool_name = primary_class? ? Base.name : name
251 252
        self.connection_specification_name = pool_name

253
        db_config = Base.configurations.resolve(config_or_env, pool_name)
254
        db_config.owner_name = pool_name
255 256 257
        db_config
      end

258 259
      def swap_connection_handler(handler, &blk) # :nodoc:
        old_handler, ActiveRecord::Base.connection_handler = ActiveRecord::Base.connection_handler, handler
260 261 262
        return_value = yield
        return_value.load if return_value.is_a? ActiveRecord::Relation
        return_value
263 264 265
      ensure
        ActiveRecord::Base.connection_handler = old_handler
      end
266 267
  end
end