Module: ActiveRecord::ConnectionAdapters::SchemaStatements

Defined in:
lib/activerecord-postgres-earthdistance/activerecord.rb

Instance Method Summary collapse

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, options = {}
  execute "CREATE INDEX %s_earthdistance_ix ON %s USING gist (ll_to_earth(%s, %s));" %
    [table_name, table_name, (options[:lat] || 'lat'), (options[: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