API tools faq
paste
Guest User

Untitled

a guest
Oct 25th, 2017
413
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.30 KB | None | 0 0
raw download clone embed print report
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.  
  11.  
  12.  
  13.  
  14.  
  15. Started PUT "/bookings/23/exec_reserve.json" for 127.0.0.1 at Thu Jun 23 10:20:12 +0600 2011
  16. Processing by BookingsController#exec_reserve as JSON
  17. Parameters: {"commit"=>"Save", "booking"=>{"start_date"=>"09/18/2014", "amount"=>"56", "stop_date"=>"08/30/2023", "description"=>""}, "id"=>"23"}
  18. User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."fb_user_id" = '1561794357' LIMIT 1
  19. SQL (0.3ms) BEGIN
  20. SQL (0.7ms) INSERT INTO "delayed_jobs" ("attempts", "handler", "failed_at", "locked_by", "last_error", "priority", "updated_at", "created_at", "run_at", "locked_at") VALUES (0, '--- !ruby/struct:Delayed::PerformableMethod
  21. object: !ruby/ActiveRecord:User
  22. attributes:
  23. session_expires_at:
  24. authorize_signature: 207114539328990|96fd4c3d9db2955c037a85ab.1-1561794357|KHEQUsWSze1qidBIfEzRW1htSVE
  25. company: ""
  26. referral_id:
  27. app_api_key:
  28. created_at: 2011-05-08 08:53:24.399349
  29. sms_starting_at: "01:00:00"
  30. valid_country: f
  31. session_key: 96fd4c3d9db2955c037a85ab.1-1561794357
  32. linked_account_ids:
  33. redeemed_rewards:
  34. authorized_at:
  35. fb_user_id: "1561794357"
  36. updated_at: 2011-06-23 04:20:06.179893
  37. twitter_name:
  38. fake_fb_uid: "1"
  39. fb_updated_at:
  40. fb_friend_ids:
  41. fb_location: Perm, Russia
  42. fb_location_update_at: 2011-05-08 08:53:27.178155
  43. fb_lng: "56.2352792"
  44. subscription_plan: advanced
  45. admin: t
  46. yahoo_id: ""
  47. notification_channels: |
  48. ---
  49. - ""
  50. - email
  51.  
  52. id: "1"
  53. update_fb_wall: f
  54. referral_token: 9c81317f097b7de4ac21e406a88a61b93c45c2b7
  55. fake_friend_ids:
  56. has_billing_info: t
  57. twitter_token:
  58. last_poll_time: 2011-06-23 04:20:06.17804
  59. accepted_terms_of_use: t
  60. last_name: ""
  61. phone: ""
  62. sms_ending_at: "15:00:00"
  63. referral_updated_at:
  64. fb_first_name: Fodoj
  65. vrbo_password: qweqwe
  66. twitter_secret:
  67. middle_initial:
  68. use_fb_profile: t
  69. fb_lat: "57.9971695"
  70. fb_friends_update_at:
  71. time_zone:
  72. update_twitter: f
  73. email: fodojyko@gmail.com
  74. vrbo_login: fodojyko@gmail.com
  75. first_name: ""
  76. fb_last_name: Yodov
  77. method_name: :get_fb_friend_ids!
  78. args: []
  79.  
  80. ', NULL, NULL, NULL, 0, '2011-06-23 04:20:12.500753', '2011-06-23 04:20:12.500753', '2011-06-23 04:20:12.500554', NULL) RETURNING "id"
  81. SQL (0.9ms) COMMIT
  82. SQL (0.3ms) BEGIN
  83. SQL (0.8ms) INSERT INTO "delayed_jobs" ("attempts", "handler", "failed_at", "locked_by", "last_error", "priority", "updated_at", "created_at", "run_at", "locked_at") VALUES (0, '--- !ruby/struct:Delayed::PerformableMethod
  84. object: !ruby/ActiveRecord:User
  85. attributes:
  86. session_expires_at:
  87. authorize_signature: 207114539328990|96fd4c3d9db2955c037a85ab.1-1561794357|KHEQUsWSze1qidBIfEzRW1htSVE
  88. company: ""
  89. referral_id:
  90. app_api_key:
  91. created_at: 2011-05-08 08:53:24.399349
  92. sms_starting_at: "01:00:00"
  93. valid_country: f
  94. session_key: 96fd4c3d9db2955c037a85ab.1-1561794357
  95. linked_account_ids:
  96. redeemed_rewards:
  97. authorized_at:
  98. fb_user_id: "1561794357"
  99. updated_at: 2011-06-23 04:20:06.179893
  100. twitter_name:
  101. fake_fb_uid: "1"
  102. fb_updated_at:
  103. fb_friend_ids:
  104. fb_location: Perm, Russia
  105. fb_location_update_at: 2011-05-08 08:53:27.178155
  106. fb_lng: "56.2352792"
  107. subscription_plan: advanced
  108. admin: t
  109. yahoo_id: ""
  110. notification_channels: |
  111. ---
  112. - ""
  113. - email
  114.  
  115. id: "1"
  116. update_fb_wall: f
  117. referral_token: 9c81317f097b7de4ac21e406a88a61b93c45c2b7
  118. fake_friend_ids:
  119. has_billing_info: t
  120. twitter_token:
  121. last_poll_time: 2011-06-23 04:20:06.17804
  122. accepted_terms_of_use: t
  123. last_name: ""
  124. phone: ""
  125. sms_ending_at: "15:00:00"
  126. referral_updated_at:
  127. fb_first_name: Fodoj
  128. vrbo_password: qweqwe
  129. twitter_secret:
  130. middle_initial:
  131. use_fb_profile: t
  132. fb_lat: "57.9971695"
  133. fb_friends_update_at:
  134. time_zone:
  135. update_twitter: f
  136. email: fodojyko@gmail.com
  137. vrbo_login: fodojyko@gmail.com
  138. first_name: ""
  139. fb_last_name: Yodov
  140. method_name: :get_fb_friend_ids!
  141. args: []
  142.  
  143. ', NULL, NULL, NULL, 0, '2011-06-23 04:20:12.522231', '2011-06-23 04:20:12.522231', '2011-06-23 04:20:12.522049', NULL) RETURNING "id"
  144. SQL (16.7ms) COMMIT
  145. Booking Load (1.1ms) SELECT "bookings".* FROM "bookings" INNER JOIN "rental_units" ON "bookings".rental_unit_id = "rental_units".id WHERE "bookings"."id" = 23 AND (("rental_units".user_id = 1)) LIMIT 1
  146. RentalUnit Load (3.6ms) SELECT "rental_units".* FROM "rental_units" WHERE "rental_units"."id" = 9 LIMIT 1
  147. Booking Load (0.8ms) SELECT "bookings"."id" FROM "bookings" WHERE "bookings"."status" IN ('reserved', 'confirmed') AND ("bookings".rental_unit_id = 9) AND ( stop_date > '2014-09-18' AND start_date < '2023-08-30' AND id != 23 ) LIMIT 1
  148. Reservation Load (2.4ms) SELECT "reservations"."id" FROM "reservations" WHERE "reservations"."status" IN ('RESERVE', 'UNAVAILABLE') AND ("reservations".rental_unit_id = 9) AND ( '2014-09-18 00:00:00' < end_at AND '2023-08-30 00:00:00' > start_at AND booking_id IS NULL) LIMIT 1
  149. Lot Load (0.8ms) SELECT "lots"."id" FROM "lots" WHERE "lots"."status" IN ('active', 'waiting_on_charge', 'waiting_on_accepting') AND ("lots".property_id = 9) AND ( depart_on > '2014-09-18' AND arrive_on < '2023-08-30' ) LIMIT 1
  150. Deal Load (0.6ms) SELECT "deals"."id" FROM "deals" WHERE "deals"."status" = 'active' AND ("deals".rental_unit_id = 9) AND ( end_on > '2014-09-18' AND start_on < '2023-08-30' ) LIMIT 1
  151. Reservation Load (0.8ms) SELECT "reservations".* FROM "reservations" WHERE ("reservations".booking_id = 23) LIMIT 1
  152. SQL (0.3ms) BEGIN
  153. Reservation Load (0.7ms) SELECT "reservations"."id" FROM "reservations" WHERE "reservations"."status" IN ('RESERVE', 'UNAVAILABLE') AND ("reservations".rental_unit_id = 9) AND (id != NULL) AND ( '2014-09-18 07:00:00.000000' < end_at AND '2023-08-30 07:00:00.000000' > start_at) LIMIT 1
  154. SQL (17.2ms) INSERT INTO "reservations" ("first_name", "last_name", "email", "status", "address1", "inquiry_source", "fax", "notes", "updated_at", "address2", "city", "remote_id", "end_at", "number_of_children", "zip", "phone", "rental_unit_id", "mobile", "start_at", "country", "booking_id", "created_at", "state", "source", "number_of_adults") VALUES (NULL, NULL, NULL, 'RESERVE', NULL, NULL, NULL, '', '2011-06-23 04:20:12.620588', NULL, NULL, NULL, '2023-08-30 07:00:00.000000', 0, NULL, NULL, 9, NULL, '2014-09-18 07:00:00.000000', NULL, 23, '2011-06-23 04:20:12.620588', NULL, NULL, 0) RETURNING "id"
  155. SQL (0.7ms) COMMIT
  156. User Load (1.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  157. SQL (0.4ms) BEGIN
  158. Booking Load (1.0ms) SELECT "bookings"."id" FROM "bookings" WHERE "bookings"."status" IN ('reserved', 'confirmed') AND ("bookings".rental_unit_id = 9) AND ( stop_date > '2014-09-18' AND start_date < '2023-08-30' AND id != 23 ) LIMIT 1
  159. Reservation Load (1.0ms) SELECT "reservations"."id" FROM "reservations" WHERE "reservations"."status" IN ('RESERVE', 'UNAVAILABLE') AND ("reservations".rental_unit_id = 9) AND ( '2014-09-18 00:00:00' < end_at AND '2023-08-30 00:00:00' > start_at AND booking_id IS NULL) LIMIT 1
  160. Lot Load (0.9ms) SELECT "lots"."id" FROM "lots" WHERE "lots"."status" IN ('active', 'waiting_on_charge', 'waiting_on_accepting') AND ("lots".property_id = 9) AND ( depart_on > '2014-09-18' AND arrive_on < '2023-08-30' ) LIMIT 1
  161. Deal Load (0.9ms) SELECT "deals"."id" FROM "deals" WHERE "deals"."status" = 'active' AND ("deals".rental_unit_id = 9) AND ( end_on > '2014-09-18' AND start_on < '2023-08-30' ) LIMIT 1
  162. AREL (1.2ms) UPDATE "bookings" SET "stop_date" = '2023-08-30', "amount" = 56.0, "start_date" = '2014-09-18', "description" = '', "updated_at" = '2011-06-23 04:20:12.684887', "status" = 'reserved' WHERE "bookings"."id" = 23
  163. Deal Load (2.2ms) SELECT "deals".* FROM "deals" INNER JOIN "rental_units" ON "rental_units"."id" = "deals"."rental_unit_id" WHERE "deals"."status" = 'active' AND "rental_units"."deleted_at" IS NULL AND "rental_units"."verified" = 't' AND "rental_units"."owner_subscribed" = 't' AND ("deals".rental_unit_id = 9) AND (start_on < '2023-08-30' AND end_on > '2014-09-18' )
  164. SQL (0.9ms) COMMIT
  165. Completed 406 Not Acceptable in 254ms
  166.  
  167.  
  168. Started GET "/bookings.json" for 127.0.0.1 at Thu Jun 23 10:20:12 +0600 2011
  169. Processing by BookingsController#index as JSON
  170. User Load (1.2ms) SELECT "users".* FROM "users" WHERE "users"."fb_user_id" = '1561794357' LIMIT 1
  171. SQL (0.3ms) BEGIN
  172. SQL (0.8ms) INSERT INTO "delayed_jobs" ("attempts", "handler", "failed_at", "locked_by", "last_error", "priority", "updated_at", "created_at", "run_at", "locked_at") VALUES (0, '--- !ruby/struct:Delayed::PerformableMethod
  173. object: !ruby/ActiveRecord:User
  174. attributes:
  175. session_expires_at:
  176. authorize_signature: 207114539328990|96fd4c3d9db2955c037a85ab.1-1561794357|KHEQUsWSze1qidBIfEzRW1htSVE
  177. company: ""
  178. referral_id:
  179. app_api_key:
  180. created_at: 2011-05-08 08:53:24.399349
  181. sms_starting_at: "01:00:00"
  182. valid_country: f
  183. session_key: 96fd4c3d9db2955c037a85ab.1-1561794357
  184. linked_account_ids:
  185. redeemed_rewards:
  186. authorized_at:
  187. fb_user_id: "1561794357"
  188. updated_at: 2011-06-23 04:20:06.179893
  189. twitter_name:
  190. fake_fb_uid: "1"
  191. fb_updated_at:
  192. fb_friend_ids:
  193. fb_location: Perm, Russia
  194. fb_location_update_at: 2011-05-08 08:53:27.178155
  195. fb_lng: "56.2352792"
  196. subscription_plan: advanced
  197. admin: t
  198. yahoo_id: ""
  199. notification_channels: |
  200. ---
  201. - ""
  202. - email
  203.  
  204. id: "1"
  205. update_fb_wall: f
  206. referral_token: 9c81317f097b7de4ac21e406a88a61b93c45c2b7
  207. fake_friend_ids:
  208. has_billing_info: t
  209. twitter_token:
  210. last_poll_time: 2011-06-23 04:20:06.17804
  211. accepted_terms_of_use: t
  212. last_name: ""
  213. phone: ""
  214. sms_ending_at: "15:00:00"
  215. referral_updated_at:
  216. fb_first_name: Fodoj
  217. vrbo_password: qweqwe
  218. twitter_secret:
  219. middle_initial:
  220. use_fb_profile: t
  221. fb_lat: "57.9971695"
  222. fb_friends_update_at:
  223. time_zone:
  224. update_twitter: f
  225. email: fodojyko@gmail.com
  226. vrbo_login: fodojyko@gmail.com
  227. first_name: ""
  228. fb_last_name: Yodov
  229. method_name: :get_fb_friend_ids!
  230. args: []
  231.  
  232. ', NULL, NULL, NULL, 0, '2011-06-23 04:20:12.794742', '2011-06-23 04:20:12.794742', '2011-06-23 04:20:12.794546', NULL) RETURNING "id"
  233. SQL (0.9ms) COMMIT
  234. SQL (0.3ms) BEGIN
  235. SQL (0.9ms) INSERT INTO "delayed_jobs" ("attempts", "handler", "failed_at", "locked_by", "last_error", "priority", "updated_at", "created_at", "run_at", "locked_at") VALUES (0, '--- !ruby/struct:Delayed::PerformableMethod
  236. object: !ruby/ActiveRecord:User
  237. attributes:
  238. session_expires_at:
  239. authorize_signature: 207114539328990|96fd4c3d9db2955c037a85ab.1-1561794357|KHEQUsWSze1qidBIfEzRW1htSVE
  240. company: ""
  241. referral_id:
  242. app_api_key:
  243. created_at: 2011-05-08 08:53:24.399349
  244. sms_starting_at: "01:00:00"
  245. valid_country: f
  246. session_key: 96fd4c3d9db2955c037a85ab.1-1561794357
  247. linked_account_ids:
  248. redeemed_rewards:
  249. authorized_at:
  250. fb_user_id: "1561794357"
  251. updated_at: 2011-06-23 04:20:06.179893
  252. twitter_name:
  253. fake_fb_uid: "1"
  254. fb_updated_at:
  255. fb_friend_ids:
  256. fb_location: Perm, Russia
  257. fb_location_update_at: 2011-05-08 08:53:27.178155
  258. fb_lng: "56.2352792"
  259. subscription_plan: advanced
  260. admin: t
  261. yahoo_id: ""
  262. notification_channels: |
  263. ---
  264. - ""
  265. - email
  266.  
  267. id: "1"
  268. update_fb_wall: f
  269. referral_token: 9c81317f097b7de4ac21e406a88a61b93c45c2b7
  270. fake_friend_ids:
  271. has_billing_info: t
  272. twitter_token:
  273. last_poll_time: 2011-06-23 04:20:06.17804
  274. accepted_terms_of_use: t
  275. last_name: ""
  276. phone: ""
  277. sms_ending_at: "15:00:00"
  278. referral_updated_at:
  279. fb_first_name: Fodoj
  280. vrbo_password: qweqwe
  281. twitter_secret:
  282. middle_initial:
  283. use_fb_profile: t
  284. fb_lat: "57.9971695"
  285. fb_friends_update_at:
  286. time_zone:
  287. update_twitter: f
  288. email: fodojyko@gmail.com
  289. vrbo_login: fodojyko@gmail.com
  290. first_name: ""
  291. fb_last_name: Yodov
  292. method_name: :get_fb_friend_ids!
  293. args: []
  294.  
  295. ', NULL, NULL, NULL, 0, '2011-06-23 04:20:12.808519', '2011-06-23 04:20:12.808519', '2011-06-23 04:20:12.808348', NULL) RETURNING "id"
  296. SQL (20.2ms) COMMIT
  297. Booking Load (1.2ms) SELECT "bookings".* FROM "bookings" INNER JOIN "rental_units" ON "bookings".rental_unit_id = "rental_units".id WHERE "bookings"."status" = 'reserved' AND (("rental_units".user_id = 1)) ORDER BY start_date
  298. RentalUnit Load (0.9ms) SELECT "rental_units".* FROM "rental_units" WHERE ("rental_units"."id" = 9)
  299. User Load (0.8ms) SELECT "users".* FROM "users" WHERE ("users"."id" = 1)
  300. Reservation Load (2.2ms) SELECT "reservations".* FROM "reservations" WHERE ("reservations".booking_id IN (25,24,23))
  301. Completed 200 OK in 86ms (Views: 22.7ms | ActiveRecord: 31.8ms | Sphinx: 0.0ms)
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!