(7.7ms)  CREATE TABLE "schema_migrations" ("version" character varying NOT NULL) 
   (1.1ms)  CREATE UNIQUE INDEX  "unique_schema_migrations" ON "schema_migrations"  ("version")
  ActiveRecord::SchemaMigration Load (0.3ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateApidaeSelections (20170512212941)
   (0.1ms)  BEGIN
   (15.7ms)  CREATE TABLE "apidae_selections" ("id" serial primary key, "label" character varying, "reference" character varying, "apidae_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) 
  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20170512212941"]]
   (6.1ms)  COMMIT
Migrating to CreateApidaeObjects (20170512214641)
   (5.7ms)  BEGIN
   (9.3ms)  CREATE TABLE "apidae_objects" ("id" serial primary key, "address" character varying, "apidae_id" integer, "apidae_type" character varying, "apidae_subtype" character varying, "title" character varying, "short_desc" text, "contact" text, "long_desc" text, "type_data" text, "latitude" float, "longitude" float, "openings" text, "rates" text, "reservation" text, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) 
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20170512214641"]]
   (0.4ms)  COMMIT
Migrating to CreateApidaeObjectsApidaeSelections (20170512221525)
   (0.2ms)  BEGIN
   (2.3ms)  CREATE TABLE "apidae_objects_apidae_selections" ("id" serial primary key, "object_id" integer, "selection_id" integer) 
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20170512221525"]]
   (0.3ms)  COMMIT
  ActiveRecord::SchemaMigration Load (0.2ms)  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 = 'apidae_objects'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (1.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 = 'apidae_objects_apidae_selections'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (1.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 = 'apidae_selections'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

  ActiveRecord::SchemaMigration Load (25.6ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateApidaeTowns (20170513114002)
   (0.1ms)  BEGIN
   (42.6ms)  CREATE TABLE "apidae_towns" ("id" serial primary key, "country" character varying, "apidae_id" integer, "insee_code" character varying, "name" character varying, "postal_code" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL) 
   (1.4ms)  CREATE UNIQUE INDEX  "index_apidae_towns_on_insee_code" ON "apidae_towns"  ("insee_code")
  SQL (11.2ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20170513114002"]]
   (6.2ms)  COMMIT
Migrating to AddTownInseeCodeToObjects (20170513114409)
   (5.0ms)  BEGIN
   (1.2ms)  ALTER TABLE "objects" ADD "town_insee_code" character varying
   (0.1ms)  ROLLBACK
  ActiveRecord::SchemaMigration Load (0.4ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to AddTownInseeCodeToObjects (20170513114409)
   (0.1ms)  BEGIN
   (3.0ms)  ALTER TABLE "apidae_objects" ADD "town_insee_code" character varying
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20170513114409"]]
   (0.3ms)  COMMIT
  ActiveRecord::SchemaMigration Load (0.1ms)  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 = 'apidae_objects'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (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 = 'apidae_objects_apidae_selections'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (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 = 'apidae_selections'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (2.0ms)  SELECT t2.oid::regclass::text AS to_table, a1.attname AS column, a2.attname AS primary_key, c.conname AS name, c.confupdtype AS on_update, c.confdeltype AS on_delete
FROM pg_constraint c
JOIN pg_class t1 ON c.conrelid = t1.oid
JOIN pg_class t2 ON c.confrelid = t2.oid
JOIN pg_attribute a1 ON a1.attnum = c.conkey[1] AND a1.attrelid = t1.oid
JOIN pg_attribute a2 ON a2.attnum = c.confkey[1] AND a2.attrelid = t2.oid
JOIN pg_namespace t3 ON c.connamespace = t3.oid
WHERE c.contype = 'f'
  AND t1.relname = 'apidae_towns'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

  Apidae::Object Load (23.9ms)  SELECT  "apidae_objects".* FROM "apidae_objects" WHERE "apidae_objects"."apidae_id" = $1 LIMIT 1  [["apidae_id", 504]]
  Apidae::Town Load (17.9ms)  SELECT  "apidae_towns".* FROM "apidae_towns" WHERE "apidae_towns"."apidae_id" = $1 LIMIT 1  [["apidae_id", 30248]]
  ActiveRecord::SchemaMigration Load (2.3ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to AddPicturesDataToObjects (20170513115401)
   (0.1ms)  BEGIN
   (29.9ms)  ALTER TABLE "apidae_objects" ADD "pictures_data" text
  SQL (7.8ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1)  [["version", "20170513115401"]]
   (13.6ms)  COMMIT
Migrating to CreateApidaeAttachedFiles (20170513121215)
   (0.2ms)  BEGIN
   (0.1ms)  ROLLBACK
  ActiveRecord::SchemaMigration Load (0.3ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateApidaeAttachedFiles (20170513121215)
   (0.2ms)  BEGIN
   (0.1ms)  ROLLBACK
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateApidaeAttachedFiles (20170513121215)
   (0.1ms)  BEGIN
   (0.1ms)  ROLLBACK
  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 = 'apidae_objects'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (1.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 = 'apidae_objects_apidae_selections'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (1.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 = 'apidae_selections'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

   (1.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 = 'apidae_towns'
  AND t3.nspname = ANY (current_schemas(false))
ORDER BY c.conname

DEPRECATION WARNING: Defining a route where `to` is a controller without an action is deprecated. Please change `to: 'dashboard/index'` to `controller: 'dashboard/index'`. (called from block in <top (required)> at /Users/jbvilain/workspace/code/apidae-engine-rails/config/routes.rb:9)
   (45.2ms)  CREATE TABLE "ar_internal_metadata" ("key" character varying NOT NULL PRIMARY KEY, "value" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
   (2.4ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
   (5.3ms)  SELECT pg_try_advisory_lock(6140174353533887940)
   (0.3ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
Migrating to AddPicturesDataToObjects (20170513115401)
   (0.2ms)  SELECT pg_advisory_unlock(6140174353533887940)
   (0.4ms)  SELECT pg_try_advisory_lock(6140174353533887940)
   (1.1ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
Migrating to CreateApidaeAttachedFiles (20170513121215)
   (11.7ms)  BEGIN
   (24.3ms)  CREATE TABLE "apidae_attached_files" ("id" serial NOT NULL PRIMARY KEY, "name" character varying, "credits" character varying, "description" text, "apidae_object_id" integer, "picture_file_name" character varying, "picture_content_type" character varying, "picture_file_size" integer, "picture_updated_at" timestamp, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
  SQL (0.4ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"  [["version", "20170513121215"]]
   (0.6ms)  COMMIT
Migrating to RenameObjectsSelectionsTable (20170513205932)
   (6.0ms)  BEGIN
   (18.8ms)  ALTER TABLE "apidae_objects_apidae_selections" RENAME TO "apidae_objects_selections"
   (0.4ms)  ALTER TABLE "public"."apidae_objects_apidae_selections_id_seq" RENAME TO "apidae_objects_selections_id_seq"
   (0.3ms)  ALTER INDEX "apidae_objects_apidae_selections_pkey" RENAME TO "apidae_objects_selections_pkey"
  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"  [["version", "20170513205932"]]
   (0.4ms)  COMMIT
Migrating to AddEntityDataToObjects (20170720161134)
   (0.2ms)  BEGIN
   (10.3ms)  ALTER TABLE "apidae_objects" ADD "entity_data" text
  SQL (0.4ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"  [["version", "20170720161134"]]
   (6.3ms)  COMMIT
Migrating to CreateApidaeFileImports (20170730102424)
   (0.2ms)  BEGIN
   (21.6ms)  CREATE TABLE "apidae_file_imports" ("id" serial NOT NULL PRIMARY KEY, "status" character varying, "remote_file" character varying, "created" integer, "updated" integer, "deleted" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
  SQL (0.4ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"  [["version", "20170730102424"]]
   (0.6ms)  COMMIT
Migrating to CreateApidaeExports (20171025075304)
   (6.2ms)  BEGIN
   (15.7ms)  CREATE TABLE "apidae_exports" ("id" serial NOT NULL PRIMARY KEY, "status" character varying, "remote_status" character varying, "oneshot" boolean, "reset" boolean, "file_url" character varying, "confirm_url" character varying, "project_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
  SQL (0.4ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"  [["version", "20171025075304"]]
   (0.5ms)  COMMIT
Migrating to CreateApidaeSelectionObjects (20180217222410)
   (6.3ms)  BEGIN
   (8.9ms)  CREATE TABLE "apidae_selection_objects" ("id" bigserial primary key, "apidae_selection_id" integer, "apidae_object_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"  [["version", "20180217222410"]]
   (6.0ms)  COMMIT
Migrating to AddIndexToApidaeTowns (20180218094339)
   (0.4ms)  BEGIN
   (0.2ms)  ROLLBACK
   (0.3ms)  SELECT pg_advisory_unlock(6140174353533887940)
   (0.2ms)  SELECT pg_try_advisory_lock(6140174353533887940)
   (0.9ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
Migrating to ChangeTextColumnsToJson (20180218172704)
   (0.1ms)  BEGIN
   (0.8ms)  ALTER TABLE "apidae_objects" ALTER COLUMN "pictures_data" TYPE jsonb USING CAST(value AS JSON)
   (0.1ms)  ROLLBACK
   (0.2ms)  SELECT pg_advisory_unlock(6140174353533887940)
   (0.2ms)  SELECT pg_try_advisory_lock(6140174353533887940)
   (0.5ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
Migrating to ChangeTextColumnsToJson (20180218172704)
   (0.2ms)  BEGIN
   (0.7ms)  ALTER TABLE "apidae_objects" ALTER COLUMN "pictures_data" TYPE jsonb USING CAST(pictures_data AS JSON)
   (0.1ms)  ROLLBACK
   (0.2ms)  SELECT pg_advisory_unlock(6140174353533887940)
   (0.1ms)  SELECT pg_try_advisory_lock(6140174353533887940)
   (0.8ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
Migrating to ChangeTextColumnsToJson (20180218172704)
   (0.2ms)  BEGIN
   (0.8ms)  ALTER TABLE "apidae_objects" ALTER COLUMN "pictures_data" TYPE jsonb USING pictures_data::JSON
   (0.1ms)  ROLLBACK
   (0.2ms)  SELECT pg_advisory_unlock(6140174353533887940)
   (0.2ms)  SELECT pg_try_advisory_lock(6140174353533887940)
   (0.5ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
Migrating to ChangeTextColumnsToJson (20180218172704)
   (0.2ms)  BEGIN
   (8.5ms)  ALTER TABLE "apidae_objects" ALTER COLUMN "pictures_data" TYPE jsonb USING pictures_data::text::jsonb
   (2.4ms)  ALTER TABLE "apidae_objects" ALTER COLUMN "type_data" TYPE jsonb USING type_data::text::jsonb
   (4.0ms)  ALTER TABLE "apidae_objects" ALTER COLUMN "entity_data" TYPE jsonb USING entity_data::text::jsonb
   (2.8ms)  ALTER TABLE "apidae_objects" ALTER COLUMN "contact" TYPE jsonb USING contact::text::jsonb
   (2.9ms)  ALTER TABLE "apidae_objects" ALTER COLUMN "address" TYPE jsonb USING address::text::jsonb
   (3.1ms)  ALTER TABLE "apidae_objects" ALTER COLUMN "openings" TYPE jsonb USING openings::text::jsonb
  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"  [["version", "20180218172704"]]
   (3.6ms)  COMMIT
  ActiveRecord::InternalMetadata Load (0.7ms)  SELECT  "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2  [["key", "environment"], ["LIMIT", 1]]
   (0.2ms)  BEGIN
  SQL (0.4ms)  INSERT INTO "ar_internal_metadata" ("key", "value", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "key"  [["key", "environment"], ["value", "development"], ["created_at", "2018-02-18 17:35:13.592426"], ["updated_at", "2018-02-18 17:35:13.592426"]]
   (0.3ms)  COMMIT
   (0.2ms)  SELECT pg_advisory_unlock(6140174353533887940)
   (0.3ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
   (0.3ms)  SELECT pg_try_advisory_lock(6140174353533887940)
   (1.0ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
Migrating to AddServiceDataToApidaeObjects (20180218231319)
   (0.2ms)  BEGIN
   (0.9ms)  ALTER TABLE "apidae_objects" ADD "service_data" jsonb
  SQL (0.4ms)  INSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"  [["version", "20180218231319"]]
   (5.5ms)  COMMIT
  ActiveRecord::InternalMetadata Load (7.7ms)  SELECT  "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2  [["key", "environment"], ["LIMIT", 1]]
   (0.2ms)  BEGIN
   (0.1ms)  COMMIT
   (0.3ms)  SELECT pg_advisory_unlock(6140174353533887940)
   (0.3ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC