X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/f70ec189894ef6bc37355cad7990420065a0b2cb..e377bc72e31add6d589270c51318dad9efde5b46:/db/migrate/006_tile_nodes.rb?ds=inline diff --git a/db/migrate/006_tile_nodes.rb b/db/migrate/006_tile_nodes.rb index d13ada170..a7f9b1af0 100644 --- a/db/migrate/006_tile_nodes.rb +++ b/db/migrate/006_tile_nodes.rb @@ -1,5 +1,3 @@ -require "migrate" - class TileNodes < ActiveRecord::Migration[4.2] class Node < ApplicationRecord self.table_name = "current_nodes" @@ -10,25 +8,14 @@ class TileNodes < ActiveRecord::Migration[4.2] end def self.upgrade_table(from_table, to_table, model) - if ENV["USE_DB_FUNCTIONS"] - execute <<-SQL.squish - INSERT INTO #{to_table} (id, latitude, longitude, user_id, visible, tags, timestamp, tile) - SELECT id, ROUND(latitude * 10000000), ROUND(longitude * 10000000), - user_id, visible, tags, timestamp, - tile_for_point(CAST(ROUND(latitude * 10000000) AS INTEGER), - CAST(ROUND(longitude * 10000000) AS INTEGER)) - FROM #{from_table} - SQL - else - execute <<-SQL.squish - INSERT INTO #{to_table} (id, latitude, longitude, user_id, visible, tags, timestamp, tile) - SELECT id, ROUND(latitude * 10000000), ROUND(longitude * 10000000), - user_id, visible, tags, timestamp, 0 - FROM #{from_table} - SQL - - model.all.each(&:save!) - end + execute <<-SQL.squish + INSERT INTO #{to_table} (id, latitude, longitude, user_id, visible, tags, timestamp, tile) + SELECT id, ROUND(latitude * 10000000), ROUND(longitude * 10000000), + user_id, visible, tags, timestamp, 0 + FROM #{from_table} + SQL + + model.all.each(&:save!) end def self.downgrade_table(from_table, to_table)