Method: RailsSync::Table#create_temp_table

Defined in:
lib/rails_sync/table.rb

#create_temp_table ⇒ Object 



89
90
91
92
93
94
95
96
97
98
99
100
101
 
# File 'lib/rails_sync/table.rb', line 89

def create_temp_table
  unless @dest_columns.include?(dest_primary_key)
    @dest_columns.unshift dest_primary_key
  end

  sql = "CREATE TABLE `#{@dest_table_name}` (\n"
  sql << dest_sql_table(only: @dest_columns)
  sql << ")"
  sql << "ENGINE=FEDERATED\n"
  sql << "CONNECTION='#{adapter.url}/#{@dest_table}';"

  connection.execute(sql)
end