Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- irb(main):008:0> v = VhostUser.create(:username => "aj", :password => "non-crypt-password", :ssl => true, :mysql => true, :pgsql => true)
- ~ SELECT "id", "username" FROM "vhost_users" WHERE ("username" = 'aj') ORDER BY "id", "username" LIMIT 1
- ~ SELECT "id", "username" FROM "vhost_users" WHERE ("username" = 'aj') ORDER BY "id", "username" LIMIT 1
- ~ 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"
- ~ SELECT COUNT(*) FROM "mysql_databases" WHERE ("vhost_user_id" IN (NULL)) AND ("vhost_user_username" IN ('aj'))
- ~ SELECT "id" FROM "mysql_databases" WHERE ("name" = 'aj') ORDER BY "id" LIMIT 1
- ~ INSERT INTO "mysql_databases" ("vhost_user_username", "name") VALUES ('aj', 'aj')
- ~ SELECT "id", "username", "password", "mysql_database_id" FROM "mysql_database_users" WHERE ("mysql_database_id" IN (1)) ORDER BY "id"
- ~ SELECT "id" FROM "mysql_database_users" WHERE ("username" = 'aj') ORDER BY "id" LIMIT 1
- ~ INSERT INTO "mysql_database_users" ("mysql_database_id", "username", "password") VALUES (1, 'aj', 'non-crypt-password')
- ~ 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"
- ~ SELECT COUNT(*) FROM "pgsql_databases" WHERE ("vhost_user_id" IN (NULL)) AND ("vhost_user_username" IN ('aj'))
- ~ SELECT "id" FROM "pgsql_databases" WHERE ("name" = 'aj') ORDER BY "id" LIMIT 1
- ~ INSERT INTO "pgsql_databases" ("name", "vhost_user_username") VALUES ('aj', 'aj')
- ~ SELECT "id", "username", "password", "pgsql_database_id" FROM "pgsql_database_users" WHERE ("pgsql_database_id" IN (1)) ORDER BY "id"
- ~ SELECT "id" FROM "pgsql_database_users" WHERE ("username" = 'aj') ORDER BY "id" LIMIT 1
- ~ INSERT INTO "pgsql_database_users" ("password", "username", "pgsql_database_id") VALUES ('non-crypt-password', 'aj', 1)
- ~ INSERT INTO "vhost_users" ("username", "quota", "mysql", "statistics", "ssl", "pgsql", "suspended", "password") VALUES ('aj', 0, 't', 'f', 't', 't', 't', 'non-crypt-password')
- ~ SELECT "id" FROM "mysql_databases" WHERE ("name" = 'aj') ORDER BY "id" LIMIT 1
- ~ UPDATE "mysql_databases" SET "vhost_user_id" = 1 WHERE ("id" = 1)
- ~ SELECT "id" FROM "mysql_database_users" WHERE ("username" = 'aj') ORDER BY "id" LIMIT 1
- ~ SELECT "id" FROM "pgsql_databases" WHERE ("name" = 'aj') ORDER BY "id" LIMIT 1
- ~ UPDATE "pgsql_databases" SET "vhost_user_id" = 1 WHERE ("id" = 1)
- ~ SELECT "id" FROM "pgsql_database_users" WHERE ("username" = 'aj') ORDER BY "id" LIMIT 1
- => #<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