Guest User

Untitled

a guest
Apr 13th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. irb(main):001:0> require 'do_mysql.rb'
  2. => true
  3. irb(main):002:0> c = DataObject::Mysql::Connection.new("socket=/tmp/mysql.sock user=root")
  4. => #<DataObject::Mysql::Connection:0x5c3b4 @user="root", @socket="/tmp/mysql.sock", @connection_string="socket=/tmp/mysql.sock user=root">
  5. irb(main):003:0> c.open
  6. => true
  7. irb(main):004:0> cmd = c.create_command("select * from conduit_development.accounts")
  8. => #<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">>
  9. irb(main):005:0> r = cmd.execute_reader
  10. => #<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>
  11. irb(main):006:0> 0.upto(r.rows - 1) { |row|
  12. irb(main):007:1* 0.upto(r.field_count - 1) { |field|
  13. irb(main):008:2* puts "#{r.name(field)}: #{r.item(field)}"
  14. irb(main):009:2> }
  15. irb(main):010:1> r.next
  16. irb(main):011:1> }
  17. id: 1
  18. name: Testing Account
  19. owner_id: 1
  20. id: 2
  21. name: Test Account
  22. owner_id: 3
  23. => 0
Add Comment
Please, Sign In to add comment