API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 29th, 2016
104
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Ruby 6.42 KB | None | 0 0
raw download clone embed print report
  1. Loading development environment (Rails 5.0.0.1)
  2. [1] pry(main)>
  3. [1] pry(main)> admin = User.find_or_initialize_by(id: 1)
  4.   User Load (0.8ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  5. => #<User:0x000000042cb420
  6.  id: 1,
  7.  email: nil,
  8.  crypted_password: nil,
  9.  salt: nil,
  10.  first_name: nil,
  11.  last_name: nil,
  12.  created_at: nil,
  13.  updated_at: nil,
  14.  remember_me_token: nil,
  15.  remember_me_token_expires_at: nil,
  16.  reset_password_token: nil,
  17.  reset_password_token_expires_at: nil,
  18.  reset_password_email_sent_at: nil,
  19.  activation_state: nil,
  20.  activation_token: nil,
  21.  activation_token_expires_at: nil,
  22.  last_login_at: nil,
  23.  last_logout_at: nil,
  24.  last_activity_at: nil,
  25.  last_login_from_ip_address: nil>
  26. [2] pry(main)> data = {
  27. [2] pry(main)*   first_name: "super",  
  28. [2] pry(main)*   last_name: "admin",  
  29. [2] pry(main)*   email: "admin@qtile.com",  
  30. [2] pry(main)*   password: "qwerty"  
  31. [2] pry(main)* }  
  32. => {:first_name=>"super", :last_name=>"admin", :email=>"admin@qtile.com", :password=>"qwerty"}
  33. [3] pry(main)> admin.assign_attributes(data)
  34. => nil
  35. [4] pry(main)> admin.send(:encrypt_password)
  36. => "$2a$10$tNJGINrNLNJkrxdsjXVk2uydVGcj2EzGaoRPHH.Z/O8Hvjl7gxT3m"
  37. [5] pry(main)> admin
  38. => #<User:0x000000042cb420
  39.  id: 1,
  40.  email: "admin@qtile.com",
  41.  crypted_password: "$2a$10$tNJGINrNLNJkrxdsjXVk2uydVGcj2EzGaoRPHH.Z/O8Hvjl7gxT3m",
  42.  salt: "AiWvwM7xzs2WxbMRgvoR",
  43.  first_name: "super",
  44.  last_name: "admin",
  45.  created_at: nil,
  46.  updated_at: nil,
  47.  remember_me_token: nil,
  48.  remember_me_token_expires_at: nil,
  49.  reset_password_token: nil,
  50.  reset_password_token_expires_at: nil,
  51.  reset_password_email_sent_at: nil,
  52.  activation_state: nil,
  53.  activation_token: nil,
  54.  activation_token_expires_at: nil,
  55.  last_login_at: nil,
  56.  last_logout_at: nil,
  57.  last_activity_at: nil,
  58.  last_login_from_ip_address: nil>
  59. [6] pry(main)> admin.save!(validate: false)
  60.    (0.2ms)  BEGIN
  61.   SQL (0.7ms)  INSERT INTO "users" ("id", "email", "crypted_password", "salt", "first_name", "last_name", "created_at", "updated_at", "activation_state", "activation_token") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) RETURNING "id"  [["id", 1], ["email", "admin@qtile.com"], ["crypted_password", "$2a$10$tNJGINrNLNJkrxdsjXVk2uydVGcj2EzGaoRPHH.Z/O8Hvjl7gxT3m"], ["salt", "AiWvwM7xzs2WxbMRgvoR"], ["first_name", "super"], ["last_name", "admin"], ["created_at", 2016-09-29 10:40:39 UTC], ["updated_at", 2016-09-29 10:40:39 UTC], ["activation_state", "pending"], ["activation_token", "Ug8x2s3R8c9s5tLYhHms"]]
  62.    (0.7ms)  COMMIT
  63. => true
  64. [7] pry(main)> admin.activate!
  65.    (0.1ms)  BEGIN
  66.   SQL (0.5ms)  UPDATE "users" SET "updated_at" = $1, "activation_state" = $2, "activation_token" = $3 WHERE "users"."id" = $4  [["updated_at", 2016-09-29 10:40:39 UTC], ["activation_state", "active"], ["activation_token", nil], ["id", 1]]
  67.    (0.6ms)  COMMIT
  68. => true
  69. [8] pry(main)> admin.add_role(:admin)
  70.   Role Load (0.5ms)  SELECT  "roles".* FROM "roles" WHERE "roles"."name" = $1 AND "roles"."resource_type" IS NULL AND "roles"."resource_id" IS NULL ORDER BY "roles"."id" ASC LIMIT $2  [["name", "admin"], ["LIMIT", 1]]
  71.    (0.1ms)  BEGIN
  72.   SQL (0.5ms)  INSERT INTO "roles" ("name", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id"  [["name", "admin"], ["created_at", 2016-09-29 10:40:39 UTC], ["updated_at", 2016-09-29 10:40:39 UTC]]
  73.    (0.6ms)  COMMIT
  74.   Role Exists (0.5ms)  SELECT  1 AS one FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = $1 AND "roles"."id" = $2 LIMIT $3  [["user_id", 1], ["id", 1], ["LIMIT", 1]]
  75.    (0.4ms)  SELECT "roles".id FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = $1  [["user_id", 1]]
  76.   Role Load (0.3ms)  SELECT "roles".* FROM "roles" WHERE "roles"."id" = 1
  77.   Role Load (0.5ms)  SELECT "roles".* FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = $1  [["user_id", 1]]
  78.    (0.1ms)  BEGIN
  79.   SQL (0.8ms)  INSERT INTO "users_roles" ("user_id", "role_id") VALUES ($1, $2)  [["user_id", 1], ["role_id", 1]]
  80.    (0.8ms)  COMMIT
  81. => #<Role:0x00000005b55338 id: 1, name: "admin", resource_type: nil, resource_id: nil, created_at: Thu, 29 Sep 2016 10:40:39 UTC +00:00, updated_at: Thu, 29 Sep 2016 10:40:39 UTC +00:00>
  82. [9] pry(main)> user = User.new
  83. => #<User:0x00000004040480
  84.  id: nil,
  85.  email: nil,
  86.  crypted_password: nil,
  87.  salt: nil,
  88.  first_name: nil,
  89.  last_name: nil,
  90.  created_at: nil,
  91.  updated_at: nil,
  92.  remember_me_token: nil,
  93.  remember_me_token_expires_at: nil,
  94.  reset_password_token: nil,
  95.  reset_password_token_expires_at: nil,
  96.  reset_password_email_sent_at: nil,
  97.  activation_state: nil,
  98.  activation_token: nil,
  99.  activation_token_expires_at: nil,
  100.  last_login_at: nil,
  101.  last_logout_at: nil,
  102.  last_activity_at: nil,
  103.  last_login_from_ip_address: nil>
  104. [10] pry(main)> user.assign_attributes email: "test@mail.com", first_name: "Test", last_name: "User", password: "querty"
  105. => nil
  106. [11] pry(main)> user.valid?
  107.   User Exists (0.6ms)  SELECT  1 AS one FROM "users" WHERE "users"."email" = $1 LIMIT $2  [["email", "test@mail.com"], ["LIMIT", 1]]
  108. => true
  109. [12] pry(main)> user.save
  110.    (0.2ms)  BEGIN
  111.   User Exists (0.4ms)  SELECT  1 AS one FROM "users" WHERE "users"."email" = $1 LIMIT $2  [["email", "test@mail.com"], ["LIMIT", 1]]
  112.   SQL (1.0ms)  INSERT INTO "users" ("email", "crypted_password", "salt", "first_name", "last_name", "created_at", "updated_at", "activation_state", "activation_token") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id"  [["email", "test@mail.com"], ["crypted_password", "$2a$10$ul6fKZbd2mRgjYWjf.quyOSyZkGzyfJSAcZmQ33dZEqfeVItxFmg."], ["salt", "w4ZDdNq9Fy3r3HVexFfo"], ["first_name", "Test"], ["last_name", "User"], ["created_at", 2016-09-29 10:42:58 UTC], ["updated_at", 2016-09-29 10:42:58 UTC], ["activation_state", "pending"], ["activation_token", "1iswCp23X61HaHsxqMaL"]]
  113.    (0.1ms)  ROLLBACK
  114. ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "users_pkey"
  115. DETAIL:  Key (id)=(1) already exists.
  116. : INSERT INTO "users" ("email", "crypted_password", "salt", "first_name", "last_name", "created_at", "updated_at", "activation_state", "activation_token") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id"
  117. from /home/artem/.rvm/gems/ruby-2.3.0@qtile/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `async_exec'
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!