X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/8dae890a7645fba17a44d84f78be03d993e22ccb..5c3a3770854c8a0699a462a12dde16614798a9ef:/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 1f27ec79e..d13ada170 100644 --- a/db/migrate/006_tile_nodes.rb +++ b/db/migrate/006_tile_nodes.rb @@ -1,9 +1,17 @@ require "migrate" -class TileNodes < ActiveRecord::Migration +class TileNodes < ActiveRecord::Migration[4.2] + class Node < ApplicationRecord + self.table_name = "current_nodes" + end + + class OldNode < ApplicationRecord + self.table_name = "nodes" + end + def self.upgrade_table(from_table, to_table, model) if ENV["USE_DB_FUNCTIONS"] - execute <<-SQL + 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, @@ -12,7 +20,7 @@ class TileNodes < ActiveRecord::Migration FROM #{from_table} SQL else - execute <<-SQL + 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 @@ -24,7 +32,7 @@ class TileNodes < ActiveRecord::Migration end def self.downgrade_table(from_table, to_table) - execute <<-SQL + execute <<-SQL.squish INSERT INTO #{to_table} (id, latitude, longitude, user_id, visible, tags, timestamp) SELECT id, latitude / 10000000, longitude / 10000000, user_id, visible, tags, timestamp