Module: ActiveRecordShards::ConnectionSwitcher

Included in:
ActiveRecord::Base
Defined in:
lib/active_record_shards/connection_switcher.rb

Defined Under Namespace

Classes: MasterSlaveProxy

Class Method Summary collapse

Instance Method Summary collapse

Class Method Details

.extended(klass) ⇒ Object



3
4
5
6
# File 'lib/active_record_shards/connection_switcher.rb', line 3

def self.extended(klass)
  klass.singleton_class.alias_method_chain :columns, :default_shard
  klass.singleton_class.alias_method_chain :table_exists?, :default_shard
end

Instance Method Details

#connection_pool_nameObject

Name of the connection pool. Used by ConnectionHandler to retrieve the current connection pool.



106
107
108
109
110
111
112
113
114
# File 'lib/active_record_shards/connection_switcher.rb', line 106

def connection_pool_name # :nodoc:
  name = @connection_pool_name_override || current_shard_selection.shard_name(self)

  if configurations[name].nil? && on_slave?
    current_shard_selection.shard_name(self, false)
  else
    name
  end
end

#current_shard_idObject



133
134
135
# File 'lib/active_record_shards/connection_switcher.rb', line 133

def current_shard_id
  current_shard_selection.shard
end

#current_shard_selectionObject



129
130
131
# File 'lib/active_record_shards/connection_switcher.rb', line 129

def current_shard_selection
  Thread.current[:shard_selection] ||= ShardSelection.new
end

#default_shard=(new_default_shard) ⇒ Object



8
9
10
11
# File 'lib/active_record_shards/connection_switcher.rb', line 8

def default_shard=(new_default_shard)
  ActiveRecordShards::ShardSelection.default_shard = new_default_shard
  switch_connection(:shard => new_default_shard)
end

#establish_connection_override(connection_name) ⇒ Object



116
117
118
119
# File 'lib/active_record_shards/connection_switcher.rb', line 116

def establish_connection_override(connection_name)
  @connection_pool_name_override = connection_name
  establish_connection(connection_name)
end

#on_all_shards(&block) ⇒ Object



26
27
28
29
30
31
32
33
34
35
36
37
38
# File 'lib/active_record_shards/connection_switcher.rb', line 26

def on_all_shards(&block)
  old_options = current_shard_selection.options
  if supports_sharding?
    shard_names.map do |shard|
      switch_connection(:shard => shard)
      yield(shard)
    end
  else
    [yield]
  end
ensure
  switch_connection(old_options)
end

#on_cx_switch_block(which, options = {}, &block) ⇒ Object



86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
# File 'lib/active_record_shards/connection_switcher.rb', line 86

def on_cx_switch_block(which, options = {}, &block)
  old_options = current_shard_selection.options
  switch_to_slave = (which == :slave && (@disallow_slave.nil? || @disallow_slave == 0))
  switch_connection(:slave => switch_to_slave)

  @disallow_slave = (@disallow_slave || 0) + 1 if which == :master

  # we avoid_readonly_scope to prevent some stack overflow problems, like when
  # .columns calls .with_scope which calls .columns and onward, endlessly.
  if self == ActiveRecord::Base || !switch_to_slave || options[:construct_ro_scope] == false
    yield
  else
    with_scope({:find => {:readonly => true}}, &block)
  end
ensure
  @disallow_slave -= 1 if which == :master
  switch_connection(old_options)
end

#on_first_shard(&block) ⇒ Object



21
22
23
24
# File 'lib/active_record_shards/connection_switcher.rb', line 21

def on_first_shard(&block)
  shard_name = shard_names.first
  on_shard(shard_name) { yield }
end

#on_master(&block) ⇒ Object



77
78
79
# File 'lib/active_record_shards/connection_switcher.rb', line 77

def on_master(&block)
  on_master_or_slave(:master, &block)
end

#on_master_if(condition, &block) ⇒ Object



48
49
50
# File 'lib/active_record_shards/connection_switcher.rb', line 48

def on_master_if(condition, &block)
  condition ? on_master(&block) : yield
end

#on_master_or_slave(which, &block) ⇒ Object



56
57
58
59
60
61
62
# File 'lib/active_record_shards/connection_switcher.rb', line 56

def on_master_or_slave(which, &block)
   if block_given?
     on_cx_switch_block(which, &block)
   else
     MasterSlaveProxy.new(self, which)
   end
end

#on_master_unless(condition, &block) ⇒ Object



52
53
54
# File 'lib/active_record_shards/connection_switcher.rb', line 52

def on_master_unless(condition, &block)
  on_master_if(!condition, &block)
end

#on_shard(shard, &block) ⇒ Object



13
14
15
16
17
18
19
# File 'lib/active_record_shards/connection_switcher.rb', line 13

def on_shard(shard, &block)
  old_options = current_shard_selection.options
  switch_connection(:shard => shard) if supports_sharding?
  yield
ensure
  switch_connection(old_options)
end

#on_slave(&block) ⇒ Object Also known as: with_slave

Executes queries using the slave database. Fails over to master if no slave is found. if you want to execute a block of code on the slave you can go:

Account.on_slave do
  Account.first
end

the first account will be found on the slave DB

For one-liners you can simply do

Account.on_slave.first


73
74
75
# File 'lib/active_record_shards/connection_switcher.rb', line 73

def on_slave(&block)
  on_master_or_slave(:slave, &block)
end

#on_slave?Boolean

Returns:

  • (Boolean)


125
126
127
# File 'lib/active_record_shards/connection_switcher.rb', line 125

def on_slave?
  current_shard_selection.on_slave?
end

#on_slave_if(condition, &block) ⇒ Object Also known as: with_slave_if



40
41
42
# File 'lib/active_record_shards/connection_switcher.rb', line 40

def on_slave_if(condition, &block)
  condition ? on_slave(&block) : yield
end

#on_slave_unless(condition, &block) ⇒ Object Also known as: with_slave_unless



44
45
46
# File 'lib/active_record_shards/connection_switcher.rb', line 44

def on_slave_unless(condition, &block)
  on_slave_if(!condition, &block)
end

#shard_namesObject



137
138
139
140
141
142
# File 'lib/active_record_shards/connection_switcher.rb', line 137

def shard_names
  unless config = configurations[shard_env]
    raise "Did not find #{shard_env} in configurations, did you forget to add it to your database.yml ? (configurations: #{configurations.inspect})"
  end
  config['shard_names'] || []
end

#supports_sharding?Boolean

Returns:

  • (Boolean)


121
122
123
# File 'lib/active_record_shards/connection_switcher.rb', line 121

def supports_sharding?
  shard_names.any?
end