Guest User

Untitled

a guest
Feb 21st, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.83 KB | None | 0 0
  1. shingara@slick ~/data/perso/project/merb/oupsnow $ merb -i
  2. Loading init file from /mnt/data/home_data/perso/project/merb/oupsnow/config/init.rb
  3. Loading /mnt/data/home_data/perso/project/merb/oupsnow/config/environments/development.rb
  4. ~ Connecting to database...
  5. ~ Loaded slice 'MerbAuthSlicePassword' ...
  6. ~ Parent pid: 9989
  7. ~ Compiling routes...
  8. ~ Activating slice 'MerbAuthSlicePassword' ...
  9. irb: warn: can't alias context from irb_context.
  10. irb(main):001:0> Project.first
  11. ~ SELECT "id", "name" FROM "projects" ORDER BY "id" LIMIT 1
  12. => #<Project id=1 name="good project" description=<not loaded>>
  13. irb(main):002:0> Project.first.tickets
  14. ~ SELECT "id", "name" FROM "projects" ORDER BY "id" LIMIT 1
  15. ~ SELECT "id", "title", "project_id" FROM "tickets" WHERE ("project_id" IN (1)) ORDER BY "id"
  16. => [#<Ticket id=1 title="ok" description=<not loaded> project_id=1>]
  17. irb(main):003:0> Project.first.tickets.first
  18. ~ SELECT "id", "name" FROM "projects" ORDER BY "id" LIMIT 1
  19. ~ SELECT "id", "title", "project_id" FROM "tickets" WHERE ("project_id" IN (1)) ORDER BY "id"
  20. ~ SELECT "id", "title", "project_id" FROM "tickets" WHERE ("project_id" = 1) ORDER BY "id" LIMIT 1
  21. => #<Ticket id=1 title="ok" description=<not loaded> project_id=1>
  22. irb(main):004:0> Project.first.tickets.first.title = 'ko'
  23. ~ SELECT "id", "name" FROM "projects" ORDER BY "id" LIMIT 1
  24. ~ SELECT "id", "title", "project_id" FROM "tickets" WHERE ("project_id" IN (1)) ORDER BY "id"
  25. ~ SELECT "id", "title", "project_id" FROM "tickets" WHERE ("project_id" = 1) ORDER BY "id" LIMIT 1
  26. => "ko"
  27. irb(main):005:0> Project.first.tickets.first.save
  28. ~ SELECT "id", "name" FROM "projects" ORDER BY "id" LIMIT 1
  29. ~ SELECT "id", "title", "project_id" FROM "tickets" WHERE ("project_id" IN (1)) ORDER BY "id"
  30. ~ SELECT "id", "title", "project_id" FROM "tickets" WHERE ("project_id" = 1) ORDER BY "id" LIMIT 1
  31. => true
  32. irb(main):006:0> Ticket.first
  33. ~ SELECT "id", "title", "project_id" FROM "tickets" ORDER BY "id" LIMIT 1
  34. => #<Ticket id=1 title="ok" description=<not loaded> project_id=1>
  35. irb(main):007:0> Ticket.first.project
  36. ~ SELECT "id", "title", "project_id" FROM "tickets" ORDER BY "id" LIMIT 1
  37. ~ SELECT "id", "name" FROM "projects" WHERE ("id" IN (1)) ORDER BY "id"
  38. => #<Project id=1 name="good project" description=<not loaded>>
  39. irb(main):008:0> Ticket.first.project.name = 'bad project'
  40. ~ SELECT "id", "title", "project_id" FROM "tickets" ORDER BY "id" LIMIT 1
  41. ~ SELECT "id", "name" FROM "projects" WHERE ("id" IN (1)) ORDER BY "id"
  42. => "bad project"
  43. irb(main):009:0> Ticket.first.project.save
  44. ~ SELECT "id", "title", "project_id" FROM "tickets" ORDER BY "id" LIMIT 1
  45. ~ SELECT "id", "name" FROM "projects" WHERE ("id" IN (1)) ORDER BY "id"
  46. => true
  47. irb(main):010:0> Ticket.first.project
  48. ~ SELECT "id", "title", "project_id" FROM "tickets" ORDER BY "id" LIMIT 1
  49. ~ SELECT "id", "name" FROM "projects" WHERE ("id" IN (1)) ORDER BY "id"
  50. => #<Project id=1 name="good project" description=<not loaded>>
  51. irb(main):011:0> t = Ticket.first
  52. ~ SELECT "id", "title", "project_id" FROM "tickets" ORDER BY "id" LIMIT 1
  53. => #<Ticket id=1 title="ok" description=<not loaded> project_id=1>
  54. irb(main):012:0> t.project.name = "bad project"
  55. ~ SELECT "id", "name" FROM "projects" WHERE ("id" IN (1)) ORDER BY "id"
  56. => "bad project"
  57. irb(main):013:0> t.project
  58. => #<Project id=1 name="bad project" description=<not loaded>>
  59. irb(main):014:0> t.project.save
  60. => true
  61. irb(main):015:0> p = t.project
  62. => #<Project id=1 name="bad project" description=<not loaded>>
  63. irb(main):016:0> p.save
  64. => true
  65. irb(main):017:0> Project.first(:name => 'bad project')
  66. ~ SELECT "id", "name" FROM "projects" WHERE ("name" = 'bad project') ORDER BY "id" LIMIT 1
  67. => nil
  68. irb(main):020:0> p = Project.first
  69. ~ SELECT "id", "name" FROM "projects" ORDER BY "id" LIMIT 1
  70. => #<Project id=1 name="good project" description=<not loaded>>
  71. irb(main):021:0> p.tickets.first
  72. ~ SELECT "id", "title", "project_id" FROM "tickets" WHERE ("project_id" IN (1)) ORDER BY "id"
  73. ~ SELECT "id", "title", "project_id" FROM "tickets" WHERE ("project_id" = 1) ORDER BY "id" LIMIT 1
  74. => #<Ticket id=1 title="ok" description=<not loaded> project_id=1>
  75. irb(main):022:0> Ticket.first(:title => 'ko')
  76. ~ SELECT "id", "title", "project_id" FROM "tickets" WHERE ("title" = 'ko') ORDER BY "id" LIMIT 1
  77. => nil
  78. irb(main):023:0> p.tickets.first.title = 'ko'
  79. ~ SELECT "id", "title", "project_id" FROM "tickets" WHERE ("project_id" = 1) ORDER BY "id" LIMIT 1
  80. => "ko"
  81. irb(main):024:0> p.tickets.first.save
  82. ~ SELECT "id", "title", "project_id" FROM "tickets" WHERE ("project_id" = 1) ORDER BY "id" LIMIT 1
  83. ~ UPDATE "tickets" SET "title" = 'ko' WHERE ("id" = 1)
  84. => true
  85. irb(main):025:0> Ticket.first(:title => 'ko')
  86. ~ SELECT "id", "title", "project_id" FROM "tickets" WHERE ("title" = 'ko') ORDER BY "id" LIMIT 1
  87. => #<Ticket id=1 title="ko" description=<not loaded> project_id=1>
Add Comment
Please, Sign In to add comment