(113.9ms) DROP DATABASE IF EXISTS "views_test"  (341.4ms) CREATE DATABASE "views_test" ENCODING = 'utf8' SQL (1.0ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (8.8ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  (0.3ms) DROP VIEW IF EXISTS guitars  (13.5ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  (1.6ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)   (0.9ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.2ms) SELECT version FROM "schema_migrations"  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161125151623')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20161017172847') ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (5.0ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)   (0.8ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.2ms) BEGIN  (3.7ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.4ms) COMMIT Migrating to CreateGuitarsView (20161125151623)  (0.2ms) BEGIN  (1.2ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.3ms) COMMIT Migrating to ChangeGuitarsView (20161126212242)  (0.1ms) BEGIN  (0.7ms) DROP VIEW guitars  (0.8ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161126212242"]]  (0.3ms) COMMIT ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.5ms) 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 = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname  (0.5ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC  ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to ChangeGuitarsView (20161126212242)  (0.1ms) SAVEPOINT active_record_1  (10.7ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_dump -------------------  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.3ms) BEGIN ------------------- TaskTest: test_load -------------------  (0.2ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_dump -------------------  (0.1ms) ROLLBACK  (0.1ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.2ms) SAVEPOINT active_record_1  (6.3ms) DROP VIEW guitars SQL (0.3ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (14.6ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.2ms) SAVEPOINT active_record_1  (2.9ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (15.5ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (3.5ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.6ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.8ms) DROP VIEW guitars SQL (0.3ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (13.2ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.2ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (1.9ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (6.2ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.4ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (114.0ms) DROP DATABASE IF EXISTS "views_test"  (332.0ms) CREATE DATABASE "views_test" ENCODING = 'utf8' ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (28.3ms) DROP VIEW guitars SQL (7.0ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) DROP TABLE "products" SQL (0.3ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.2ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (13.3ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.8ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (6.1ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.2ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (112.7ms) DROP DATABASE IF EXISTS "views_test"  (268.2ms) CREATE DATABASE "views_test" ENCODING = 'utf8' SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (5.6ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  (0.2ms) DROP VIEW IF EXISTS guitars  (1.6ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  (1.3ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)   (0.8ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.3ms) SELECT version FROM "schema_migrations"  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161126212242')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161017172847')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161125151623')  (1.0ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.1ms) BEGIN ------------------- TaskTest: test_dump -------------------  (0.2ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.3ms) BEGIN ------------------- TaskTest: test_load -------------------  (112.5ms) DROP DATABASE IF EXISTS "views_test"  (369.0ms) CREATE DATABASE "views_test" ENCODING = 'utf8' SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (5.5ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  (0.3ms) DROP VIEW IF EXISTS guitars  (1.5ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  (1.4ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)   (0.9ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.3ms) SELECT version FROM "schema_migrations"  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161126212242')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161017172847')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161125151623')  (0.9ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.1ms) BEGIN ------------------- TaskTest: test_dump ------------------- ActiveRecord::SchemaMigration Load (1.5ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.3ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete FROM pg_constraint c JOIN pg_class t1 ON c.conrelid = t1.oid JOIN pg_class t2 ON c.confrelid = t2.oid JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid JOIN pg_namespace t3 ON c.connamespace = t3.oid WHERE c.contype = 'f' AND t1.relname = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname  (0.5ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC  ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (1.8ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete FROM pg_constraint c JOIN pg_class t1 ON c.conrelid = t1.oid JOIN pg_class t2 ON c.confrelid = t2.oid JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid JOIN pg_namespace t3 ON c.connamespace = t3.oid WHERE c.contype = 'f' AND t1.relname = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname   (0.5ms) SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.1ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete FROM pg_constraint c JOIN pg_class t1 ON c.conrelid = t1.oid JOIN pg_class t2 ON c.confrelid = t2.oid JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid JOIN pg_namespace t3 ON c.connamespace = t3.oid WHERE c.contype = 'f' AND t1.relname = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname  (0.5ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC  ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (1.6ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete FROM pg_constraint c JOIN pg_class t1 ON c.conrelid = t1.oid JOIN pg_class t2 ON c.confrelid = t2.oid JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid JOIN pg_namespace t3 ON c.connamespace = t3.oid WHERE c.contype = 'f' AND t1.relname = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname   (0.4ms) SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC  (0.2ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.2ms) ROLLBACK  (0.1ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.4ms) SAVEPOINT active_record_1  (18.9ms) DROP VIEW guitars SQL (0.3ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.6ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.2ms) SAVEPOINT active_record_1  (12.7ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (6.0ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.6ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.2ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_dump ------------------- ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.0ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete FROM pg_constraint c JOIN pg_class t1 ON c.conrelid = t1.oid JOIN pg_class t2 ON c.confrelid = t2.oid JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid JOIN pg_namespace t3 ON c.connamespace = t3.oid WHERE c.contype = 'f' AND t1.relname = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname  (0.4ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (110.8ms) DROP DATABASE IF EXISTS "views_test"  (0.2ms) DROP DATABASE IF EXISTS "views_test"  (289.8ms) CREATE DATABASE "views_test" ENCODING = 'utf8'  (0.6ms) CREATE DATABASE "views_test" ENCODING = 'utf8' SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (5.0ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)   (0.4ms) DROP VIEW IF EXISTS guitars  (8.0ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'   (12.1ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)  (4.2ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.3ms) SELECT version FROM "schema_migrations"  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161126212242')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20161017172847')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20161125151623') SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (7.8ms) DROP TABLE "products" CASCADE  (2.7ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  (0.3ms) DROP VIEW IF EXISTS guitars  (1.5ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  (0.3ms) SELECT version FROM "schema_migrations"  (1.0ms) SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC  (0.1ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.2ms) SAVEPOINT active_record_1  (1.3ms) DROP VIEW guitars SQL (0.5ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (1.0ms) DROP TABLE "products" SQL (0.3ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.2ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (8.2ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.2ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (1.0ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (6.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN ------------------- TaskTest: test_dump ------------------- ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.7ms) 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 = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname  (0.4ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.2ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (111.6ms) DROP DATABASE IF EXISTS "views_test"  (0.2ms) DROP DATABASE IF EXISTS "views_test"  (266.8ms) CREATE DATABASE "views_test" ENCODING = 'utf8'  (0.7ms) CREATE DATABASE "views_test" ENCODING = 'utf8' SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (4.7ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)   (0.4ms) DROP VIEW IF EXISTS guitars  (7.9ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'   (16.9ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)  (0.7ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.3ms) SELECT version FROM "schema_migrations"  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161126212242')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20161017172847')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20161125151623') SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (8.1ms) DROP TABLE "products" CASCADE  (3.5ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  (0.3ms) DROP VIEW IF EXISTS guitars  (1.1ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  (0.3ms) SELECT version FROM "schema_migrations"  (0.9ms) SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC  (0.1ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) DROP VIEW guitars SQL (2.8ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.5ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.2ms) SAVEPOINT active_record_1  (0.7ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (19.1ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (6.2ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.4ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN ------------------- TaskTest: test_dump ------------------- ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.4ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete FROM pg_constraint c JOIN pg_class t1 ON c.conrelid = t1.oid JOIN pg_class t2 ON c.confrelid = t2.oid JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid JOIN pg_namespace t3 ON c.connamespace = t3.oid WHERE c.contype = 'f' AND t1.relname = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname  (0.4ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.3ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (115.4ms) DROP DATABASE IF EXISTS "views_test"  (0.2ms) DROP DATABASE IF EXISTS "views_test"  (346.3ms) CREATE DATABASE "views_test" ENCODING = 'utf8'  (0.6ms) CREATE DATABASE "views_test" ENCODING = 'utf8' SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (4.8ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)   (0.3ms) DROP VIEW IF EXISTS guitars  (6.7ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'   (18.1ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)  (0.8ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.2ms) SELECT version FROM "schema_migrations"  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161126212242')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20161017172847')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20161125151623') SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (7.3ms) DROP TABLE "products" CASCADE  (6.7ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  (0.4ms) DROP VIEW IF EXISTS guitars  (1.0ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  (0.2ms) SELECT version FROM "schema_migrations"  (0.9ms) SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC  (0.2ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.8ms) DROP VIEW guitars SQL (0.4ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.9ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (19.1ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (6.0ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.3ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.2ms) SAVEPOINT active_record_1  (0.8ms) DROP VIEW guitars SQL (0.3ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (7.0ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.2ms) RELEASE SAVEPOINT active_record_1  (1.3ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_dump -------------------  (0.2ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (0.3ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.7ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.2ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_dump -------------------  (0.2ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (0.2ms) ROLLBACK  (0.1ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.8ms) DROP VIEW guitars SQL (0.3ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.6ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (23.5ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (9.8ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.2ms) SAVEPOINT active_record_1  (1.2ms) DROP VIEW guitars SQL (0.3ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (1.0ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (20.8ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (1.0ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (6.3ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.2ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_dump ------------------- ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.2ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete FROM pg_constraint c JOIN pg_class t1 ON c.conrelid = t1.oid JOIN pg_class t2 ON c.confrelid = t2.oid JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid JOIN pg_namespace t3 ON c.connamespace = t3.oid WHERE c.contype = 'f' AND t1.relname = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname  (0.4ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (115.6ms) DROP DATABASE IF EXISTS "views_test"  (0.2ms) DROP DATABASE IF EXISTS "views_test"  (434.6ms) CREATE DATABASE "views_test" ENCODING = 'utf8'  (0.6ms) CREATE DATABASE "views_test" ENCODING = 'utf8' SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (4.0ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)   (0.2ms) DROP VIEW IF EXISTS guitars  (1.4ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'   (1.9ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)  (1.0ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.4ms) SELECT version FROM "schema_migrations"  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20161126212242')  (0.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20161017172847')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161125151623') SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (8.1ms) DROP TABLE "products" CASCADE  (7.0ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  (0.2ms) DROP VIEW IF EXISTS guitars  (0.9ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  (0.4ms) SELECT version FROM "schema_migrations"  (1.1ms) SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.3ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.3ms) ROLLBACK  (0.1ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.2ms) SAVEPOINT active_record_1  (1.0ms) DROP VIEW guitars SQL (11.4ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.9ms) DROP TABLE "products" SQL (0.3ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (18.7ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (6.1ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_dump ------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.6ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete FROM pg_constraint c JOIN pg_class t1 ON c.conrelid = t1.oid JOIN pg_class t2 ON c.confrelid = t2.oid JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid JOIN pg_namespace t3 ON c.connamespace = t3.oid WHERE c.contype = 'f' AND t1.relname = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname  (0.5ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (187.4ms) DROP DATABASE IF EXISTS "views_test"  (0.2ms) DROP DATABASE IF EXISTS "views_test"  (363.2ms) CREATE DATABASE "views_test" ENCODING = 'utf8'  (0.6ms) CREATE DATABASE "views_test" ENCODING = 'utf8' SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (5.5ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)   (0.3ms) DROP VIEW IF EXISTS guitars  (2.8ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'   (1.4ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)  (0.8ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.3ms) SELECT version FROM "schema_migrations"  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161126212242')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161017172847')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161125151623') SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (7.6ms) DROP TABLE "products" CASCADE  (6.6ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  (0.2ms) DROP VIEW IF EXISTS guitars  (1.0ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  (0.3ms) SELECT version FROM "schema_migrations"  (1.1ms) SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.2ms) SAVEPOINT active_record_1  (1.1ms) DROP VIEW guitars SQL (7.1ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.6ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (13.8ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.2ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.8ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (6.0ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (111.8ms) DROP DATABASE IF EXISTS "views_test"  (35.2ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)   (11.3ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) BEGIN  (27.8ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  SQL (0.4ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (5.5ms) COMMIT Migrating to CreateGuitarsView (20161125151623)  (5.4ms) BEGIN  (28.3ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.3ms) COMMIT ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.4ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete FROM pg_constraint c JOIN pg_class t1 ON c.conrelid = t1.oid JOIN pg_class t2 ON c.confrelid = t2.oid JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid JOIN pg_namespace t3 ON c.connamespace = t3.oid WHERE c.contype = 'f' AND t1.relname = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname   (0.4ms) SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.2ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_dump ------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.4ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete FROM pg_constraint c JOIN pg_class t1 ON c.conrelid = t1.oid JOIN pg_class t2 ON c.confrelid = t2.oid JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid JOIN pg_namespace t3 ON c.connamespace = t3.oid WHERE c.contype = 'f' AND t1.relname = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname  (0.5ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (130.4ms) DROP DATABASE IF EXISTS "views_test"  (0.2ms) DROP DATABASE IF EXISTS "views_test"  (403.9ms) CREATE DATABASE "views_test" ENCODING = 'utf8'  (0.7ms) CREATE DATABASE "views_test" ENCODING = 'utf8' SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (4.6ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)   (0.3ms) DROP VIEW IF EXISTS guitars  (11.7ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'   (11.6ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)  (0.7ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.2ms) SELECT version FROM "schema_migrations"  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161125151623')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20161017172847') SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (7.5ms) DROP TABLE "products" CASCADE  (6.9ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)   (0.2ms) DROP VIEW IF EXISTS guitars  (0.9ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'   (0.2ms) SELECT version FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.6ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.1ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.9ms) DROP VIEW guitars SQL (0.4ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.8ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (18.8ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.2ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.9ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (6.0ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.2ms) SAVEPOINT active_record_1  (0.8ms) DROP VIEW guitars SQL (0.3ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.6ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (13.4ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.9ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (6.2ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.2ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (177.2ms) DROP DATABASE IF EXISTS "views_test"  (309.8ms) CREATE DATABASE "views_test" ENCODING = 'utf8' SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (3.8ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  (0.2ms) DROP VIEW IF EXISTS guitars  (1.2ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  (1.3ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)   (0.7ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.2ms) SELECT version FROM "schema_migrations"  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161125151623')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20161017172847') ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.6ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.1ms) BEGIN ------------------- TaskTest: test_dump ------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.1ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete FROM pg_constraint c JOIN pg_class t1 ON c.conrelid = t1.oid JOIN pg_class t2 ON c.confrelid = t2.oid JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid JOIN pg_namespace t3 ON c.connamespace = t3.oid WHERE c.contype = 'f' AND t1.relname = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname  (0.4ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC  ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (1.8ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete FROM pg_constraint c JOIN pg_class t1 ON c.conrelid = t1.oid JOIN pg_class t2 ON c.confrelid = t2.oid JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid JOIN pg_namespace t3 ON c.connamespace = t3.oid WHERE c.contype = 'f' AND t1.relname = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname   (0.4ms) SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC  (0.2ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.9ms) DROP VIEW guitars SQL (0.3ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (13.6ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (1.6ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.2ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (1.3ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (6.1ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_dump ------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.5ms) 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 = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname  (0.5ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.2ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (148.7ms) DROP DATABASE IF EXISTS "views_test"  (0.2ms) DROP DATABASE IF EXISTS "views_test"  (293.4ms) CREATE DATABASE "views_test" ENCODING = 'utf8'  (0.7ms) CREATE DATABASE "views_test" ENCODING = 'utf8' SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (3.9ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)   (0.2ms) DROP VIEW IF EXISTS guitars  (1.3ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'   (2.0ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)  (1.0ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.4ms) SELECT version FROM "schema_migrations"  (2.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20161125151623')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161017172847') SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (7.2ms) DROP TABLE "products" CASCADE  (7.5ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)   (0.2ms) DROP VIEW IF EXISTS guitars  (0.9ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'   (0.3ms) SELECT version FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.7ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.1ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.2ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.3ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.2ms) ROLLBACK  (0.1ms) BEGIN -------------------------- MigrationTest: test_column -------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (1.1ms) DROP VIEW guitars SQL (0.4ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.8ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (3.5ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (1.0ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (1.1ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (136.1ms) DROP DATABASE IF EXISTS "views_test"  (281.1ms) CREATE DATABASE "views_test" ENCODING = 'utf8' SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (4.1ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)  (0.2ms) DROP VIEW IF EXISTS guitars  (1.5ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  (1.3ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)   (0.8ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.3ms) SELECT version FROM "schema_migrations"  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161125151623')  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20161017172847') ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.6ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.1ms) BEGIN ------------------- TaskTest: test_dump ------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.2ms) SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete FROM pg_constraint c JOIN pg_class t1 ON c.conrelid = t1.oid JOIN pg_class t2 ON c.confrelid = t2.oid JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid JOIN pg_namespace t3 ON c.connamespace = t3.oid WHERE c.contype = 'f' AND t1.relname = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname  (0.5ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC  ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (1.5ms) 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 = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname   (0.5ms) SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.3ms) BEGIN ------------------- TaskTest: test_dump ------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.5ms) 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 = 'products' AND t3.nspname = ANY (current_schemas(false)) ORDER BY c.conname  (0.4ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------- TaskTest: test_load -------------------  (130.5ms) DROP DATABASE IF EXISTS "views_test"  (0.2ms) DROP DATABASE IF EXISTS "views_test"  (313.1ms) CREATE DATABASE "views_test" ENCODING = 'utf8'  (0.6ms) CREATE DATABASE "views_test" ENCODING = 'utf8' SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (16.9ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)   (0.2ms) DROP VIEW IF EXISTS guitars  (6.6ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'   (17.5ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)  (0.9ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.3ms) SELECT version FROM "schema_migrations"  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20161125151623')  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20161017172847') SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"  (12.5ms) DROP TABLE "products" CASCADE  (2.9ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)   (0.2ms) DROP VIEW IF EXISTS guitars  (0.9ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'   (0.3ms) SELECT version FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.5ms)  SELECT c.relname as name, c.relkind AS type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('v') AND n.nspname = ANY (current_schemas(false)) ORDER BY c.oid ASC   (0.1ms) BEGIN ----------------------------------- GeneratorTest: test_file_generation -----------------------------------  (0.2ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------- MigrationTest: test_create_and_drop ----------------------------------- ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateGuitarsView (20161125151623)  (0.2ms) SAVEPOINT active_record_1  (2.8ms) DROP VIEW guitars SQL (0.4ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) DROP TABLE "products" SQL (0.2ms) DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = $1 [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateProducts (20161017172847)  (0.1ms) SAVEPOINT active_record_1  (13.5ms) CREATE TABLE "products" ("id" serial primary key, "name" character varying, "category" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161017172847"]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Migrating to CreateGuitarsView (20161125151623)  (0.1ms) SAVEPOINT active_record_1  (0.7ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20161125151623"]]  (0.1ms) RELEASE SAVEPOINT active_record_1  (6.7ms) ROLLBACK  (0.1ms) BEGIN -------------------------- MigrationTest: test_change --------------------------  (0.4ms) DROP VIEW guitars  (0.6ms) CREATE VIEW guitars AS SELECT * FROM products WHERE category = 'Guitar'  (0.1ms) ROLLBACK