Guest User

Untitled

a guest
Feb 20th, 2018
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.71 KB | None | 0 0
  1. irb(main):008:0> v = VhostUser.create(:username => "aj", :password => "non-crypt-password", :ssl => true, :mysql => true, :pgsql => true)
  2. ~ SELECT "id", "username" FROM "vhost_users" WHERE ("username" = 'aj') ORDER BY "id", "username" LIMIT 1
  3. ~ SELECT "id", "username" FROM "vhost_users" WHERE ("username" = 'aj') ORDER BY "id", "username" LIMIT 1
  4. ~ SELECT "id", "name", "vhost_user_id", "vhost_user_username" FROM "mysql_databases" WHERE ("vhost_user_id" IN (NULL)) AND ("vhost_user_username" IN ('aj')) ORDER BY "id"
  5. ~ SELECT COUNT(*) FROM "mysql_databases" WHERE ("vhost_user_id" IN (NULL)) AND ("vhost_user_username" IN ('aj'))
  6. ~ SELECT "id" FROM "mysql_databases" WHERE ("name" = 'aj') ORDER BY "id" LIMIT 1
  7. ~ INSERT INTO "mysql_databases" ("vhost_user_username", "name") VALUES ('aj', 'aj')
  8. ~ SELECT "id", "username", "password", "mysql_database_id" FROM "mysql_database_users" WHERE ("mysql_database_id" IN (1)) ORDER BY "id"
  9. ~ SELECT "id" FROM "mysql_database_users" WHERE ("username" = 'aj') ORDER BY "id" LIMIT 1
  10. ~ INSERT INTO "mysql_database_users" ("mysql_database_id", "username", "password") VALUES (1, 'aj', 'non-crypt-password')
  11. ~ SELECT "id", "name", "vhost_user_id", "vhost_user_username" FROM "pgsql_databases" WHERE ("vhost_user_id" IN (NULL)) AND ("vhost_user_username" IN ('aj')) ORDER BY "id"
  12. ~ SELECT COUNT(*) FROM "pgsql_databases" WHERE ("vhost_user_id" IN (NULL)) AND ("vhost_user_username" IN ('aj'))
  13. ~ SELECT "id" FROM "pgsql_databases" WHERE ("name" = 'aj') ORDER BY "id" LIMIT 1
  14. ~ INSERT INTO "pgsql_databases" ("name", "vhost_user_username") VALUES ('aj', 'aj')
  15. ~ SELECT "id", "username", "password", "pgsql_database_id" FROM "pgsql_database_users" WHERE ("pgsql_database_id" IN (1)) ORDER BY "id"
  16. ~ SELECT "id" FROM "pgsql_database_users" WHERE ("username" = 'aj') ORDER BY "id" LIMIT 1
  17. ~ INSERT INTO "pgsql_database_users" ("password", "username", "pgsql_database_id") VALUES ('non-crypt-password', 'aj', 1)
  18. ~ INSERT INTO "vhost_users" ("username", "quota", "mysql", "statistics", "ssl", "pgsql", "suspended", "password") VALUES ('aj', 0, 't', 'f', 't', 't', 't', 'non-crypt-password')
  19. ~ SELECT "id" FROM "mysql_databases" WHERE ("name" = 'aj') ORDER BY "id" LIMIT 1
  20. ~ UPDATE "mysql_databases" SET "vhost_user_id" = 1 WHERE ("id" = 1)
  21. ~ SELECT "id" FROM "mysql_database_users" WHERE ("username" = 'aj') ORDER BY "id" LIMIT 1
  22. ~ SELECT "id" FROM "pgsql_databases" WHERE ("name" = 'aj') ORDER BY "id" LIMIT 1
  23. ~ UPDATE "pgsql_databases" SET "vhost_user_id" = 1 WHERE ("id" = 1)
  24. ~ SELECT "id" FROM "pgsql_database_users" WHERE ("username" = 'aj') ORDER BY "id" LIMIT 1
  25. => #<VhostUser id=1 username="aj" password="non-crypt-password" quota=0 ssl=true mysql=true pgsql=true statistics=false suspended=true>
Add Comment
Please, Sign In to add comment