Module: SimpleMaster::Master::Queryable

Included in:
SimpleMaster::Master
Defined in:
lib/simple_master/master/queryable.rb

Overview

Query in database

Instance Method Summary collapse

Instance Method Details

#connection ⇒ Object 



70
71
72
 
# File 'lib/simple_master/master/queryable.rb', line 70

def connection
  ::ActiveRecord::Base.connection
end

#delete_all_query ⇒ Object 



60
61
62
 
# File 'lib/simple_master/master/queryable.rb', line 60

def delete_all_query
  "DELETE FROM #{table_name};"
end

#insert_queries(records, on_duplicate_key_update = false, batch_size: 10000) ⇒ Object 



17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
 
# File 'lib/simple_master/master/queryable.rb', line 17

def insert_queries(records, on_duplicate_key_update = false, batch_size: 10000)
  return [] if records.empty?

  column_names = all_columns.map(&:name)
  db_column_names = all_columns.map(&:db_column_name)
  sql_columns = db_column_names.map { "`#{_1}`" }.join(", ").then { "(#{_1})" }

  sql_column_methods = column_names.map { |column_name| :"#{column_name}_value_for_sql" }
  current_time = "'#{Time.now.utc.strftime('%Y-%m-%d %H:%M:%S')}'"

  if on_duplicate_key_update
    sql_update = db_column_names.filter_map { |column_name| "`#{column_name}` = new.#{column_name}" if column_name != :created_at }.join(", ")
    on_duplicate_key_update_sql = " AS new ON DUPLICATE KEY UPDATE #{sql_update}"
  else
    on_duplicate_key_update_sql = ""
  end

  records.each_slice(batch_size).map { |sliced_records|
    values_sql =
      sliced_records.map { |record|
        sql_column_methods
          .zip(column_names)
          .map { |method_name, column_name|
            if [:updated_at, :created_at].include?(column_name)
              current_time
            else
              record.send(method_name)
            end
          }.join(", ").then { "(#{_1})" }
      }.join(", \n")

    "INSERT INTO `#{table_name}` \n#{sql_columns} VALUES \n#{values_sql}#{on_duplicate_key_update_sql};\n"
  }
end

#query_delete_all ⇒ Object 



56
57
58
 
# File 'lib/simple_master/master/queryable.rb', line 56

def query_delete_all
  connection.execute(delete_all_query)
end

#query_select_all ⇒ Object 



7
8
9
 
# File 'lib/simple_master/master/queryable.rb', line 7

def query_select_all
  connection.select_all("SELECT * from #{table_name}")
end

#query_upsert_records(records, batch_size: 10000) ⇒ Object 



11
12
13
14
15
 
# File 'lib/simple_master/master/queryable.rb', line 11

def query_upsert_records(records, batch_size: 10000)
  insert_queries(records, true, batch_size: batch_size).each do |sql|
    connection.execute(sql)
  end
end

#sqlite_insert_query(records) ⇒ Object 



52
53
54
 
# File 'lib/simple_master/master/queryable.rb', line 52

def sqlite_insert_query(records)
  insert_queries(records, false).join("\n").gsub("\\\\", "\\")
end

#table_available? ⇒ Boolean

Returns:

  • (Boolean) 


64
65
66
67
68
 
# File 'lib/simple_master/master/queryable.rb', line 64

def table_available?
  connection.table_exists? table_name
rescue
  false
end