Module: DbSync

Defined in:
lib/db_sync.rb,
lib/db_sync/railtie.rb,
lib/db_sync/version.rb

Defined Under Namespace

Classes: Configuration, Railtie

Constant Summary collapse

VERSION =
"0.0.1"

Class Attribute Summary collapse

Class Method Summary collapse

Class Attribute Details

.configurationObject

Returns the value of attribute configuration.



14
15
16
# File 'lib/db_sync.rb', line 14

def configuration
  @configuration
end

Class Method Details

.configure {|configuration| ... } ⇒ Object

Yields:



17
18
19
20
# File 'lib/db_sync.rb', line 17

def self.configure
  self.configuration ||= Configuration.new
  yield(configuration) if block_given?
end

.dump_dataObject



22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
# File 'lib/db_sync.rb', line 22

def self.dump_data
  DbSync.configuration.sync_tables.each do |table_name|    
    location = FileUtils.mkdir_p "#{Rails.root}/db/data"    
    i = "000"    
    sql  = "SELECT * FROM %s"    
    File.open("#{location.first}/#{table_name}.yml", 'w') do |file|      
      data = ActiveRecord::Base.connection.select_all(sql % table_name.upcase)      
      file.write data.inject({}) { |hash, record|  
        hash["#{table_name}_#{i.succ!}"] = record        
        hash      
      }.to_yaml      
      puts "wrote #{file.path} /"    
    end  
  end
end

.load_dataObject



38
39
40
41
42
43
44
45
46
# File 'lib/db_sync.rb', line 38

def self.load_data
  require 'active_record/fixtures'  
  base_dir     = "#{Rails.root}/db/data"  
  fixtures_dir = File.join [base_dir, ENV['FIXTURES_DIR']].compact  
  fixture_files = (ENV['FIXTURES'] ? ENV['FIXTURES'].split(/,/) : Dir["#{fixtures_dir}/**/*.{yml,csv}"].map {|f| f[(fixtures_dir.size + 1)..-5] })
  fixture_files.each do |fixture_file|    
    ActiveRecord::Fixtures.create_fixtures(fixtures_dir, fixture_file)  
  end
end