Re: Beginners problem with database and datamapper

Hello all....again :)

When I try to do this with activerecord I get some kind of sqlite3
problem that I cant resolve. My code and error message below. Maybe any
one of you can see what Im doing wrong? This work fine with datamapper
(and sqlite3).

This is my code:

require 'rubygems'
require 'mechanize'
require 'active_record'
#require 'sqlite3'
ActiveRecord::Base.establish_connection(
    :adapter  => "sqlite3",
    :host    => "localhost",
    :dbfile   => "\Ruby\Stats\StatsDB.sqlite"
  )

class Site < ActiveRecord::Base
end

class Estadistica < ActiveRecord::Base
end

time=Time.now.strftime("%Y-%m-%d %H:%M")

Site.all.each do |site|

    Estadistica.create(
    :date =>  time,
    :site_id =>  site.id
    )
end

Error message:

C:/Ruby200/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:45:in
`r
equire': Please install the sqlite3 adapter: `gem install
activerecord-sqlite3-a
dapter` (cannot load such file -- sqlite3/sqlite3_native) (LoadError)
        from
C:/Ruby200/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_requir
e.rb:45:in `require'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/activesupport-3.2.13/lib/active
_support/dependencies.rb:251:in `block in require'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/activesupport-3.2.13/lib/active
_support/dependencies.rb:236:in `load_dependency'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/activesupport-3.2.13/lib/active
_support/dependencies.rb:251:in `require'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/sqlite3-1.3.7-x86-mingw32/lib/s
qlite3.rb:6:in `rescue in <top (required)>'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/sqlite3-1.3.7-x86-mingw32/lib/s
qlite3.rb:2:in `<top (required)>'
        from
C:/Ruby200/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_requir
e.rb:45:in `require'
        from
C:/Ruby200/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_requir
e.rb:45:in `require'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/activesupport-3.2.13/lib/active
_support/dependencies.rb:251:in `block in require'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/activesupport-3.2.13/lib/active
_support/dependencies.rb:236:in `load_dependency'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/activesupport-3.2.13/lib/active
_support/dependencies.rb:251:in `require'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/activerecord-3.2.13/lib/active_
record/connection_adapters/sqlite3_adapter.rb:4:in `<top (required)>'
        from
C:/Ruby200/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_requir
e.rb:45:in `require'
        from
C:/Ruby200/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_requir
e.rb:45:in `require'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/activesupport-3.2.13/lib/active
_support/dependencies.rb:251:in `block in require'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/activesupport-3.2.13/lib/active
_support/dependencies.rb:236:in `load_dependency'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/activesupport-3.2.13/lib/active
_support/dependencies.rb:251:in `require'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/activerecord-3.2.13/lib/active_
record/connection_adapters/abstract/connection_specification.rb:50:in
`resolve_h
ash_connection'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/activerecord-3.2.13/lib/active_
record/connection_adapters/abstract/connection_specification.rb:29:in
`spec'
        from
C:/Ruby200/lib/ruby/gems/2.0.0/gems/activerecord-3.2.13/lib/active_
record/connection_adapters/abstract/connection_specification.rb:130:in
`establis
h_connection'
        from Stats_testDB3.rb:15:in `<main>'

-- 
Posted via http://www.ruby-forum.com/.