X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/7fff6361c1ec35d0ff61d27fedab301671b37b3a..476e3f2b550eac56a38efd1938a6361c9ab49432:/lib/migrate.rb diff --git a/lib/migrate.rb b/lib/migrate.rb index d43982e8c..392060b60 100644 --- a/lib/migrate.rb +++ b/lib/migrate.rb @@ -92,12 +92,16 @@ module ActiveRecord end def alter_column_nwr_enum (table_name, column) - execute "alter table #{table_name} change column #{column} #{column} enum('node','way','relation');" + execute "alter table #{table_name} change column #{column} #{column} enum('Node','Way','Relation');" end def alter_primary_key(table_name, new_columns) execute("alter table #{table_name} drop primary key, add primary key (#{new_columns.join(',')})") end + + def interval_constant(interval) + "'#{interval}'" + end end class PostgreSQLAdapter @@ -141,7 +145,7 @@ module ActiveRecord def alter_column_nwr_enum (table_name, column) response = select_one("select count(*) as count from pg_type where typname = 'nwr_enum'") if response['count'] == "0" #yep, as a string - execute "create type nwr_enum as ENUM ('node', 'way', 'relation')" + execute "create type nwr_enum as ENUM ('Node', 'Way', 'Relation')" end execute "alter table #{table_name} drop #{column}" execute "alter table #{table_name} add #{column} nwr_enum" @@ -150,6 +154,10 @@ module ActiveRecord def alter_primary_key(table_name, new_columns) execute "alter table #{table_name} drop constraint #{table_name}_pkey; alter table #{table_name} add primary key (#{new_columns.join(',')})" end + + def interval_constant(interval) + "'#{interval}'::interval" + end end end end