spec/dummy/log/test.log in bloom_remit-0.5.0 vs spec/dummy/log/test.log in bloom_remit-0.6.0

- old
+ new

@@ -30141,5 +30141,496 @@  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK + ActiveRecord::SchemaMigration Load (1.7ms) SELECT "schema_migrations".* FROM "schema_migrations" +Migrating to AddVendorExternalIdToBloomRemitTxns (20160817003323) +  (0.2ms) BEGIN +  (4.5ms) ALTER TABLE "bloom_remit_txns" ADD "vendor_external_id" character varying NOT NULL +  (6.4ms) CREATE INDEX "index_bloom_remit_txns_on_vendor_external_id" ON "bloom_remit_txns" ("vendor_external_id") + SQL (0.7ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160817003323"]] +  (0.7ms) COMMIT + ActiveRecord::SchemaMigration Load (0.7ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (2.1ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'billers' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + +  (2.2ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'bloom_remit_responses' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + +  (2.0ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'bloom_remit_txns' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + +  (2.0ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'payments' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + +  (1.9ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'users' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + + ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (1.0ms) ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL;ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL +  (1.3ms)  SELECT schemaname || '.' || tablename + FROM pg_tables + WHERE + tablename !~ '_prt_' AND + tablename <> 'schema_migrations' AND + schemaname = ANY (current_schemas(false)) + +  (3.1ms) select table_name from information_schema.views where table_schema = 'bloom_remit_rails_test' +  (13.6ms) TRUNCATE TABLE "public"."bloom_remit_txns", "public"."billers", "public"."users", "public"."bloom_remit_responses", "public"."payments" RESTART IDENTITY CASCADE; +  (0.4ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL +  (0.3ms) BEGIN + SQL (0.6ms) INSERT INTO "users" DEFAULT VALUES RETURNING "id" +  (0.6ms) COMMIT +  (1.5ms) BEGIN + SQL (0.9ms) INSERT INTO "bloom_remit_txns" ("target_slug", "amount", "secret", "external_id", "sender_id", "sender_type") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["target_slug", "TARGET_SLUG"], ["amount", "2500.0"], ["secret", "2b0fb056-f9b5-4474-8091-ffbb1eb55770"], ["external_id", "1df3340b8a9f1d32e41ab7c6"], ["sender_id", "1"], ["sender_type", "User"]] +  (0.2ms) ROLLBACK +  (0.3ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL +  (10.5ms) TRUNCATE TABLE "public"."bloom_remit_txns", "public"."billers", "public"."users", "public"."bloom_remit_responses", "public"."payments" RESTART IDENTITY CASCADE; +  (0.3ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" + ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" +Migrating to AddVendorExternalIdToBloomRemitTxns (20160817003323) +  (0.1ms) BEGIN +  (2.8ms) DROP INDEX "index_bloom_remit_txns_on_vendor_external_id" +  (0.3ms) ALTER TABLE "bloom_remit_txns" DROP "vendor_external_id" + SQL (0.5ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20160817003323"]] +  (0.9ms) COMMIT + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (1.8ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'billers' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + +  (1.6ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'bloom_remit_responses' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + +  (1.8ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'bloom_remit_txns' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + +  (2.0ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'payments' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + +  (2.0ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'users' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + + ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" +Migrating to AddVendorExternalIdToBloomRemitTxns (20160817003323) +  (0.2ms) BEGIN +  (1.0ms) ALTER TABLE "bloom_remit_txns" ADD "vendor_external_id" character varying +  (1.1ms) CREATE INDEX "index_bloom_remit_txns_on_vendor_external_id" ON "bloom_remit_txns" ("vendor_external_id") + SQL (0.4ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160817003323"]] +  (0.5ms) COMMIT + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (2.2ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'billers' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + +  (1.6ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'bloom_remit_responses' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + +  (1.9ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'bloom_remit_txns' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + +  (1.8ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'payments' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + +  (1.9ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete +FROM pg_constraint c +JOIN pg_class t1 ON c.conrelid = t1.oid +JOIN pg_class t2 ON c.confrelid = t2.oid +JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid +JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid +JOIN pg_namespace t3 ON c.connamespace = t3.oid +WHERE c.contype = 'f' + AND t1.relname = 'users' + AND t3.nspname = ANY (current_schemas(false)) +ORDER BY c.conname + + ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.3ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL +  (1.1ms)  SELECT schemaname || '.' || tablename + FROM pg_tables + WHERE + tablename !~ '_prt_' AND + tablename <> 'schema_migrations' AND + schemaname = ANY (current_schemas(false)) + +  (0.9ms) select table_name from information_schema.views where table_schema = 'bloom_remit_rails_test' +  (17.7ms) TRUNCATE TABLE "public"."billers", "public"."users", "public"."bloom_remit_txns", "public"."bloom_remit_responses", "public"."payments" RESTART IDENTITY CASCADE; +  (0.3ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL +  (0.1ms) BEGIN + SQL (0.4ms) INSERT INTO "users" DEFAULT VALUES RETURNING "id" +  (0.4ms) COMMIT +  (0.1ms) BEGIN + SQL (0.7ms) INSERT INTO "bloom_remit_txns" ("target_slug", "amount", "secret", "external_id", "sender_id", "sender_type") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["target_slug", "TARGET_SLUG"], ["amount", "2500.0"], ["secret", "dd381c1f-742c-402e-b563-3b5a8f990c93"], ["external_id", "630147c85c5cda161a212506"], ["sender_id", "1"], ["sender_type", "User"]] +  (0.5ms) COMMIT + BloomRemit::Txn Load (0.3ms) SELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 AND "bloom_remit_txns"."secret" = $2 LIMIT 1 [["id", 1], ["secret", "dd381c1f-742c-402e-b563-3b5a8f990c93"]] +  (0.1ms) BEGIN + SQL (0.2ms) UPDATE "bloom_remit_txns" SET "status" = $1, "status_description" = $2 WHERE "bloom_remit_txns"."id" = $3 [["status", 1], ["status_description", "My status description"], ["id", 1]] +  (0.4ms) COMMIT +  (0.2ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL +  (10.7ms) TRUNCATE TABLE "public"."billers", "public"."users", "public"."bloom_remit_txns", "public"."bloom_remit_responses", "public"."payments" RESTART IDENTITY CASCADE; +  (0.2ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL + ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.4ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL +  (1.2ms)  SELECT schemaname || '.' || tablename + FROM pg_tables + WHERE + tablename !~ '_prt_' AND + tablename <> 'schema_migrations' AND + schemaname = ANY (current_schemas(false)) + +  (1.2ms) select table_name from information_schema.views where table_schema = 'bloom_remit_rails_test' +  (14.1ms) TRUNCATE TABLE "public"."billers", "public"."users", "public"."bloom_remit_txns", "public"."bloom_remit_responses", "public"."payments" RESTART IDENTITY CASCADE; +  (0.3ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL +  (0.3ms) BEGIN + SQL (0.5ms) INSERT INTO "users" DEFAULT VALUES RETURNING "id" +  (0.4ms) COMMIT +  (0.3ms) BEGIN + SQL (0.7ms) INSERT INTO "bloom_remit_txns" ("target_slug", "amount", "secret", "external_id", "sender_id", "sender_type") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["target_slug", "TARGET_SLUG"], ["amount", "2500.0"], ["secret", "5ed3fee1-8975-4032-abc2-36de05e8f225"], ["external_id", "17845ccaaaab11d5b123e291"], ["sender_id", "1"], ["sender_type", "User"]] +  (0.5ms) COMMIT + BloomRemit::Txn Load (0.5ms) SELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 AND "bloom_remit_txns"."secret" = $2 LIMIT 1 [["id", 1], ["secret", "5ed3fee1-8975-4032-abc2-36de05e8f225"]] +  (0.2ms) BEGIN + SQL (0.3ms) UPDATE "bloom_remit_txns" SET "status" = $1, "status_description" = $2 WHERE "bloom_remit_txns"."id" = $3 [["status", 1], ["status_description", "My status description"], ["id", 1]] +  (0.5ms) COMMIT +  (0.5ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL +  (13.2ms) TRUNCATE TABLE "public"."billers", "public"."users", "public"."bloom_remit_txns", "public"."bloom_remit_responses", "public"."payments" RESTART IDENTITY CASCADE; +  (0.3ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL + ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.4ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL +  (1.2ms)  SELECT schemaname || '.' || tablename + FROM pg_tables + WHERE + tablename !~ '_prt_' AND + tablename <> 'schema_migrations' AND + schemaname = ANY (current_schemas(false)) + +  (1.1ms) select table_name from information_schema.views where table_schema = 'bloom_remit_rails_test' +  (16.5ms) TRUNCATE TABLE "public"."billers", "public"."users", "public"."bloom_remit_txns", "public"."bloom_remit_responses", "public"."payments" RESTART IDENTITY CASCADE; +  (0.7ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL +  (0.3ms) BEGIN + SQL (0.6ms) INSERT INTO "users" DEFAULT VALUES RETURNING "id" +  (0.3ms) COMMIT +  (0.3ms) BEGIN + SQL (0.6ms) INSERT INTO "bloom_remit_txns" ("target_slug", "amount", "secret", "external_id", "sender_id", "sender_type") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["target_slug", "TARGET_SLUG"], ["amount", "2500.0"], ["secret", "ef181f7f-9dcf-45ce-a99d-ae02cfb31ea4"], ["external_id", "08aaf82fff2f866502d31bfa"], ["sender_id", "1"], ["sender_type", "User"]] +  (0.5ms) COMMIT + BloomRemit::Txn Load (0.5ms) SELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 AND "bloom_remit_txns"."secret" = $2 LIMIT 1 [["id", 1], ["secret", "ef181f7f-9dcf-45ce-a99d-ae02cfb31ea4"]] +  (0.2ms) BEGIN + SQL (0.3ms) UPDATE "bloom_remit_txns" SET "status" = $1, "status_description" = $2, "vendor_external_id" = $3 WHERE "bloom_remit_txns"."id" = $4 [["status", 1], ["status_description", "My status description"], ["vendor_external_id", "somerefno"], ["id", 1]] +  (0.4ms) COMMIT +  (0.2ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL +  (9.3ms) TRUNCATE TABLE "public"."billers", "public"."users", "public"."bloom_remit_txns", "public"."bloom_remit_responses", "public"."payments" RESTART IDENTITY CASCADE; +  (0.7ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL + ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.4ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL +  (1.1ms)  SELECT schemaname || '.' || tablename + FROM pg_tables + WHERE + tablename !~ '_prt_' AND + tablename <> 'schema_migrations' AND + schemaname = ANY (current_schemas(false)) + +  (1.1ms) select table_name from information_schema.views where table_schema = 'bloom_remit_rails_test' +  (15.6ms) TRUNCATE TABLE "public"."billers", "public"."users", "public"."bloom_remit_txns", "public"."bloom_remit_responses", "public"."payments" RESTART IDENTITY CASCADE; +  (0.3ms) ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL +  (0.3ms) BEGIN +  (0.2ms) COMMIT +  (0.3ms) BEGIN +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +  (0.3ms) COMMIT +  (0.3ms) BEGIN +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN + SQL (0.6ms) INSERT INTO "billers" ("slug") VALUES ($1) RETURNING "id" [["slug", "PLDT"]] +  (0.5ms) COMMIT +  (0.5ms) BEGIN + SQL (0.8ms) INSERT INTO "users" ("type") VALUES ($1) RETURNING "id" [["type", "SubUser"]] +  (0.5ms) COMMIT +  (4.8ms) BEGIN + SQL (0.4ms) INSERT INTO "payments" ("type") VALUES ($1) RETURNING "id" [["type", "SubPayment"]] +  (0.5ms) COMMIT +  (0.5ms) BEGIN + SQL (1.1ms) INSERT INTO "bloom_remit_txns" ("secret", "sender_type", "sender_id", "amount", "account_name", "account_id", "target_slug", "owner_id", "owner_type", "external_id") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) RETURNING "id" [["secret", "2cad015b-3395-40e9-8dc1-68bbd5090c70"], ["sender_type", "User"], ["sender_id", "1"], ["amount", "800.0"], ["account_name", "028109090"], ["account_id", "Hooli X"], ["target_slug", "PLDT"], ["owner_id", "1"], ["owner_type", "Payment"], ["external_id", "786631e8c08249666f97c2ed"]] +  (1.1ms) COMMIT + User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 1]] + Payment Load (0.3ms) SELECT "payments".* FROM "payments" WHERE "payments"."id" = $1 LIMIT 1 [["id", 1]] +  (0.3ms) ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL +  (10.5ms) TRUNCATE TABLE "public"."billers", "public"."users", "public"."bloom_remit_txns", "public"."bloom_remit_responses", "public"."payments" RESTART IDENTITY CASCADE; +  (0.3ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL +  (0.2ms) BEGIN + SQL (0.5ms) INSERT INTO "users" DEFAULT VALUES RETURNING "id" +  (0.7ms) COMMIT +  (0.3ms) BEGIN + SQL (0.5ms) INSERT INTO "bloom_remit_txns" ("target_slug", "amount", "secret", "external_id", "sender_id", "sender_type") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["target_slug", "TARGET_SLUG"], ["amount", "2500.0"], ["secret", "4fdd287b-5237-4c2d-bbe3-9fce4fa6ca9d"], ["external_id", "bb87b488581bb3963f1ae681"], ["sender_id", "1"], ["sender_type", "User"]] +  (0.5ms) COMMIT + BloomRemit::Txn Load (0.4ms) SELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 AND "bloom_remit_txns"."secret" = $2 LIMIT 1 [["id", 1], ["secret", "4fdd287b-5237-4c2d-bbe3-9fce4fa6ca9d"]] +  (0.2ms) BEGIN + SQL (0.5ms) UPDATE "bloom_remit_txns" SET "status" = $1, "status_description" = $2, "vendor_external_id" = $3 WHERE "bloom_remit_txns"."id" = $4 [["status", 1], ["status_description", "My status description"], ["vendor_external_id", "somerefno"], ["id", 1]] +  (0.5ms) COMMIT +  (0.3ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL +  (10.1ms) TRUNCATE TABLE "public"."billers", "public"."users", "public"."bloom_remit_txns", "public"."bloom_remit_responses", "public"."payments" RESTART IDENTITY CASCADE; +  (0.3ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL +  (0.2ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.2ms) ROLLBACK +  (0.3ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +  (0.5ms) COMMIT +  (0.3ms) BEGIN +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.5ms) INSERT INTO "users" DEFAULT VALUES RETURNING "id" +  (0.3ms) RELEASE SAVEPOINT active_record_1 +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.7ms) INSERT INTO "bloom_remit_txns" ("target_slug", "amount", "secret", "external_id", "sender_id", "sender_type") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["target_slug", "TARGET_SLUG"], ["amount", "2500.0"], ["secret", "cd84855b-ba05-4e15-8c5a-84339bcd8949"], ["external_id", "c9734b05a759b19e79288cbd"], ["sender_id", "1"], ["sender_type", "User"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +Started POST "/bloom_remit/api/v1/txns/1" for 127.0.0.1 at 2016-08-17 00:41:20 +0000 +Processing by BloomRemit::Api::V1::TxnsController#post_update as JSON + Parameters: {"secret"=>"fake", "status"=>"doesn't matter", "id"=>"1", "txn"=>{"status"=>"doesn't matter", "secret"=>"fake"}} + BloomRemit::Txn Load (0.4ms) SELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 AND "bloom_remit_txns"."secret" = $2 LIMIT 1 [["id", 1], ["secret", nil]] + Rendered text template (0.0ms) +Completed 404 Not Found in 40ms (Views: 38.2ms | ActiveRecord: 0.4ms) +Started POST "/bloom_remit/api/v1/txns/1" for 127.0.0.1 at 2016-08-17 00:41:20 +0000 +Processing by BloomRemit::Api::V1::TxnsController#post_update as JSON + Parameters: {"secret"=>"cd84855b-ba05-4e15-8c5a-84339bcd8949", "status"=>"paid", "id"=>"1", "txn"=>{"status"=>"paid", "secret"=>"cd84855b-ba05-4e15-8c5a-84339bcd8949"}} + BloomRemit::Txn Load (0.4ms) SELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 AND "bloom_remit_txns"."secret" = $2 LIMIT 1 [["id", 1], ["secret", "cd84855b-ba05-4e15-8c5a-84339bcd8949"]] +  (0.4ms) SAVEPOINT active_record_1 + SQL (0.4ms) UPDATE "bloom_remit_txns" SET "status" = $1 WHERE "bloom_remit_txns"."id" = $2 [["status", 1], ["id", 1]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +Completed 200 OK in 7ms (Views: 0.4ms | ActiveRecord: 1.4ms) + BloomRemit::Txn Load (0.3ms) SELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 LIMIT 1 [["id", 1]] +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "users" DEFAULT VALUES RETURNING "id" +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "bloom_remit_txns" ("target_slug", "amount", "secret", "external_id", "sender_id", "sender_type") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["target_slug", "TARGET_SLUG"], ["amount", "2500.0"], ["secret", "5c753e87-9c88-48df-9db8-84ae83c9bb68"], ["external_id", "79a121e4b804673472668ca0"], ["sender_id", "2"], ["sender_type", "User"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +Started PATCH "/bloom_remit/api/v1/txns/2" for 127.0.0.1 at 2016-08-17 00:41:20 +0000 +Processing by BloomRemit::Api::V1::TxnsController#update as JSON + Parameters: {"secret"=>"fake", "status"=>"doesn't matter", "id"=>"2", "txn"=>{"status"=>"doesn't matter", "secret"=>"fake"}} + BloomRemit::Txn Load (0.4ms) SELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 AND "bloom_remit_txns"."secret" = $2 LIMIT 1 [["id", 2], ["secret", nil]] + Rendered text template (0.0ms) +Completed 404 Not Found in 2ms (Views: 0.5ms | ActiveRecord: 0.4ms) +Started PATCH "/bloom_remit/api/v1/txns/2" for 127.0.0.1 at 2016-08-17 00:41:20 +0000 +Processing by BloomRemit::Api::V1::TxnsController#update as JSON + Parameters: {"secret"=>"5c753e87-9c88-48df-9db8-84ae83c9bb68", "status"=>"paid", "id"=>"2", "txn"=>{"status"=>"paid", "secret"=>"5c753e87-9c88-48df-9db8-84ae83c9bb68"}} + BloomRemit::Txn Load (0.4ms) SELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 AND "bloom_remit_txns"."secret" = $2 LIMIT 1 [["id", 2], ["secret", "5c753e87-9c88-48df-9db8-84ae83c9bb68"]] +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.4ms) UPDATE "bloom_remit_txns" SET "status" = $1 WHERE "bloom_remit_txns"."id" = $2 [["status", 1], ["id", 2]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +Completed 204 No Content in 37ms (ActiveRecord: 1.4ms) + BloomRemit::Txn Load (0.5ms) SELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 LIMIT 1 [["id", 2]] +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "users" ("type") VALUES ($1) RETURNING "id" [["type", "SubUser"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.5ms) INSERT INTO "billers" ("slug") VALUES ($1) RETURNING "id" [["slug", "PLDT"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "payments" ("type") VALUES ($1) RETURNING "id" [["type", "SubPayment"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "bloom_remit_txns" ("secret", "sender_type", "sender_id", "amount", "account_name", "account_id", "target_slug", "owner_id", "owner_type", "external_id") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) RETURNING "id" [["secret", "0528a802-e2b8-4201-b5b6-397b8898d272"], ["sender_type", "User"], ["sender_id", "3"], ["amount", "800.0"], ["account_name", "028109090"], ["account_id", "Hooli X"], ["target_slug", "PLDT"], ["owner_id", "1"], ["owner_type", "Payment"], ["external_id", "1e2e391c01bfb3f1ad43143f"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.3ms) ROLLBACK +  (0.3ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "payments" DEFAULT VALUES RETURNING "id" +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "users" DEFAULT VALUES RETURNING "id" +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "bloom_remit_txns" ("target_slug", "amount", "secret", "external_id", "owner_id", "owner_type", "sender_id", "sender_type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id" [["target_slug", "TARGET_SLUG"], ["amount", "2500.0"], ["secret", "bbd98f05-7eb6-49dd-b122-269770e20a0a"], ["external_id", "2221cac99e93d66b6517eccd"], ["owner_id", "2"], ["owner_type", "Payment"], ["sender_id", "4"], ["sender_type", "User"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.6ms) INSERT INTO "bloom_remit_responses" ("body", "txn_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["body", "{\"i\":\"am body\"}"], ["txn_id", 4], ["created_at", "2016-08-17 00:41:20.598918"], ["updated_at", "2016-08-17 00:41:20.598918"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.4ms) SELECT COUNT(*) FROM "bloom_remit_responses" WHERE "bloom_remit_responses"."txn_id" = $1 [["txn_id", 4]] + BloomRemit::Response Load (0.3ms) SELECT "bloom_remit_responses".* FROM "bloom_remit_responses" WHERE "bloom_remit_responses"."txn_id" = $1 ORDER BY "bloom_remit_responses"."id" ASC LIMIT 1 [["txn_id", 4]] +  (0.3ms) ROLLBACK +  (0.3ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.4ms) ROLLBACK +  (0.2ms) BEGIN +  (0.4ms) COMMIT +  (0.4ms) BEGIN +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +  (0.2ms) COMMIT +  (0.4ms) BEGIN +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +  (0.2ms) COMMIT +  (0.2ms) BEGIN +  (0.2ms) ROLLBACK