Class: Databender::Runner

Inherits:
Object
  • Object
show all
Extended by:
SQLHelper
Defined in:
lib/databender/runner.rb

Class Method Summary collapse

Methods included from SQLHelper

count_all_query, count_filtered_query, insert_into_select, merge_filters, resolve_column_filter, where_clause_by_reference

Class Method Details

.apply_column_filters(table, source, source_db, target_db) ⇒ Object 



24
25
26
27
28
29
30
31
 
# File 'lib/databender/runner.rb', line 24

def self.apply_column_filters(table, source, source_db, target_db)
  columns = source.columns_for(source_db, table.name)
  overlapping_filters = Databender::Config.column_filters.keys & columns
  if overlapping_filters.present?
    column_filter = Databender::Config.column_filters[overlapping_filters.first]
    resolve_column_filter(target_db, overlapping_filters.first, column_filter)
  end
end

.generate_script(params) ⇒ Object 



19
20
21
22
 
# File 'lib/databender/runner.rb', line 19

def self.generate_script(params)
  template = File.read("#{GEM_ROOT}/subset.sh.mustache")
  File.write('subset.sh', Mustache.render(template, params))
end

.process!(db_name) ⇒ Object 



33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
 
# File 'lib/databender/runner.rb', line 33

def self.process!(db_name)
  unless db_name
    puts 'Parameter db_name not specified. Terminating!'
    exit(1)
  end

  report = []

  Databender::Config.load!(db_name)
  target_db = Databender::Config.target_db
  source_db = Databender::Config.source.database

  source = Databender::Connection.new(Databender::Config.source.to_h)

  tables = source.tables_for(source_db)

  ## process tables with filters first
  tables.sort_by! {|table| [Databender::Config.table_filters.keys.include?(table.to_sym) ? 0 : 1, table]}

  all_tables = tables.collect {|table| Databender::Table.new(table)}

  ordered_tables = Databender::TableOrder.order_by_foreign_key_dependency(source, source_db, all_tables)

  entries = ordered_tables.collect do |table|
    column_filters = apply_column_filters table, source, source_db, target_db
    sql = count_all_query source_db, table.name
    all_count = source.execute_count(sql).first.first
    sql, count_query, filter = if Databender::Config.table_filters.keys.include?(table.name)
                         conditions = merge_filters(Databender::Config.table_filters[table.name], column_filters)
                         [insert_into_select(source_db, table.name, conditions),
                          count_filtered_query(source_db, table.name, conditions), conditions]
                       else
                         if column_filters.present?
                           [insert_into_select(source_db, table.name, column_filters), count_filtered_query(source_db, table.name, column_filters), column_filters]
                         else
                           parents = Databender::TableOrder.parent_tables_for(table.name)
                           condition = parents.present? ? where_clause_by_reference(target_db, parents) : nil
                           [insert_into_select(source_db, table.name, condition), count_filtered_query(source_db, table.name, condition), nil]
                         end
                               end
    subset_count = source.execute_count(count_query).count
    report << [table.name, all_count, subset_count, filter && filter]
    {sql: sql, table: table.name}
  end

  headings = ['Table Name', 'Total Rows', 'Fetched Rows', 'Filter(s)']
  tty = Terminal::Table.new headings: headings, rows: report
  puts tty


  self.generate_script source: Databender::Config.source, target_db: target_db, entries: entries, database: db_name

end