(0.4ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (1.5ms) CREATE TABLE "filings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "url" varchar(255), "buyer" varchar(255), "amount" integer, "verified" boolean, "notes" text)   (1.1ms) CREATE TABLE "transcriptions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "buyer" varchar(255), "amount" integer, "filing_id" integer, "user_id" varchar(255), "notes" text)  (1.1ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)   (1.3ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.2ms) SELECT version FROM "schema_migrations"  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20130710175855') ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.5ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.2ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.6ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction -------------------------------------------------- TranscribableTest: test_assign_documents_correctly -------------------------------------------------- Filing Load (22.9ms) SELECT "filings".* FROM "filings" WHERE "filings"."id" = ? LIMIT 1 [["id", 1]]  (0.1ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction -------------------------------------------------- TranscribableTest: test_assign_documents_correctly -------------------------------------------------- Filing Load (4.4ms) SELECT "filings".* FROM "filings" WHERE "filings"."id" = ? LIMIT 1 [["id", 1]]  (0.1ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction -------------------------------------------------- TranscribableTest: test_assign_documents_correctly -------------------------------------------------- Filing Load (0.2ms) SELECT "filings".* FROM "filings" ORDER BY "filings"."id" ASC LIMIT 1  (0.1ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction -------------------------------------------------- TranscribableTest: test_assign_documents_correctly -------------------------------------------------- Filing Load (0.2ms) SELECT "filings".* FROM "filings" ORDER BY "filings"."id" ASC LIMIT 1  (0.1ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction -------------------------------------------------- TranscribableTest: test_assign_documents_correctly --------------------------------------------------  (0.1ms) SELECT COUNT(*) FROM "filings"  (0.2ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction -------------------------------------------------- TranscribableTest: test_assign_documents_correctly --------------------------------------------------  (0.1ms) SELECT COUNT(*) FROM "filings"  (0.3ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction -------------------------------------------------- TranscribableTest: test_assign_documents_correctly --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction ------------------------------------------------------------------------------------------------------- TranscribableAssignerTest: test_should_assign_documents_that_aren't_verified_or_transcribed_by_the_user -------------------------------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (6.0ms) INSERT INTO "filings" ("id", "url", "verified") VALUES (?, ?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326844-fox-chicago-public-file"], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 2], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 3], ["url", "https://www.documentcloud.org/documents/326753-cbs-chicago-public-file"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "transcriptions" ("filing_id", "user_id") VALUES (?, ?) [["filing_id", 2], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Transcription Load (0.2ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."user_id" = '40765bb0cfa90130c5fb442c03361f6e' Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE (("filings"."verified" = 'f' OR "filings"."verified" IS NULL)) AND (id NOT IN (2)) SQL (0.2ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (21.3ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction ------------------------------------------------------------------------------------------------------- TranscribableAssignerTest: test_should_assign_documents_that_aren't_verified_or_transcribed_by_the_user -------------------------------------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1 SQL (6.0ms) INSERT INTO "filings" ("id", "url", "verified") VALUES (?, ?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326844-fox-chicago-public-file"], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 2], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 3], ["url", "https://www.documentcloud.org/documents/326753-cbs-chicago-public-file"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "transcriptions" ("filing_id", "user_id") VALUES (?, ?) [["filing_id", 2], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Transcription Load (0.1ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."user_id" = '40765bb0cfa90130c5fb442c03361f6e' Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE (("filings"."verified" = 'f' OR "filings"."verified" IS NULL)) AND (id NOT IN (2)) SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.7ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction ------------------------------------------------------------------------------------------------------- TranscribableAssignerTest: test_should_assign_documents_that_aren't_verified_or_transcribed_by_the_user -------------------------------------------------------------------------------------------------------  (0.3ms) SAVEPOINT active_record_1 SQL (5.8ms) INSERT INTO "filings" ("id", "url", "verified") VALUES (?, ?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326844-fox-chicago-public-file"], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 2], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 3], ["url", "https://www.documentcloud.org/documents/326753-cbs-chicago-public-file"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "transcriptions" ("filing_id", "user_id") VALUES (?, ?) [["filing_id", 2], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Transcription Load (0.1ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."user_id" = '40765bb0cfa90130c5fb442c03361f6e' Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE (("filings"."verified" = 'f' OR "filings"."verified" IS NULL)) AND (id NOT IN (2)) SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.7ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction ------------------------------------------------------------------------------------------------------- TranscribableAssignerTest: test_should_assign_documents_that_aren't_verified_or_transcribed_by_the_user -------------------------------------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1 SQL (6.0ms) INSERT INTO "filings" ("id", "url", "verified") VALUES (?, ?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326844-fox-chicago-public-file"], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 2], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 3], ["url", "https://www.documentcloud.org/documents/326753-cbs-chicago-public-file"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "transcriptions" ("filing_id", "user_id") VALUES (?, ?) [["filing_id", 2], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Transcription Load (0.1ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."user_id" = '40765bb0cfa90130c5fb442c03361f6e' Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE (("filings"."verified" = 'f' OR "filings"."verified" IS NULL)) AND (id NOT IN (2)) SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.7ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction ------------------------------------------------------------------------------------------------------- TranscribableAssignerTest: test_should_assign_documents_that_aren't_verified_or_transcribed_by_the_user -------------------------------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (6.0ms) INSERT INTO "filings" ("id", "url", "verified") VALUES (?, ?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326844-fox-chicago-public-file"], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 2], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 3], ["url", "https://www.documentcloud.org/documents/326753-cbs-chicago-public-file"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "transcriptions" ("filing_id", "user_id") VALUES (?, ?) [["filing_id", 2], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Transcription Load (0.1ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."user_id" = '40765bb0cfa90130c5fb442c03361f6e' Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE (("filings"."verified" = 'f' OR "filings"."verified" IS NULL)) AND (id NOT IN (2)) SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.7ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.5ms) begin transaction ------------------------------------------------------------------------------------------------------- TranscribableAssignerTest: test_should_assign_documents_that_aren't_verified_or_transcribed_by_the_user -------------------------------------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1 SQL (6.1ms) INSERT INTO "filings" ("id", "url", "verified") VALUES (?, ?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326844-fox-chicago-public-file"], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 2], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 3], ["url", "https://www.documentcloud.org/documents/326753-cbs-chicago-public-file"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "transcriptions" ("filing_id", "user_id") VALUES (?, ?) [["filing_id", 2], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Transcription Load (0.1ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."user_id" = '40765bb0cfa90130c5fb442c03361f6e' Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE (("filings"."verified" = 'f' OR "filings"."verified" IS NULL)) AND (id NOT IN (2)) SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (49.8ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------------------------ TranscribableVerifierTest: test_should_verify_transcriptions ------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.5ms) INSERT INTO "transcriptions" ("amount", "buyer", "filing_id", "user_id") VALUES (?, ?, ?, ?) [["amount", 123], ["buyer", "Restore Our Future"], ["filing_id", 1], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "transcriptions" ("amount", "buyer", "filing_id", "user_id") VALUES (?, ?, ?, ?) [["amount", 123], ["buyer", "Restore our Future"], ["filing_id", 1], ["user_id", "5aa499f0cfb30130c5fc442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Filing Load (0.1ms) SELECT "filings".* FROM "filings" WHERE "filings"."id" = ? LIMIT 1 [["id", 1]] == Verifying buyer, amount Transcription Load (0.2ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."filing_id" = ? [["filing_id", 1]]  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) UPDATE "filings" SET "buyer" = ?, "amount" = ?, "verified" = ? WHERE "filings"."id" = 1 [["buyer", "RESTORE OUR FUTURE"], ["amount", 123], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1 == Verified https://www.documentcloud.org/documents/326749-abc-chicago SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.7ms) rollback transaction  (0.5ms) begin transaction ------------------------------------------------------------------------------------------------------- TranscribableAssignerTest: test_should_assign_documents_that_aren't_verified_or_transcribed_by_the_user -------------------------------------------------------------------------------------------------------  (0.3ms) SAVEPOINT active_record_1 SQL (6.3ms) INSERT INTO "filings" ("id", "url", "verified") VALUES (?, ?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326844-fox-chicago-public-file"], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 2], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 3], ["url", "https://www.documentcloud.org/documents/326753-cbs-chicago-public-file"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "transcriptions" ("filing_id", "user_id") VALUES (?, ?) [["filing_id", 2], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Transcription Load (0.2ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."user_id" = '40765bb0cfa90130c5fb442c03361f6e' Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE (("filings"."verified" = 'f' OR "filings"."verified" IS NULL)) AND (id NOT IN (2)) SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.7ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------------------------ TranscribableVerifierTest: test_should_verify_transcriptions ------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO "transcriptions" ("amount", "buyer", "filing_id", "user_id") VALUES (?, ?, ?, ?) [["amount", 123], ["buyer", "Restore Our Future"], ["filing_id", 1], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "transcriptions" ("amount", "buyer", "filing_id", "user_id") VALUES (?, ?, ?, ?) [["amount", 123], ["buyer", "Restore our Future"], ["filing_id", 1], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE "filings"."id" = ? LIMIT 1 [["id", 1]] == Verifying buyer, amount Transcription Load (0.3ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."filing_id" = ? [["filing_id", 1]]  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) UPDATE "filings" SET "buyer" = ?, "amount" = ?, "verified" = ? WHERE "filings"."id" = 1 [["buyer", "RESTORE OUR FUTURE"], ["amount", 123], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1 == Verified https://www.documentcloud.org/documents/326749-abc-chicago SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.7ms) rollback transaction  (0.6ms) begin transaction ------------------------------------------------------------------------------------------------------- TranscribableAssignerTest: test_should_assign_documents_that_aren't_verified_or_transcribed_by_the_user -------------------------------------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1 SQL (5.9ms) INSERT INTO "filings" ("id", "url", "verified") VALUES (?, ?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326844-fox-chicago-public-file"], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 2], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 3], ["url", "https://www.documentcloud.org/documents/326753-cbs-chicago-public-file"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "transcriptions" ("filing_id", "user_id") VALUES (?, ?) [["filing_id", 2], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Transcription Load (0.2ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."user_id" = '40765bb0cfa90130c5fb442c03361f6e' Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE (("filings"."verified" = 'f' OR "filings"."verified" IS NULL)) AND (id NOT IN (2)) SQL (0.3ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (1.7ms) rollback transaction  (0.2ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------------------------ TranscribableVerifierTest: test_should_verify_transcriptions ------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "transcriptions" ("amount", "buyer", "filing_id", "user_id") VALUES (?, ?, ?, ?) [["amount", 123], ["buyer", "Restore Our Future"], ["filing_id", 1], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "transcriptions" ("amount", "buyer", "filing_id", "user_id") VALUES (?, ?, ?, ?) [["amount", 123], ["buyer", "Restore our Future"], ["filing_id", 1], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE "filings"."id" = ? LIMIT 1 [["id", 1]] == Verifying buyer, amount Transcription Load (0.3ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."filing_id" = ? [["filing_id", 1]]  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) UPDATE "filings" SET "buyer" = ?, "amount" = ?, "verified" = ? WHERE "filings"."id" = 1 [["buyer", "RESTORE OUR FUTURE"], ["amount", 123], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1 == Verified https://www.documentcloud.org/documents/326749-abc-chicago SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.7ms) rollback transaction  (0.5ms) begin transaction ------------------------------------------------------------------------------------------------------- TranscribableAssignerTest: test_should_assign_documents_that_aren't_verified_or_transcribed_by_the_user -------------------------------------------------------------------------------------------------------  (0.3ms) SAVEPOINT active_record_1 SQL (6.0ms) INSERT INTO "filings" ("id", "url", "verified") VALUES (?, ?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326844-fox-chicago-public-file"], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 2], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 3], ["url", "https://www.documentcloud.org/documents/326753-cbs-chicago-public-file"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO "transcriptions" ("filing_id", "user_id") VALUES (?, ?) [["filing_id", 2], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Transcription Load (0.2ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."user_id" = '40765bb0cfa90130c5fb442c03361f6e' Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE (("filings"."verified" = 'f' OR "filings"."verified" IS NULL)) AND (id NOT IN (2)) SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.7ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------------------------ TranscribableVerifierTest: test_should_verify_transcriptions ------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO "transcriptions" ("amount", "buyer", "filing_id", "user_id") VALUES (?, ?, ?, ?) [["amount", 123], ["buyer", "Restore Our Future"], ["filing_id", 1], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "transcriptions" ("amount", "buyer", "filing_id", "user_id") VALUES (?, ?, ?, ?) [["amount", 123], ["buyer", "Restore our Future"], ["filing_id", 1], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Filing Load (0.1ms) SELECT "filings".* FROM "filings" WHERE "filings"."id" = ? LIMIT 1 [["id", 1]] == Verifying buyer, amount Transcription Load (0.2ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."filing_id" = ? [["filing_id", 1]]  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) UPDATE "filings" SET "buyer" = ?, "amount" = ?, "verified" = ? WHERE "filings"."id" = 1 [["buyer", "RESTORE OUR FUTURE"], ["amount", 123], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1 == Verified https://www.documentcloud.org/documents/326749-abc-chicago SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.5ms) rollback transaction  (0.6ms) begin transaction ------------------------------------------------------------------------------------------------------- TranscribableAssignerTest: test_should_assign_documents_that_aren't_verified_or_transcribed_by_the_user -------------------------------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (6.1ms) INSERT INTO "filings" ("id", "url", "verified") VALUES (?, ?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326844-fox-chicago-public-file"], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 2], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 3], ["url", "https://www.documentcloud.org/documents/326753-cbs-chicago-public-file"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "transcriptions" ("filing_id", "user_id") VALUES (?, ?) [["filing_id", 2], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Transcription Load (0.1ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."user_id" = '40765bb0cfa90130c5fb442c03361f6e' Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE (("filings"."verified" = 'f' OR "filings"."verified" IS NULL)) AND (id NOT IN (2)) SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.7ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------------------------ TranscribableVerifierTest: test_should_verify_transcriptions ------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO "transcriptions" ("amount", "buyer", "filing_id", "user_id") VALUES (?, ?, ?, ?) [["amount", 123], ["buyer", "Restore Our Future"], ["filing_id", 1], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO "transcriptions" ("amount", "buyer", "filing_id", "user_id") VALUES (?, ?, ?, ?) [["amount", 1234], ["buyer", "Restore our Future"], ["filing_id", 1], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE "filings"."id" = ? LIMIT 1 [["id", 1]] == Verifying buyer, amount Transcription Load (0.2ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."filing_id" = ? [["filing_id", 1]] == Not verified: https://www.documentcloud.org/documents/326749-abc-chicago SQL (0.2ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.8ms) rollback transaction  (0.5ms) begin transaction ------------------------------------------------------------------------------------------------------- TranscribableAssignerTest: test_should_assign_documents_that_aren't_verified_or_transcribed_by_the_user -------------------------------------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1 SQL (7.0ms) INSERT INTO "filings" ("id", "url", "verified") VALUES (?, ?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326844-fox-chicago-public-file"], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 2], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 3], ["url", "https://www.documentcloud.org/documents/326753-cbs-chicago-public-file"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO "transcriptions" ("filing_id", "user_id") VALUES (?, ?) [["filing_id", 2], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Transcription Load (0.2ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."user_id" = '40765bb0cfa90130c5fb442c03361f6e' Filing Load (0.2ms) SELECT "filings".* FROM "filings" WHERE (("filings"."verified" = 'f' OR "filings"."verified" IS NULL)) AND (id NOT IN (2)) SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.7ms) rollback transaction  (0.1ms) begin transaction ---------------------------------------------- TranscribableTest: test_set_verification_level ----------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------- TranscribableTest: test_skipped_attr_is_set -------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction --------------------------------------------------- TranscribableTest: test_transcribable_attrs_are_set ---------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction -------------------------------------------------- TranscribableTest: test_transcribable_table_is_set --------------------------------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ----------------------------- TranscribableTest: test_truth -----------------------------  (0.1ms) rollback transaction  (0.1ms) begin transaction ------------------------------------------------------------ TranscribableVerifierTest: test_should_verify_transcriptions ------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "filings" ("id", "url") VALUES (?, ?) [["id", 1], ["url", "https://www.documentcloud.org/documents/326749-abc-chicago"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO "transcriptions" ("amount", "buyer", "filing_id", "user_id") VALUES (?, ?, ?, ?) [["amount", 123], ["buyer", "Restore Our Future"], ["filing_id", 1], ["user_id", "40765bb0cfa90130c5fb442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO "transcriptions" ("amount", "buyer", "filing_id", "user_id") VALUES (?, ?, ?, ?) [["amount", 123], ["buyer", "Restore our Future"], ["filing_id", 1], ["user_id", "5aa499f0cfb30130c5fc442c03361f6e"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Filing Load (0.1ms) SELECT "filings".* FROM "filings" WHERE "filings"."id" = ? LIMIT 1 [["id", 1]] == Verifying buyer, amount Transcription Load (0.3ms) SELECT "transcriptions".* FROM "transcriptions" WHERE "transcriptions"."filing_id" = ? [["filing_id", 1]]  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) UPDATE "filings" SET "buyer" = ?, "amount" = ?, "verified" = ? WHERE "filings"."id" = 1 [["buyer", "RESTORE OUR FUTURE"], ["amount", 123], ["verified", true]]  (0.1ms) RELEASE SAVEPOINT active_record_1 == Verified https://www.documentcloud.org/documents/326749-abc-chicago SQL (0.1ms) DELETE FROM "filings" SQL (0.1ms) DELETE FROM "transcriptions"  (0.7ms) rollback transaction