spec/dummy/log/test.log in bloom_remit-0.8.0 vs spec/dummy/log/test.log in bloom_remit-0.9.0
- old
+ new
@@ -33825,5 +33825,601 @@
[1m[35m (0.6ms)[0m ROLLBACK
[1m[36m (0.5ms)[0m [1mBEGIN[0m
[1m[35m (0.3ms)[0m COMMIT
[1m[36m (0.4ms)[0m [1mBEGIN[0m
[1m[35m (0.6ms)[0m ROLLBACK
+ [1m[36mActiveRecord::SchemaMigration Load (14.7ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+ [1m[36mActiveRecord::SchemaMigration Load (0.9ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+ [1m[36mActiveRecord::SchemaMigration Load (0.9ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+ [1m[35m (4.1ms)[0m ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "billers" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" DISABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" DISABLE TRIGGER ALL;ALTER TABLE "payments" DISABLE TRIGGER ALL;ALTER TABLE "users" DISABLE TRIGGER ALL
+ [1m[36m (1.9ms)[0m [1m SELECT schemaname || '.' || tablename
+ FROM pg_tables
+ WHERE
+ tablename !~ '_prt_' AND
+ tablename <> 'schema_migrations' AND
+ schemaname = ANY (current_schemas(false))
+[0m
+ [1m[35m (5.2ms)[0m select table_name from information_schema.views where table_schema = 'app_test'
+ [1m[36m (394.9ms)[0m [1mTRUNCATE TABLE "public"."billers", "public"."bloom_remit_responses", "public"."bloom_remit_txns", "public"."payments", "public"."users" RESTART IDENTITY CASCADE;[0m
+ [1m[35m (1.0ms)[0m ALTER TABLE "billers" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_responses" ENABLE TRIGGER ALL;ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "bloom_remit_txns" ENABLE TRIGGER ALL;ALTER TABLE "payments" ENABLE TRIGGER ALL;ALTER TABLE "users" ENABLE TRIGGER ALL
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (0.5ms)[0m COMMIT
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (0.7ms)[0m SAVEPOINT active_record_1
+ [1m[36mSQL (1.0ms)[0m [1mINSERT INTO "users" ("type") VALUES ($1) RETURNING "id"[0m [["type", "SubUser"]]
+ [1m[35m (0.6ms)[0m RELEASE SAVEPOINT active_record_1
+ [1m[36m (0.6ms)[0m [1mSAVEPOINT active_record_1[0m
+ [1m[35mSQL (0.8ms)[0m INSERT INTO "billers" ("slug") VALUES ($1) RETURNING "id" [["slug", "PLDT"]]
+ [1m[36m (0.5ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
+ [1m[35m (0.7ms)[0m SAVEPOINT active_record_1
+ [1m[36mSQL (0.8ms)[0m [1mINSERT INTO "payments" ("type") VALUES ($1) RETURNING "id"[0m [["type", "SubPayment"]]
+ [1m[35m (0.5ms)[0m RELEASE SAVEPOINT active_record_1
+ [1m[36m (0.7ms)[0m [1mSAVEPOINT active_record_1[0m
+ [1m[35mSQL (1.0ms)[0m 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", "9e4c75e1-fbf0-45e7-9cd4-6f0deb8abab4"], ["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", "f8346db2d56fbc2f8ba599b7"]]
+ [1m[36m (0.6ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
+ [1m[35m (0.8ms)[0m ROLLBACK
+ [1m[36mActiveRecord::SchemaMigration Load (3.8ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+ [1m[36m (226.4ms)[0m [1mDROP DATABASE IF EXISTS "app_test"[0m
+ [1m[35m (596.9ms)[0m CREATE DATABASE "app_test" ENCODING = 'unicode'
+ [1m[36mSQL (2.7ms)[0m [1mCREATE EXTENSION IF NOT EXISTS "plpgsql"[0m
+ [1m[35m (123.1ms)[0m CREATE TABLE "billers" ("id" serial primary key, "slug" character varying)
+ [1m[36m (84.4ms)[0m [1mCREATE 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) [0m
+ [1m[35m (55.5ms)[0m CREATE INDEX "index_bloom_remit_responses_on_txn_id" ON "bloom_remit_responses" USING btree ("txn_id")
+ [1m[36m (79.7ms)[0m [1mCREATE 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) [0m
+ [1m[35m (51.4ms)[0m CREATE INDEX "index_bloom_remit_txns_on_external_id" ON "bloom_remit_txns" USING btree ("external_id")
+ [1m[36m (39.4ms)[0m [1mCREATE INDEX "index_bloom_remit_txns_on_owner_id_and_owner_type" ON "bloom_remit_txns" USING btree ("owner_id", "owner_type")[0m
+ [1m[35m (44.2ms)[0m CREATE INDEX "index_bloom_remit_txns_on_vendor_external_id" ON "bloom_remit_txns" USING btree ("vendor_external_id")
+ [1m[36m (90.4ms)[0m [1mCREATE TABLE "payments" ("id" serial primary key, "type" character varying) [0m
+ [1m[35m (73.1ms)[0m CREATE TABLE "users" ("id" serial primary key, "email" character varying, "bloom_remit_id" character varying, "type" character varying)
+ [1m[36m (44.3ms)[0m [1mCREATE TABLE "schema_migrations" ("version" character varying NOT NULL) [0m
+ [1m[35m (44.0ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
+ [1m[36m (1.4ms)[0m [1mSELECT version FROM "schema_migrations"[0m
+ [1m[35m (13.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20160817003323')
+ [1m[36m (14.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20160729085500')[0m
+ [1m[35m (11.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20160805001840')
+ [1m[36m (11.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20160805042105')[0m
+ [1m[35m (12.7ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20160806011259')
+ [1m[36m (11.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20160806012210')[0m
+ [1m[35mActiveRecord::SchemaMigration Load (0.8ms)[0m SELECT "schema_migrations".* FROM "schema_migrations"
+ [1m[36mActiveRecord::SchemaMigration Load (1.2ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+ [1m[36m (224.6ms)[0m [1mDROP DATABASE IF EXISTS "app_test"[0m
+ [1m[35m (512.8ms)[0m CREATE DATABASE "app_test" ENCODING = 'unicode'
+ [1m[36mSQL (0.8ms)[0m [1mCREATE EXTENSION IF NOT EXISTS "plpgsql"[0m
+ [1m[35m (59.9ms)[0m CREATE TABLE "billers" ("id" serial primary key, "slug" character varying)
+ [1m[36m (56.9ms)[0m [1mCREATE 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) [0m
+ [1m[35m (38.0ms)[0m CREATE INDEX "index_bloom_remit_responses_on_txn_id" ON "bloom_remit_responses" USING btree ("txn_id")
+ [1m[36m (53.3ms)[0m [1mCREATE 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) [0m
+ [1m[35m (37.5ms)[0m CREATE INDEX "index_bloom_remit_txns_on_external_id" ON "bloom_remit_txns" USING btree ("external_id")
+ [1m[36m (32.5ms)[0m [1mCREATE INDEX "index_bloom_remit_txns_on_owner_id_and_owner_type" ON "bloom_remit_txns" USING btree ("owner_id", "owner_type")[0m
+ [1m[35m (46.9ms)[0m CREATE INDEX "index_bloom_remit_txns_on_vendor_external_id" ON "bloom_remit_txns" USING btree ("vendor_external_id")
+ [1m[36m (67.9ms)[0m [1mCREATE TABLE "payments" ("id" serial primary key, "type" character varying) [0m
+ [1m[35m (61.8ms)[0m CREATE TABLE "users" ("id" serial primary key, "email" character varying, "bloom_remit_id" character varying, "type" character varying)
+ [1m[36m (31.9ms)[0m [1mCREATE TABLE "schema_migrations" ("version" character varying NOT NULL) [0m
+ [1m[35m (37.2ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
+ [1m[36m (1.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
+ [1m[35m (11.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20160817003323')
+ [1m[36m (17.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20160729085500')[0m
+ [1m[35m (13.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20160805001840')
+ [1m[36m (17.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20160805042105')[0m
+ [1m[35m (16.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20160806011259')
+ [1m[36m (16.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20160806012210')[0m
+ [1m[35mActiveRecord::SchemaMigration Load (3.5ms)[0m SELECT "schema_migrations".* FROM "schema_migrations"
+ [1m[36mActiveRecord::SchemaMigration Load (2.3ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+Migrating to CreateBloomRemitTxns (20160729070509)
+ [1m[35m (0.9ms)[0m BEGIN
+ [1m[36m (4.4ms)[0m [1mCREATE 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) [0m
+ [1m[35m (0.6ms)[0m ROLLBACK
+ [1m[36m (38.8ms)[0m [1mCREATE TABLE "schema_migrations" ("version" character varying NOT NULL) [0m
+ [1m[35m (42.3ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
+ [1m[36mActiveRecord::SchemaMigration Load (1.0ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+Migrating to CreateBloomRemitTxns (20160729070509)
+ [1m[35m (0.6ms)[0m BEGIN
+ [1m[36m (51.8ms)[0m [1mCREATE 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) [0m
+ [1m[35mSQL (0.7ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160729070509"]]
+ [1m[36m (11.9ms)[0m [1mCOMMIT[0m
+Migrating to CreateUsers (20160729085500)
+ [1m[35m (2.9ms)[0m BEGIN
+ [1m[36m (77.6ms)[0m [1mCREATE TABLE "users" ("id" serial primary key, "email" character varying, "bloom_remit_id" character varying) [0m
+ [1m[35mSQL (0.6ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160729085500"]]
+ [1m[36m (26.3ms)[0m [1mCOMMIT[0m
+Migrating to CreateBillers (20160805001840)
+ [1m[35m (2.3ms)[0m BEGIN
+ [1m[36m (58.8ms)[0m [1mCREATE TABLE "billers" ("id" serial primary key, "slug" character varying) [0m
+ [1m[35mSQL (5.6ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160805001840"]]
+ [1m[36m (15.6ms)[0m [1mCOMMIT[0m
+Migrating to DropRecipientFromTxns (20160805004223)
+ [1m[35m (1.8ms)[0m BEGIN
+ [1m[36m (9.2ms)[0m [1mALTER TABLE "bloom_remit_txns" DROP "recipient_id"[0m
+ [1m[35m (6.5ms)[0m ALTER TABLE "bloom_remit_txns" DROP "recipient_type"
+ [1m[36mSQL (2.9ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805004223"]]
+ [1m[35m (17.2ms)[0m COMMIT
+Migrating to AddTargetSlugToBloomRemitTxns (20160805004350)
+ [1m[36m (2.0ms)[0m [1mBEGIN[0m
+ [1m[35m (2.9ms)[0m ALTER TABLE "bloom_remit_txns" ADD "target_slug" character varying NOT NULL
+ [1m[36mSQL (3.1ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805004350"]]
+ [1m[35m (18.0ms)[0m COMMIT
+Migrating to AddOwnerToBloomRemitTxns (20160805040950)
+ [1m[36m (0.9ms)[0m [1mBEGIN[0m
+ [1m[35m (1.4ms)[0m ALTER TABLE "bloom_remit_txns" ADD "owner_id" character varying
+ [1m[36m (4.6ms)[0m [1mALTER TABLE "bloom_remit_txns" ADD "owner_type" character varying[0m
+ [1m[35m (35.5ms)[0m CREATE INDEX "index_bloom_remit_txns_on_owner_id_and_owner_type" ON "bloom_remit_txns" ("owner_id", "owner_type")
+ [1m[36mSQL (3.2ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805040950"]]
+ [1m[35m (14.8ms)[0m COMMIT
+Migrating to CreatePayments (20160805042105)
+ [1m[36m (0.7ms)[0m [1mBEGIN[0m
+ [1m[35m (30.7ms)[0m CREATE TABLE "payments" ("id" serial primary key)
+ [1m[36mSQL (0.7ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805042105"]]
+ [1m[35m (23.6ms)[0m COMMIT
+Migrating to ChangeTxnsSenderIdToString (20160805095308)
+ [1m[36m (4.9ms)[0m [1mBEGIN[0m
+ [1m[35m (115.3ms)[0m ALTER TABLE "bloom_remit_txns" ALTER COLUMN "sender_id" TYPE character varying
+ [1m[36mSQL (0.6ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805095308"]]
+ [1m[35m (13.9ms)[0m COMMIT
+Migrating to AddTypeToUsers (20160806011259)
+ [1m[36m (0.7ms)[0m [1mBEGIN[0m
+ [1m[35m (1.1ms)[0m ALTER TABLE "users" ADD "type" character varying
+ [1m[36mSQL (0.6ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160806011259"]]
+ [1m[35m (12.1ms)[0m COMMIT
+Migrating to AddTypeToPayments (20160806012210)
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (25.1ms)[0m ALTER TABLE "payments" ADD "type" character varying
+ [1m[36mSQL (1.3ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160806012210"]]
+ [1m[35m (13.1ms)[0m COMMIT
+Migrating to CreateBloomRemitResponses (20160806054012)
+ [1m[36m (0.7ms)[0m [1mBEGIN[0m
+ [1m[35m (56.9ms)[0m 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)
+ [1m[36m (26.0ms)[0m [1mCREATE INDEX "index_bloom_remit_responses_on_txn_id" ON "bloom_remit_responses" ("txn_id")[0m
+ [1m[35mSQL (0.7ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160806054012"]]
+ [1m[36m (9.7ms)[0m [1mCOMMIT[0m
+Migrating to AddExternalIdToBloomRemitTxns (20160808081300)
+ [1m[35m (0.8ms)[0m BEGIN
+ [1m[36m (0.9ms)[0m [1mALTER TABLE "bloom_remit_txns" ADD "external_id" character varying NOT NULL[0m
+ [1m[35m (24.9ms)[0m CREATE INDEX "index_bloom_remit_txns_on_external_id" ON "bloom_remit_txns" ("external_id")
+ [1m[36mSQL (0.5ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160808081300"]]
+ [1m[35m (11.2ms)[0m COMMIT
+Migrating to AddStatusDescriptionToBloomRemitTxns (20160809043433)
+ [1m[36m (0.7ms)[0m [1mBEGIN[0m
+ [1m[35m (0.8ms)[0m ALTER TABLE "bloom_remit_txns" ADD "status_description" text
+ [1m[36mSQL (1.7ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160809043433"]]
+ [1m[35m (17.8ms)[0m COMMIT
+Migrating to AddVendorExternalIdToBloomRemitTxns (20160817003323)
+ [1m[36m (1.3ms)[0m [1mBEGIN[0m
+ [1m[35m (0.9ms)[0m ALTER TABLE "bloom_remit_txns" ADD "vendor_external_id" character varying
+ [1m[36m (22.0ms)[0m [1mCREATE INDEX "index_bloom_remit_txns_on_vendor_external_id" ON "bloom_remit_txns" ("vendor_external_id")[0m
+ [1m[35mSQL (5.4ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160817003323"]]
+ [1m[36m (12.7ms)[0m [1mCOMMIT[0m
+Migrating to AllowNullExternalIdForTxns (20160930034811)
+ [1m[35m (0.8ms)[0m BEGIN
+ [1m[36m (1.5ms)[0m [1mALTER TABLE "txns" ALTER COLUMN "external_id" TYPE character varying[0m
+ [1m[35m (1.1ms)[0m ROLLBACK
+ [1m[36m (38.1ms)[0m [1mCREATE TABLE "schema_migrations" ("version" character varying NOT NULL) [0m
+ [1m[35m (39.3ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
+ [1m[36mActiveRecord::SchemaMigration Load (0.9ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+Migrating to CreateBloomRemitTxns (20160729070509)
+ [1m[35m (0.6ms)[0m BEGIN
+ [1m[36m (55.4ms)[0m [1mCREATE 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) [0m
+ [1m[35mSQL (2.4ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160729070509"]]
+ [1m[36m (17.4ms)[0m [1mCOMMIT[0m
+Migrating to CreateUsers (20160729085500)
+ [1m[35m (2.2ms)[0m BEGIN
+ [1m[36m (53.1ms)[0m [1mCREATE TABLE "users" ("id" serial primary key, "email" character varying, "bloom_remit_id" character varying) [0m
+ [1m[35mSQL (0.7ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160729085500"]]
+ [1m[36m (12.2ms)[0m [1mCOMMIT[0m
+Migrating to CreateBillers (20160805001840)
+ [1m[35m (1.1ms)[0m BEGIN
+ [1m[36m (53.2ms)[0m [1mCREATE TABLE "billers" ("id" serial primary key, "slug" character varying) [0m
+ [1m[35mSQL (1.2ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160805001840"]]
+ [1m[36m (16.3ms)[0m [1mCOMMIT[0m
+Migrating to DropRecipientFromTxns (20160805004223)
+ [1m[35m (0.7ms)[0m BEGIN
+ [1m[36m (1.1ms)[0m [1mALTER TABLE "bloom_remit_txns" DROP "recipient_id"[0m
+ [1m[35m (0.8ms)[0m ALTER TABLE "bloom_remit_txns" DROP "recipient_type"
+ [1m[36mSQL (1.5ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805004223"]]
+ [1m[35m (16.6ms)[0m COMMIT
+Migrating to AddTargetSlugToBloomRemitTxns (20160805004350)
+ [1m[36m (4.0ms)[0m [1mBEGIN[0m
+ [1m[35m (0.9ms)[0m ALTER TABLE "bloom_remit_txns" ADD "target_slug" character varying NOT NULL
+ [1m[36mSQL (0.6ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805004350"]]
+ [1m[35m (14.4ms)[0m COMMIT
+Migrating to AddOwnerToBloomRemitTxns (20160805040950)
+ [1m[36m (1.5ms)[0m [1mBEGIN[0m
+ [1m[35m (3.0ms)[0m ALTER TABLE "bloom_remit_txns" ADD "owner_id" character varying
+ [1m[36m (2.8ms)[0m [1mALTER TABLE "bloom_remit_txns" ADD "owner_type" character varying[0m
+ [1m[35m (34.5ms)[0m CREATE INDEX "index_bloom_remit_txns_on_owner_id_and_owner_type" ON "bloom_remit_txns" ("owner_id", "owner_type")
+ [1m[36mSQL (2.4ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805040950"]]
+ [1m[35m (14.6ms)[0m COMMIT
+Migrating to CreatePayments (20160805042105)
+ [1m[36m (5.9ms)[0m [1mBEGIN[0m
+ [1m[35m (33.1ms)[0m CREATE TABLE "payments" ("id" serial primary key)
+ [1m[36mSQL (2.9ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805042105"]]
+ [1m[35m (19.3ms)[0m COMMIT
+Migrating to ChangeTxnsSenderIdToString (20160805095308)
+ [1m[36m (1.4ms)[0m [1mBEGIN[0m
+ [1m[35m (90.9ms)[0m ALTER TABLE "bloom_remit_txns" ALTER COLUMN "sender_id" TYPE character varying
+ [1m[36mSQL (0.6ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805095308"]]
+ [1m[35m (16.3ms)[0m COMMIT
+Migrating to AddTypeToUsers (20160806011259)
+ [1m[36m (0.8ms)[0m [1mBEGIN[0m
+ [1m[35m (0.8ms)[0m ALTER TABLE "users" ADD "type" character varying
+ [1m[36mSQL (0.8ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160806011259"]]
+ [1m[35m (12.2ms)[0m COMMIT
+Migrating to AddTypeToPayments (20160806012210)
+ [1m[36m (0.7ms)[0m [1mBEGIN[0m
+ [1m[35m (28.2ms)[0m ALTER TABLE "payments" ADD "type" character varying
+ [1m[36mSQL (0.6ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160806012210"]]
+ [1m[35m (12.6ms)[0m COMMIT
+Migrating to CreateBloomRemitResponses (20160806054012)
+ [1m[36m (0.7ms)[0m [1mBEGIN[0m
+ [1m[35m (44.0ms)[0m 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)
+ [1m[36m (21.5ms)[0m [1mCREATE INDEX "index_bloom_remit_responses_on_txn_id" ON "bloom_remit_responses" ("txn_id")[0m
+ [1m[35mSQL (1.2ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160806054012"]]
+ [1m[36m (11.3ms)[0m [1mCOMMIT[0m
+Migrating to AddExternalIdToBloomRemitTxns (20160808081300)
+ [1m[35m (1.2ms)[0m BEGIN
+ [1m[36m (0.8ms)[0m [1mALTER TABLE "bloom_remit_txns" ADD "external_id" character varying NOT NULL[0m
+ [1m[35m (37.5ms)[0m CREATE INDEX "index_bloom_remit_txns_on_external_id" ON "bloom_remit_txns" ("external_id")
+ [1m[36mSQL (3.0ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160808081300"]]
+ [1m[35m (15.3ms)[0m COMMIT
+Migrating to AddStatusDescriptionToBloomRemitTxns (20160809043433)
+ [1m[36m (0.7ms)[0m [1mBEGIN[0m
+ [1m[35m (0.7ms)[0m ALTER TABLE "bloom_remit_txns" ADD "status_description" text
+ [1m[36mSQL (0.5ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160809043433"]]
+ [1m[35m (12.9ms)[0m COMMIT
+Migrating to AddVendorExternalIdToBloomRemitTxns (20160817003323)
+ [1m[36m (1.5ms)[0m [1mBEGIN[0m
+ [1m[35m (1.5ms)[0m ALTER TABLE "bloom_remit_txns" ADD "vendor_external_id" character varying
+ [1m[36m (32.1ms)[0m [1mCREATE INDEX "index_bloom_remit_txns_on_vendor_external_id" ON "bloom_remit_txns" ("vendor_external_id")[0m
+ [1m[35mSQL (1.0ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160817003323"]]
+ [1m[36m (13.0ms)[0m [1mCOMMIT[0m
+Migrating to AllowNullExternalIdForTxns (20160930034811)
+ [1m[36m (42.5ms)[0m [1mCREATE TABLE "schema_migrations" ("version" character varying NOT NULL) [0m
+ [1m[35m (38.1ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
+ [1m[36mActiveRecord::SchemaMigration Load (0.9ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+Migrating to CreateBloomRemitTxns (20160729070509)
+ [1m[35m (0.6ms)[0m BEGIN
+ [1m[36m (45.1ms)[0m [1mCREATE 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) [0m
+ [1m[35mSQL (1.1ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160729070509"]]
+ [1m[36m (12.6ms)[0m [1mCOMMIT[0m
+Migrating to CreateUsers (20160729085500)
+ [1m[35m (0.9ms)[0m BEGIN
+ [1m[36m (52.6ms)[0m [1mCREATE TABLE "users" ("id" serial primary key, "email" character varying, "bloom_remit_id" character varying) [0m
+ [1m[35mSQL (0.8ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160729085500"]]
+ [1m[36m (10.9ms)[0m [1mCOMMIT[0m
+Migrating to CreateBillers (20160805001840)
+ [1m[35m (1.8ms)[0m BEGIN
+ [1m[36m (76.5ms)[0m [1mCREATE TABLE "billers" ("id" serial primary key, "slug" character varying) [0m
+ [1m[35mSQL (0.5ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160805001840"]]
+ [1m[36m (10.0ms)[0m [1mCOMMIT[0m
+Migrating to DropRecipientFromTxns (20160805004223)
+ [1m[35m (1.9ms)[0m BEGIN
+ [1m[36m (4.2ms)[0m [1mALTER TABLE "bloom_remit_txns" DROP "recipient_id"[0m
+ [1m[35m (4.2ms)[0m ALTER TABLE "bloom_remit_txns" DROP "recipient_type"
+ [1m[36mSQL (1.2ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805004223"]]
+ [1m[35m (15.6ms)[0m COMMIT
+Migrating to AddTargetSlugToBloomRemitTxns (20160805004350)
+ [1m[36m (0.7ms)[0m [1mBEGIN[0m
+ [1m[35m (0.8ms)[0m ALTER TABLE "bloom_remit_txns" ADD "target_slug" character varying NOT NULL
+ [1m[36mSQL (2.5ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805004350"]]
+ [1m[35m (17.1ms)[0m COMMIT
+Migrating to AddOwnerToBloomRemitTxns (20160805040950)
+ [1m[36m (3.1ms)[0m [1mBEGIN[0m
+ [1m[35m (3.2ms)[0m ALTER TABLE "bloom_remit_txns" ADD "owner_id" character varying
+ [1m[36m (1.1ms)[0m [1mALTER TABLE "bloom_remit_txns" ADD "owner_type" character varying[0m
+ [1m[35m (37.9ms)[0m CREATE INDEX "index_bloom_remit_txns_on_owner_id_and_owner_type" ON "bloom_remit_txns" ("owner_id", "owner_type")
+ [1m[36mSQL (1.1ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805040950"]]
+ [1m[35m (16.9ms)[0m COMMIT
+Migrating to CreatePayments (20160805042105)
+ [1m[36m (1.3ms)[0m [1mBEGIN[0m
+ [1m[35m (39.1ms)[0m CREATE TABLE "payments" ("id" serial primary key)
+ [1m[36mSQL (0.9ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805042105"]]
+ [1m[35m (19.2ms)[0m COMMIT
+Migrating to ChangeTxnsSenderIdToString (20160805095308)
+ [1m[36m (2.9ms)[0m [1mBEGIN[0m
+ [1m[35m (94.9ms)[0m ALTER TABLE "bloom_remit_txns" ALTER COLUMN "sender_id" TYPE character varying
+ [1m[36mSQL (0.5ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160805095308"]]
+ [1m[35m (10.6ms)[0m COMMIT
+Migrating to AddTypeToUsers (20160806011259)
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (0.9ms)[0m ALTER TABLE "users" ADD "type" character varying
+ [1m[36mSQL (0.5ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160806011259"]]
+ [1m[35m (9.7ms)[0m COMMIT
+Migrating to AddTypeToPayments (20160806012210)
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (23.4ms)[0m ALTER TABLE "payments" ADD "type" character varying
+ [1m[36mSQL (0.6ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160806012210"]]
+ [1m[35m (14.4ms)[0m COMMIT
+Migrating to CreateBloomRemitResponses (20160806054012)
+ [1m[36m (3.0ms)[0m [1mBEGIN[0m
+ [1m[35m (57.8ms)[0m 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)
+ [1m[36m (27.4ms)[0m [1mCREATE INDEX "index_bloom_remit_responses_on_txn_id" ON "bloom_remit_responses" ("txn_id")[0m
+ [1m[35mSQL (0.9ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160806054012"]]
+ [1m[36m (17.7ms)[0m [1mCOMMIT[0m
+Migrating to AddExternalIdToBloomRemitTxns (20160808081300)
+ [1m[35m (1.2ms)[0m BEGIN
+ [1m[36m (5.4ms)[0m [1mALTER TABLE "bloom_remit_txns" ADD "external_id" character varying NOT NULL[0m
+ [1m[35m (33.1ms)[0m CREATE INDEX "index_bloom_remit_txns_on_external_id" ON "bloom_remit_txns" ("external_id")
+ [1m[36mSQL (0.7ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160808081300"]]
+ [1m[35m (14.7ms)[0m COMMIT
+Migrating to AddStatusDescriptionToBloomRemitTxns (20160809043433)
+ [1m[36m (2.4ms)[0m [1mBEGIN[0m
+ [1m[35m (1.2ms)[0m ALTER TABLE "bloom_remit_txns" ADD "status_description" text
+ [1m[36mSQL (2.7ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160809043433"]]
+ [1m[35m (13.1ms)[0m COMMIT
+Migrating to AddVendorExternalIdToBloomRemitTxns (20160817003323)
+ [1m[36m (0.8ms)[0m [1mBEGIN[0m
+ [1m[35m (1.2ms)[0m ALTER TABLE "bloom_remit_txns" ADD "vendor_external_id" character varying
+ [1m[36m (28.9ms)[0m [1mCREATE INDEX "index_bloom_remit_txns_on_vendor_external_id" ON "bloom_remit_txns" ("vendor_external_id")[0m
+ [1m[35mSQL (0.8ms)[0m INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20160817003323"]]
+ [1m[36m (15.5ms)[0m [1mCOMMIT[0m
+Migrating to AllowNullExternalIdForBloomRemitTxns (20160930034811)
+ [1m[35m (0.7ms)[0m BEGIN
+ [1m[36m (1.2ms)[0m [1mALTER TABLE "bloom_remit_txns" ALTER COLUMN "external_id" TYPE character varying[0m
+ [1m[35m (0.6ms)[0m ALTER TABLE "bloom_remit_txns" ALTER "external_id" DROP NOT NULL
+ [1m[36mSQL (1.0ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20160930034811"]]
+ [1m[35m (14.8ms)[0m COMMIT
+ [1m[36mActiveRecord::SchemaMigration Load (1.2ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+ [1m[35m (2.7ms)[0m 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
+
+ [1m[36m (2.5ms)[0m [1mSELECT 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
+[0m
+ [1m[35m (2.6ms)[0m 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
+
+ [1m[36m (2.5ms)[0m [1mSELECT 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
+[0m
+ [1m[35m (2.4ms)[0m 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
+
+ [1m[36mActiveRecord::SchemaMigration Load (1.0ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+ [1m[35m (1.2ms)[0m 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
+ [1m[36m (2.2ms)[0m [1m SELECT schemaname || '.' || tablename
+ FROM pg_tables
+ WHERE
+ tablename !~ '_prt_' AND
+ tablename <> 'schema_migrations' AND
+ schemaname = ANY (current_schemas(false))
+[0m
+ [1m[35m (1.9ms)[0m select table_name from information_schema.views where table_schema = 'app_test'
+ [1m[36m (358.3ms)[0m [1mTRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" RESTART IDENTITY CASCADE;[0m
+ [1m[35m (0.8ms)[0m 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
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (0.5ms)[0m COMMIT
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (0.7ms)[0m ROLLBACK
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (0.4ms)[0m COMMIT
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (0.6ms)[0m ROLLBACK
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35mSQL (0.9ms)[0m INSERT INTO "billers" ("slug") VALUES ($1) RETURNING "id" [["slug", "PLDT"]]
+ [1m[36m (13.5ms)[0m [1mCOMMIT[0m
+ [1m[35m (0.7ms)[0m BEGIN
+ [1m[36mSQL (1.9ms)[0m [1mINSERT INTO "users" ("type") VALUES ($1) RETURNING "id"[0m [["type", "SubUser"]]
+ [1m[35m (21.6ms)[0m COMMIT
+ [1m[36m (0.9ms)[0m [1mBEGIN[0m
+ [1m[35mSQL (1.0ms)[0m INSERT INTO "payments" ("type") VALUES ($1) RETURNING "id" [["type", "SubPayment"]]
+ [1m[36m (12.9ms)[0m [1mCOMMIT[0m
+ [1m[35m (0.8ms)[0m BEGIN
+ [1m[36mSQL (1.0ms)[0m [1mINSERT 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"[0m [["secret", "78e86390-c7bb-4356-9b57-1de35f8aeb4c"], ["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", "ec2495560413b85cd84f8bcc"]]
+ [1m[35m (12.4ms)[0m COMMIT
+ [1m[36mUser Load (0.8ms)[0m [1mSELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1[0m [["id", 1]]
+ [1m[35mPayment Load (0.9ms)[0m SELECT "payments".* FROM "payments" WHERE "payments"."id" = $1 LIMIT 1 [["id", 1]]
+ [1m[36m (0.8ms)[0m [1mALTER 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[0m
+ [1m[35m (359.9ms)[0m TRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" RESTART IDENTITY CASCADE;
+ [1m[36m (1.0ms)[0m [1mALTER 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[0m
+ [1m[35m (0.7ms)[0m BEGIN
+ [1m[36mSQL (1.4ms)[0m [1mINSERT INTO "users" DEFAULT VALUES RETURNING "id"[0m
+ [1m[35m (10.7ms)[0m COMMIT
+ [1m[36m (0.9ms)[0m [1mBEGIN[0m
+ [1m[35mSQL (1.4ms)[0m 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", "60e9a0da-4b67-4acf-bee7-f7d29cd04eef"], ["external_id", "6abe9b9def0a5d6a8d8854d0"], ["sender_id", "1"], ["sender_type", "User"]]
+ [1m[36m (13.7ms)[0m [1mCOMMIT[0m
+ [1m[35mBloomRemit::Txn Load (1.3ms)[0m 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", "60e9a0da-4b67-4acf-bee7-f7d29cd04eef"]]
+ [1m[36m (1.1ms)[0m [1mBEGIN[0m
+ [1m[35mSQL (2.6ms)[0m 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]]
+ [1m[36m (11.5ms)[0m [1mCOMMIT[0m
+ [1m[35m (0.8ms)[0m 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
+ [1m[36m (352.2ms)[0m [1mTRUNCATE TABLE "public"."billers", "public"."users", "public"."payments", "public"."bloom_remit_responses", "public"."bloom_remit_txns" RESTART IDENTITY CASCADE;[0m
+ [1m[35m (1.4ms)[0m 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
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (0.5ms)[0m COMMIT
+ [1m[36m (0.4ms)[0m [1mBEGIN[0m
+ [1m[35m (0.5ms)[0m ROLLBACK
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (0.4ms)[0m COMMIT
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (1.7ms)[0m ROLLBACK
+ [1m[36m (0.8ms)[0m [1mBEGIN[0m
+ [1m[35m (0.5ms)[0m COMMIT
+ [1m[36m (0.4ms)[0m [1mBEGIN[0m
+ [1m[35m (0.8ms)[0m ROLLBACK
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (0.6ms)[0m COMMIT
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (0.7ms)[0m ROLLBACK
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (0.5ms)[0m COMMIT
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (0.5ms)[0m ROLLBACK
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (0.5ms)[0m COMMIT
+ [1m[36m (0.4ms)[0m [1mBEGIN[0m
+ [1m[35m (0.4ms)[0m ROLLBACK
+ [1m[36m (0.4ms)[0m [1mBEGIN[0m
+ [1m[35m (0.4ms)[0m COMMIT
+ [1m[36m (0.4ms)[0m [1mBEGIN[0m
+ [1m[35m (1.4ms)[0m ROLLBACK
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (0.5ms)[0m COMMIT
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (0.9ms)[0m SAVEPOINT active_record_1
+ [1m[36mSQL (1.3ms)[0m [1mINSERT INTO "users" DEFAULT VALUES RETURNING "id"[0m
+ [1m[35m (0.6ms)[0m RELEASE SAVEPOINT active_record_1
+ [1m[36m (0.6ms)[0m [1mSAVEPOINT active_record_1[0m
+ [1m[35mSQL (1.0ms)[0m 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", "3597527b-097a-41b9-bf95-6d4068dad936"], ["external_id", "f9145fea664a67b039934157"], ["sender_id", "1"], ["sender_type", "User"]]
+ [1m[36m (0.6ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
+Started POST "/bloom_remit/api/v1/txns/1" for 127.0.0.1 at 2016-09-30 11:55:23 +0800
+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"}}
+ [1m[35mBloomRemit::Txn Load (1.0ms)[0m 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 17ms (Views: 15.4ms | ActiveRecord: 1.0ms)
+Started POST "/bloom_remit/api/v1/txns/1" for 127.0.0.1 at 2016-09-30 11:55:24 +0800
+Processing by BloomRemit::Api::V1::TxnsController#post_update as JSON
+ Parameters: {"secret"=>"3597527b-097a-41b9-bf95-6d4068dad936", "status"=>"paid", "id"=>"1", "txn"=>{"status"=>"paid", "secret"=>"3597527b-097a-41b9-bf95-6d4068dad936"}}
+ [1m[36mBloomRemit::Txn Load (1.3ms)[0m [1mSELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 AND "bloom_remit_txns"."secret" = $2 LIMIT 1[0m [["id", 1], ["secret", "3597527b-097a-41b9-bf95-6d4068dad936"]]
+ [1m[35m (0.6ms)[0m SAVEPOINT active_record_1
+ [1m[36mSQL (0.8ms)[0m [1mUPDATE "bloom_remit_txns" SET "status" = $1 WHERE "bloom_remit_txns"."id" = $2[0m [["status", 1], ["id", 1]]
+ [1m[35m (0.4ms)[0m RELEASE SAVEPOINT active_record_1
+Completed 200 OK in 8ms (Views: 0.4ms | ActiveRecord: 3.1ms)
+ [1m[36mBloomRemit::Txn Load (0.7ms)[0m [1mSELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 LIMIT 1[0m [["id", 1]]
+ [1m[35m (0.6ms)[0m ROLLBACK
+ [1m[36m (0.4ms)[0m [1mBEGIN[0m
+ [1m[35m (0.4ms)[0m COMMIT
+ [1m[36m (0.4ms)[0m [1mBEGIN[0m
+ [1m[35m (0.8ms)[0m SAVEPOINT active_record_1
+ [1m[36mSQL (0.7ms)[0m [1mINSERT INTO "users" DEFAULT VALUES RETURNING "id"[0m
+ [1m[35m (0.5ms)[0m RELEASE SAVEPOINT active_record_1
+ [1m[36m (0.6ms)[0m [1mSAVEPOINT active_record_1[0m
+ [1m[35mSQL (1.0ms)[0m 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", "ebbc4f0d-2ed9-4207-9354-4a35a56788d2"], ["external_id", "5d65f6ca013abe6f13c097ab"], ["sender_id", "2"], ["sender_type", "User"]]
+ [1m[36m (0.7ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
+Started PATCH "/bloom_remit/api/v1/txns/2" for 127.0.0.1 at 2016-09-30 11:55:24 +0800
+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"}}
+ [1m[35mBloomRemit::Txn Load (0.9ms)[0m 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.3ms | ActiveRecord: 0.9ms)
+Started PATCH "/bloom_remit/api/v1/txns/2" for 127.0.0.1 at 2016-09-30 11:55:24 +0800
+Processing by BloomRemit::Api::V1::TxnsController#update as JSON
+ Parameters: {"secret"=>"ebbc4f0d-2ed9-4207-9354-4a35a56788d2", "status"=>"paid", "id"=>"2", "txn"=>{"status"=>"paid", "secret"=>"ebbc4f0d-2ed9-4207-9354-4a35a56788d2"}}
+ [1m[36mBloomRemit::Txn Load (0.9ms)[0m [1mSELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 AND "bloom_remit_txns"."secret" = $2 LIMIT 1[0m [["id", 2], ["secret", "ebbc4f0d-2ed9-4207-9354-4a35a56788d2"]]
+ [1m[35m (0.9ms)[0m SAVEPOINT active_record_1
+ [1m[36mSQL (1.0ms)[0m [1mUPDATE "bloom_remit_txns" SET "status" = $1 WHERE "bloom_remit_txns"."id" = $2[0m [["status", 1], ["id", 2]]
+ [1m[35m (0.7ms)[0m RELEASE SAVEPOINT active_record_1
+Completed 204 No Content in 23ms (ActiveRecord: 3.5ms)
+ [1m[36mBloomRemit::Txn Load (1.2ms)[0m [1mSELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 LIMIT 1[0m [["id", 2]]
+ [1m[35m (0.7ms)[0m ROLLBACK
+ [1m[36m (0.7ms)[0m [1mBEGIN[0m
+ [1m[35m (0.6ms)[0m COMMIT
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (0.6ms)[0m SAVEPOINT active_record_1
+ [1m[36mSQL (1.0ms)[0m [1mINSERT INTO "users" ("type") VALUES ($1) RETURNING "id"[0m [["type", "SubUser"]]
+ [1m[35m (0.6ms)[0m RELEASE SAVEPOINT active_record_1
+ [1m[36m (0.6ms)[0m [1mSAVEPOINT active_record_1[0m
+ [1m[35mSQL (0.9ms)[0m INSERT INTO "billers" ("slug") VALUES ($1) RETURNING "id" [["slug", "PLDT"]]
+ [1m[36m (0.6ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
+ [1m[35m (1.5ms)[0m SAVEPOINT active_record_1
+ [1m[36mSQL (0.9ms)[0m [1mINSERT INTO "payments" ("type") VALUES ($1) RETURNING "id"[0m [["type", "SubPayment"]]
+ [1m[35m (0.5ms)[0m RELEASE SAVEPOINT active_record_1
+ [1m[36m (0.8ms)[0m [1mSAVEPOINT active_record_1[0m
+ [1m[35mSQL (1.0ms)[0m 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", "d2f65adf-0924-4c16-91b6-bc63b96ef15d"], ["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", "8c13944c69c425e285e7b1b8"]]
+ [1m[36m (0.7ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
+ [1m[35m (0.7ms)[0m ROLLBACK
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (0.7ms)[0m COMMIT
+ [1m[36m (0.6ms)[0m [1mBEGIN[0m
+ [1m[35m (0.7ms)[0m ROLLBACK
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (0.5ms)[0m COMMIT
+ [1m[36m (1.2ms)[0m [1mBEGIN[0m
+ [1m[35m (0.7ms)[0m SAVEPOINT active_record_1
+ [1m[36mSQL (0.9ms)[0m [1mINSERT INTO "payments" DEFAULT VALUES RETURNING "id"[0m
+ [1m[35m (0.6ms)[0m RELEASE SAVEPOINT active_record_1
+ [1m[36m (0.6ms)[0m [1mSAVEPOINT active_record_1[0m
+ [1m[35mSQL (0.7ms)[0m INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+ [1m[36m (0.6ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
+ [1m[35m (0.7ms)[0m SAVEPOINT active_record_1
+ [1m[36mSQL (0.7ms)[0m [1mINSERT 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"[0m [["target_slug", "TARGET_SLUG"], ["amount", "2500.0"], ["secret", "0c3cf030-ca19-45d7-a96e-8fcf7ffbd728"], ["external_id", "0c05e32beefd0e97024f8825"], ["owner_id", "2"], ["owner_type", "Payment"], ["sender_id", "4"], ["sender_type", "User"]]
+ [1m[35m (0.7ms)[0m RELEASE SAVEPOINT active_record_1
+ [1m[36m (0.8ms)[0m [1mSAVEPOINT active_record_1[0m
+ [1m[35mSQL (1.1ms)[0m 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-30 03:55:24.141234"], ["updated_at", "2016-09-30 03:55:24.141234"]]
+ [1m[36m (0.6ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
+ [1m[35m (1.0ms)[0m SELECT COUNT(*) FROM "bloom_remit_responses" WHERE "bloom_remit_responses"."txn_id" = $1 [["txn_id", 4]]
+ [1m[36mBloomRemit::Response Load (0.8ms)[0m [1mSELECT "bloom_remit_responses".* FROM "bloom_remit_responses" WHERE "bloom_remit_responses"."txn_id" = $1 ORDER BY "bloom_remit_responses"."id" ASC LIMIT 1[0m [["txn_id", 4]]
+ [1m[35m (0.6ms)[0m ROLLBACK
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (0.5ms)[0m COMMIT
+ [1m[36m (0.4ms)[0m [1mBEGIN[0m
+ [1m[35m (0.6ms)[0m SAVEPOINT active_record_1
+ [1m[36mSQL (0.8ms)[0m [1mINSERT INTO "payments" DEFAULT VALUES RETURNING "id"[0m
+ [1m[35m (0.6ms)[0m RELEASE SAVEPOINT active_record_1
+ [1m[36m (0.5ms)[0m [1mSAVEPOINT active_record_1[0m
+ [1m[35mSQL (0.7ms)[0m INSERT INTO "users" DEFAULT VALUES RETURNING "id"
+ [1m[36m (0.5ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
+ [1m[35m (0.4ms)[0m SAVEPOINT active_record_1
+ [1m[36mSQL (0.6ms)[0m [1mINSERT 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"[0m [["target_slug", "TARGET_SLUG"], ["amount", "2500.0"], ["secret", "d4068db1-db2e-41e3-9028-d56d18438a11"], ["external_id", "f317415d3fca29902c933c06"], ["owner_id", "3"], ["owner_type", "Payment"], ["sender_id", "5"], ["sender_type", "User"]]
+ [1m[35m (0.6ms)[0m RELEASE SAVEPOINT active_record_1
+ [1m[36m (0.5ms)[0m [1mSAVEPOINT active_record_1[0m
+ [1m[35mSQL (0.9ms)[0m UPDATE "bloom_remit_txns" SET "status" = $1 WHERE "bloom_remit_txns"."id" = $2 [["status", 7], ["id", 5]]
+ [1m[36m (0.6ms)[0m [1mRELEASE SAVEPOINT active_record_1[0m
+ [1m[35m (0.6ms)[0m SAVEPOINT active_record_1
+ [1m[36mSQL (0.8ms)[0m [1mINSERT INTO "bloom_remit_responses" ("body", "txn_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id"[0m [["body", "{\"status\":\"500\",\"error\":\"Internal Server Error\"}"], ["txn_id", 5], ["created_at", "2016-09-30 03:55:24.172343"], ["updated_at", "2016-09-30 03:55:24.172343"]]
+ [1m[35m (0.6ms)[0m RELEASE SAVEPOINT active_record_1
+ [1m[36mBloomRemit::Txn Load (0.8ms)[0m [1mSELECT "bloom_remit_txns".* FROM "bloom_remit_txns" WHERE "bloom_remit_txns"."id" = $1 LIMIT 1[0m [["id", 5]]
+ [1m[35m (0.7ms)[0m ROLLBACK
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (0.5ms)[0m COMMIT
+ [1m[36m (0.4ms)[0m [1mBEGIN[0m
+ [1m[35m (0.7ms)[0m ROLLBACK
+ [1m[36m (1.2ms)[0m [1mBEGIN[0m
+ [1m[35m (0.6ms)[0m COMMIT
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (0.7ms)[0m ROLLBACK
+ [1m[36m (0.9ms)[0m [1mBEGIN[0m
+ [1m[35m (1.1ms)[0m COMMIT
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (0.6ms)[0m ROLLBACK
+ [1m[36m (0.7ms)[0m [1mBEGIN[0m
+ [1m[35m (0.5ms)[0m COMMIT
+ [1m[36m (0.4ms)[0m [1mBEGIN[0m
+ [1m[35m (0.8ms)[0m ROLLBACK
+ [1m[36m (0.7ms)[0m [1mBEGIN[0m
+ [1m[35m (0.6ms)[0m COMMIT
+ [1m[36m (0.5ms)[0m [1mBEGIN[0m
+ [1m[35m (0.7ms)[0m ROLLBACK