X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/e6667b7ff5117c101a891c899f1c624f707fa22e..8d76be71bbb8a799cbf0627dee170f26ade5a11f:/db/migrate/006_tile_nodes.rb diff --git a/db/migrate/006_tile_nodes.rb b/db/migrate/006_tile_nodes.rb index ca898cb37..7fdb34e57 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" @@ -11,7 +9,7 @@ class TileNodes < ActiveRecord::Migration[4.2] 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, @@ -20,7 +18,7 @@ class TileNodes < ActiveRecord::Migration[4.2] 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 @@ -32,7 +30,7 @@ class TileNodes < ActiveRecord::Migration[4.2] 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