Viewing the contents of tables in schema.rb in rails

Question

I'm sorry if this is a stupid question, but in my schema.rb I have several tables like

  create_table "messages", :force => true do |t|
    t.integer  "user_id",            :null => false
    t.string   "message",            :null => false
    t.datetime "created_at",         :null => false
    t.string   "photo_file_name"
    t.string   "photo_content_type"
    t.integer  "photo_file_size"
    t.datetime "photo_updated_at"
  end

Is it possible to view the contents of each table i.e view each message and associated user id, message content, time created at, linked image, etc?

Thanks

you need to use your DB console for that – Pablo Fernandez Aug 13 '11 at 22:15 — Pablo Fernandez, Aug 13 '11 at 22:15

score 11 · Accepted Answer · answered Aug 13 '11 at 22:21

11

A database schema represents the structure of the database, not the content of it.

If you want to access the content in your database, you would query it to do so. You can do that via command line clients (running $ rails dbconsole will try to open one for the configured database) or graphical tools like Sequel Pro (for MySQL on Mac OS X).

You can also get this through your Rails application by running $ rails console and then using the methods available through ActiveRecord (e.g. Post.all or User.where(:name => 'Billy').limit(5)).

answered Aug 13 '11 at 22:21

coreyward

77,547
20
137
166

Yes, I have sequel pro but how exactly do I access the content of the database from it? Thanks – user852974 Aug 13 '11 at 22:24
1

Uh, that's how you use it. That's most of what it does. I'm confused. http://www.sequelpro.com/ – coreyward Aug 13 '11 at 22:30

score 0 · Answer 2 · answered Aug 21 '17 at 23:30

0

You can use gem "annotate". It is very helpful for me.

answered Aug 21 '17 at 23:30

Alla Johnson

3
2

score 0 · Answer 3 · answered Jul 11 '23 at 12:07

0

you can use modelname.all for eg: Country.all will give you all entries in your table

answered Jul 11 '23 at 12:07

Nidhi Tyagi

3
1

Anupam · Answer 4 · 2020-02-11T08:19:21.467

-1

For viewing the table structure on the rails console only need to run the table name eg If there is a table with name country. only run the 'Country '

2.4.4 :004 > Country => Country(id: integer, name: string, percentage: string, created_at: datetime, updated_at: datetime, is_sync: boolean) 2.4.4 :005 >

edited Feb 11 '20 at 08:19

answered Feb 10 '20 at 06:51

Anupam

21
3

Viewing the contents of tables in schema.rb in rails

4 Answers4