test.log

   (14.2ms)  ALTER TABLE "certificates" DISABLE TRIGGER ALL;ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "keys" DISABLE TRIGGER ALL
   (0.2ms)  select current_database()
   (1.5ms)  select table_name from information_schema.views where table_schema = 'securesignapp_test'
   (3.8ms)  TRUNCATE TABLE "certificates" RESTART IDENTITY CASCADE;
   (6.6ms)  TRUNCATE TABLE "users" RESTART IDENTITY CASCADE;
   (2.4ms)  TRUNCATE TABLE "keys" RESTART IDENTITY CASCADE;
   (0.3ms)  ALTER TABLE "certificates" ENABLE TRIGGER ALL;ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "keys" ENABLE TRIGGER ALL
  User Load (0.4ms)  SELECT "users".* FROM "users" 
  Key Load (0.3ms)  SELECT "keys".* FROM "keys" 
  Certificate Load (0.4ms)  SELECT "certificates".* FROM "certificates" 
   (0.1ms)  BEGIN
   (0.6ms)  SELECT 1 FROM "users" WHERE LOWER("users"."login") = LOWER('foo1') LIMIT 1
   (0.2ms)  SELECT 1 FROM "users" WHERE LOWER("users"."email") = LOWER('[email protected]') LIMIT 1
  SQL (8.4ms)  INSERT INTO "users" ("created_at", "display_name", "email", "first_name", "last_name", "login", "password_digest", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id"  [["created_at", Sun, 18 Sep 2011 19:05:57 UTC +00:00], ["display_name", "foo1"], ["email", "[email protected]"], ["first_name", "First"], ["last_name", "Last"], ["login", "foo1"], ["password_digest", "$2a$10$jgz5/bcEFk1hfd3/BUKOJ.FHkOvgEhu.JIAWZc5CtgIiYg.tasbcG"], ["updated_at", Sun, 18 Sep 2011 19:05:57 UTC +00:00]]
   (1.3ms)  COMMIT
   (0.1ms)  BEGIN
  User Load (0.6ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
   (0.7ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."login") = LOWER('foo1') AND "users"."id" != 1) LIMIT 1
   (0.3ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."email") = LOWER('[email protected]') AND "users"."id" != 1) LIMIT 1
  SQL (1.0ms)  INSERT INTO "keys" ("body", "created_at", "password_digest", "title", "updated_at", "user_id") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id"  [["body", nil], ["created_at", Sun, 18 Sep 2011 19:05:57 UTC +00:00], ["password_digest", "$2a$10$HlJEbdG7GhjepKNQl33JYuk5oIyIUIlKXbajcmsCuOhPM3L.Q2cKS"], ["title", "foo1"], ["updated_at", Sun, 18 Sep 2011 19:05:57 UTC +00:00], ["user_id", 1]]
   (1.1ms)  COMMIT
   (0.2ms)  BEGIN
   (0.6ms)  UPDATE "keys" SET "body" = '-----BEGIN RSA PRIVATE KEY-----
Proc-Type: 4,ENCRYPTED
DEK-Info: AES-256-CBC,AA9237587B1FDD23ADA7BE15EB6F6866

ycPMq4i+bpKSYTn8mBuFdFBufyYQBGQudXLopVXJI1es3MP0gwLsn6i6HymGh8HL
Xijy+JeDgRzo4nc0UL8+Z5S9GQVbAj3pxNZjncuv8VaKXxBVpr+S+TvP2RzEawFB
C6lZ7epsYjvk1RZTqw6KBLv0jQulfUX5FRwCZkA3YOYX3d7sLWH246gFblGYrR2g
qnegjvPufrTxO/QksfscA7xXyZQwADzaHba3KW0K/eXcz2RVgfy2Rg+Y4BUeuWVf
f+blJSWuFsAEMM+zPokltJBdn9yEN9gsURbO23LBAuEaVj/1M07sT8jPfxvmatdj
qkIMszfyuHshW1lk8FDoZGiok9ivxTAXCO/+VkOzDMQfPGZqc0fj2H2wPiQ+7P3c
HQPV9bVEBPpfmVFlVfrE6Q0sLpX6mvailwy6+Ccqb7KtQ2yAQJYkPrwBe35yYzaL
343eg9vXqtSI4oCi4neidWVTSHeTbSFoa8Rdd4/EMLjmyW45qDxPaopzGYwA27tO
qqfc6WrH6R9NMqMT8k7QFRRK/GM9F+LF3fh7AFGOp4aZL6vCLAmATNzy+g7T/37R
D1+DWmjy1+fKhuZDeGiWsqAPO4ii+isTTWe/VqFWk4EunTBWKHQrVKy3WToEZB76
jKyN8cPpb+63t0oppcqQL7EWHlASfJas5mbgAlTy+S7VSO14nYYlgjXMYipe0VVT
Jm59bMRXkP7OZDj2jz3N16pKPzuaBiQphqUVM1xjkYV2Da1UybaRPqGxzWV3L4sJ
zHP+HdrgAuAiGQl0lLQeeE3dlxHSn/Mp5GdY3DQTTPAJXVvfJipFVTIHyqYoQhZ5
yRlITcENwos9zHrPoyYdacK0sf+vlv06Fsa6VYFBgCMwck/X1bux6g4HE/+BHTtS
FbjVlXVIHYZE9dH9c4Z5+JXvoxYkMWfUw5GnbW7XWJ1gimwePvIC6hXqL1gkvCVn
h3JtCuxMp/MlcL6m51zzf3a95pv3XPqlbxzVCk4Yh1+5uI2vMiHq8YedEy03rds1
nENpApC/x9HtJEihstg3QEFU+eTCdOkm607uptNwIrm4HiWyRr14xLbFlEN3JlM6
mdWEAWPF7E4sLYy7coXZj1qJ/y2Vuqv7gYXqpxlGeZ9GmYzarihnC5/TDV/gFFoO
YKRwmWorb+Q6jEAlCye14BqD/heL3BfSA9s8JQ3m8smiGAp36Lt1RoZW3q2ECu5o
HNIuJ3oyvmZCSfC9utQK+a8NqE61pDByQfdBVa31pNSn/X1CfHSxJ6p+YX5DikLk
ZXUhC4aD8GABQACpBeVLhKC6UFtOVVl/FWT7bmGf3kTMRgE0qVA2A6aZCd/8R+h7
HJ8KkYi3ETP3n11/ATjzEaH6W9uBWJImPvTht18a1iXbrZfIcCBkwgzWT49HRWh6
neSVukm4cWc5Xj87jSjtI3duzgeALDkGe9Vy2lryXxB1HlyRqWvZh5Tl7PdTYn3u
WkXmkbUGvDoB8CuN+AYd7BSlIcyHtyJF9jt4NifzigY+/kfaEOILA1bX1dAkbFhq
wCAVkm7ce1YRVrODslGK6VA4VrbqCsCETC44aBwrW+4HVJ9Fs+cvQ4xpFjpuUT+s
-----END RSA PRIVATE KEY-----
', "updated_at" = '2011-09-18 19:05:58.119884' WHERE "keys"."id" = 1
   (0.6ms)  COMMIT
   (0.1ms)  BEGIN
  User Load (0.3ms)  SELECT "users".* FROM "users" LIMIT 1
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
   (0.3ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."login") = LOWER('foo1') AND "users"."id" != 1) LIMIT 1
   (0.2ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."email") = LOWER('[email protected]') AND "users"."id" != 1) LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 1 LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
   (0.3ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."login") = LOWER('foo1') AND "users"."id" != 1) LIMIT 1
   (0.2ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."email") = LOWER('[email protected]') AND "users"."id" != 1) LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 1 LIMIT 1
  SQL (1.1ms)  INSERT INTO "certificates" ("body", "ca_name", "certificate_id", "common_name", "country", "created_at", "days", "email", "key_id", "locality", "organization", "organization_unit", "request_status", "state", "title", "updated_at", "user_id") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17) RETURNING "id"  [["body", nil], ["ca_name", nil], ["certificate_id", 0], ["common_name", "example.com"], ["country", "RU"], ["created_at", Sun, 18 Sep 2011 19:05:58 UTC +00:00], ["days", 365], ["email", "[email protected]"], ["key_id", 1], ["locality", "Moscow"], ["organization", "SecureSign"], ["organization_unit", "SecureSign Certificate Authority"], ["request_status", nil], ["state", "Central Federal District"], ["title", "FooBar"], ["updated_at", Sun, 18 Sep 2011 19:05:58 UTC +00:00], ["user_id", 1]]
   (0.6ms)  COMMIT
  Key Load (0.3ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 1 LIMIT 1
   (0.5ms)  BEGIN
   (0.5ms)  UPDATE "certificates" SET "body" = '', "updated_at" = '2011-09-18 19:05:58.370330' WHERE "certificates"."id" = 1
   (0.4ms)  COMMIT
   (0.3ms)  BEGIN
   (0.4ms)  UPDATE "certificates" SET "request_status" = 1, "updated_at" = '2011-09-18 19:05:58.394994' WHERE "certificates"."id" = 1
   (0.6ms)  COMMIT