search

rgeo / activerecord-spatialite-adapter

ActiveRecord connection adapter for SpatiaLite, based on sqlite3 and rgeo
11 stars 14 forks source link

database.yml and Mac OSX instructions #4

Closed vgeorge closed 12 years ago

vgeorge commented 12 years ago

Added database.yml and instructions for Mac OSX users.

dazuma commented 12 years ago

Thanks! I think we should still avoid checking in database.yml because everyone's might be different, but I added a readme to the test directory to let people know how to set up their system to run the tests. Your addition to the main readme regarding installation on Mac OS X was also a good idea. I'll put these in and get a (badly delayed) release out.

lxcid commented 11 years ago

Hi there,

I have trouble following the instruction though. I tries to use homebrew to install both sqlite3 and spatialite but i'm facing problem with rake db:migrate with errors like:

SQLite3::SQLException: no such table: geometry_columns: SELECT * FROM geometry_columns WHERE f_table_name='schema_migrations'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/sqlite3-1.3.7/lib/sqlite3/database.rb:91:in `initialize'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/sqlite3-1.3.7/lib/sqlite3/database.rb:91:in `new'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/sqlite3-1.3.7/lib/sqlite3/database.rb:91:in `prepare'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/sqlite3-1.3.7/lib/sqlite3/database.rb:134:in `execute'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/connection_adapters/sqlite_adapter.rb:278:in `block in execute'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activesupport-3.2.11/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/connection_adapters/sqlite_adapter.rb:278:in `execute'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-spatialite-adapter-0.4.1/lib/active_record/connection_adapters/spatialite_adapter/main_adapter.rb:259:in `spatial_column_info'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-spatialite-adapter-0.4.1/lib/active_record/connection_adapters/spatialite_adapter/main_adapter.rb:133:in `columns'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/connection_adapters/schema_cache.rb:12:in `block in initialize'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/connection_adapters/schema_cache.rb:16:in `yield'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/connection_adapters/schema_cache.rb:16:in `default'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/connection_adapters/schema_cache.rb:16:in `block in initialize'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/to_sql.rb:101:in `yield'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/to_sql.rb:101:in `default'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/to_sql.rb:101:in `column_for'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/to_sql.rb:364:in `visit_Arel_Attributes_Attribute'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/visitor.rb:19:in `visit'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/to_sql.rb:134:in `block in visit_Arel_Nodes_SelectCore'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/to_sql.rb:134:in `map'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/to_sql.rb:134:in `visit_Arel_Nodes_SelectCore'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/to_sql.rb:121:in `block in visit_Arel_Nodes_SelectStatement'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/to_sql.rb:121:in `map'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/to_sql.rb:121:in `visit_Arel_Nodes_SelectStatement'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/sqlite.rb:12:in `visit_Arel_Nodes_SelectStatement'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/visitor.rb:19:in `visit'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/visitor.rb:5:in `accept'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/arel-3.0.2/lib/arel/visitors/to_sql.rb:19:in `accept'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `to_sql'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/connection_adapters/abstract/database_statements.rb:38:in `select_values'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/migration.rb:587:in `get_all_versions'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/migration.rb:745:in `migrated'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/migration.rb:668:in `current_version'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/migration.rb:685:in `block in migrate'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/migration.rb:685:in `each'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/migration.rb:685:in `detect'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/migration.rb:685:in `migrate'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/migration.rb:570:in `up'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/migration.rb:551:in `migrate'
/Users/khinboon/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.2.11/lib/active_record/railties/databases.rake:179:in `block (2 levels) in <top (required)>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

Commands I executed.

gem install sqlite3 -- --with-sqlite3-dir="/usr/local/Cellar/sqlite/3.7.14"

Database.yml

development:
  adapter: spatialite
  libspatialite: /usr/local/Cellar/libspatialite/3.0.1/lib/libspatialite.dylib
  database: db/development.sqlite3
  pool: 5
  timeout: 5000