API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 30th, 2015
914
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 43.65 KB | None | 0 0
raw download clone embed print report
  1. lutsko@lutsko-X55A:~/project/qna$ rspec spec/
  2. D, [2015-11-30T19:20:17.922273 #12806] DEBUG -- : (20.1ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "authorizations" DISABLE TRIGGER ALL;ALTER TABLE "oauth_access_tokens" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "attachments" DISABLE TRIGGER ALL;ALTER TABLE "answers" DISABLE TRIGGER ALL;ALTER TABLE "questions" DISABLE TRIGGER ALL;ALTER TABLE "oauth_applications" DISABLE TRIGGER ALL;ALTER TABLE "oauth_access_grants" DISABLE TRIGGER ALL;ALTER TABLE "votes" DISABLE TRIGGER ALL;ALTER TABLE "comments" DISABLE TRIGGER ALL
  3. D, [2015-11-30T19:20:17.924309 #12806] DEBUG -- : (1.8ms) SELECT schemaname || '.' || tablename
  4. FROM pg_tables
  5. WHERE
  6. tablename !~ '_prt_' AND
  7. tablename <> 'schema_migrations' AND
  8. schemaname = ANY (current_schemas(false))
  9.  
  10. D, [2015-11-30T19:20:17.926410 #12806] DEBUG -- : (1.5ms) select table_name from information_schema.views where table_schema = 'qna_test'
  11. D, [2015-11-30T19:20:19.830749 #12806] DEBUG -- : (1903.6ms) TRUNCATE TABLE "public"."authorizations", "public"."oauth_access_tokens", "public"."users", "public"."attachments", "public"."answers", "public"."questions", "public"."oauth_applications", "public"."oauth_access_grants", "public"."votes", "public"."comments" RESTART IDENTITY CASCADE;
  12. D, [2015-11-30T19:20:19.839634 #12806] DEBUG -- : (6.1ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "authorizations" ENABLE TRIGGER ALL;ALTER TABLE "oauth_access_tokens" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "attachments" ENABLE TRIGGER ALL;ALTER TABLE "answers" ENABLE TRIGGER ALL;ALTER TABLE "questions" ENABLE TRIGGER ALL;ALTER TABLE "oauth_applications" ENABLE TRIGGER ALL;ALTER TABLE "oauth_access_grants" ENABLE TRIGGER ALL;ALTER TABLE "votes" ENABLE TRIGGER ALL;ALTER TABLE "comments" ENABLE TRIGGER ALL
  13. D, [2015-11-30T19:20:19.878700 #12806] DEBUG -- : (0.4ms) BEGIN
  14. D, [2015-11-30T19:20:19.903443 #12806] DEBUG -- : Doorkeeper::Application Exists (0.8ms) SELECT 1 AS one FROM "oauth_applications" WHERE "oauth_applications"."uid" = '12345671' LIMIT 1
  15. D, [2015-11-30T19:20:19.906999 #12806] DEBUG -- : SQL (0.7ms) INSERT INTO "oauth_applications" ("name", "redirect_uri", "uid", "secret", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["name", "Test"], ["redirect_uri", "urn:ietf:wg:oauth:2.0:oob"], ["uid", "12345671"], ["secret", "87654321"], ["created_at", "2015-11-30 17:20:19.903944"], ["updated_at", "2015-11-30 17:20:19.903944"]]
  16. D, [2015-11-30T19:20:19.914493 #12806] DEBUG -- : (6.6ms) COMMIT
  17. D, [2015-11-30T19:20:19.958070 #12806] DEBUG -- : (0.3ms) BEGIN
  18. D, [2015-11-30T19:20:19.960622 #12806] DEBUG -- : User Exists (0.8ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user1@test.com' LIMIT 1
  19. D, [2015-11-30T19:20:19.962989 #12806] DEBUG -- : SQL (0.6ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user1@test.com"], ["encrypted_password", "$2a$04$28.s3QPrRRfKmF7P/5M2jue8i9yFjmLMvapINnBgNOQF.lhfonDHm"]]
  20. D, [2015-11-30T19:20:19.972644 #12806] DEBUG -- : (8.9ms) COMMIT
  21. D, [2015-11-30T19:20:19.973319 #12806] DEBUG -- : (0.2ms) BEGIN
  22. D, [2015-11-30T19:20:19.975780 #12806] DEBUG -- : Doorkeeper::AccessToken Exists (0.8ms) SELECT 1 AS one FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = '6a2b30b921117e36418e496e67a86c0bc2b61bbc118f06497064ead0c8b16096' LIMIT 1
  23. D, [2015-11-30T19:20:19.978688 #12806] DEBUG -- : SQL (0.8ms) INSERT INTO "oauth_access_tokens" ("application_id", "resource_owner_id", "token", "created_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["application_id", 1], ["resource_owner_id", 1], ["token", "6a2b30b921117e36418e496e67a86c0bc2b61bbc118f06497064ead0c8b16096"], ["created_at", "2015-11-30 17:20:19.976307"]]
  24. D, [2015-11-30T19:20:19.989295 #12806] DEBUG -- : (9.9ms) COMMIT
  25. D, [2015-11-30T19:20:20.012895 #12806] DEBUG -- : (0.5ms) BEGIN
  26. D, [2015-11-30T19:20:20.015586 #12806] DEBUG -- : User Exists (1.2ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user2@test.com' LIMIT 1
  27. D, [2015-11-30T19:20:20.017225 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user2@test.com"], ["encrypted_password", "$2a$04$5cFIQhjbjPOl0Mc3/vBOleQqnyqLY.evmsKSpZ2/HSSm3/QM82uYy"]]
  28. D, [2015-11-30T19:20:20.022718 #12806] DEBUG -- : (4.8ms) COMMIT
  29. D, [2015-11-30T19:20:20.024683 #12806] DEBUG -- : (0.3ms) BEGIN
  30. D, [2015-11-30T19:20:20.027279 #12806] DEBUG -- : SQL (0.6ms) INSERT INTO "questions" ("title", "body", "user_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["title", "MyString"], ["body", "MyText"], ["user_id", 2], ["created_at", "2015-11-30 17:20:20.025356"], ["updated_at", "2015-11-30 17:20:20.025356"]]
  31. D, [2015-11-30T19:20:20.031010 #12806] DEBUG -- : (3.1ms) COMMIT
  32. D, [2015-11-30T19:20:20.036182 #12806] DEBUG -- : (0.2ms) BEGIN
  33. D, [2015-11-30T19:20:20.037867 #12806] DEBUG -- : User Exists (0.5ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user3@test.com' LIMIT 1
  34. D, [2015-11-30T19:20:20.039278 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user3@test.com"], ["encrypted_password", "$2a$04$2jCP9aguORPy4JIORYIDTOOba3Y/5sE6Xw2uFLzroXTEKPtv7nxha"]]
  35. D, [2015-11-30T19:20:20.048184 #12806] DEBUG -- : (8.3ms) COMMIT
  36. D, [2015-11-30T19:20:20.051918 #12806] DEBUG -- : (0.8ms) BEGIN
  37. D, [2015-11-30T19:20:20.055495 #12806] DEBUG -- : SQL (0.8ms) INSERT INTO "answers" ("body", "question_id", "user_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["body", "Answer body"], ["question_id", 1], ["user_id", 3], ["created_at", "2015-11-30 17:20:20.053088"], ["updated_at", "2015-11-30 17:20:20.053088"]]
  38. D, [2015-11-30T19:20:20.065933 #12806] DEBUG -- : (9.7ms) COMMIT
  39. D, [2015-11-30T19:20:20.079771 #12806] DEBUG -- : (0.3ms) BEGIN
  40. D, [2015-11-30T19:20:20.081309 #12806] DEBUG -- : User Exists (0.5ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user4@test.com' LIMIT 1
  41. D, [2015-11-30T19:20:20.082615 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user4@test.com"], ["encrypted_password", "$2a$04$r2acPtXBBz8kcyw8R3U7Aup7AMlUcfEehHLscgzgMr14nDot3UQyy"]]
  42. D, [2015-11-30T19:20:20.090654 #12806] DEBUG -- : (7.4ms) COMMIT
  43. D, [2015-11-30T19:20:20.091225 #12806] DEBUG -- : (0.2ms) BEGIN
  44. D, [2015-11-30T19:20:20.107431 #12806] DEBUG -- : SQL (0.6ms) INSERT INTO "questions" ("title", "body", "user_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["title", "MyString"], ["body", "MyText"], ["user_id", 4], ["created_at", "2015-11-30 17:20:20.091686"], ["updated_at", "2015-11-30 17:20:20.091686"]]
  45. D, [2015-11-30T19:20:20.115838 #12806] DEBUG -- : (7.8ms) COMMIT
  46. D, [2015-11-30T19:20:20.119221 #12806] DEBUG -- : (0.2ms) BEGIN
  47. D, [2015-11-30T19:20:20.122416 #12806] DEBUG -- : SQL (0.6ms) INSERT INTO "attachments" ("attachmentable_id", "attachmentable_type", "file", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["attachmentable_id", "2"], ["attachmentable_type", "Question"], ["file", "spec_helper.rb"], ["created_at", "2015-11-30 17:20:20.120616"], ["updated_at", "2015-11-30 17:20:20.120616"]]
  48. D, [2015-11-30T19:20:20.174341 #12806] DEBUG -- : (50.5ms) COMMIT
  49. D, [2015-11-30T19:20:20.191855 #12806] DEBUG -- : (0.3ms) BEGIN
  50. D, [2015-11-30T19:20:20.195422 #12806] DEBUG -- : SQL (0.9ms) INSERT INTO "authorizations" ("provider", "uid", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["provider", "MyString"], ["uid", "MyString"], ["created_at", "2015-11-30 17:20:20.192420"], ["updated_at", "2015-11-30 17:20:20.192420"]]
  51. D, [2015-11-30T19:20:20.207593 #12806] DEBUG -- : (11.4ms) COMMIT
  52. D, [2015-11-30T19:20:20.226564 #12806] DEBUG -- : (0.3ms) BEGIN
  53. D, [2015-11-30T19:20:20.228572 #12806] DEBUG -- : User Exists (0.6ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user5@test.com' LIMIT 1
  54. D, [2015-11-30T19:20:20.238475 #12806] DEBUG -- : SQL (0.5ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user5@test.com"], ["encrypted_password", "$2a$04$eHGJrDc6h/3rD0E8WULTwOO4mN7dOomMFAqAYyK43tqu/.mUxHvpm"]]
  55. D, [2015-11-30T19:20:20.249069 #12806] DEBUG -- : (9.8ms) COMMIT
  56. D, [2015-11-30T19:20:20.251306 #12806] DEBUG -- : (0.3ms) BEGIN
  57. D, [2015-11-30T19:20:20.254147 #12806] DEBUG -- : SQL (0.7ms) INSERT INTO "comments" ("body", "user_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["body", "Comment_1"], ["user_id", 5], ["created_at", "2015-11-30 17:20:20.251950"], ["updated_at", "2015-11-30 17:20:20.251950"]]
  58. D, [2015-11-30T19:20:20.265900 #12806] DEBUG -- : (11.1ms) COMMIT
  59. D, [2015-11-30T19:20:20.267140 #12806] DEBUG -- : (0.2ms) BEGIN
  60. D, [2015-11-30T19:20:20.268811 #12806] DEBUG -- : Doorkeeper::Application Exists (0.6ms) SELECT 1 AS one FROM "oauth_applications" WHERE "oauth_applications"."uid" = '12345672' LIMIT 1
  61. D, [2015-11-30T19:20:20.270768 #12806] DEBUG -- : SQL (0.5ms) INSERT INTO "oauth_applications" ("name", "redirect_uri", "uid", "secret", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["name", "Test"], ["redirect_uri", "urn:ietf:wg:oauth:2.0:oob"], ["uid", "12345672"], ["secret", "87654321"], ["created_at", "2015-11-30 17:20:20.269107"], ["updated_at", "2015-11-30 17:20:20.269107"]]
  62. D, [2015-11-30T19:20:20.282572 #12806] DEBUG -- : (11.1ms) COMMIT
  63. D, [2015-11-30T19:20:20.286938 #12806] DEBUG -- : (0.3ms) BEGIN
  64. D, [2015-11-30T19:20:20.288666 #12806] DEBUG -- : User Exists (0.5ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user6@test.com' LIMIT 1
  65. D, [2015-11-30T19:20:20.290697 #12806] DEBUG -- : SQL (0.7ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user6@test.com"], ["encrypted_password", "$2a$04$ClCZ2P5Pl7k/tt5dH5ua0.SfHZtnZWANcB6h0G9Mf6AsjQK6KzdNy"]]
  66. D, [2015-11-30T19:20:20.299152 #12806] DEBUG -- : (7.5ms) COMMIT
  67. D, [2015-11-30T19:20:20.299778 #12806] DEBUG -- : (0.2ms) BEGIN
  68. D, [2015-11-30T19:20:20.301694 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "questions" ("title", "body", "user_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["title", "MyString"], ["body", "MyText"], ["user_id", 6], ["created_at", "2015-11-30 17:20:20.300270"], ["updated_at", "2015-11-30 17:20:20.300270"]]
  69. D, [2015-11-30T19:20:20.307612 #12806] DEBUG -- : (5.2ms) COMMIT
  70. D, [2015-11-30T19:20:20.312404 #12806] DEBUG -- : (1.3ms) BEGIN
  71. D, [2015-11-30T19:20:20.314908 #12806] DEBUG -- : User Exists (0.5ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user7@test.com' LIMIT 1
  72. D, [2015-11-30T19:20:20.316476 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user7@test.com"], ["encrypted_password", "$2a$04$RSnoc1fq/DUgP3tZ2hsHWuuDX9cdG6PkmpL/LH5QwKNbeGQyVb07K"]]
  73. D, [2015-11-30T19:20:20.324295 #12806] DEBUG -- : (6.0ms) COMMIT
  74. D, [2015-11-30T19:20:20.336348 #12806] DEBUG -- : (0.5ms) BEGIN
  75. D, [2015-11-30T19:20:20.338516 #12806] DEBUG -- : Vote Exists (0.7ms) SELECT 1 AS one FROM "votes" WHERE ("votes"."user_id" IS NULL AND "votes"."votable_type" IS NULL AND "votes"."votable_id" IS NULL) LIMIT 1
  76. D, [2015-11-30T19:20:20.341227 #12806] DEBUG -- : SQL (0.8ms) INSERT INTO "votes" ("value", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["value", 1], ["created_at", "2015-11-30 17:20:20.338773"], ["updated_at", "2015-11-30 17:20:20.338773"]]
  77. D, [2015-11-30T19:20:20.349031 #12806] DEBUG -- : (6.8ms) COMMIT
  78.  
  79. Profiles API
  80. GET /
  81. unauthorized
  82. D, [2015-11-30T19:20:20.350615 #12806] DEBUG -- : (0.3ms) BEGIN
  83. D, [2015-11-30T19:20:20.404572 #12806] DEBUG -- : (0.2ms) ROLLBACK
  84. returns 401
  85. authorized
  86. D, [2015-11-30T19:20:20.405921 #12806] DEBUG -- : (0.2ms) BEGIN
  87. D, [2015-11-30T19:20:20.409417 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  88. D, [2015-11-30T19:20:20.410943 #12806] DEBUG -- : User Exists (0.4ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user8@test.com' LIMIT 1
  89. D, [2015-11-30T19:20:20.412623 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user8@test.com"], ["encrypted_password", "$2a$04$tggWuan8vRSD.CGvwSVlIuJhA8OsXIS7SQoGUMCwzk4y12cj/CvuO"]]
  90. D, [2015-11-30T19:20:20.413595 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  91. D, [2015-11-30T19:20:20.416762 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  92. D, [2015-11-30T19:20:20.418576 #12806] DEBUG -- : User Exists (0.6ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user9@test.com' LIMIT 1
  93. D, [2015-11-30T19:20:20.420017 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user9@test.com"], ["encrypted_password", "$2a$04$pJNBtOkH7f0ebIooNPmfPeLwl82fUptrOyH5UioRuswJW5eIvrGRK"]]
  94. D, [2015-11-30T19:20:20.420939 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  95. D, [2015-11-30T19:20:20.424033 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  96. D, [2015-11-30T19:20:20.425523 #12806] DEBUG -- : User Exists (0.5ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user10@test.com' LIMIT 1
  97. D, [2015-11-30T19:20:20.426757 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user10@test.com"], ["encrypted_password", "$2a$04$VbYzTXpwMohV/sHIftyfBe/Nb69ciUvT8IrHnRZUuv8PL4/JkMZIm"]]
  98. D, [2015-11-30T19:20:20.427522 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  99. D, [2015-11-30T19:20:20.430690 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  100. D, [2015-11-30T19:20:20.432375 #12806] DEBUG -- : User Exists (0.6ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user11@test.com' LIMIT 1
  101. D, [2015-11-30T19:20:20.433859 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user11@test.com"], ["encrypted_password", "$2a$04$.s6.JwapyGg3P1LbXRICweRaW60QlyoDm/hVCayVbsMvWJU4abpMa"]]
  102. D, [2015-11-30T19:20:20.434554 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  103. D, [2015-11-30T19:20:20.438008 #12806] DEBUG -- : (0.3ms) SAVEPOINT active_record_1
  104. D, [2015-11-30T19:20:20.439798 #12806] DEBUG -- : User Exists (0.6ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user12@test.com' LIMIT 1
  105. D, [2015-11-30T19:20:20.441031 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user12@test.com"], ["encrypted_password", "$2a$04$ak2ZnbcYyRhNVN2dNKtfkerxo489Y40j1U6X1dsEaPozPj1MWPzNm"]]
  106. D, [2015-11-30T19:20:20.441861 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  107. D, [2015-11-30T19:20:20.443156 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  108. D, [2015-11-30T19:20:20.444701 #12806] DEBUG -- : Doorkeeper::Application Exists (0.5ms) SELECT 1 AS one FROM "oauth_applications" WHERE "oauth_applications"."uid" = '12345673' LIMIT 1
  109. D, [2015-11-30T19:20:20.446288 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "oauth_applications" ("name", "redirect_uri", "uid", "secret", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["name", "Test"], ["redirect_uri", "urn:ietf:wg:oauth:2.0:oob"], ["uid", "12345673"], ["secret", "87654321"], ["created_at", "2015-11-30 17:20:20.444979"], ["updated_at", "2015-11-30 17:20:20.444979"]]
  110. D, [2015-11-30T19:20:20.447025 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  111. D, [2015-11-30T19:20:20.447634 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  112. D, [2015-11-30T19:20:20.449554 #12806] DEBUG -- : Doorkeeper::AccessToken Exists (0.6ms) SELECT 1 AS one FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = '0329a0fcef5cbcd9e57506de97b12279665652cae981d229019a0414de466e77' LIMIT 1
  113. D, [2015-11-30T19:20:20.450970 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "oauth_access_tokens" ("application_id", "resource_owner_id", "token", "created_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["application_id", 3], ["resource_owner_id", 12], ["token", "0329a0fcef5cbcd9e57506de97b12279665652cae981d229019a0414de466e77"], ["created_at", "2015-11-30 17:20:20.449925"]]
  114. D, [2015-11-30T19:20:20.451651 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  115. D, [2015-11-30T19:20:20.461185 #12806] DEBUG -- : Doorkeeper::AccessToken Load (0.4ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT 1 [["token", "0329a0fcef5cbcd9e57506de97b12279665652cae981d229019a0414de466e77"]]
  116. D, [2015-11-30T19:20:20.464895 #12806] DEBUG -- : User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 12]]
  117. D, [2015-11-30T19:20:20.480369 #12806] DEBUG -- : User Load (0.7ms) SELECT "users".* FROM "users" WHERE ("users"."id" != 12)
  118. D, [2015-11-30T19:20:20.491614 #12806] DEBUG -- : (2.2ms) ROLLBACK
  119. returns 200 status
  120. D, [2015-11-30T19:20:20.492845 #12806] DEBUG -- : (0.1ms) BEGIN
  121. D, [2015-11-30T19:20:20.496581 #12806] DEBUG -- : (0.3ms) SAVEPOINT active_record_1
  122. D, [2015-11-30T19:20:20.498355 #12806] DEBUG -- : User Exists (0.5ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user13@test.com' LIMIT 1
  123. D, [2015-11-30T19:20:20.499684 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user13@test.com"], ["encrypted_password", "$2a$04$1YNDaj4mfH6XtoT0M9d2r.I5.Z/gP2IkZEiJI8TI2sOB3/bfIK.pC"]]
  124. D, [2015-11-30T19:20:20.500502 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  125. D, [2015-11-30T19:20:20.503663 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  126. D, [2015-11-30T19:20:20.505092 #12806] DEBUG -- : User Exists (0.5ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user14@test.com' LIMIT 1
  127. D, [2015-11-30T19:20:20.506272 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user14@test.com"], ["encrypted_password", "$2a$04$kDYF.Xhc30.DiGFih8zBuu6LxAUjBTMjeCBgIjgorKYocUbJwJ77."]]
  128. D, [2015-11-30T19:20:20.506961 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  129. D, [2015-11-30T19:20:20.511056 #12806] DEBUG -- : (1.0ms) SAVEPOINT active_record_1
  130. D, [2015-11-30T19:20:20.512991 #12806] DEBUG -- : User Exists (0.8ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user15@test.com' LIMIT 1
  131. D, [2015-11-30T19:20:20.514356 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user15@test.com"], ["encrypted_password", "$2a$04$ghphxv84nXDBHgrbjq9Nn.pPfF/khqUIFRheMLxCQ6TNdt1fz/6JO"]]
  132. D, [2015-11-30T19:20:20.515185 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  133. D, [2015-11-30T19:20:20.519573 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  134. D, [2015-11-30T19:20:20.521226 #12806] DEBUG -- : User Exists (0.5ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user16@test.com' LIMIT 1
  135. D, [2015-11-30T19:20:20.522515 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user16@test.com"], ["encrypted_password", "$2a$04$6V1XAyhCVtoYtWfbLMTxVegNycwEBi5nXixJJu8GVrxcc1FaLfWu6"]]
  136. D, [2015-11-30T19:20:20.523290 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  137. D, [2015-11-30T19:20:20.526623 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  138. D, [2015-11-30T19:20:20.528028 #12806] DEBUG -- : User Exists (0.4ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user17@test.com' LIMIT 1
  139. D, [2015-11-30T19:20:20.529192 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user17@test.com"], ["encrypted_password", "$2a$04$sx3jM5V39qOLtVoxk1DLu.VGmv6foNz/v1gDPOztlOMAM2evgP7wK"]]
  140. D, [2015-11-30T19:20:20.531813 #12806] DEBUG -- : (2.0ms) RELEASE SAVEPOINT active_record_1
  141. D, [2015-11-30T19:20:20.534929 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  142. D, [2015-11-30T19:20:20.536483 #12806] DEBUG -- : Doorkeeper::Application Exists (0.4ms) SELECT 1 AS one FROM "oauth_applications" WHERE "oauth_applications"."uid" = '12345674' LIMIT 1
  143. D, [2015-11-30T19:20:20.538269 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "oauth_applications" ("name", "redirect_uri", "uid", "secret", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["name", "Test"], ["redirect_uri", "urn:ietf:wg:oauth:2.0:oob"], ["uid", "12345674"], ["secret", "87654321"], ["created_at", "2015-11-30 17:20:20.536770"], ["updated_at", "2015-11-30 17:20:20.536770"]]
  144. D, [2015-11-30T19:20:20.539210 #12806] DEBUG -- : (0.3ms) RELEASE SAVEPOINT active_record_1
  145. D, [2015-11-30T19:20:20.539833 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  146. D, [2015-11-30T19:20:20.541551 #12806] DEBUG -- : Doorkeeper::AccessToken Exists (0.4ms) SELECT 1 AS one FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = '54933a7c681d6b37988ef899b22b3cc42f7ef95df08f125df71105e731f6ceea' LIMIT 1
  147. D, [2015-11-30T19:20:20.542994 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "oauth_access_tokens" ("application_id", "resource_owner_id", "token", "created_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["application_id", 4], ["resource_owner_id", 17], ["token", "54933a7c681d6b37988ef899b22b3cc42f7ef95df08f125df71105e731f6ceea"], ["created_at", "2015-11-30 17:20:20.541893"]]
  148. D, [2015-11-30T19:20:20.543696 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  149. D, [2015-11-30T19:20:20.547389 #12806] DEBUG -- : Doorkeeper::AccessToken Load (0.5ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT 1 [["token", "54933a7c681d6b37988ef899b22b3cc42f7ef95df08f125df71105e731f6ceea"]]
  150. D, [2015-11-30T19:20:20.548693 #12806] DEBUG -- : User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 17]]
  151. D, [2015-11-30T19:20:20.551716 #12806] DEBUG -- : User Load (0.5ms) SELECT "users".* FROM "users" WHERE ("users"."id" != 17)
  152. D, [2015-11-30T19:20:20.583586 #12806] DEBUG -- : (0.4ms) ROLLBACK
  153. contains array of users (FAILED - 1)
  154. D, [2015-11-30T19:20:20.584921 #12806] DEBUG -- : (0.1ms) BEGIN
  155. D, [2015-11-30T19:20:20.588336 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  156. D, [2015-11-30T19:20:20.589898 #12806] DEBUG -- : User Exists (0.4ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user18@test.com' LIMIT 1
  157. D, [2015-11-30T19:20:20.591795 #12806] DEBUG -- : SQL (0.7ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user18@test.com"], ["encrypted_password", "$2a$04$UhgSSJ75Oq5Yb9MCAiIC1OBS9BFew.lDiy2zrPkf8TEidtIdZAY9K"]]
  158. D, [2015-11-30T19:20:20.592645 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  159. D, [2015-11-30T19:20:20.596150 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  160. D, [2015-11-30T19:20:20.597612 #12806] DEBUG -- : User Exists (0.5ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user19@test.com' LIMIT 1
  161. D, [2015-11-30T19:20:20.599271 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user19@test.com"], ["encrypted_password", "$2a$04$BvkkxmexZQmGC2aCUskdw.1OO7bHkAXXpOjLNsBl/ZmsaFMSQDkZa"]]
  162. D, [2015-11-30T19:20:20.600075 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  163. D, [2015-11-30T19:20:20.603801 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  164. D, [2015-11-30T19:20:20.605554 #12806] DEBUG -- : User Exists (0.6ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user20@test.com' LIMIT 1
  165. D, [2015-11-30T19:20:20.606916 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user20@test.com"], ["encrypted_password", "$2a$04$5ih14Q.AHODSlCMEnMSPiucGPgB2FzycWK4DOhM0vOZ91LH5FGBwK"]]
  166. D, [2015-11-30T19:20:20.607713 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  167. D, [2015-11-30T19:20:20.611651 #12806] DEBUG -- : (1.0ms) SAVEPOINT active_record_1
  168. D, [2015-11-30T19:20:20.613491 #12806] DEBUG -- : User Exists (0.5ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user21@test.com' LIMIT 1
  169. D, [2015-11-30T19:20:20.614824 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user21@test.com"], ["encrypted_password", "$2a$04$tt1vTCX6Bc7y4xNrRrkoYODhBP1u2LmY3No0WK5uHiOQhTPMuNQYm"]]
  170. D, [2015-11-30T19:20:20.615601 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  171. D, [2015-11-30T19:20:20.619041 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  172. D, [2015-11-30T19:20:20.620407 #12806] DEBUG -- : User Exists (0.4ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user22@test.com' LIMIT 1
  173. D, [2015-11-30T19:20:20.622163 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user22@test.com"], ["encrypted_password", "$2a$04$0hn0GcpK5LU2opWWZwB2VOYUmLcnw6CUFtqSU6spkvimcqipRxr.W"]]
  174. D, [2015-11-30T19:20:20.622993 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  175. D, [2015-11-30T19:20:20.624469 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  176. D, [2015-11-30T19:20:20.625930 #12806] DEBUG -- : Doorkeeper::Application Exists (0.4ms) SELECT 1 AS one FROM "oauth_applications" WHERE "oauth_applications"."uid" = '12345675' LIMIT 1
  177. D, [2015-11-30T19:20:20.627531 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "oauth_applications" ("name", "redirect_uri", "uid", "secret", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["name", "Test"], ["redirect_uri", "urn:ietf:wg:oauth:2.0:oob"], ["uid", "12345675"], ["secret", "87654321"], ["created_at", "2015-11-30 17:20:20.626189"], ["updated_at", "2015-11-30 17:20:20.626189"]]
  178. D, [2015-11-30T19:20:20.628222 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  179. D, [2015-11-30T19:20:20.628963 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  180. D, [2015-11-30T19:20:20.630599 #12806] DEBUG -- : Doorkeeper::AccessToken Exists (0.5ms) SELECT 1 AS one FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = '7f3463a51fedc55f9c0237a736a6c4e5ea2a1765d9be61d0d4f0329f1c4ef650' LIMIT 1
  181. D, [2015-11-30T19:20:20.632336 #12806] DEBUG -- : SQL (0.6ms) INSERT INTO "oauth_access_tokens" ("application_id", "resource_owner_id", "token", "created_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["application_id", 5], ["resource_owner_id", 22], ["token", "7f3463a51fedc55f9c0237a736a6c4e5ea2a1765d9be61d0d4f0329f1c4ef650"], ["created_at", "2015-11-30 17:20:20.630964"]]
  182. D, [2015-11-30T19:20:20.633737 #12806] DEBUG -- : (0.6ms) RELEASE SAVEPOINT active_record_1
  183. D, [2015-11-30T19:20:20.638520 #12806] DEBUG -- : Doorkeeper::AccessToken Load (0.8ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT 1 [["token", "7f3463a51fedc55f9c0237a736a6c4e5ea2a1765d9be61d0d4f0329f1c4ef650"]]
  184. D, [2015-11-30T19:20:20.640847 #12806] DEBUG -- : User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 22]]
  185. D, [2015-11-30T19:20:20.644567 #12806] DEBUG -- : User Load (0.7ms) SELECT "users".* FROM "users" WHERE ("users"."id" != 22)
  186. D, [2015-11-30T19:20:20.654839 #12806] DEBUG -- : (0.2ms) ROLLBACK
  187. doesnt contain current user
  188. GET /me
  189. unauthorized
  190. D, [2015-11-30T19:20:20.656206 #12806] DEBUG -- : (0.1ms) BEGIN
  191. D, [2015-11-30T19:20:20.661383 #12806] DEBUG -- : (0.2ms) ROLLBACK
  192. returns 401 status if there is no access_token
  193. D, [2015-11-30T19:20:20.662538 #12806] DEBUG -- : (0.1ms) BEGIN
  194. D, [2015-11-30T19:20:20.666649 #12806] DEBUG -- : Doorkeeper::AccessToken Load (0.4ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT 1 [["token", "1234"]]
  195. D, [2015-11-30T19:20:20.667368 #12806] DEBUG -- : CACHE (0.0ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT 1 [["token", "1234"]]
  196. D, [2015-11-30T19:20:20.667904 #12806] DEBUG -- : CACHE (0.0ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT 1 [["token", "1234"]]
  197. D, [2015-11-30T19:20:20.668476 #12806] DEBUG -- : CACHE (0.0ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT 1 [["token", "1234"]]
  198. D, [2015-11-30T19:20:20.670058 #12806] DEBUG -- : (0.3ms) ROLLBACK
  199. returns 401 status if there is no access_token
  200. authorized
  201. D, [2015-11-30T19:20:20.672283 #12806] DEBUG -- : (0.2ms) BEGIN
  202. D, [2015-11-30T19:20:20.675906 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  203. D, [2015-11-30T19:20:20.677707 #12806] DEBUG -- : User Exists (0.6ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user23@test.com' LIMIT 1
  204. D, [2015-11-30T19:20:20.679433 #12806] DEBUG -- : SQL (0.5ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user23@test.com"], ["encrypted_password", "$2a$04$aWpFasAOGuKicZ9EzSZUr.AI2dVa4LGz.er4CRGFAhE7c1rSZrIoa"]]
  205. D, [2015-11-30T19:20:20.680487 #12806] DEBUG -- : (0.3ms) RELEASE SAVEPOINT active_record_1
  206. D, [2015-11-30T19:20:20.682053 #12806] DEBUG -- : (0.3ms) SAVEPOINT active_record_1
  207. D, [2015-11-30T19:20:20.683548 #12806] DEBUG -- : Doorkeeper::Application Exists (0.4ms) SELECT 1 AS one FROM "oauth_applications" WHERE "oauth_applications"."uid" = '12345676' LIMIT 1
  208. D, [2015-11-30T19:20:20.685317 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "oauth_applications" ("name", "redirect_uri", "uid", "secret", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["name", "Test"], ["redirect_uri", "urn:ietf:wg:oauth:2.0:oob"], ["uid", "12345676"], ["secret", "87654321"], ["created_at", "2015-11-30 17:20:20.683825"], ["updated_at", "2015-11-30 17:20:20.683825"]]
  209. D, [2015-11-30T19:20:20.686125 #12806] DEBUG -- : (0.3ms) RELEASE SAVEPOINT active_record_1
  210. D, [2015-11-30T19:20:20.686666 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  211. D, [2015-11-30T19:20:20.688108 #12806] DEBUG -- : Doorkeeper::AccessToken Exists (0.4ms) SELECT 1 AS one FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = 'a51b48093974c31752594d112f8d4644edce510c4326df9c4846fcc64ae54275' LIMIT 1
  212. D, [2015-11-30T19:20:20.689560 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "oauth_access_tokens" ("application_id", "resource_owner_id", "token", "created_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["application_id", 6], ["resource_owner_id", 23], ["token", "a51b48093974c31752594d112f8d4644edce510c4326df9c4846fcc64ae54275"], ["created_at", "2015-11-30 17:20:20.688439"]]
  213. D, [2015-11-30T19:20:20.690266 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  214. D, [2015-11-30T19:20:20.694817 #12806] DEBUG -- : Doorkeeper::AccessToken Load (0.8ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT 1 [["token", "a51b48093974c31752594d112f8d4644edce510c4326df9c4846fcc64ae54275"]]
  215. D, [2015-11-30T19:20:20.695957 #12806] DEBUG -- : User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 23]]
  216. D, [2015-11-30T19:20:20.702935 #12806] DEBUG -- : (0.2ms) ROLLBACK
  217. returns 200 status
  218. D, [2015-11-30T19:20:20.703982 #12806] DEBUG -- : (0.1ms) BEGIN
  219. D, [2015-11-30T19:20:20.707354 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  220. D, [2015-11-30T19:20:20.708979 #12806] DEBUG -- : User Exists (0.4ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user24@test.com' LIMIT 1
  221. D, [2015-11-30T19:20:20.710317 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user24@test.com"], ["encrypted_password", "$2a$04$o6ej.GEhVNWMNNFmXH1ecuWQfa49XG/pa3A5G6Cs4MQQTM7a5j5A6"]]
  222. D, [2015-11-30T19:20:20.712839 #12806] DEBUG -- : (1.9ms) RELEASE SAVEPOINT active_record_1
  223. D, [2015-11-30T19:20:20.714418 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  224. D, [2015-11-30T19:20:20.715968 #12806] DEBUG -- : Doorkeeper::Application Exists (0.5ms) SELECT 1 AS one FROM "oauth_applications" WHERE "oauth_applications"."uid" = '12345677' LIMIT 1
  225. D, [2015-11-30T19:20:20.718024 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "oauth_applications" ("name", "redirect_uri", "uid", "secret", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["name", "Test"], ["redirect_uri", "urn:ietf:wg:oauth:2.0:oob"], ["uid", "12345677"], ["secret", "87654321"], ["created_at", "2015-11-30 17:20:20.716294"], ["updated_at", "2015-11-30 17:20:20.716294"]]
  226. D, [2015-11-30T19:20:20.718848 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  227. D, [2015-11-30T19:20:20.719477 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  228. D, [2015-11-30T19:20:20.720977 #12806] DEBUG -- : Doorkeeper::AccessToken Exists (0.4ms) SELECT 1 AS one FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = 'c049ca4d21a8ca8cd33ae715e5f1db91048b67d7287e08f5f232c61317eb8c64' LIMIT 1
  229. D, [2015-11-30T19:20:20.722561 #12806] DEBUG -- : SQL (0.4ms) INSERT INTO "oauth_access_tokens" ("application_id", "resource_owner_id", "token", "created_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["application_id", 7], ["resource_owner_id", 24], ["token", "c049ca4d21a8ca8cd33ae715e5f1db91048b67d7287e08f5f232c61317eb8c64"], ["created_at", "2015-11-30 17:20:20.721330"]]
  230. D, [2015-11-30T19:20:20.723415 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  231. D, [2015-11-30T19:20:20.727494 #12806] DEBUG -- : Doorkeeper::AccessToken Load (0.5ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT 1 [["token", "c049ca4d21a8ca8cd33ae715e5f1db91048b67d7287e08f5f232c61317eb8c64"]]
  232. D, [2015-11-30T19:20:20.728618 #12806] DEBUG -- : User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 24]]
  233. D, [2015-11-30T19:20:20.733184 #12806] DEBUG -- : (0.3ms) ROLLBACK
  234. contains id
  235. D, [2015-11-30T19:20:20.734535 #12806] DEBUG -- : (0.2ms) BEGIN
  236. D, [2015-11-30T19:20:20.738954 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  237. D, [2015-11-30T19:20:20.741434 #12806] DEBUG -- : User Exists (1.0ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user25@test.com' LIMIT 1
  238. D, [2015-11-30T19:20:20.742922 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user25@test.com"], ["encrypted_password", "$2a$04$yVJNRbvzKgJ8QrJOGlOF0ux8jjuiJ7xcwKSm2J/ZttULfPuG2dCMG"]]
  239. D, [2015-11-30T19:20:20.744272 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  240. D, [2015-11-30T19:20:20.745646 #12806] DEBUG -- : (0.3ms) SAVEPOINT active_record_1
  241. D, [2015-11-30T19:20:20.747511 #12806] DEBUG -- : Doorkeeper::Application Exists (0.4ms) SELECT 1 AS one FROM "oauth_applications" WHERE "oauth_applications"."uid" = '12345678' LIMIT 1
  242. D, [2015-11-30T19:20:20.749010 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "oauth_applications" ("name", "redirect_uri", "uid", "secret", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["name", "Test"], ["redirect_uri", "urn:ietf:wg:oauth:2.0:oob"], ["uid", "12345678"], ["secret", "87654321"], ["created_at", "2015-11-30 17:20:20.747778"], ["updated_at", "2015-11-30 17:20:20.747778"]]
  243. D, [2015-11-30T19:20:20.749699 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  244. D, [2015-11-30T19:20:20.750172 #12806] DEBUG -- : (0.1ms) SAVEPOINT active_record_1
  245. D, [2015-11-30T19:20:20.752623 #12806] DEBUG -- : Doorkeeper::AccessToken Exists (0.9ms) SELECT 1 AS one FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = '97c785d864e6979f37d7bc52d0bba1fde8346b0c1ec9cb3d4ae0e74e57e9ab4c' LIMIT 1
  246. D, [2015-11-30T19:20:20.754633 #12806] DEBUG -- : SQL (0.8ms) INSERT INTO "oauth_access_tokens" ("application_id", "resource_owner_id", "token", "created_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["application_id", 8], ["resource_owner_id", 25], ["token", "97c785d864e6979f37d7bc52d0bba1fde8346b0c1ec9cb3d4ae0e74e57e9ab4c"], ["created_at", "2015-11-30 17:20:20.752990"]]
  247. D, [2015-11-30T19:20:20.755559 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  248. D, [2015-11-30T19:20:20.760960 #12806] DEBUG -- : Doorkeeper::AccessToken Load (0.3ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT 1 [["token", "97c785d864e6979f37d7bc52d0bba1fde8346b0c1ec9cb3d4ae0e74e57e9ab4c"]]
  249. D, [2015-11-30T19:20:20.762163 #12806] DEBUG -- : User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 25]]
  250. D, [2015-11-30T19:20:20.769545 #12806] DEBUG -- : (0.3ms) ROLLBACK
  251. contains email
  252. D, [2015-11-30T19:20:20.770552 #12806] DEBUG -- : (0.1ms) BEGIN
  253. D, [2015-11-30T19:20:20.774664 #12806] DEBUG -- : (0.3ms) SAVEPOINT active_record_1
  254. D, [2015-11-30T19:20:20.776257 #12806] DEBUG -- : User Exists (0.4ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user26@test.com' LIMIT 1
  255. D, [2015-11-30T19:20:20.778028 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user26@test.com"], ["encrypted_password", "$2a$04$nWkDUlepxCC7Ublut7WL7O1VvYxtfV.U1psVtlxELO03E8FuEG8qy"]]
  256. D, [2015-11-30T19:20:20.778880 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  257. D, [2015-11-30T19:20:20.780162 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  258. D, [2015-11-30T19:20:20.781985 #12806] DEBUG -- : Doorkeeper::Application Exists (0.4ms) SELECT 1 AS one FROM "oauth_applications" WHERE "oauth_applications"."uid" = '12345679' LIMIT 1
  259. D, [2015-11-30T19:20:20.783546 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "oauth_applications" ("name", "redirect_uri", "uid", "secret", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["name", "Test"], ["redirect_uri", "urn:ietf:wg:oauth:2.0:oob"], ["uid", "12345679"], ["secret", "87654321"], ["created_at", "2015-11-30 17:20:20.782276"], ["updated_at", "2015-11-30 17:20:20.782276"]]
  260. D, [2015-11-30T19:20:20.784408 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  261. D, [2015-11-30T19:20:20.785140 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  262. D, [2015-11-30T19:20:20.786671 #12806] DEBUG -- : Doorkeeper::AccessToken Exists (0.4ms) SELECT 1 AS one FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = '2e58d52027307377e4c7261ccb30716b7828ff9b57a19117f4198cbb1e1352f1' LIMIT 1
  263. D, [2015-11-30T19:20:20.788643 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "oauth_access_tokens" ("application_id", "resource_owner_id", "token", "created_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["application_id", 9], ["resource_owner_id", 26], ["token", "2e58d52027307377e4c7261ccb30716b7828ff9b57a19117f4198cbb1e1352f1"], ["created_at", "2015-11-30 17:20:20.787647"]]
  264. D, [2015-11-30T19:20:20.789351 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  265. D, [2015-11-30T19:20:20.793398 #12806] DEBUG -- : Doorkeeper::AccessToken Load (0.3ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT 1 [["token", "2e58d52027307377e4c7261ccb30716b7828ff9b57a19117f4198cbb1e1352f1"]]
  266. D, [2015-11-30T19:20:20.794617 #12806] DEBUG -- : User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 26]]
  267. D, [2015-11-30T19:20:20.800732 #12806] DEBUG -- : (0.6ms) ROLLBACK
  268. doesnt contain password
  269. D, [2015-11-30T19:20:20.802182 #12806] DEBUG -- : (0.1ms) BEGIN
  270. D, [2015-11-30T19:20:20.805630 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  271. D, [2015-11-30T19:20:20.807498 #12806] DEBUG -- : User Exists (0.4ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'user27@test.com' LIMIT 1
  272. D, [2015-11-30T19:20:20.808731 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "users" ("email", "encrypted_password") VALUES ($1, $2) RETURNING "id" [["email", "user27@test.com"], ["encrypted_password", "$2a$04$.CB0KhxIK7j6Ozq6U3Pfr.FI0B7xCZNCbUquwP8uR211XcLQHieCu"]]
  273. D, [2015-11-30T19:20:20.809463 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  274. D, [2015-11-30T19:20:20.810851 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  275. D, [2015-11-30T19:20:20.813674 #12806] DEBUG -- : Doorkeeper::Application Exists (1.9ms) SELECT 1 AS one FROM "oauth_applications" WHERE "oauth_applications"."uid" = '123456710' LIMIT 1
  276. D, [2015-11-30T19:20:20.818281 #12806] DEBUG -- : SQL (3.3ms) INSERT INTO "oauth_applications" ("name", "redirect_uri", "uid", "secret", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["name", "Test"], ["redirect_uri", "urn:ietf:wg:oauth:2.0:oob"], ["uid", "123456710"], ["secret", "87654321"], ["created_at", "2015-11-30 17:20:20.813950"], ["updated_at", "2015-11-30 17:20:20.813950"]]
  277. D, [2015-11-30T19:20:20.819445 #12806] DEBUG -- : (0.2ms) RELEASE SAVEPOINT active_record_1
  278. D, [2015-11-30T19:20:20.820081 #12806] DEBUG -- : (0.2ms) SAVEPOINT active_record_1
  279. D, [2015-11-30T19:20:20.821833 #12806] DEBUG -- : Doorkeeper::AccessToken Exists (0.5ms) SELECT 1 AS one FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = '6e3872b0eb59736ac0504a127e40bc3cefb5eba0ab41cc7bb4bd80502c63bb69' LIMIT 1
  280. D, [2015-11-30T19:20:20.823329 #12806] DEBUG -- : SQL (0.3ms) INSERT INTO "oauth_access_tokens" ("application_id", "resource_owner_id", "token", "created_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["application_id", 10], ["resource_owner_id", 27], ["token", "6e3872b0eb59736ac0504a127e40bc3cefb5eba0ab41cc7bb4bd80502c63bb69"], ["created_at", "2015-11-30 17:20:20.822260"]]
  281. D, [2015-11-30T19:20:20.824289 #12806] DEBUG -- : (0.4ms) RELEASE SAVEPOINT active_record_1
  282. D, [2015-11-30T19:20:20.827961 #12806] DEBUG -- : Doorkeeper::AccessToken Load (0.3ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT 1 [["token", "6e3872b0eb59736ac0504a127e40bc3cefb5eba0ab41cc7bb4bd80502c63bb69"]]
  283. D, [2015-11-30T19:20:20.828854 #12806] DEBUG -- : User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 27]]
  284. D, [2015-11-30T19:20:20.834431 #12806] DEBUG -- : (0.4ms) ROLLBACK
  285. doesnt contain encrypted_password
  286.  
  287.  
  288. Failures:
  289.  
  290. 1) Profiles API GET / authorized contains array of users
  291. Failure/Error: expect(response.body).to be_json_eql(users.to_json)
  292.  
  293. Expected equivalent JSON
  294. Diff:
  295. @@ -1,5 +1,26 @@
  296. [
  297. {
  298. + "email": "user1@test.com"
  299. + },
  300. + {
  301. + "email": "user2@test.com"
  302. + },
  303. + {
  304. + "email": "user3@test.com"
  305. + },
  306. + {
  307. + "email": "user4@test.com"
  308. + },
  309. + {
  310. + "email": "user5@test.com"
  311. + },
  312. + {
  313. + "email": "user6@test.com"
  314. + },
  315. + {
  316. + "email": "user7@test.com"
  317. + },
  318. + {
  319. "email": "user13@test.com"
  320. },
  321. {
  322.  
  323. # ./spec/api/v1/profiles_spec.rb:24:in `block (4 levels) in <top (required)>'
  324.  
  325. Finished in 3.05 seconds (files took 2.96 seconds to load)
  326. 12 examples, 1 failure
  327.  
  328. Failed examples:
  329.  
  330. rspec ./spec/api/v1/profiles_spec.rb:23 # Profiles API GET / authorized contains array of users
  331.  
  332. lutsko@lutsko-X55A:~/project/qna$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!