Module: ActiveRecord::ConnectionAdapters::SchemaStatements
- Defined in:
- lib/activerecord-postgres-earthdistance/activerecord.rb
Instance Method Summary collapse
- #add_earthdistance_index(table_name, options = {}) ⇒ Object
- #remove_earthdistance_index(table_name) ⇒ Object
Instance Method Details
#add_earthdistance_index(table_name, options = {}) ⇒ Object
7 8 9 10 |
# File 'lib/activerecord-postgres-earthdistance/activerecord.rb', line 7 def add_earthdistance_index table_name, = {} execute "CREATE INDEX %s_earthdistance_ix ON %s USING gist (ll_to_earth(%s, %s));" % [table_name, table_name, ([:lat] || 'lat'), ([:lng] || 'lng')] end |
#remove_earthdistance_index(table_name) ⇒ Object
12 13 14 |
# File 'lib/activerecord-postgres-earthdistance/activerecord.rb', line 12 def remove_earthdistance_index table_name execute "DROP INDEX %s_earthdistance_ix;" % [table_name] end |