stgeneral

# 
# = Capistrano database.yml task
#
# Provides a couple of tasks for creating the database.yml 
# configuration file dynamically when deploy:setup is run.
#
# Category::    Capistrano
# Package::     Database
# Author::      Simone Carletti <[email protected]>
# Copyright::   2007-2010 The Authors

stgeneral

  * executing "cd -- /home/user/example.com/releases/20130124125126 && bundle exec rake RAILS_ENV=production RAILS_GROUPS=assets assets:precompile && cp -- /home/user/example.com/shared/assets/manifest.yml /home/user/example.com/releases/20130124125126/assets_manifest.yml"
    servers: ["example.com"]
    [example.com] executing command
*** [err :: example.com] rake aborted!
*** [err :: example.com] Mysql2::Error: Table 'database_production.shop_orders' doesn't exist: SHOW FULL FIELDS FROM `shop_orders`
*** [err :: example.com] /home/user/example.com/shared/bundle/ruby/1.9.1/gems/activerecord-3.2.11/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `query'
*** [err :: example.com] /home/user/example.com/shared/bundle/ruby/1.9.1/gems/activerecord-3.2.11/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `block in execute'
*** [err :: example.com] /home/user/example.com/shared/bundle/ruby/1.9.1/gems/activerecord-3.2.11/lib/active_record/connection_adapters/abstract_adapt

stgeneral

require 'geocoder'

#Example postal code '75003' has several locations and one of them is in Ukraine (not a EU member for now :)
query = '75003'

puts "\n=== Search with Google for '#{query}' ==="
# Specify countries of our interest to exclude irrelevant results
eu_countries = %w(France Estonia)
Geocoder.search(query).each do |point|
  puts "#{point.latitude},#{point.longitude} (#{point.address})" if eu_countries.include?(point.country)