connect mysql:show tables
in [Ruby]
|
From: Pen Ttt on 25 Apr 2010 22:33 require "mysql" dbh = Mysql.real_connect("localhost", "root", "******", "valuation") res = dbh.query("show tables") puts res res.free the output is: #<Mysql::Result:0x997c014> in mysql console: mysql> show tables; +---------------------+ | Tables_in_valuation | +---------------------+ | balance_sheet | | test | +---------------------+ 2 rows in set (0.00 sec) how can i get it with ruby? -- Posted via http://www.ruby-forum.com/.
From: Francesco Vollero on 26 Apr 2010 05:13 Il 26/04/10 04.33, Pen Ttt ha scritto: > require "mysql" > dbh = Mysql.real_connect("localhost", "root", "******", "valuation") > res = dbh.query("show tables") > puts res > res.free > > the output is: > #<Mysql::Result:0x997c014> > > in mysql console: > > mysql> show tables; > +---------------------+ > | Tables_in_valuation | > +---------------------+ > | balance_sheet | > | test | > +---------------------+ > 2 rows in set (0.00 sec) > > how can i get it with ruby? > Is more simple than you think... i just rewrite your code with a little "add": require "mysql" dbh = Mysql.real_connect("localhost", "root", "******", "valuation") res = dbh.query("show tables") - puts res + puts "Tables_in_valutation" + res.each {|x| p x.to_s} res.free Or... require "mysql" dbh = Mysql.real_connect("localhost", "root", "******", "valuation") res = dbh.query("show tables") - puts res + rows = [] + puts "Tables_in_valutation" + res.each {|x| p x.to_s; rows<<x} res.free
From: ghorner on 26 Apr 2010 16:52 > require "mysql" > dbh = Mysql.real_connect("localhost", "root", "******", "valuation") > res = dbh.query("show tables") > - puts res > + rows = [] > + puts "Tables_in_valutation" > + res.each {|x| p x.to_s; rows<<x} > res.free You can take this one step further to actually print a table with hirb, http://github.com/cldwalker/hirb: require "mysql" dbh = Mysql.real_connect("localhost", "root", "******", "valuation") res = dbh.query("show tables") rows = [] res.each {|e| rows << e } puts Hirb::Helpers::AutoTable.render(rows, :headers=>["Tables in valuation"]) With my own database this produces: +---------------------+ | Tables in valuation | +---------------------+ | nodes | | schema_migrations | | taggings | | tags | | trees | | urls | +---------------------+ 6 rows in set If you're interested in having irb act as a database shell, try hirb with one of the database gems listed in http://tagaholic.me/2010/03/11/hirb-and-tables-for-all.html Gabriel
|
Pages: 1 Prev: [ANN] jruby_gc_stats 0.1: a set of GC monitoring methods similar toREE Next: [ANN] Ember 0.2.0 |