active record allメソッドの出力について

Question

active record を使いsqlite3への書き込み後allメソッドで出力すると、データがうまく出てくれません。
よろしければご教授願います。

create table books(

id integer primary key,

title text,

url text,

create_at,

updated_at

);

require 'active_record'

ActiveRecord::Base.establish_connection(
'adapter' => 'sqlite3',
'database' => './datebase.db'
)

class Book < ActiveRecord::Base
end

db = Book.new(title: '焼肉', url: 'https:')
db.save

puts Book.all

結果
#Book:0x007fbdd12c0ad8

Answer 1

puts でなく p を使ってみてください。
あるいは、 puts Bool.all.inspect のように inspect を使ってみてください。

irb での操作例を示します。 (DB は rails アプリで作成済のものを使っています)

irb(main):001:0> require 'active_record'
=> true

irb(main):002:0> ActiveRecord::Base.establish_connection( 
irb(main):003:1*  'adapter' => 'sqlite3', 
irb(main):004:1*  'database' => 'db/production.sqlite3'
irb(main):005:1>  )

irb(main):006:0> class Idea < ActiveRecord::Base
irb(main):007:1> end
=> nil

irb(main):008:0> puts Idea.all
 #<Idea:0x007feb758d8250>
 #<Idea:0x007feb758e0d38>
 #<Idea:0x007feb758e0bf8>
=> nil

irb(main):009:0> p Idea.all
 #<ActiveRecord::Relation [#<Idea id: 102, name: "IDEA_002", description: "MyText 002", picture: "fish.jpg", comments_count: 1, created_at: "2013-08-19 21:05:04", updated_at: "2013-08-19 21:05:04", lock_version: 0>, #<Idea id: 980190962, name: "IDEA_001", description: "MyText 001", picture: nil, comments_count: 2, created_at: "2013-08-19 21:05:04", updated_at: "2013-08-19 21:05:04", lock_version: 0>, #<Idea id: 980190963, name: nil, description: nil, picture: nil, comments_count: 0, created_at: "2017-01-16 14:48:23", updated_at: "2017-01-16 14:48:23", lock_version: 0>]>
=> #<ActiveRecord::Relation [#<Idea id: 102, name: "IDEA_002", description: "MyText 002", picture: "fish.jpg", comments_count: 1, created_at: "2013-08-19 21:05:04", updated_at: "2013-08-19 21:05:04", lock_version: 0>, #<Idea id: 980190962, name: "IDEA_001", description: "MyText 001", picture: nil, comments_count: 2, created_at: "2013-08-19 21:05:04", updated_at: "2013-08-19 21:05:04", lock_version: 0>, #<Idea id: 980190963, name: nil, description: nil, picture: nil, comments_count: 0, created_at: "2017-01-16 14:48:23", updated_at: "2017-01-16 14:48:23", lock_version: 0>]>

irb(main):010:0> p Idea.all[0]
 #<Idea id: 102, name: "IDEA_002", description: "MyText 002", picture: "fish.jpg", comments_count: 1, created_at: "2013-08-19 21:05:04", updated_at: "2013-08-19 21:05:04", lock_version: 0>

irb(main):011:0> puts Idea.all.inspect
 #<ActiveRecord::Relation [#<Idea id: 102, name: "IDEA_002", description: "MyText 002", picture: "fish.jpg", comments_count: 1, created_at: "2013-08-19 21:05:04", updated_at: "2013-08-19 21:05:04", lock_version: 0>, #<Idea id: 980190962, name: "IDEA_001", description: "MyText 001", picture: nil, comments_count: 2, created_at: "2013-08-19 21:05:04", updated_at: "2013-08-19 21:05:04", lock_version: 0>, #<Idea id: 980190963, name: nil, description: nil, picture: nil, comments_count: 0, created_at: "2017-01-16 14:48:23", updated_at: "2017-01-16 14:48:23", lock_version: 0>]>
=> nil

Comments

[Buncho0]

無事解決しました。的確な回答ありがとうございました＾＾