Skip to content

Instantly share code, notes, and snippets.

@thornomad
Created January 24, 2020 21:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save thornomad/79f5b03e69d83551cfe7fb25ac7127bb to your computer and use it in GitHub Desktop.
Save thornomad/79f5b03e69d83551cfe7fb25ac7127bb to your computer and use it in GitHub Desktop.
Rails 6 test log
(499.2ms) CREATE DATABASE "test_app_6_test" ENCODING = 'unicode'
(19.8ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL PRIMARY KEY)
(7.6ms) CREATE TABLE "ar_internal_metadata" ("key" character varying NOT NULL PRIMARY KEY, "value" character varying, "created_at" timestamp(6) NOT NULL, "updated_at" timestamp(6) NOT NULL)
(0.2ms) SELECT pg_try_advisory_lock(6568561817215537440)
(0.5ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
Migrating to CreateTableAndViewForTesting (20200122031151)
(0.2ms) BEGIN
(3.6ms) CREATE TABLE "people" ("id" bigserial primary key, "name" character varying)
(0.9ms) DROP VIEW IF EXISTS view_people;
CREATE OR REPLACE VIEW view_people AS
SELECT id, name
FROM people
CreateTableAndViewForTesting::Person Create (0.4ms) INSERT INTO "people" ("name") VALUES ($1) RETURNING "id" [["name", "Person #1"]]
CreateTableAndViewForTesting::Person Create (0.1ms) INSERT INTO "people" ("name") VALUES ($1) RETURNING "id" [["name", "Person #2"]]
CreateTableAndViewForTesting::Person Create (0.1ms) INSERT INTO "people" ("name") VALUES ($1) RETURNING "id" [["name", "Person #3"]]
CreateTableAndViewForTesting::Person Create (0.2ms) INSERT INTO "people" ("name") VALUES ($1) RETURNING "id" [["name", "Person #4"]]
CreateTableAndViewForTesting::Person Create (0.1ms) INSERT INTO "people" ("name") VALUES ($1) RETURNING "id" [["name", "Person #5"]]
primary::SchemaMigration Create (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version" [["version", "20200122031151"]]
(0.3ms) COMMIT
ActiveRecord::InternalMetadata Load (0.2ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2 [["key", "environment"], ["LIMIT", 1]]
(0.1ms) BEGIN
ActiveRecord::InternalMetadata Create (0.3ms) INSERT INTO "ar_internal_metadata" ("key", "value", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "key" [["key", "environment"], ["value", "test"], ["created_at", "2020-01-24 21:23:00.181823"], ["updated_at", "2020-01-24 21:23:00.181823"]]
(0.3ms) COMMIT
(0.1ms) SELECT pg_advisory_unlock(6568561817215537440)
(0.7ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
(0.3ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "schema_sha1"]]
(0.4ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
(0.2ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "environment"]]
(0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
(0.1ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "environment"]]
(0.2ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
(0.1ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "environment"]]
(205.2ms) DROP DATABASE IF EXISTS "test_app_6_test"
(415.0ms) CREATE DATABASE "test_app_6_test" ENCODING = 'unicode'
SQL (0.4ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"
(0.2ms) DROP TABLE IF EXISTS "people" CASCADE
(7.1ms) CREATE TABLE "people" ("id" bigserial primary key, "name" character varying)
(2.8ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL PRIMARY KEY)
(0.4ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
(0.5ms) INSERT INTO "schema_migrations" (version) VALUES (20200122031151)
(2.8ms) CREATE TABLE "ar_internal_metadata" ("key" character varying NOT NULL PRIMARY KEY, "value" character varying, "created_at" timestamp(6) NOT NULL, "updated_at" timestamp(6) NOT NULL)
ActiveRecord::InternalMetadata Load (0.4ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2 [["key", "environment"], ["LIMIT", 1]]
(0.2ms) BEGIN
ActiveRecord::InternalMetadata Create (0.4ms) INSERT INTO "ar_internal_metadata" ("key", "value", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "key" [["key", "environment"], ["value", "test"], ["created_at", "2020-01-24 21:23:08.077896"], ["updated_at", "2020-01-24 21:23:08.077896"]]
(0.4ms) COMMIT
ActiveRecord::InternalMetadata Load (0.3ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2 [["key", "environment"], ["LIMIT", 1]]
ActiveRecord::InternalMetadata Load (0.2ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2 [["key", "schema_sha1"], ["LIMIT", 1]]
(0.1ms) BEGIN
ActiveRecord::InternalMetadata Create (0.3ms) INSERT INTO "ar_internal_metadata" ("key", "value", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "key" [["key", "schema_sha1"], ["value", "fdb19af870ececa45a74da2b399c435011ea0785"], ["created_at", "2020-01-24 21:23:08.082253"], ["updated_at", "2020-01-24 21:23:08.082253"]]
(0.3ms) COMMIT
(0.5ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
(1.2ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "schema_sha1"]]
(1.4ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "schema_sha1"]]
(1.1ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "schema_sha1"]]
(1.3ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "schema_sha1"]]
(1.1ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "schema_sha1"]]
(1.4ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "schema_sha1"]]
(1.4ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "schema_sha1"]]
(1.6ms) SELECT "ar_internal_metadata"."value" FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 [["key", "schema_sha1"]]
(0.1ms) BEGIN
(0.1ms) BEGIN
(0.1ms) BEGIN
(0.1ms) BEGIN
(0.1ms) BEGIN
(0.1ms) BEGIN
(0.5ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" DISABLE TRIGGER ALL;ALTER TABLE "people" DISABLE TRIGGER ALL
(0.7ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" DISABLE TRIGGER ALL;ALTER TABLE "people" DISABLE TRIGGER ALL
(0.2ms) BEGIN
(0.5ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" DISABLE TRIGGER ALL;ALTER TABLE "people" DISABLE TRIGGER ALL
(0.1ms) COMMIT
(0.7ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" DISABLE TRIGGER ALL;ALTER TABLE "people" DISABLE TRIGGER ALL
(0.1ms) COMMIT
(0.1ms) COMMIT
(0.5ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" DISABLE TRIGGER ALL;ALTER TABLE "people" DISABLE TRIGGER ALL
(0.1ms) BEGIN
(0.1ms) COMMIT
(0.7ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" DISABLE TRIGGER ALL;ALTER TABLE "people" DISABLE TRIGGER ALL
(0.1ms) COMMIT
(0.1ms) COMMIT
(0.5ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" DISABLE TRIGGER ALL;ALTER TABLE "people" DISABLE TRIGGER ALL
(0.2ms) COMMIT
(0.5ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" DISABLE TRIGGER ALL;ALTER TABLE "people" DISABLE TRIGGER ALL
(0.1ms) COMMIT
(5.2ms) TRUNCATE TABLE "people"
(6.2ms) TRUNCATE TABLE "people"
(6.5ms) TRUNCATE TABLE "people"
(6.6ms) TRUNCATE TABLE "people"
(6.4ms) TRUNCATE TABLE "people"
(6.1ms) TRUNCATE TABLE "people"
(0.1ms) BEGIN
(0.1ms) BEGIN
(6.7ms) TRUNCATE TABLE "people"
(5.2ms) TRUNCATE TABLE "people"
(0.1ms) BEGIN
(0.1ms) BEGIN
(0.1ms) BEGIN
(0.1ms) BEGIN
(0.1ms) BEGIN
(0.1ms) BEGIN
(0.2ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" ENABLE TRIGGER ALL;ALTER TABLE "people" ENABLE TRIGGER ALL
(0.2ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" ENABLE TRIGGER ALL;ALTER TABLE "people" ENABLE TRIGGER ALL
(0.2ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" ENABLE TRIGGER ALL;ALTER TABLE "people" ENABLE TRIGGER ALL
(0.2ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" ENABLE TRIGGER ALL;ALTER TABLE "people" ENABLE TRIGGER ALL
(0.2ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" ENABLE TRIGGER ALL;ALTER TABLE "people" ENABLE TRIGGER ALL
(0.1ms) COMMIT
(0.2ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" ENABLE TRIGGER ALL;ALTER TABLE "people" ENABLE TRIGGER ALL
(0.3ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" ENABLE TRIGGER ALL;ALTER TABLE "people" ENABLE TRIGGER ALL
(0.1ms) COMMIT
(0.1ms) COMMIT
(0.1ms) COMMIT
(0.1ms) COMMIT
(0.2ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "ar_internal_metadata" ENABLE TRIGGER ALL;ALTER TABLE "people" ENABLE TRIGGER ALL
(0.1ms) COMMIT
(0.1ms) COMMIT
(0.1ms) COMMIT
(0.1ms) BEGIN
--------------------------------------------------
PersonTest: test_there_are_five_people_in_the_view
--------------------------------------------------
(0.1ms) BEGIN
---------------------------------------------
PersonTest: test_there_are_five_seeded_people
---------------------------------------------
(0.1ms) ROLLBACK
(2.1ms) SELECT COUNT(*) FROM "people"
(0.2ms) ROLLBACK
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment