2 desc 'Adds a version number to the noes table'
4 require File.dirname(__FILE__) + '/../../config/environment'
8 node_count = OldNode.count
11 while lower_bound < node_count
12 upper_bound = lower_bound + increment
15 OldNode.find(:all, :conditions => ['id >= ? AND id < ?',lower_bound, upper_bound], :order => 'timestamp').each do |node|
16 hash[node.id] = [] if hash[node.id].nil?
20 hash.each_value do |node_array|
22 node_array.each do |node|
23 temp_old_node = TempOldNode.new
24 temp_old_node.id = node.id
25 temp_old_node.latitude = node.latitude
26 temp_old_node.longitude = node.longitude
27 temp_old_node.user_id = node.user_id
28 temp_old_node.visible = node.visible
29 temp_old_node.timestamp = node.timestamp
30 temp_old_node.tile = node.tile
31 temp_old_node.version = n
32 temp_old_node.save! || raise
36 lower_bound += increment