I was wondering if you could list/examine what databases/objects are available to you in the Rails console. I know you can see them using other tools, I am just curious. Thanks.
-
2that's what script/dbconsole is for thoughhgmnz– hgmnz2010-01-20 00:25:48 +00:00Commented Jan 20, 2010 at 0:25
-
Yes, that drops you into mysql (or whatever). For some stranger reason I want to list columns/tables etc from regular console. I am thinking that it might require custom made ruby methods to do such a thing.rtfminc– rtfminc2010-01-20 02:19:41 +00:00Commented Jan 20, 2010 at 2:19
Add a comment
|
6 Answers
You are probably seeking:
ActiveRecord::Base.connection.tables
and
ActiveRecord::Base.connection.columns('projects').map(&:name)
You should probably wrap them in shorter syntax inside your .irbrc.
6 Comments
rtfminc
Thanks, the first one works like I want. But the second one doesn't - hunted for something similar but no luck.
cwninja
ActiveRecord::Base.connection.columns("foos") should also work, but it returns column objects, .map{|c| [c.name, c.type] } on the end fixes that.
Kelvin
table_structure seems to be specific to the sqlite adapter.
Stephen Provis
For Rails4 use Model.column_names to list table columns
themattkellyshow
Also in Rails 4, you can just use ModelName to get a list of the columns and their data types.
|
I hope my late answer can be of some help.
This will go to rails database console.
rails db
pretty print your query output
.headers on
.mode columns
(turn headers on and show database data in column mode )
Show the tables
.table
'.help' to see help.
Or use SQL statements like 'Select * from cars'
2 Comments
Tom Hundt
'rails dbconsole' puts you in the command line interpreter (CLI) of whatever database engine you're using... the above are SQLite commands... Postgres, for example, would use '\dt' to list tables...
Mark
is there a way to ensure that every time you don't have to apply .headers on and .more columns when running rails db
To get a list of all model classes, you can use ActiveRecord::Base.subclasses e.g.
ActiveRecord::Base.subclasses.map { |cl| cl.name }
ActiveRecord::Base.subclasses.find { |cl| cl.name == "Foo" }
You can use rails dbconsole to view the database that your rails application is using. It's alternative answer rails db. Both commands will direct you the command line interface and will allow you to use that database query syntax.
From the dbconsole command line:
\lLists available databases\dLists tables available in the current database\?(help) lists the many options for examining other sorts of objects
Comments
Run this:
Rails.application.eager_load!
Then
ActiveRecord::Base.descendants
To return a list of models/tables
Comments
Its a start, it can list:
models = Dir.new("#{RAILS_ROOT}/app/models").entries
Looking some more...
1 Comment
abo-elleef
by doing this you just list models files what if tables are exists in db and do not have model fild in the models dir !!