如何在Rails中创建地理和双精度数据库列

Question

我想用这个postgresql查询创建一个类似的表。如何使用DOUBLE PRECISION和Geography列进行rails迁移？

CREATE TABLE poi_trace (
poi_id BIGINT REFERENCES pois(id),
trace_id BIGINT REFERENCES traces(id),
geog GEOGRAPHY(Point, 4326),
advance_on_trace DOUBLE PRECISION,
active BOOLEAN
);

Answer 1

您可以在迁移中运行自定义sql

class ExampleMigration < ActiveRecord::Migration
def up
execute <<-SQL
CREATE TABLE poi_trace (
poi_id BIGINT REFERENCES pois(id),
trace_id BIGINT REFERENCES traces(id),
geog GEOGRAPHY(Point, 4326),
advance_on_trace DOUBLE PRECISION,
active BOOLEAN
);
SQL
end

def down
drop_table :poi_trace
end
end

阅读有关此的更多信息