rake.rb

desc "Move paths to more specific tables."
task :path_moving => :environment do
  filetemp = "tmp/temp.sql"
  File.open(filetemp, 'w') do |file|
    Path.paginated_each do |path|
      if path.user_agent =~ /[B|b]ot|[B|b]aidu|[S|s]pider/
        file.puts "insert into `spiders_paths` (#{path.attribute_names.map{|attr| "`#{attr}`"}.join(', ')})
                           values(#{path.attribute_names.map{|attr| "#{path.send(attr).blank? ? 'NULL' : "'#{path.send(attr).to_s.gsub(/[']/, '\\\\\'')}'"}"}.join(', ')});\n"
      else
        file.puts << "insert into `customers_paths` (#{path.attribute_names.map{|attr| "`#{attr}`"}.join(', ')})
                     values(#{path.attribute_names.map{|attr| "#{path.send(attr).blank? ? 'NULL' : "'#{path.send(attr).to_s.gsub(/[']/, '\\\\\'')}'"}"}.join(', ')});\n"
      end
    end
  end
  system("mysql -u root usedcisco_development < #{filetemp}")
  File.delete(filetemp)
end