Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- irb(main):001:0> require 'do_mysql.rb'
- => true
- irb(main):002:0> c = DataObject::Mysql::Connection.new("socket=/tmp/mysql.sock user=root")
- => #<DataObject::Mysql::Connection:0x5c3b4 @user="root", @socket="/tmp/mysql.sock", @connection_string="socket=/tmp/mysql.sock user=root">
- irb(main):003:0> c.open
- => true
- irb(main):004:0> cmd = c.create_command("select * from conduit_development.accounts")
- => #<DataObject::Mysql::Command:0x53020 @text="select * from conduit_development.accounts", @connection=#<DataObject::Mysql::Connection:0x5c3b4 @user="root", @socket="/tmp/mysql.sock", @state=0, @db=#<Mysql_c::MYSQL:0x58624>, @connection_string="socket=/tmp/mysql.sock user=root">>
- irb(main):005:0> r = cmd.execute_reader
- => #<DataObject::Mysql::Reader:0x502d0 @has_rows=true, @fields=["id", "name", "owner_id"], @reader=#<Mysql_c::MYSQL_RES:0x502f8>, @row=["1", "Testing Account", "1"], @state=0, @rows=2, @field_count=3>
- irb(main):006:0> 0.upto(r.rows - 1) { |row|
- irb(main):007:1* 0.upto(r.field_count - 1) { |field|
- irb(main):008:2* puts "#{r.name(field)}: #{r.item(field)}"
- irb(main):009:2> }
- irb(main):010:1> r.next
- irb(main):011:1> }
- id: 1
- name: Testing Account
- owner_id: 1
- id: 2
- name: Test Account
- owner_id: 3
- => 0
Add Comment
Please, Sign In to add comment