test.log

   (0.4ms)  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.1ms)  select current_database()
   (1.3ms)  select table_name from information_schema.views where table_schema = 'securesignapp_test'
   (3.8ms)  TRUNCATE TABLE "certificates" RESTART IDENTITY CASCADE;
   (3.8ms)  TRUNCATE TABLE "users" RESTART IDENTITY CASCADE;
   (3.0ms)  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.5ms)  SELECT "users".* FROM "users" 
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" 
  Certificate Load (0.5ms)  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 (6.7ms)  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:01:11 UTC +00:00], ["display_name", "foo1"], ["email", "[email protected]"], ["first_name", "First"], ["last_name", "Last"], ["login", "foo1"], ["password_digest", "$2a$10$JegKCdQPlZas.BtEow87kOLJj.lQQmVIkQEwyUYTlMCwdTxdqi2KG"], ["updated_at", Sun, 18 Sep 2011 19:01:11 UTC +00:00]]
   (0.9ms)  COMMIT
   (0.1ms)  BEGIN
  User Load (0.6ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
   (0.5ms)  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:01:11 UTC +00:00], ["password_digest", "$2a$10$MaiaqBU1MhvmF7A.w/8U7exLkoTmngOR0E8I4YOYMLsDhul2RMir2"], ["title", "foo1"], ["updated_at", Sun, 18 Sep 2011 19:01:11 UTC +00:00], ["user_id", 1]]
   (0.6ms)  COMMIT
   (0.4ms)  BEGIN
   (0.6ms)  UPDATE "keys" SET "body" = '-----BEGIN RSA PRIVATE KEY-----
Proc-Type: 4,ENCRYPTED
DEK-Info: AES-256-CBC,8FC8F469DC7DCCF0CCE20A3F551EF962

pXyro4D1YoaKkMUVYwfuGJeUaPfyRyPKMLsrS+AHlIsNsdyJVVbx6TQnz2Ll5xVz
xI5Je8h5HJ+hHye+j4UdrBW7qaB/+ud0U+s3wXzbOVkl05uGp54IcldpyoNw371o
HkzIhjF69nGcppTn0LRFdHfhH+AFIR6HAmWcwzvjzDWtYctBaZLYjU3ZmX/q7WGV
qtP+JRXBgW3yuOunZfGtmj/cP2chnN8Z1DxHuqH0tA7qIacWK400ltNAx+UAcgCT
N6CySuB+GOTmdgW3W0uGUW5yNcvVjldVLSS0zQkV4raQA9jmbtfdIpYtqxmmhFgb
m7+vmfI03lQ+aKRzAhT/Hebk177RfAhJVBvXOKPzus7/K/Sfiy3NiLO+exoPIOhp
6sQ0oSVgzL9R/UJDHE+xL2H/boLE86BXNoeKlumG7szEYBdrfO7zArG+ayMevz/c
7WOI3Asvlt7+sV18mk2h1evjYpXz1r0p153GM4T/iwj//wK/oy87OdhL0/Qyb7U3
YAwcJnGPZrPcfGeivjuPW6dYMoa/P0fYNzs6HFT2GVGvtPJVsMinXHpMtWK23RY0
M3OXqzWQMIiEbIuZbe1NK0HXyw8ltrFvKu5R9AsKJfI5jAmg89w3lynd5J1QpHZ/
1JFQDQFObrGj9RoxwnfU2bo0+aBRgggVRQEA1D11NkwJ4Xg1UHnoovgbvJ81mWyd
C0M+Qiu9e3T/HRRHOhoob+oUXqurEsmKZd1um4YeQoiUqSDV28gGI3MPffGJjJdT
R4mzbhXMsb9ZEKZIblpcdvXqPgOoqQwcLcfhGBsIF+iZHeuyZdb1NcmgWuw6K2CH
GLEXqGLC9l8sVQFXsG2nRgxVjEiSWkm1yT+HIlsKexsHNx2Ot2PzguLefxZb+Hh3
/R43BRe/Lstx70sQG4YZu5KxRg3inYl97p7Mc+s5K45eiAaO4OwO28UHf+I+bKWp
Cabo+6mnis4Y6EarXsPyZ5e6JhgaB58dZr8mC6JMeeatgCgm8IGKFq3MTy+l7TF3
9lyB+3yD0ujKevG1aGVLqL5SqOcmmFGG7Gr79vozRDQwKLAyPsB6UX28XVKoQgKH
RmLCqAijQC8hlx8Z8nEokZARtoYRa8n8T5/yp4oBcWXXROFrIJH6Eed88iTHEaFM
QQ/PjqH72I1aUbWqwfrgY2YgaXknfzM/vdSwdpFjy8evVISyG9/KtrkRYspgUwHk
N8TAY+1OX/ZPWCgc9izNjCE3rKdIrp54fmC7u+0afTiHKY7GdAEwsSzXwa8NVqNY
q7nKQvTBVp6Koa7LQ/B1jWKnVaNiCP/duJsSpKpzPX9GBPwf6ZAHdF9GI7Cmgc8S
gdfVs4cXtQ+pwq94+MXyATUCx5Sy/nfKAgyW9Dh2Ldh2Dl6YtWv+iZGpoKO0EG+c
yU6k7f0EP2AGI3S8bbDY3PZCFMImbax4opokgEZdK3PWYPkKIVr6FfoTWFcg041d
L44gGsm89ZY55swMstvsLMYdnY3tX5bPAM2die5I0sc9jaJmrhL/27WukcbwkFal
Hj9959mIudayAxmCcOK330igz8g82YV0k9AAcKbCfHNliuLr0Qhtrl7hEooa7Al/
-----END RSA PRIVATE KEY-----
', "updated_at" = '2011-09-18 19:01:12.117920' WHERE "keys"."id" = 1
   (0.6ms)  COMMIT
  User Load (0.4ms)  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
  User Load (0.3ms)  SELECT "users".* FROM "users" 
   (0.1ms)  BEGIN
  SQL (0.4ms)  DELETE FROM "users" WHERE "users"."id" = $1  [["id", 1]]
   (0.6ms)  COMMIT
  Key Load (0.3ms)  SELECT "keys".* FROM "keys" 
   (0.1ms)  BEGIN
  SQL (0.3ms)  DELETE FROM "keys" WHERE "keys"."id" = $1  [["id", 1]]
   (0.6ms)  COMMIT
  Certificate Load (0.2ms)  SELECT "certificates".* FROM "certificates" 
   (0.1ms)  BEGIN
   (0.4ms)  SELECT 1 FROM "users" WHERE LOWER("users"."login") = LOWER('foo2') LIMIT 1
   (0.2ms)  SELECT 1 FROM "users" WHERE LOWER("users"."email") = LOWER('[email protected]') LIMIT 1
  SQL (0.6ms)  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:01:12 UTC +00:00], ["display_name", "foo2"], ["email", "[email protected]"], ["first_name", "First"], ["last_name", "Last"], ["login", "foo2"], ["password_digest", "$2a$10$cAdQuAyJaYB1JOnamFnJbu0x6UzQdEC9VZZLKc8cjdCr22h3AYd1W"], ["updated_at", Sun, 18 Sep 2011 19:01:12 UTC +00:00]]
   (0.6ms)  COMMIT
   (0.1ms)  BEGIN
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  SQL (0.3ms)  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:01:12 UTC +00:00], ["password_digest", "$2a$10$CDQdCgpVcnvzaiVaJT4SAufDoOulxfsIc31FjPH1lnUz2Dz3uEd/q"], ["title", "foo2"], ["updated_at", Sun, 18 Sep 2011 19:01:12 UTC +00:00], ["user_id", 1]]
   (0.6ms)  COMMIT
   (0.9ms)  BEGIN
   (0.4ms)  UPDATE "keys" SET "body" = '-----BEGIN RSA PRIVATE KEY-----
Proc-Type: 4,ENCRYPTED
DEK-Info: AES-256-CBC,00ECBE85E0933E8822F3082F6A9FFB60

VwZi/FbBjj6txgUsAHRFTTs1WUGnH0n54OA4wmRfZwkIOQjrx+le/Ww2h0maOuHk
CNn8kL7afBEWG8YbBV8ev/3aUKraTVM6YADZq6wN6ZXBD5ntPR1Y7XGg8P+G1xhw
yb83ghGwyFoTiyLfr2EKOotbcrO1HMpiQ6LkEWFd96QJ2/hDq5KI6rmi15i4p4oc
ZTN9K7A6yqrl1Uxn7wUh/c7Bl893K/UjtMFws8dBJwKW7AP7i3DldjXsyk57WffO
g4j1PKhLranzfO7sIXcxp4pipKChONx0hICr9P2pC1/BV7eiKiZgZfdoSL7T0Gfs
Zko6DtGVMz/Tu/5ZYHLGav67fjoiKBLCEM9zEhINjWPGmMfzsY7/8CpNcd7bZBAL
jI5UXPnMy1tFrtZKmPIzerahzFeAuSjQURJQ9XgxZyrZhv9huk4KKgeay9OItn+0
R9zbsg6suT2FfmQd8qkBZthIcru/Vo0XVZicLtcROb/6R197n6fm+pPl4jkhJzVt
tpI8nnoQvFCZuMTbfjvx274pUkqK8HKnjgoMjdh4UPoih6ZXHkm7EWVt695NRrKB
g9TsuzyiMRLyLE6OcBQkJ0V1JD+nzPlxLmgdfwoDWMBLOpZXv1iqz00y7BUqzEe9
TXvUhg/0B3seVasDraGTBjjT0EGxQmhcWeV4G6b+P/A0P+RhDaKlgmhJXYf6Yxxs
XIhHnDIRk4Il+GhMy/KJA5ygWKXiPZ0QcdQ9azsubVXSjIpRBA4gsuxuzaIg6Dxq
kw7yOoQtNl9C8EYbOZOJ+WC21Mhp/9jnuBgN+auH0gcuIKcVn1CiSskRwrONttVb
SUMqENcRMbzLWV8ZxFSCY58eIKBZppA36sx9OM0BInIq2e5AK4PNA/ZZxkgRAA5o
zybVs8kooIPzdK54v3czbUxqxrvoT6b5z1eef5qCB0Yp2Vos1RMK0s5wselRB3hX
YwmTMfokmSNI1fAwHEVVJrFwgJ9Yjq8WxWtz24rw0VsarTJOV4MgYthfwM4bxxe7
4Ygj5sWkgeYYGJ4qH4lZRr9RZcMwTFEPYVmp+EYsK3azzKldsPJZTgRh6tgDP6SL
trV8ITRT96Zi5JmytDYiV2ackjkTVjfL22yRy+Un3DVmRFZEohJi7zAL12YCJgk4
b2AsvWXIAIdn6Dy8ZCmAGyFipfduLK3s+bImxbdqp+wWGlQnGN8VDxHcFBLuOZDX
Fb9S5kPtJp6ZMARqoCJykyzis6t8stZDtA3QHS0FmlDdquV3kyrZhUKc2JS7rnPa
TjS92tYMZ8oyCz2aw2hbrfxQNJPxYMOkq38V9sfwcYfnnGBoc/K6iqnzSr45TwuE
7Nsgyk+WPNTxZa3ePI/8EHn/1nZQiRPWAcD7x+ARGbmP2pUa6WL9v3vRfhYcolau
pQ/1UAC0y3HTx7nyAQGdhNtTPPTiitc8+rcrFQyZO5tXZhPT/GPpZOJMRkbaDTT3
xnfbNtxsyP/r5QUnZ3W6JO9QDh1p2Fp5wJTR8e0DvlZuPhR8HkWPEvAZrMvZjMpI
hkBliyWZGhfMoJSndTjLFBqHjZp4Fv8sMjvI8T/sFuMr8jYon4BwoFw+RTmn5BvG
-----END RSA PRIVATE KEY-----
', "updated_at" = '2011-09-18 19:01:12.519460' WHERE "keys"."id" = 2
   (0.6ms)  COMMIT
  User Load (0.5ms)  SELECT "users".* FROM "users" LIMIT 1
  User Load (0.5ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1
   (0.4ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."login") = LOWER('foo2') AND "users"."id" != 2) LIMIT 1
   (0.2ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."email") = LOWER('[email protected]') AND "users"."id" != 2) LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 2 LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 2 LIMIT 1
  User Load (0.4ms)  SELECT "users".* FROM "users" LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" 
   (0.1ms)  BEGIN
  SQL (0.2ms)  DELETE FROM "users" WHERE "users"."id" = $1  [["id", 2]]
   (0.6ms)  COMMIT
  Key Load (0.2ms)  SELECT "keys".* FROM "keys" 
   (0.1ms)  BEGIN
  SQL (0.1ms)  DELETE FROM "keys" WHERE "keys"."id" = $1  [["id", 2]]
   (0.5ms)  COMMIT
  Certificate Load (0.2ms)  SELECT "certificates".* FROM "certificates" 
   (0.1ms)  BEGIN
   (0.3ms)  SELECT 1 FROM "users" WHERE LOWER("users"."login") = LOWER('foo3') LIMIT 1
   (0.2ms)  SELECT 1 FROM "users" WHERE LOWER("users"."email") = LOWER('[email protected]') LIMIT 1
  SQL (0.5ms)  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:01:12 UTC +00:00], ["display_name", "foo3"], ["email", "[email protected]"], ["first_name", "First"], ["last_name", "Last"], ["login", "foo3"], ["password_digest", "$2a$10$E5/RF4jCAsj7ds.B7Xe0lu414.dZWpHICJVHjfBKHEU7WCYBfTHmO"], ["updated_at", Sun, 18 Sep 2011 19:01:12 UTC +00:00]]
   (0.6ms)  COMMIT
   (0.1ms)  BEGIN
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  SQL (0.4ms)  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:01:12 UTC +00:00], ["password_digest", "$2a$10$CZuMokOJdxOAmXtxqX8bUO28SwhaaKNfW5I/6hHX/pm1AmPxMov9m"], ["title", "foo3"], ["updated_at", Sun, 18 Sep 2011 19:01:12 UTC +00:00], ["user_id", 1]]
   (0.6ms)  COMMIT
   (0.4ms)  BEGIN
   (0.4ms)  UPDATE "keys" SET "body" = '-----BEGIN RSA PRIVATE KEY-----
Proc-Type: 4,ENCRYPTED
DEK-Info: AES-256-CBC,9717AD9AF8818F862D249067F88529D5

Zjs6kwxUrlrbza+eLe9lCm1KF5IGLXNoa+zsvDxWwmIE2XaJ1T4GQF/fkU8yc6VR
iyEnYzn5LiJwPItfAfZhy0/y4mf4QNlbakx9tKRK7HSFO4OM9vKuUEJOBmaHklXt
QSlyph4lf/3F6V5PJcERaCidw2W4feW2VJBjeuU7DBNxu0f02y2pSQ7qtw6QfRbm
cLpR409Q9csUa06SeKnx+yzDjkTp0wmmKyWpQrnwJCTaI5CRxba/PtgzdnX6phMg
VJ12RMXWha2x2ed3HJOsx+o0ysvHw58vpj7A88cd9Ppg5whZo5+CqQTfantmSkEC
+NewhkuwxSlXHzqtKYxMpnpIfECD1cF3kxqTIorUAV9KRF2sOGf29TpxdNqutJB2
OihYkLKyyTD6Bve0d6lq1eWk70JO5lT/eqWOtIC2szrw209qKm4aVIiOIAcr+98u
ygTQDh5SvWCcTVUAn54xpwPisfUFzZ+OzRlIfMivU88VTXX2yLtc8MxSIw8ZyajA
EjAvPL3akwiYN4SHhzT3JnfG+pc0WnlBCd9rQbGiPh3XwiceRkOQqGgdQpdT4/t4
FZl8HJFX0G0VMls78yWQcSd4CN6pEXA+3fXK+iAkuPVj16N/YvzP3wTzliZrMtmD
yGOZ2d+uiTiM/Sbgo8Vny5OjsWFrNGRn1itDw79e2Dg93AtQrx7i1YU50MJQqqBZ
mwVFsbVkKDenZZJj2FXdQ61YUZ0ckszDT4HL0bYXQT6GSS1lFMMfBoePcGP3uZV9
burcQe1L01EJFuDlIV4P60elU60iZnfLE4sr31tuPtnyv/JKIiSQAz3iM1LnA+b9
sE7kBxfm3dpwCX0ps7TZhydAZfPhdUyt+kQ1fBNlgl1s1CCjhIRVniVd31BomBEo
I1sPQiiMA3lCOrkLA0NccCQ1rin6KR1QdRfe2l8PqFbBmPYPA3UMXA0VL+9BI0gu
/XOJ/AOGGjBchrHWoIURUDJgOKFibKdNI42BErP9u/rC7P3Qwg/qKA+bi0nlWjrB
2ewwv0YTEsC1jmq8CGVop9EupB/Xr/iiIhAC7j7WSpQQvE/7LNdad19CeRMiOQ6e
unXMy7sqvLtEmMHJWjHcTIJbIFLx7lOHB9PglQrrW3fNRXUfKBexNSYG7b/LJaqJ
2u2HmyY1z2Dfa44TRAWpRGUi9bHNAFJlbwJ5dHexp/bDvDfjPUF7G1JOZpPfLHEF
FWMqP3fHxGpnmZnci90jjZatYdD4Gjp79B/0Xm+uyDZlmWsr5EDMj9bxNfqSNKzb
MI8KkCYII1Nq0eWROVsTpJVMO+ihtK6xZNm5+4quniH/a9LFTu+stA+gJDq0uPla
80yKKqqmX8z8Lx2LmdpAQnLkw7RgNXswPiIvHf6zaTz5pYrnSH84Ag9hbqUKoSxL
JxzP0sial8o9pzKBRHVI9IpKhlINURXA5liXp0+NojKFwqEP41Qk4sQDImUj2znF
fIFeB01vKndzp3I8UkWcxQvKo0q9/Erf98aYx2g+19AIAb13TGu5i3ROioN8nxRA
DR09dNFDN3ps/wDTEKT6eLRoJPMsGNeFg5hl4D0br2MwyzO7slpfaFc9GmrxZM7V
-----END RSA PRIVATE KEY-----
', "updated_at" = '2011-09-18 19:01:13.227682' WHERE "keys"."id" = 3
   (0.6ms)  COMMIT
  User Load (0.6ms)  SELECT "users".* FROM "users" LIMIT 1
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 3 LIMIT 1
   (0.3ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."login") = LOWER('foo3') AND "users"."id" != 3) LIMIT 1
   (0.2ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."email") = LOWER('[email protected]') AND "users"."id" != 3) LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 3 LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 3 LIMIT 1
  User Load (0.4ms)  SELECT "users".* FROM "users" 
   (0.1ms)  BEGIN
  SQL (0.2ms)  DELETE FROM "users" WHERE "users"."id" = $1  [["id", 3]]
   (0.5ms)  COMMIT
  Key Load (0.3ms)  SELECT "keys".* FROM "keys" 
   (0.1ms)  BEGIN
  SQL (0.2ms)  DELETE FROM "keys" WHERE "keys"."id" = $1  [["id", 3]]
   (0.5ms)  COMMIT
  Certificate Load (0.2ms)  SELECT "certificates".* FROM "certificates" 
   (0.1ms)  BEGIN
   (0.3ms)  SELECT 1 FROM "users" WHERE LOWER("users"."login") = LOWER('foo4') LIMIT 1
   (0.2ms)  SELECT 1 FROM "users" WHERE LOWER("users"."email") = LOWER('[email protected]') LIMIT 1
  SQL (0.6ms)  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:01:13 UTC +00:00], ["display_name", "foo4"], ["email", "[email protected]"], ["first_name", "First"], ["last_name", "Last"], ["login", "foo4"], ["password_digest", "$2a$10$edeLhGeaKEczTMh77Iy3qe57rGvEVssa7lKQCLBXIxdnRZpblPLLS"], ["updated_at", Sun, 18 Sep 2011 19:01:13 UTC +00:00]]
   (0.6ms)  COMMIT
   (0.1ms)  BEGIN
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  SQL (0.3ms)  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:01:13 UTC +00:00], ["password_digest", "$2a$10$S8e0miV6ujwaBYDudMdeFOeV3J85WEo8Bwwlkic2aVY8uTD3HAl6W"], ["title", "foo4"], ["updated_at", Sun, 18 Sep 2011 19:01:13 UTC +00:00], ["user_id", 1]]
   (0.6ms)  COMMIT
   (0.4ms)  BEGIN
   (0.4ms)  UPDATE "keys" SET "body" = '-----BEGIN RSA PRIVATE KEY-----
Proc-Type: 4,ENCRYPTED
DEK-Info: AES-256-CBC,39BFBEBE736AF45AEE2EED938115F991

5+gq2Sw6veUmOnW/l0UbehanljTmV/3WQT1jPHOobNV46DMhKCfE/+C7zP1kuErd
YC8hDSmVYf3qJT+eOT5AVdZvH/4FQZJ5wrP6u/iMPWbkwJlStYO9wC+fvdU3cdfl
PhffMRsLbmuGSvLHz1GUC0vsDSG4YJhQ5tUTHXFdrNmGakaQobwMUr1TX61/yRAa
rVsn/LVCT7dRIGKN+JJT7Zcfi2AF6rDl/zijc9gdNW3yjgaMJwrFhCYxih0sPrKR
t8Ng18JE85ztu8yKqM6mVNVYIbw2lX70Ij+cPBz30TPeTELteYj5tlP+4j9QyAvg
zdi06SsTssH+cyC1YwQKxr978HLB1ztsTBUbO1SISchgw0iVYFWBcPqCNF1MJen6
SuaIG0gyemw1GWblOJ5N6Cjs2K11pwaxhHWXHrCAVxE4YOhv4DMw5eE+HFswcWRW
9u/keTYtGWMg91qKJgfIK4XdRHyQNfKjdx4pK1fSz/yttVMdC/vGni+eEXg8KmL8
HOJDgdieoWiwnbPOyWqJewdblNsafx31eyNdEBbfki1s2XSG+QceCzncSVgwl2F6
xHUvmuNNo1jJGNnV+4Khx4/YGRaNbZSyL4g0lFt1V18ww7sFfWtOJWhDZQ4488Yi
OXhmovqCPXszAttT1P8CfolweqJx9X4Xah9az/MXmfCX9G5VkE5MoQlv/qZBKoVu
4fkwd/USyWmxWdyo4Kix+4nj4MOuOmhpgupBIU+RJDiy1kZSH5exZziAwKCkjY4j
G7RgW4us4FHpPdgot3dFaUibprZcVO0q7Mfcw1A9D7eSzPlxWCS6wSliBeLAkyPN
EnlszfP+H5Ucf4ur/xT7C49eMRE2Q6xrTk5ETcqkUJ8FTJwE9NRrVb4qxLrMXuNn
mOlwo2eAKymKa54gWwbQy48yRWgbpUPqcc+/XlH27C1W3wqe/yNulDKxkq9IrCb6
Cy07/3i7xYcj2GUZFAvXcV9scvKjzjtGVtw/lxezRiQj+D1+0ZC6rPWwUazQnzWD
j3pPE1e+bksVDe1yymKsCqEp0zHR48ndYJAKLIoKTo6Gp2kbgNpZZI7y5rVV7QR5
uy8XWu29xmjptlYOunTTJyKC/2w69tr8kDmxl5f97JlkqiQHBGKiGhtNQqBjig9N
q7PeKN7FpGtKMP4fAi5crn12ucu2Q0LIEOeWpOgG7xcQt2KdKK3x/7X/KYS0tF1m
69ma5lste6paLs20vlNuq7LyFTgUmxmoyZ7jDeoj2mvmC8wDg4v3pM/8ftJaAlgs
QjYyCT3XFKvJXd8MK6NMyw9TD27M7NH/c355JheuOFHO9cW12vctwiS8FqTrxJul
PCGSMdDX8wzp7Nh/n+6PZndu2zRmysv1lyc9SRrlfmg5umJ/Ult2lGTOfVBMAOEV
Ph8MPtD8gHHvrzfSMg9CA0uEnN1bMOfupKOtHQBaOCm/xvaqR4Vya7r3FOxo1aZ8
ktP0FiaZhhKpSSOkE2+urrAmwdTLKfrmAca64xrByLllN+eSkP8fEiZUeW/ktaBS
Hm8bEZaIwiMzpPrqAHDXvnbZA5e8+pc9sCJl1yzG6U5+WJTSOa8l8ZGZJcMwg8VJ
-----END RSA PRIVATE KEY-----
', "updated_at" = '2011-09-18 19:01:13.756226' WHERE "keys"."id" = 4
   (0.6ms)  COMMIT
  User Load (0.6ms)  SELECT "users".* FROM "users" LIMIT 1
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 4 LIMIT 1
   (0.3ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."login") = LOWER('foo4') AND "users"."id" != 4) LIMIT 1
   (0.3ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."email") = LOWER('[email protected]') AND "users"."id" != 4) LIMIT 1
  Key Load (1.0ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 4 LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 4 LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" 
   (0.1ms)  BEGIN
  SQL (0.2ms)  DELETE FROM "users" WHERE "users"."id" = $1  [["id", 4]]
   (0.7ms)  COMMIT
  Key Load (0.3ms)  SELECT "keys".* FROM "keys" 
   (0.1ms)  BEGIN
  SQL (0.2ms)  DELETE FROM "keys" WHERE "keys"."id" = $1  [["id", 4]]
   (0.4ms)  COMMIT
  Certificate Load (0.3ms)  SELECT "certificates".* FROM "certificates" 
   (0.1ms)  BEGIN
   (0.3ms)  SELECT 1 FROM "users" WHERE LOWER("users"."login") = LOWER('foo5') LIMIT 1
   (0.2ms)  SELECT 1 FROM "users" WHERE LOWER("users"."email") = LOWER('[email protected]') LIMIT 1
  SQL (0.5ms)  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:01:13 UTC +00:00], ["display_name", "foo5"], ["email", "[email protected]"], ["first_name", "First"], ["last_name", "Last"], ["login", "foo5"], ["password_digest", "$2a$10$hKhhAyDBNUMI9JTkjC6VKOWZ4Resy1Zy.Uq7apYQ.IoyRvIbKhYCi"], ["updated_at", Sun, 18 Sep 2011 19:01:13 UTC +00:00]]
   (0.6ms)  COMMIT
   (0.1ms)  BEGIN
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  SQL (0.3ms)  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:01:14 UTC +00:00], ["password_digest", "$2a$10$MMp0.K/.YsYc6INOrYsy4ey8pRe2RsElrDUFjzXTugke/m74l6kLa"], ["title", "foo5"], ["updated_at", Sun, 18 Sep 2011 19:01:14 UTC +00:00], ["user_id", 1]]
   (0.6ms)  COMMIT
   (0.5ms)  BEGIN
   (0.5ms)  UPDATE "keys" SET "body" = '-----BEGIN RSA PRIVATE KEY-----
Proc-Type: 4,ENCRYPTED
DEK-Info: AES-256-CBC,3555F6F5980A51232917414863A42E92

vKnCX1twhL8a+tc7lT0WPBs39kbOX5TdmcGZUUPsn8VBm81cfLNismNjgQTvkkg3
SoZkkyCsMAIQmFc7y9+q5xmWrgr8QA8vaeoELeTDHlD+PEKAWflVa8Ri+RjdPaIl
LkfF7huYRDWfhf9ekrXpVkUCZcYZWtB+JS6akusAfw8ADFuzgfnuRkKpq8faF4VC
pekxLvUErDKm7CkR3osjT4KVJUGpT8pn4ATx47bzxKaamQvl8HFRGXTtEW4oa/Cz
Kg0CcQs4GFVrxw694lWnz4lbuvGDVIVOaIS81ZrrNdHX7TN3ZrUHbHdM/motlgS2
/YpMGhT8SuG/f0DcOEgUAL6Qrgsj53dhWjiT5HZTqaQT0wa+GW7hqLpjyDV/Rv0P
ahs/SdiGkoP+IQHmJnob3ozZBQw0JKCyCjRx7rf9ZNu6bDQej1nJD/Y51O3YWpys
ZnSlm98/QBMlrEJquH48tQavbP+xLPmbi8VbAKcWbuk1m8O/Sm62yHTzFeGeIINS
2K56byxttdpPXO5tRiAH9WP3rFqhVvs+0A+s07CbhHhkyAN5Lh6B/C6L/T30OVS4
4mjBzmAQAZhGElWomW+0rou7TbnpJ1RCi4Ru/W8+vhsz0pKKxFe4s1gQ/RCs/OAc
U+cPQ6cwQ7bXIuK9di7eas9a7oh/hQQMNOZccM2VesGHpghFNaOzdFeoEQ8DIfTK
/JWlO+AwQnS+/gNY6H605wdB6xoLLlZzYGbMSZF69ptcU8syZuVLjbaKYbHsDGbK
maIxbfcZ4PIGoSSPLwp7zbXgtmPbhv4LBbYLmSPZHvuJ00zpIaiR7unX5T6O9uTH
TmaXiQkuryfTWEzl5LwXUJ2DvnHVEq4lIHVAp7Wh4OGK9AzSizkS4e5wdVZf/PM3
b740VaZu8BILmjlJGzZEfd348SnPO/1gGX1MZCRGrMmpPtPB8EXvvHgdd3JoU1eZ
blQcQOU5WR6SzH6ttBCCFX6F+a0xWawh3zyHXtPHOKZDT6AUyHE6eiffJW6+TAJN
pmeElYqb20INYmOvCmBk8TsRUeeAJM8Bwz46I1sE9ryEbO643Hb+MmJO5ZrI6P6j
fR5S/q+672D5ZrK8bEbMrO9vFXIHtv7SSIHHC4pjp5D8yTh1udfb4zgSk0PdFgBI
WCV4iMvHjzOzvSpVCrxUKSIWVnAGAHmiTRK+yrJBKbWPDuCO9IjTDCADg1CJZSeH
NppknAyKkypCrYfap4+kERXlQVPvY2W/3MpAKWWH0neBPdgzftYCROd72pdQzme3
BduIhBoRJ8TZmnNyMsTSzQrWnmdVjq15ivvv38fpcEeEOvCK9E0exqKsULt38uZ+
rHgH7qfXyQ1NC+jr+sPGKrqyk+YfrLygrNbPGTokZ9zlwdUgETvQQczU7sJDZDUe
dCvxDtmqNTo8wupvq8wkAV/Ho2Ujo3d8LJDF1TqqQKrfmvPcyYLe30BON/v1K0pV
eaSSU1aLmh6Fjwznz1qCAXXri4UdyuFgKXwxegnCSdf3S8Jvk8IAh3k21rdtKfYy
sgrIKzkEUIdpHV5GyvH7FlrRKHN3wyykVOI/O41kiGRMVoPLTHqguNv/9xV01PAF
-----END RSA PRIVATE KEY-----
', "updated_at" = '2011-09-18 19:01:15.275167' WHERE "keys"."id" = 5
   (0.4ms)  COMMIT
  User Load (0.5ms)  SELECT "users".* FROM "users" LIMIT 1
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 5 LIMIT 1
   (0.4ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."login") = LOWER('foo5') AND "users"."id" != 5) LIMIT 1
   (0.3ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."email") = LOWER('[email protected]') AND "users"."id" != 5) LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 5 LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 5 LIMIT 1
  User Load (0.4ms)  SELECT "users".* FROM "users" LIMIT 1
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 5 LIMIT 1
   (0.3ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."login") = LOWER('foo5') AND "users"."id" != 5) LIMIT 1
   (0.3ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."email") = LOWER('[email protected]') AND "users"."id" != 5) LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 5 LIMIT 1
  User Load (0.7ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 5 LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" 
   (0.1ms)  BEGIN
  SQL (0.2ms)  DELETE FROM "users" WHERE "users"."id" = $1  [["id", 5]]
   (0.4ms)  COMMIT
  Key Load (0.3ms)  SELECT "keys".* FROM "keys" 
   (0.1ms)  BEGIN
  SQL (0.1ms)  DELETE FROM "keys" WHERE "keys"."id" = $1  [["id", 5]]
   (0.4ms)  COMMIT
  Certificate Load (0.3ms)  SELECT "certificates".* FROM "certificates" 
   (0.1ms)  BEGIN
   (0.3ms)  SELECT 1 FROM "users" WHERE LOWER("users"."login") = LOWER('foo6') LIMIT 1
   (0.5ms)  SELECT 1 FROM "users" WHERE LOWER("users"."email") = LOWER('[email protected]') LIMIT 1
  SQL (0.7ms)  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:01:15 UTC +00:00], ["display_name", "foo6"], ["email", "[email protected]"], ["first_name", "First"], ["last_name", "Last"], ["login", "foo6"], ["password_digest", "$2a$10$rk6P7HIWPkoFE7YXnWoVTOVTJdYowcd7toJ5bpwO9.A8RrLbfKU4q"], ["updated_at", Sun, 18 Sep 2011 19:01:15 UTC +00:00]]
   (0.4ms)  COMMIT
   (0.1ms)  BEGIN
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  SQL (0.4ms)  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:01:15 UTC +00:00], ["password_digest", "$2a$10$d.oUznTBqnuI2yK1unCVHuJY/sWkwEKWfjEfSSh9uTlOkDTIsWLQi"], ["title", "foo6"], ["updated_at", Sun, 18 Sep 2011 19:01:15 UTC +00:00], ["user_id", 1]]
   (0.4ms)  COMMIT
   (0.4ms)  BEGIN
   (0.4ms)  UPDATE "keys" SET "body" = '-----BEGIN RSA PRIVATE KEY-----
Proc-Type: 4,ENCRYPTED
DEK-Info: AES-256-CBC,873F6ACE3EC117C93F86010BFAE434B5

WPUNx9BkiOJjVr5VfMFwJfg3kNaX/af4pOXIT4s+ClVXQYOeV4+J2v7/mu3J0z0h
bXLz/mzI7gXmf7/6MNjpWGGry0Phb4VyMRSFBI5pfTxP6j0LJHFm+TjtBkHFceu8
HvKbFPO/xtvcy0297yoNy3esOOJBoLgyb0EKiV+Ko2Br7Aj0+xN74j5hdclUpZ2Z
+XdZJmI3iNmUAz/FGE07Kg08za1DWgvmUHwmYz6dIPhN8WiTpSSDcg66pZcOv6mC
bRcQzBc+OUsBgehHIYlwxtoJtJMNUFaAwtf7AV+oQimXlkY0YdYZRH9kSNYfmCQ5
c5f9B74nJRWuN3fxhZwSVQAr8wd2PJUHKzPgjb661WmHVR8ZG3SooENxdQ3ADP7A
gGpqK3HG26T+Un9/yoYAKkkl4+9XrDepSbWDZ7Y8fFfrFzWcTjd2y9Jhd5qO4Ce8
iQTYNTvODWyrwnnIXoeVDQLSc/YPul6LARhU/S6+DY4mCSc+AztmNNDMs64WEm1b
sAj3q8L2Tj5UU/t0iX9vKzJ0eMhoA6zpKYjVLeEtWZ5GGfjpfPYFVGtiDvGdixWH
xzJkCs+GGHrXj/1HxoaQvDXhnDa8tkc7YVjY0cvZcTYN3u1Daqhps/1oSm5qTgY2
xKtiVusFN8+g6lMixKs2MZseEARnmxqss4QMTEQFWPw28h4gh4l/fSIXsmUl+ntl
0SvO78lRzB8+QpA8XZhCJOAEKwUt73d/A24pKDuk+1hzr6suQkgqW48+mtODxt/o
vb5pd78y4vyTPuXF4Z9ZxwoojExWKHYj2EaOlSzK1IDFJ10Q1XiDVV3UFqdcYuRj
s8oW9b2EICcg0qoBwb0EcbFApyMH+ea2UzWkqwZhHOHR/r/6UgY3TjYsbO19tlBn
zSZ5UAS8kZRhaeYM/oRVliM/+SiNhBMyR9/L7zlX3m+tEI6SFkQsgR/RjfZEgaTB
owKGcSfBMYEsr7TfyMMB22l+OAzYvROWOZMjcomsRUFruvnTvpvUBt53ePaa2uf8
pzDxowB9DNU7VKSDr/XSyxWZkW+ispvzaMGnLlqtcujLrBcubgQT7UZXMz9TNOMX
JYbexa5no7dQ4gnMy/nyQfQWbEIXzIl1DfHp0Et4Toszf3MtnhVhrWdPmDShzR5x
Dg2o319N+BsuANwZpIRD7GXK9diM8UWa62r/RmJgeOIwv2NmlblwgzQfhKOphpjg
ooR95ESixrlbfZacJwIuN2pz8IlEy9blZlsKJReaU5cD0u6FlleREIKA2/FxRSKg
TDX04ZbSsJLXAnIYy0GVfND2WLXU9z82jY4Qb/2BrdML7V45DSvIvTVXhBEMcIG/
vcvCDEF03e+Mk3JDUs5/gkzMDJHQhEt1uvSnWH1ZebDYe4LM5O4+nYPI0H6/+3Jh
SEMBNggEpTIBNGJD6c7sxolK8ZJ57lp4/GDXu5ciOuHG2yaZqCbDBiQd2WpeJyBS
NMdVIXTwRsk/vqPx1xDTERPfP2L+KZHUWnqNDoU0i86/CttVgfekuiw8So5DERJ2
/SW/eIX0C54EHp9mCxQAoqzbD/oIrT/iYov0acMLtVBc05HQRcZ1+rH9v3OSTVnM
-----END RSA PRIVATE KEY-----
', "updated_at" = '2011-09-18 19:01:16.174396' WHERE "keys"."id" = 6
   (0.4ms)  COMMIT
  User Load (0.5ms)  SELECT "users".* FROM "users" LIMIT 1
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 6 LIMIT 1
   (0.3ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."login") = LOWER('foo6') AND "users"."id" != 6) LIMIT 1
   (0.3ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."email") = LOWER('[email protected]') AND "users"."id" != 6) LIMIT 1
  Key Load (1.7ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 6 LIMIT 1
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 6 LIMIT 1
   (0.1ms)  BEGIN
   (0.4ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."login") = LOWER('foo6') AND "users"."id" != 6) LIMIT 1
   (0.3ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."email") = LOWER('[email protected]') AND "users"."id" != 6) LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 6 LIMIT 1
  SQL (1.2ms)  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:01:16 UTC +00:00], ["days", 365], ["email", "[email protected]"], ["key_id", 6], ["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:01:16 UTC +00:00], ["user_id", 6]]
   (0.6ms)  COMMIT
  Certificate Load (0.5ms)  SELECT "certificates".* FROM "certificates" WHERE "certificates"."id" = 1 LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" 
   (0.1ms)  BEGIN
  SQL (0.2ms)  DELETE FROM "users" WHERE "users"."id" = $1  [["id", 6]]
   (0.4ms)  COMMIT
  Key Load (0.2ms)  SELECT "keys".* FROM "keys" 
   (0.1ms)  BEGIN
  SQL (0.1ms)  DELETE FROM "keys" WHERE "keys"."id" = $1  [["id", 6]]
   (0.3ms)  COMMIT
  Certificate Load (0.3ms)  SELECT "certificates".* FROM "certificates" 
   (0.1ms)  BEGIN
  SQL (0.3ms)  DELETE FROM "certificates" WHERE "certificates"."id" = $1  [["id", 1]]
   (0.3ms)  COMMIT
   (0.1ms)  BEGIN
   (0.3ms)  SELECT 1 FROM "users" WHERE LOWER("users"."login") = LOWER('foo7') LIMIT 1
   (0.2ms)  SELECT 1 FROM "users" WHERE LOWER("users"."email") = LOWER('[email protected]') LIMIT 1
  SQL (0.6ms)  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:01:16 UTC +00:00], ["display_name", "foo7"], ["email", "[email protected]"], ["first_name", "First"], ["last_name", "Last"], ["login", "foo7"], ["password_digest", "$2a$10$UqvfqYFrnRl8OyysesRZS.qaOXOpWOURiW8G1cT2oNXevLkb6jlBq"], ["updated_at", Sun, 18 Sep 2011 19:01:16 UTC +00:00]]
   (0.5ms)  COMMIT
   (0.1ms)  BEGIN
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  SQL (0.3ms)  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:01:16 UTC +00:00], ["password_digest", "$2a$10$tVNXdQbKIxcz./s810tkXeYK/irRBuPNZih5ReX7Mzg73SKu9Okfi"], ["title", "foo7"], ["updated_at", Sun, 18 Sep 2011 19:01:16 UTC +00:00], ["user_id", 1]]
   (0.4ms)  COMMIT
   (0.5ms)  BEGIN
   (0.4ms)  UPDATE "keys" SET "body" = '-----BEGIN RSA PRIVATE KEY-----
Proc-Type: 4,ENCRYPTED
DEK-Info: AES-256-CBC,6EC8C0E4F8A1CDAD517A0B2C8C2782C0

bcEVrtVUPt+sY0ah8TRv/1fiPEihR3mdWvCJuol4vQTsCYC41jnzGMPLUO468Xqg
KzKIKgi4HmGaerv+xu/26Rpl0Duu7uCoKhA/ye+3q7+MOQQFGH75giYF9fWgJmyF
c3v/K2Pr8Syc2hzFcx/wIaBKiW5yphqMEqVcOZloTxhPXjmpNZXNsTEmbqgwZwIO
uz0npxdvdTaT7TJwQuZTXn3/kc3NDXrH4Z6p9JxG6L8svZiUOuRF+X1aDKWKftn4
QfE17PAdvxoN5t29tUFtL2DurbHbbsVdUvembz0a+l+CJKaqhoXly9fpzyO4H7PL
FrFQNBOxoZtIE3HKNdTizozQ6nMeI+6ru27ZwZhRLyUdR9E7qubrYJfFzDKZ0RHS
BFC7zcIBLfJxaba777c3UipfviPzNPGYouFwaprSW0DUqkNV1JvnKLuMTyTittEO
VimzbcXy2kmsFoKLlPnZ1vfqeWKKY9qfPgt682SHmivrEgLxZpladZVW/AFnPSU9
rDJS8PWBtjQicRJ+g9YKI8+XA6YUvRjtiyUWsrQvO6Ha7baWuNdpG2Q6kRScOnUh
vPvtgXA6sQhyv8G/nqwH5ewjaIpDjDi7Ijj5Jttd3RXNY94H1359VGB4xgQslNoU
qBiZeFmuVTpzan8kElU98QOf7sf5Qyx/EbqP80j7lwKrPKLu/sXDhk8Vzqmhy+yX
R3dGcxSIwg+VlfQ6qmaNLgWB13HGcdtnQiimP+0kMQ4ZQ6As6OPqYkHu3AScRJiG
jBSJQOcJ5d2BmC/ugmNZ23njvDPkykDeiXRfCjuFbOQLjuz4cB7FzDS27hZGbYzz
yYf9UeYK87bXENFy8eNu/d2pVktV1JeG0Th6scndlQShyEf4CamQ/37dTg0Tb292
lriC0IXwPT/ZjO2DEAHhQBtzVsbiKSN8SCFiO7VOMLRfU+120o7415pa3LMzu0Le
yzv7CA+9MW6oUIwU4iCnmBvtV+9tqbmK4R4+xeBu6idoB3TJ7Q+onlmQ2PNAvj03
RvCLdRAHUD9R4IXp1YZIWLS9hLXlzt5zV+wYRKdXULI9M5fY6rOl5Ai6s8BvXIhX
/fonLXp9z16u9c/qVQM2gLhQwhJ0zqRTqlB1TIBhOlDoH9N4GJfPxEE0SexybafH
hq6uHb3oq+TvcpRp5YxQLEon87BnsYOqz/sH2fSXxv5ItCAFy8qTuZy+W+QNrEvm
eRT96gFp2L0AZt9RmdPEYb9XN+dkMupTCyGiwWJMZE7W5okSiwJ17s/juQg108qt
hrWV8wjruVBMumPqThjgBzQwdiJwW+detJCLmulUsWjmnlH66WqRa/q8tM7IpjLt
wl/IkvMhFBlVhdd/zJisriHt1a0Ul4hYbJwpfOLR8krDDYyTw44S7ZREkNa2o3Uy
JpTsXVDOqE+Fdi+U+s3J2gR5UKoA1qcKC1BcaAU5hC/gRqmbRcB9gpdjttW64a/w
AUWPVFSR87P6bp0T94lvTPrMvzf7LKlUWKWeubD2bGctpqqwO7sTJ0mfq79znFQv
gjLsLlhEJWpM0oGeWRI/sku6bNgn1bbS3u/ZaSUn3m+Ii+mFAWW54OoXBCzpoTAi
-----END RSA PRIVATE KEY-----
', "updated_at" = '2011-09-18 19:01:17.213969' WHERE "keys"."id" = 7
   (0.5ms)  COMMIT
   (0.3ms)  BEGIN
  User Load (1.8ms)  SELECT "users".* FROM "users" LIMIT 1
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 7 LIMIT 1
   (0.4ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."login") = LOWER('foo7') AND "users"."id" != 7) LIMIT 1
   (0.3ms)  SELECT 1 FROM "users" WHERE (LOWER("users"."email") = LOWER('[email protected]') AND "users"."id" != 7) LIMIT 1
  Key Load (0.6ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 7 LIMIT 1
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 7 LIMIT 1
  SQL (0.9ms)  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:01:17 UTC +00:00], ["days", 365], ["email", "[email protected]"], ["key_id", 7], ["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:01:17 UTC +00:00], ["user_id", 7]]
   (0.5ms)  COMMIT
  Key Load (0.4ms)  SELECT "keys".* FROM "keys" WHERE "keys"."id" = 7 LIMIT 1
   (0.5ms)  BEGIN
   (2.9ms)  UPDATE "certificates" SET "body" = '', "updated_at" = '2011-09-18 19:01:17.401059' WHERE "certificates"."id" = 2
   (1.3ms)  COMMIT
   (0.6ms)  BEGIN
   (0.4ms)  UPDATE "certificates" SET "request_status" = 1, "updated_at" = '2011-09-18 19:01:17.437751' WHERE "certificates"."id" = 2
   (0.3ms)  COMMIT