spec/dummy/log/test.log in bloom_remit-0.6.1 vs spec/dummy/log/test.log in bloom_remit-0.7.0

@@ -30632,5 +30632,876 @@
    (0.2ms)  ROLLBACK
    (0.2ms)  BEGIN
    (0.2ms)  COMMIT
    (0.2ms)  BEGIN
    (0.2ms)  ROLLBACK
+  SQL (1.3ms)  CREATE EXTENSION IF NOT EXISTS "plpgsql"
+  SQL (21.5ms)  CREATE EXTENSION IF NOT EXISTS "hstore"
+   (12.1ms)  CREATE TABLE "billers" ("id" serial primary key, "slug" character varying) 
+   (5.8ms)  CREATE TABLE "bloom_remit_billers" ("id" serial primary key, "slug" character varying NOT NULL, "description" text, "fields" hstore, "service_charge" decimal DEFAULT 0.0 NOT NULL, "deactivated_at" timestamp, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) 
+   (8.5ms)  CREATE TABLE "bloom_remit_responses" ("id" serial primary key, "txn_id" integer NOT NULL, "body" text NOT NULL, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) 
+   (3.5ms)  CREATE  INDEX  "index_bloom_remit_responses_on_txn_id" ON "bloom_remit_responses" USING btree ("txn_id")
+   (11.6ms)  CREATE TABLE "bloom_remit_txns" ("id" serial primary key, "status" integer DEFAULT 0 NOT NULL, "sender_id" character varying NOT NULL, "sender_type" character varying NOT NULL, "amount" decimal NOT NULL, "account_name" character varying, "account_id" character varying, "secret" uuid NOT NULL, "target_slug" character varying NOT NULL, "owner_id" character varying, "owner_type" character varying, "external_id" character varying NOT NULL, "status_description" text, "vendor_external_id" character varying) 
+   (4.3ms)  CREATE  INDEX  "index_bloom_remit_txns_on_external_id" ON "bloom_remit_txns" USING btree ("external_id")
+   (3.9ms)  CREATE  INDEX  "index_bloom_remit_txns_on_owner_id_and_owner_type" ON "bloom_remit_txns" USING btree ("owner_id", "owner_type")
+   (5.0ms)  CREATE  INDEX  "index_bloom_remit_txns_on_vendor_external_id" ON "bloom_remit_txns" USING btree ("vendor_external_id")
+   (6.1ms)  CREATE TABLE "payments" ("id" serial primary key, "type" character varying) 
+   (9.3ms)  CREATE TABLE "users" ("id" serial primary key, "email" character varying, "bloom_remit_id" character varying, "type" character varying) 
+   (5.3ms)  CREATE TABLE "schema_migrations" ("version" character varying NOT NULL) 
+   (2.9ms)  CREATE UNIQUE INDEX  "unique_schema_migrations" ON "schema_migrations"  ("version")
+   (0.7ms)  SELECT version FROM "schema_migrations"
+   (1.0ms)  INSERT INTO "schema_migrations" (version) VALUES ('20160817003323')
+   (1.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20160729085500')
+   (0.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20160805001840')
+   (0.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20160805042105')
+   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20160806011259')
+   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20160806012210')
+  ActiveRecord::SchemaMigration Load (0.5ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+   (2.1ms)  DROP DATABASE IF EXISTS "postgres"
+  ActiveRecord::SchemaMigration Load (0.5ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+  ActiveRecord::SchemaMigration Load (0.6ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+  ActiveRecord::SchemaMigration Load (0.3ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+   (2.4ms)  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.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_billers'
+  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_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.3ms)  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.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 = 'users'
+  AND t3.nspname = ANY (current_schemas(false))
+ORDER BY c.conname
+
+  ActiveRecord::SchemaMigration Load (0.5ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+   (0.9ms)  DROP DATABASE IF EXISTS "postgres"
+  ActiveRecord::SchemaMigration Load (0.5ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+  ActiveRecord::SchemaMigration Load (0.6ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+   (0.9ms)  DROP DATABASE IF EXISTS "postgres"
+  ActiveRecord::SchemaMigration Load (0.5ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+  ActiveRecord::SchemaMigration Load (0.5ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+Migrating to CreateBloomRemitTxns (20160729070509)
+   (0.3ms)  BEGIN
+   (2.4ms)  CREATE TABLE "bloom_remit_txns" ("id" serial primary key, "status" integer DEFAULT 0 NOT NULL, "recipient_type" character varying NOT NULL, "recipient_id" character varying NOT NULL, "sender_id" integer NOT NULL, "sender_type" character varying NOT NULL, "amount" decimal NOT NULL, "account_name" character varying, "account_id" character varying, "secret" uuid NOT NULL) 
+   (0.3ms)  ROLLBACK
+   (5.6ms)  CREATE TABLE "schema_migrations" ("version" character varying NOT NULL) 
+   (2.5ms)  CREATE UNIQUE INDEX  "unique_schema_migrations" ON "schema_migrations"  ("version")
+  ActiveRecord::SchemaMigration Load (0.4ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+Migrating to CreateBloomRemitTxns (20160729070509)
+   (0.2ms)  BEGIN
+   (7.4ms)  CREATE TABLE "bloom_remit_txns" ("id" serial primary key, "status" integer DEFAULT 0 NOT NULL, "recipient_type" character varying NOT NULL, "recipient_id" character varying NOT NULL, "sender_id" integer NOT NULL, "sender_type" character varying NOT NULL, "amount" decimal NOT NULL, "account_name" character varying, "account_id" character varying, "secret" uuid NOT NULL) 
+  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160729070509"]]
+   (1.4ms)  COMMIT
+Migrating to CreateUsers (20160729085500)
+   (0.2ms)  BEGIN
+   (6.4ms)  CREATE TABLE "users" ("id" serial primary key, "email" character varying, "bloom_remit_id" character varying) 
+  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160729085500"]]
+   (1.3ms)  COMMIT
+Migrating to CreateBillers (20160805001840)
+   (0.3ms)  BEGIN
+   (8.1ms)  CREATE TABLE "billers" ("id" serial primary key, "slug" character varying) 
+  SQL (0.8ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160805001840"]]
+   (1.1ms)  COMMIT
+Migrating to DropRecipientFromTxns (20160805004223)
+   (0.2ms)  BEGIN
+   (1.1ms)  ALTER TABLE "bloom_remit_txns" DROP "recipient_id"
+   (0.7ms)  ALTER TABLE "bloom_remit_txns" DROP "recipient_type"
+  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160805004223"]]
+   (0.9ms)  COMMIT
+Migrating to AddTargetSlugToBloomRemitTxns (20160805004350)
+   (0.2ms)  BEGIN
+   (0.9ms)  ALTER TABLE "bloom_remit_txns" ADD "target_slug" character varying NOT NULL
+  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160805004350"]]
+   (0.7ms)  COMMIT
+Migrating to AddOwnerToBloomRemitTxns (20160805040950)
+   (0.6ms)  BEGIN
+   (0.9ms)  ALTER TABLE "bloom_remit_txns" ADD "owner_id" character varying
+   (0.5ms)  ALTER TABLE "bloom_remit_txns" ADD "owner_type" character varying
+   (3.1ms)  CREATE  INDEX  "index_bloom_remit_txns_on_owner_id_and_owner_type" ON "bloom_remit_txns"  ("owner_id", "owner_type")
+  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160805040950"]]
+   (1.8ms)  COMMIT
+Migrating to CreatePayments (20160805042105)
+   (0.2ms)  BEGIN
+   (6.3ms)  CREATE TABLE "payments" ("id" serial primary key) 
+  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160805042105"]]
+   (1.3ms)  COMMIT
+Migrating to ChangeTxnsSenderIdToString (20160805095308)
+   (0.2ms)  BEGIN
+   (9.1ms)  ALTER TABLE "bloom_remit_txns" ALTER COLUMN "sender_id" TYPE character varying
+  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160805095308"]]
+   (1.7ms)  COMMIT
+Migrating to AddTypeToUsers (20160806011259)
+   (0.4ms)  BEGIN
+   (0.9ms)  ALTER TABLE "users" ADD "type" character varying
+  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160806011259"]]
+   (1.7ms)  COMMIT
+Migrating to AddTypeToPayments (20160806012210)
+   (0.3ms)  BEGIN
+   (4.5ms)  ALTER TABLE "payments" ADD "type" character varying
+  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160806012210"]]
+   (1.1ms)  COMMIT
+Migrating to CreateBloomRemitResponses (20160806054012)
+   (0.3ms)  BEGIN
+   (9.2ms)  CREATE TABLE "bloom_remit_responses" ("id" serial primary key, "txn_id" integer NOT NULL, "body" text NOT NULL, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) 
+   (3.3ms)  CREATE  INDEX  "index_bloom_remit_responses_on_txn_id" ON "bloom_remit_responses"  ("txn_id")
+  SQL (0.4ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160806054012"]]
+   (1.2ms)  COMMIT
+Migrating to AddExternalIdToBloomRemitTxns (20160808081300)
+   (0.3ms)  BEGIN
+   (0.7ms)  ALTER TABLE "bloom_remit_txns" ADD "external_id" character varying NOT NULL
+   (2.2ms)  CREATE  INDEX  "index_bloom_remit_txns_on_external_id" ON "bloom_remit_txns"  ("external_id")
+  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160808081300"]]
+   (0.8ms)  COMMIT
+Migrating to AddStatusDescriptionToBloomRemitTxns (20160809043433)
+   (0.3ms)  BEGIN
+   (2.2ms)  ALTER TABLE "bloom_remit_txns" ADD "status_description" text
+  SQL (0.4ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160809043433"]]
+   (1.0ms)  COMMIT
+Migrating to AddVendorExternalIdToBloomRemitTxns (20160817003323)
+   (0.3ms)  BEGIN
+   (0.5ms)  ALTER TABLE "bloom_remit_txns" ADD "vendor_external_id" character varying
+   (2.9ms)  CREATE  INDEX  "index_bloom_remit_txns_on_vendor_external_id" ON "bloom_remit_txns"  ("vendor_external_id")
+  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20160817003323"]]
+   (0.7ms)  COMMIT
+  ActiveRecord::SchemaMigration Load (0.4ms)  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
+
+   (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 = 'bloom_remit_responses'
+  AND t3.nspname = ANY (current_schemas(false))
+ORDER BY c.conname
+
+   (2.3ms)  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.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 = '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.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 "payments" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL
+   (1.3ms)            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 = 'app_test'
+   (26.4ms)  TRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" RESTART IDENTITY CASCADE;
+   (0.5ms)  ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL
+   (0.4ms)  BEGIN
+   (0.4ms)  COMMIT
+   (0.4ms)  BEGIN
+   (0.3ms)  ROLLBACK
+   (0.2ms)  BEGIN
+   (0.3ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.4ms)  ROLLBACK
+   (0.2ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.3ms)  BEGIN
+   (0.5ms)  ROLLBACK
+   (0.5ms)  BEGIN
+  SQL (0.7ms)  INSERT INTO "billers" ("slug") VALUES ($1) RETURNING "id"  [["slug", "PLDT"]]
+   (1.8ms)  COMMIT
+   (0.7ms)  BEGIN
+  SQL (0.5ms)  INSERT INTO "users" ("type") VALUES ($1) RETURNING "id"  [["type", "SubUser"]]
+   (0.9ms)  COMMIT
+   (0.3ms)  BEGIN
+  SQL (0.5ms)  INSERT INTO "payments" ("type") VALUES ($1) RETURNING "id"  [["type", "SubPayment"]]
+   (0.9ms)  COMMIT
+   (0.3ms)  BEGIN
+  SQL (0.7ms)  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", "b7b69113-ca68-43e5-b78c-ad22e96cb8b2"], ["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", "ac0eb9debf9e009c2864dc7c"]]
+   (0.9ms)  COMMIT
+  User Load (0.4ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
+  Payment Load (0.4ms)  SELECT  "payments".* FROM "payments" WHERE "payments"."id" = $1 LIMIT 1  [["id", 1]]
+   (0.3ms)  ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL
+   (35.1ms)  TRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" RESTART IDENTITY CASCADE;
+   (0.4ms)  ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL
+   (0.4ms)  BEGIN
+  SQL (0.8ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (0.9ms)  COMMIT
+   (0.2ms)  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", "29451f7c-e40b-43c0-9b87-19348a2b7224"], ["external_id", "9e70c49e5fd3514fb2b33e85"], ["sender_id", "1"], ["sender_type", "User"]]
+   (0.8ms)  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", "29451f7c-e40b-43c0-9b87-19348a2b7224"]]
+   (0.2ms)  BEGIN
+  SQL (1.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.8ms)  COMMIT
+   (0.2ms)  ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL
+   (36.4ms)  TRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" RESTART IDENTITY CASCADE;
+   (0.4ms)  ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL
+   (0.2ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.3ms)  ROLLBACK
+   (0.2ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  ROLLBACK
+   (0.3ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.4ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  ROLLBACK
+   (0.2ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.1ms)  BEGIN
+   (0.2ms)  ROLLBACK
+   (0.3ms)  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.2ms)  COMMIT
+   (0.1ms)  BEGIN
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.5ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  SAVEPOINT active_record_1
+  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", "aafcc137-973b-4b1b-af6f-235cfabe8b48"], ["external_id", "fab80018c674dc857bc86bd9"], ["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-09-01 08:28:10 +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 51ms (Views: 48.6ms | ActiveRecord: 0.4ms)
+Started POST "/bloom_remit/api/v1/txns/1" for 127.0.0.1 at 2016-09-01 08:28:11 +0000
+Processing by BloomRemit::Api::V1::TxnsController#post_update as JSON
+  Parameters: {"secret"=>"aafcc137-973b-4b1b-af6f-235cfabe8b48", "status"=>"paid", "id"=>"1", "txn"=>{"status"=>"paid", "secret"=>"aafcc137-973b-4b1b-af6f-235cfabe8b48"}}
+  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", "aafcc137-973b-4b1b-af6f-235cfabe8b48"]]
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.3ms)  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 8ms (Views: 0.4ms | ActiveRecord: 1.1ms)
+  BloomRemit::Txn Load (0.3ms)  SELECT  "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 LIMIT 1  [["id", 1]]
+   (0.2ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.1ms)  BEGIN
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.3ms)  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", "50716e10-ab3b-4a62-b681-f62063de9107"], ["external_id", "7174e538a66c3ff17d99122f"], ["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-09-01 08:28:11 +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 3ms (Views: 0.9ms | ActiveRecord: 0.4ms)
+Started PATCH "/bloom_remit/api/v1/txns/2" for 127.0.0.1 at 2016-09-01 08:28:11 +0000
+Processing by BloomRemit::Api::V1::TxnsController#update as JSON
+  Parameters: {"secret"=>"50716e10-ab3b-4a62-b681-f62063de9107", "status"=>"paid", "id"=>"2", "txn"=>{"status"=>"paid", "secret"=>"50716e10-ab3b-4a62-b681-f62063de9107"}}
+  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", "50716e10-ab3b-4a62-b681-f62063de9107"]]
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.3ms)  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 58ms (ActiveRecord: 1.2ms)
+  BloomRemit::Txn Load (0.4ms)  SELECT  "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 LIMIT 1  [["id", 2]]
+   (0.2ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.4ms)  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.5ms)  INSERT INTO "payments" ("type") VALUES ($1) RETURNING "id"  [["type", "SubPayment"]]
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  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", "383d5a17-8eab-4efe-8f83-2e329648c2b8"], ["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", "0616630a029ab914ed83d6e6"]]
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  ROLLBACK
+   (0.2ms)  BEGIN
+   (0.3ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  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.3ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  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", "6fa65d97-1cc8-47d6-acd5-807fb0e4a29a"], ["external_id", "de91f07512aba2b1fc7e568b"], ["owner_id", "2"], ["owner_type", "Payment"], ["sender_id", "4"], ["sender_type", "User"]]
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.4ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.3ms)  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.6ms)  RELEASE SAVEPOINT active_record_1
+   (0.4ms)  SAVEPOINT active_record_1
+  SQL (0.4ms)  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", "3380bc90-f525-474c-a1bf-fac7cc22933e"], ["external_id", "ae82cbca98a7b676c9cfcef8"], ["owner_id", "3"], ["owner_type", "Payment"], ["sender_id", "5"], ["sender_type", "User"]]
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.1ms)  BEGIN
+   (0.2ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.3ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.1ms)  BEGIN
+   (0.2ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  ROLLBACK
+  ActiveRecord::SchemaMigration Load (0.6ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+   (0.6ms)  ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL
+   (1.3ms)            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 = 'app_test'
+   (32.7ms)  TRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" RESTART IDENTITY CASCADE;
+   (0.5ms)  ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL
+   (0.4ms)  BEGIN
+   (0.3ms)  COMMIT
+   (0.3ms)  BEGIN
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.7ms)  INSERT INTO "payments" DEFAULT VALUES RETURNING "id"
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+   (0.4ms)  SAVEPOINT active_record_1
+  SQL (0.7ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (0.6ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.8ms)  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", "f2a38286-2fd8-4335-9e36-6e33046f9c02"], ["external_id", "b2a706b639cabd35a017c6a1"], ["owner_id", "1"], ["owner_type", "Payment"], ["sender_id", "1"], ["sender_type", "User"]]
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+   (0.5ms)  ROLLBACK
+   (0.3ms)  BEGIN
+   (0.3ms)  COMMIT
+   (0.3ms)  BEGIN
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.5ms)  INSERT INTO "payments" DEFAULT VALUES RETURNING "id"
+   (0.5ms)  RELEASE SAVEPOINT active_record_1
+   (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.6ms)  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", "0490b469-a25a-4108-9204-8aa8dd5d755c"], ["external_id", "078ed02b9909dc1d1c9965b2"], ["owner_id", "2"], ["owner_type", "Payment"], ["sender_id", "2"], ["sender_type", "User"]]
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  ROLLBACK
+  ActiveRecord::SchemaMigration Load (0.6ms)  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 "payments" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL
+   (1.3ms)            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 = 'app_test'
+   (26.6ms)  TRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" RESTART IDENTITY CASCADE;
+   (0.5ms)  ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL
+  ActiveRecord::SchemaMigration Load (0.5ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+   (0.5ms)  ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL
+   (1.3ms)            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 = 'app_test'
+   (33.8ms)  TRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" RESTART IDENTITY CASCADE;
+   (0.4ms)  ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL
+   (0.2ms)  BEGIN
+   (0.4ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.6ms)  INSERT INTO "payments" DEFAULT VALUES RETURNING "id"
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.6ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (0.4ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.7ms)  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", "18d7fd37-afde-4ae7-b7c2-a8dd670f4be2"], ["external_id", "0570128fc84b173c60c484ee"], ["owner_id", "1"], ["owner_type", "Payment"], ["sender_id", "1"], ["sender_type", "User"]]
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  ROLLBACK
+   (0.2ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.5ms)  INSERT INTO "payments" DEFAULT VALUES RETURNING "id"
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.3ms)  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", "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", "ab7faddd-844e-4f60-99ed-1051c336f19c"], ["external_id", "5959df784423b9b99808abcb"], ["owner_id", "2"], ["owner_type", "Payment"], ["sender_id", "2"], ["sender_type", "User"]]
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  ROLLBACK
+  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 "payments" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" 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 = 'app_test'
+   (38.8ms)  TRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" RESTART IDENTITY CASCADE;
+   (0.5ms)  ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL
+   (0.4ms)  BEGIN
+   (0.3ms)  COMMIT
+   (0.4ms)  BEGIN
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.7ms)  INSERT INTO "payments" DEFAULT VALUES RETURNING "id"
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.7ms)  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", "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", "b8a1b4b5-b10d-4fd8-952e-914e4a714539"], ["external_id", "b37131f8f23e9449d2c40e97"], ["owner_id", "1"], ["owner_type", "Payment"], ["sender_id", "1"], ["sender_type", "User"]]
+   (0.4ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  ROLLBACK
+   (0.3ms)  BEGIN
+   (0.6ms)  COMMIT
+   (0.6ms)  BEGIN
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.4ms)  INSERT INTO "payments" DEFAULT VALUES RETURNING "id"
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.4ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.5ms)  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", "7585a816-1191-44e0-8e29-5583782f91d8"], ["external_id", "19567584dbda43cf1574d76c"], ["owner_id", "2"], ["owner_type", "Payment"], ["sender_id", "2"], ["sender_type", "User"]]
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  ROLLBACK
+  ActiveRecord::SchemaMigration Load (0.5ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+   (0.8ms)  ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" 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.0ms)  select table_name from information_schema.views where table_schema = 'app_test'
+   (36.7ms)  TRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" 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 "payments" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL
+   (0.3ms)  BEGIN
+   (0.3ms)  COMMIT
+   (0.3ms)  BEGIN
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.5ms)  INSERT INTO "payments" DEFAULT VALUES RETURNING "id"
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.6ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (0.4ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (1.5ms)  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", "235e5623-9bcd-4c19-9451-7046432e612f"], ["external_id", "1af730ef4d77b4c3ef299e10"], ["owner_id", "1"], ["owner_type", "Payment"], ["sender_id", "1"], ["sender_type", "User"]]
+   (0.5ms)  RELEASE SAVEPOINT active_record_1
+   (0.6ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.1ms)  BEGIN
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.3ms)  INSERT INTO "payments" DEFAULT VALUES RETURNING "id"
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.5ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  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", "1e874f7f-78a1-41f1-b6a0-6d93ac8794ab"], ["external_id", "e9c4de674a71c3a4c3b033e0"], ["owner_id", "2"], ["owner_type", "Payment"], ["sender_id", "2"], ["sender_type", "User"]]
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  ROLLBACK
+  ActiveRecord::SchemaMigration Load (0.6ms)  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 "payments" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL
+   (1.3ms)            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 = 'app_test'
+   (28.2ms)  TRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" RESTART IDENTITY CASCADE;
+   (0.4ms)  ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL
+   (0.3ms)  BEGIN
+   (0.3ms)  COMMIT
+   (0.3ms)  BEGIN
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.6ms)  INSERT INTO "payments" DEFAULT VALUES RETURNING "id"
+   (0.4ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.6ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.7ms)  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", "732423bb-eddc-4e17-9dbe-18d9d1cb811d"], ["external_id", "51841a7af95130ba1a73513a"], ["owner_id", "1"], ["owner_type", "Payment"], ["sender_id", "1"], ["sender_type", "User"]]
+   (0.4ms)  RELEASE SAVEPOINT active_record_1
+   (0.4ms)  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", 1], ["created_at", "2016-09-01 08:36:57.667933"], ["updated_at", "2016-09-01 08:36:57.667933"]]
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+   (0.4ms)  SELECT COUNT(*) FROM "bloom_remit_responses" WHERE "bloom_remit_responses"."txn_id" = $1  [["txn_id", 1]]
+  BloomRemit::Response Load (0.6ms)  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", 1]]
+   (0.5ms)  ROLLBACK
+   (0.3ms)  BEGIN
+   (0.4ms)  COMMIT
+   (0.3ms)  BEGIN
+   (0.4ms)  SAVEPOINT active_record_1
+  SQL (0.5ms)  INSERT INTO "payments" DEFAULT VALUES RETURNING "id"
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.4ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.4ms)  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", "b6b38d6b-e6c2-43ce-b13f-8bfd44ad76a8"], ["external_id", "59eb8773a9f756be6c53a8e6"], ["owner_id", "2"], ["owner_type", "Payment"], ["sender_id", "2"], ["sender_type", "User"]]
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.5ms)  UPDATE "bloom_remit_txns" SET "status" = $1 WHERE "bloom_remit_txns"."id" = $2  [["status", 7], ["id", 2]]
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.4ms)  INSERT INTO "bloom_remit_responses" ("body", "txn_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id"  [["body", "{\"status\":\"500\",\"error\":\"Internal Server Error\"}"], ["txn_id", 2], ["created_at", "2016-09-01 08:36:57.755027"], ["updated_at", "2016-09-01 08:36:57.755027"]]
+   (0.3ms)  RELEASE SAVEPOINT active_record_1
+  BloomRemit::Txn Load (0.4ms)  SELECT  "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 LIMIT 1  [["id", 2]]
+   (0.3ms)  ROLLBACK
+  ActiveRecord::SchemaMigration Load (0.6ms)  SELECT "schema_migrations".* FROM "schema_migrations"
+   (0.5ms)  ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL
+   (1.3ms)            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 = 'app_test'
+   (33.2ms)  TRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" RESTART IDENTITY CASCADE;
+   (0.4ms)  ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL
+   (0.3ms)  BEGIN
+   (0.4ms)  COMMIT
+   (0.3ms)  BEGIN
+   (0.8ms)  ROLLBACK
+   (0.3ms)  BEGIN
+   (0.4ms)  COMMIT
+   (0.3ms)  BEGIN
+   (0.3ms)  ROLLBACK
+   (0.3ms)  BEGIN
+   (0.3ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.4ms)  ROLLBACK
+   (0.4ms)  BEGIN
+  SQL (1.3ms)  INSERT INTO "billers" ("slug") VALUES ($1) RETURNING "id"  [["slug", "PLDT"]]
+   (1.7ms)  COMMIT
+   (0.2ms)  BEGIN
+  SQL (0.3ms)  INSERT INTO "users" ("type") VALUES ($1) RETURNING "id"  [["type", "SubUser"]]
+   (0.8ms)  COMMIT
+   (0.2ms)  BEGIN
+  SQL (0.4ms)  INSERT INTO "payments" ("type") VALUES ($1) RETURNING "id"  [["type", "SubPayment"]]
+   (0.9ms)  COMMIT
+   (0.2ms)  BEGIN
+  SQL (0.5ms)  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", "2935470c-8fa5-4d20-aa94-4c04b3ba75aa"], ["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", "0093d4a144f850794a78439c"]]
+   (0.8ms)  COMMIT
+  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
+  Payment Load (0.4ms)  SELECT  "payments".* FROM "payments" WHERE "payments"."id" = $1 LIMIT 1  [["id", 1]]
+   (0.4ms)  ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL
+   (33.2ms)  TRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" 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 "payments" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL
+   (0.2ms)  BEGIN
+  SQL (0.5ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (0.6ms)  COMMIT
+   (0.2ms)  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", "3445a3fd-5c88-471d-ad94-5457b5e1cdab"], ["external_id", "045f4d23680a331a785ca3d7"], ["sender_id", "1"], ["sender_type", "User"]]
+   (0.7ms)  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", "3445a3fd-5c88-471d-ad94-5457b5e1cdab"]]
+   (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.8ms)  COMMIT
+   (0.3ms)  ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL
+   (34.1ms)  TRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" RESTART IDENTITY CASCADE;
+   (0.4ms)  ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  ROLLBACK
+   (0.2ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.1ms)  BEGIN
+   (0.4ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.1ms)  BEGIN
+   (0.2ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.3ms)  BEGIN
+   (0.2ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.1ms)  BEGIN
+   (0.2ms)  ROLLBACK
+   (0.2ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.1ms)  BEGIN
+   (0.3ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.5ms)  SAVEPOINT active_record_1
+  SQL (0.5ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (0.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.2ms)  SAVEPOINT active_record_1
+  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", "faef9bb7-6374-4476-9424-667592765c30"], ["external_id", "287cf61afd727c5c40cdf7d7"], ["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-09-01 08:40:21 +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 54ms (Views: 52.0ms | ActiveRecord: 0.4ms)
+Started POST "/bloom_remit/api/v1/txns/1" for 127.0.0.1 at 2016-09-01 08:40:21 +0000
+Processing by BloomRemit::Api::V1::TxnsController#post_update as JSON
+  Parameters: {"secret"=>"faef9bb7-6374-4476-9424-667592765c30", "status"=>"paid", "id"=>"1", "txn"=>{"status"=>"paid", "secret"=>"faef9bb7-6374-4476-9424-667592765c30"}}
+  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", "faef9bb7-6374-4476-9424-667592765c30"]]
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.2ms)  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.0ms)
+  BloomRemit::Txn Load (0.4ms)  SELECT  "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 LIMIT 1  [["id", 1]]
+   (0.2ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  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.3ms)  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", "2b86b0fc-0bc5-4b2b-a32c-4e01a3876ea4"], ["external_id", "cedeae050a38c571c6c209bd"], ["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-09-01 08:40:21 +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 3ms (Views: 1.0ms | ActiveRecord: 0.4ms)
+Started PATCH "/bloom_remit/api/v1/txns/2" for 127.0.0.1 at 2016-09-01 08:40:21 +0000
+Processing by BloomRemit::Api::V1::TxnsController#update as JSON
+  Parameters: {"secret"=>"2b86b0fc-0bc5-4b2b-a32c-4e01a3876ea4", "status"=>"paid", "id"=>"2", "txn"=>{"status"=>"paid", "secret"=>"2b86b0fc-0bc5-4b2b-a32c-4e01a3876ea4"}}
+  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", "2b86b0fc-0bc5-4b2b-a32c-4e01a3876ea4"]]
+   (0.2ms)  SAVEPOINT active_record_1
+  SQL (0.5ms)  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 47ms (ActiveRecord: 1.2ms)
+  BloomRemit::Txn Load (0.4ms)  SELECT  "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 LIMIT 1  [["id", 2]]
+   (0.2ms)  ROLLBACK
+   (0.1ms)  BEGIN
+   (0.2ms)  COMMIT
+   (0.2ms)  BEGIN
+   (0.2ms)  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.5ms)  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.8ms)  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", "f73d1176-2716-4230-b98a-af564a5566f6"], ["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", "dc278d6fbda5aa0b1708f5db"]]
+   (0.4ms)  RELEASE SAVEPOINT active_record_1
+   (1.9ms)  ROLLBACK
+   (2.7ms)  BEGIN
+   (0.6ms)  COMMIT
+   (0.6ms)  BEGIN
+   (0.7ms)  ROLLBACK
+   (0.4ms)  BEGIN
+   (0.4ms)  COMMIT
+   (0.4ms)  BEGIN
+   (0.8ms)  SAVEPOINT active_record_1
+  SQL (4.2ms)  INSERT INTO "payments" DEFAULT VALUES RETURNING "id"
+   (0.8ms)  RELEASE SAVEPOINT active_record_1
+   (0.5ms)  SAVEPOINT active_record_1
+  SQL (0.5ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (1.1ms)  RELEASE SAVEPOINT active_record_1
+   (0.7ms)  SAVEPOINT active_record_1
+  SQL (1.0ms)  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", "a113628f-420a-4380-b4ae-1db1223907bd"], ["external_id", "8d28b8e1bea5134259a1351f"], ["owner_id", "2"], ["owner_type", "Payment"], ["sender_id", "4"], ["sender_type", "User"]]
+   (0.5ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.5ms)  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-09-01 08:40:22.234828"], ["updated_at", "2016-09-01 08:40:22.234828"]]
+   (0.4ms)  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.4ms)  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.4ms)  COMMIT
+   (0.5ms)  BEGIN
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.6ms)  INSERT INTO "payments" DEFAULT VALUES RETURNING "id"
+   (1.4ms)  RELEASE SAVEPOINT active_record_1
+   (0.3ms)  SAVEPOINT active_record_1
+  SQL (0.5ms)  INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+   (1.2ms)  RELEASE SAVEPOINT active_record_1
+   (0.4ms)  SAVEPOINT active_record_1
+  SQL (0.7ms)  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", "63741166-4b03-4f41-a0e0-cd7f76d02df5"], ["external_id", "ba558d75a7a3664ec081bd46"], ["owner_id", "3"], ["owner_type", "Payment"], ["sender_id", "5"], ["sender_type", "User"]]
+   (0.4ms)  RELEASE SAVEPOINT active_record_1
+   (0.5ms)  SAVEPOINT active_record_1
+  SQL (1.4ms)  UPDATE "bloom_remit_txns" SET "status" = $1 WHERE "bloom_remit_txns"."id" = $2  [["status", 7], ["id", 5]]
+   (1.9ms)  RELEASE SAVEPOINT active_record_1
+   (0.4ms)  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", "{\"status\":\"500\",\"error\":\"Internal Server Error\"}"], ["txn_id", 5], ["created_at", "2016-09-01 08:40:22.299392"], ["updated_at", "2016-09-01 08:40:22.299392"]]
+   (0.4ms)  RELEASE SAVEPOINT active_record_1
+  BloomRemit::Txn Load (1.1ms)  SELECT  "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 LIMIT 1  [["id", 5]]
+   (1.7ms)  ROLLBACK
+   (0.4ms)  BEGIN
+   (0.4ms)  COMMIT
+   (0.3ms)  BEGIN
+   (0.4ms)  ROLLBACK
+   (0.4ms)  BEGIN
+   (0.7ms)  COMMIT
+   (0.5ms)  BEGIN
+   (0.7ms)  ROLLBACK
+   (0.5ms)  BEGIN
+   (0.5ms)  COMMIT
+   (2.2ms)  BEGIN
+   (0.5ms)  ROLLBACK
+   (0.5ms)  BEGIN
+   (0.5ms)  COMMIT
+   (0.4ms)  BEGIN
+   (0.4ms)  ROLLBACK
+   (0.3ms)  BEGIN
+   (0.4ms)  COMMIT
+   (0.4ms)  BEGIN
+   (0.4ms)  ROLLBACK