(3.2ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)   (1.7ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreatePushTypeUsers (20150102204418)  (0.3ms) BEGIN SQL (2.9ms) CREATE EXTENSION IF NOT EXISTS "uuid-ossp"  (3.3ms) CREATE TABLE "push_type_users" ("id" uuid PRIMARY KEY DEFAULT uuid_generate_v4(), "name" character varying(255), "email" character varying(255), "field_store" json, "created_at" timestamp, "updated_at" timestamp) SQL (0.6ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20150102204418"]]  (1.0ms) COMMIT Migrating to CreatePushTypeNodes (20150102204419)  (0.3ms) BEGIN  (2.7ms) CREATE TABLE "push_type_nodes" ("id" uuid PRIMARY KEY DEFAULT uuid_generate_v4(), "type" character varying(255), "title" character varying(255), "slug" character varying(255), "field_store" json, "parent_id" uuid, "sort_order" integer, "status" integer, "published_at" timestamp, "published_to" timestamp, "creator_id" uuid, "updater_id" uuid, "created_at" timestamp, "updated_at" timestamp, "deleted_at" timestamp) SQL (0.4ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20150102204419"]]  (0.6ms) COMMIT Migrating to CreatePushTypeNodeHierarchies (20150102204420)  (0.2ms) BEGIN  (1.1ms) CREATE TABLE "push_type_node_hierarchies" ("ancestor_id" uuid NOT NULL, "descendant_id" uuid NOT NULL, "generations" integer NOT NULL)  (1.6ms) CREATE UNIQUE INDEX "anc_desc_idx" ON "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations")  (0.8ms) CREATE INDEX "desc_idx" ON "push_type_node_hierarchies" ("descendant_id") SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20150102204420"]]  (0.4ms) COMMIT Migrating to CreatePushTypeAssets (20150102204421)  (0.1ms) BEGIN  (3.4ms) CREATE TABLE "push_type_assets" ("id" uuid PRIMARY KEY DEFAULT uuid_generate_v4(), "file_uid" character varying(255), "file_name" character varying(255), "file_size" integer, "file_ext" character varying(255), "mime_type" character varying(255), "description" character varying(255), "uploader_id" uuid, "created_at" timestamp, "updated_at" timestamp, "deleted_at" timestamp) SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES ($1) [["version", "20150102204421"]]  (0.5ms) COMMIT ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.6ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "push_type_users" DISABLE TRIGGER ALL;ALTER TABLE "push_type_nodes" DISABLE TRIGGER ALL;ALTER TABLE "push_type_node_hierarchies" DISABLE TRIGGER ALL;ALTER TABLE "push_type_assets" DISABLE TRIGGER ALL  (1.4ms) select table_name from information_schema.views where table_schema = 'dummy_test'  (10.2ms) TRUNCATE TABLE "push_type_users", "push_type_nodes", "push_type_node_hierarchies", "push_type_assets" RESTART IDENTITY CASCADE;  (0.5ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "push_type_users" ENABLE TRIGGER ALL;ALTER TABLE "push_type_nodes" ENABLE TRIGGER ALL;ALTER TABLE "push_type_node_hierarchies" ENABLE TRIGGER ALL;ALTER TABLE "push_type_assets" ENABLE TRIGGER ALL ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.2ms) BEGIN ---------------------------------------------------------------------------- PushType::NodesController::PUT #update::with valid node: test_0001_anonymous ----------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.7ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-1' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (1.4ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2015-01-02 20:44:26.478086"], ["slug", "foo-bar-1"], ["status", 0], ["title", "Foo bar"], ["type", "Page"], ["updated_at", "2015-01-02 20:44:26.478086"]]  (0.4ms) SELECT pg_try_advisory_lock(1213021721,0) AS t06a3e63d688e4777454324f7302cb2f5 SQL (0.6ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "7a2bbec9-62ba-4750-965a-ea5fe89db838"], ["descendant_id", "7a2bbec9-62ba-4750-965a-ea5fe89db838"], ["generations", 0]]  (0.9ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id Page Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "7a2bbec9-62ba-4750-965a-ea5fe89db838"]] PushType::Node Load (0.4ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "7a2bbec9-62ba-4750-965a-ea5fe89db838"]]  (0.4ms) SELECT pg_advisory_unlock(1213021721,0) AS tc7e253eda12f13a3d1b035ee43c321f8  (0.2ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#update as HTML Parameters: {"page"=>{"title"=>"Foo bar baz"}, "id"=>"7a2bbec9-62ba-4750-965a-ea5fe89db838"} PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "7a2bbec9-62ba-4750-965a-ea5fe89db838"]]  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.5ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-1' AND "push_type_nodes"."id" != '7a2bbec9-62ba-4750-965a-ea5fe89db838' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) UPDATE "push_type_nodes" SET "title" = $1, "updated_at" = $2 WHERE "push_type_nodes"."id" = '7a2bbec9-62ba-4750-965a-ea5fe89db838' [["title", "Foo bar baz"], ["updated_at", "2015-01-02 20:44:26.553010"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/nodes Completed 302 Found in 20ms (ActiveRecord: 1.4ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------------------------- PushType::NodesController::PUT #update::with valid node: test_0002_anonymous ----------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.4ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-2' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2015-01-02 20:44:26.562549"], ["slug", "foo-bar-2"], ["status", 0], ["title", "Foo bar"], ["type", "Page"], ["updated_at", "2015-01-02 20:44:26.562549"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS tb6e9d96c116658442980cb86b24e6a49 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "3e3c957e-f6df-4974-ac58-9b7f9ab395eb"], ["descendant_id", "3e3c957e-f6df-4974-ac58-9b7f9ab395eb"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  Page Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "3e3c957e-f6df-4974-ac58-9b7f9ab395eb"]] PushType::Node Load (0.5ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "3e3c957e-f6df-4974-ac58-9b7f9ab395eb"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tca34753484cb41d076b53e51899faca6  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#update as HTML Parameters: {"page"=>{"title"=>"Foo bar baz"}, "id"=>"3e3c957e-f6df-4974-ac58-9b7f9ab395eb"} PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "3e3c957e-f6df-4974-ac58-9b7f9ab395eb"]]  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-2' AND "push_type_nodes"."id" != '3e3c957e-f6df-4974-ac58-9b7f9ab395eb' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) UPDATE "push_type_nodes" SET "title" = $1, "updated_at" = $2 WHERE "push_type_nodes"."id" = '3e3c957e-f6df-4974-ac58-9b7f9ab395eb' [["title", "Foo bar baz"], ["updated_at", "2015-01-02 20:44:26.575472"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/nodes Completed 302 Found in 5ms (ActiveRecord: 1.1ms)  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------------------------- PushType::NodesController::PUT #update::with valid node: test_0003_anonymous ----------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-3' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2015-01-02 20:44:26.582746"], ["slug", "foo-bar-3"], ["status", 0], ["title", "Foo bar"], ["type", "Page"], ["updated_at", "2015-01-02 20:44:26.582746"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t55140d0d62a8f8b3ed7f0c2535b9b47f SQL (0.3ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "bbd1fa03-2223-4805-a75e-2c5f72e8266b"], ["descendant_id", "bbd1fa03-2223-4805-a75e-2c5f72e8266b"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id Page Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "bbd1fa03-2223-4805-a75e-2c5f72e8266b"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "bbd1fa03-2223-4805-a75e-2c5f72e8266b"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t6de4105a640e4b4178b7c0a47e054d06  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#update as HTML Parameters: {"page"=>{"title"=>"Foo bar baz"}, "id"=>"bbd1fa03-2223-4805-a75e-2c5f72e8266b"} PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "bbd1fa03-2223-4805-a75e-2c5f72e8266b"]]  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-3' AND "push_type_nodes"."id" != 'bbd1fa03-2223-4805-a75e-2c5f72e8266b' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) UPDATE "push_type_nodes" SET "title" = $1, "updated_at" = $2 WHERE "push_type_nodes"."id" = 'bbd1fa03-2223-4805-a75e-2c5f72e8266b' [["title", "Foo bar baz"], ["updated_at", "2015-01-02 20:44:26.596087"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/nodes Completed 302 Found in 7ms (ActiveRecord: 1.3ms) Page Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "bbd1fa03-2223-4805-a75e-2c5f72e8266b"]]  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------------------- PushType::AdminHelper::#ficon: test_0001_should return an element ---------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_1  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------------- PushType::AdminHelper::#ficon: test_0002_should return any text ---------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------- PushType::UsersController::GET #index: test_0001_anonymous ----------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 PushType::User Exists (0.4ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-1@example.com' LIMIT 1 SQL (0.5ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:26.620017"], ["email", "joe-1@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:26.620017"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-2@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:26.623667"], ["email", "joe-2@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:26.623667"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-3@example.com' LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:26.626248"], ["email", "joe-3@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:26.626248"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-4@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:26.629102"], ["email", "joe-4@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:26.629102"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-5@example.com' LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:26.631835"], ["email", "joe-5@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:26.631835"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::UsersController#index as HTML  (0.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_users" LIMIT 30 OFFSET 0) subquery_for_count PushType::User Load (0.5ms) SELECT "push_type_users".* FROM "push_type_users" ORDER BY "push_type_users"."name" ASC LIMIT 30 OFFSET 0 Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_user.html.haml (2.5ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_user.html.haml (0.4ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_user.html.haml (0.4ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_user.html.haml (0.3ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_user.html.haml (0.4ms)  (0.6ms) SELECT COUNT(*) FROM "push_type_users" Completed 200 OK in 11601ms (Views: 11598.5ms | ActiveRecord: 1.4ms)  (0.3ms) ROLLBACK TO SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------- PushType::UsersController::GET #index: test_0002_anonymous ----------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.4ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-6@example.com' LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.242785"], ["email", "joe-6@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.242785"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-7@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.246597"], ["email", "joe-7@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.246597"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-8@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.249224"], ["email", "joe-8@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.249224"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.2ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-9@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.251738"], ["email", "joe-9@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.251738"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-10@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.254259"], ["email", "joe-10@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.254259"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::UsersController#index as HTML  (0.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_users" LIMIT 30 OFFSET 0) subquery_for_count PushType::User Load (0.3ms) SELECT "push_type_users".* FROM "push_type_users" ORDER BY "push_type_users"."name" ASC LIMIT 30 OFFSET 0 Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_user.html.haml (0.6ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_user.html.haml (0.4ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_user.html.haml (0.3ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_user.html.haml (0.3ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_user.html.haml (0.3ms)  (0.5ms) SELECT COUNT(*) FROM "push_type_users" Completed 200 OK in 13ms (Views: 10.6ms | ActiveRecord: 1.2ms)  (0.5ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_users" LIMIT 30 OFFSET 0) subquery_for_count  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------- PushType::AssetsController::GET #edit: test_0001_anonymous ----------------------------------------------------------  (0.4ms) SAVEPOINT active_record_1  (0.2ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 SQL (0.7ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:38.295878"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "1"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:38.295878"]]  (0.2ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::AssetsController#edit as HTML Parameters: {"id"=>"39defbb0-5ee5-43c3-b20a-b1b5f2ad7acf"} PushType::Asset Load (0.4ms) SELECT "push_type_assets".* FROM "push_type_assets" WHERE "push_type_assets"."id" = $1 ORDER BY "push_type_assets"."created_at" DESC LIMIT 1 [["id", "39defbb0-5ee5-43c3-b20a-b1b5f2ad7acf"]] Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/assets/_form.html.haml (19.5ms) Completed 200 OK in 30ms (Views: 27.6ms | ActiveRecord: 0.4ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------- PushType::AssetsController::GET #edit: test_0002_anonymous ----------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:38.337465"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "2"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:38.337465"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::AssetsController#edit as HTML Parameters: {"id"=>"0ff41c7d-25e3-4b0a-9e7f-6612981dfee4"} PushType::Asset Load (0.4ms) SELECT "push_type_assets".* FROM "push_type_assets" WHERE "push_type_assets"."id" = $1 ORDER BY "push_type_assets"."created_at" DESC LIMIT 1 [["id", "0ff41c7d-25e3-4b0a-9e7f-6612981dfee4"]] Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/assets/_form.html.haml (4.6ms) Completed 200 OK in 10ms (Views: 8.3ms | ActiveRecord: 0.4ms)  (0.3ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN -------------------------------------------------- PushType::AdminHelper::#title: test_0001_anonymous --------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN -------------------------------------------------- PushType::AdminHelper::#title: test_0002_anonymous --------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN -------------------------------------------------------------------------------------- PushType::NodesController::POST #position::without reponsitioning: test_0001_anonymous --------------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-4' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.362054"], ["slug", "foo-bar-4"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.362054"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t902dec3da17b9a2412df13adb56b2f5e SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "e5377bd0-5a19-4b0c-8a4e-9ed79d3384b0"], ["descendant_id", "e5377bd0-5a19-4b0c-8a4e-9ed79d3384b0"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "e5377bd0-5a19-4b0c-8a4e-9ed79d3384b0"]] PushType::Node Load (0.4ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "e5377bd0-5a19-4b0c-8a4e-9ed79d3384b0"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tb58817c0b00b9b48c988a2fbf6499eef  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-5' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.372081"], ["slug", "foo-bar-5"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.372081"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t629e6ef0ad623cdb72e9e3900d8271aa SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "e4b5b5ac-1255-46ed-92c5-9f4e94ed6050"], ["descendant_id", "e4b5b5ac-1255-46ed-92c5-9f4e94ed6050"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "e4b5b5ac-1255-46ed-92c5-9f4e94ed6050"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "e4b5b5ac-1255-46ed-92c5-9f4e94ed6050"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tb2ab7c847538e90095d81e49f972245c  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-6' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.381589"], ["slug", "foo-bar-6"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.381589"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t8e05445179a9395ffbca3163ff4363a7 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "16100404-bb58-4b87-841d-5c8394b1fdf4"], ["descendant_id", "16100404-bb58-4b87-841d-5c8394b1fdf4"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "16100404-bb58-4b87-841d-5c8394b1fdf4"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "16100404-bb58-4b87-841d-5c8394b1fdf4"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t4b4e37768330130ef50621612229311c  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-7' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.390070"], ["slug", "foo-bar-7"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.390070"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS tbb2c6a545fa2b476d3eb56e8a89a023d SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "5872fdab-97cb-40b3-9055-600b896da447"], ["descendant_id", "5872fdab-97cb-40b3-9055-600b896da447"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "5872fdab-97cb-40b3-9055-600b896da447"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "5872fdab-97cb-40b3-9055-600b896da447"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS taefcae5093044c5f34f9ed7c03d1dd5c  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-8' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.399122"], ["slug", "foo-bar-8"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.399122"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t20d68f8573ba20337ddcb4473f9607df SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "4b97b5d7-7db6-4b03-90bc-3593101a1f9a"], ["descendant_id", "4b97b5d7-7db6-4b03-90bc-3593101a1f9a"], ["generations", 0]]  (1.0ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "4b97b5d7-7db6-4b03-90bc-3593101a1f9a"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "4b97b5d7-7db6-4b03-90bc-3593101a1f9a"]]  (0.3ms) SELECT pg_advisory_unlock(1213021721,0) AS tb280d984f8564ce8a223f0d695e7e987  (0.2ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#index as HTML  (0.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count  (0.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count PushType::Node Load (0.4ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 30 OFFSET 0  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "e5377bd0-5a19-4b0c-8a4e-9ed79d3384b0"]]  (0.3ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "e4b5b5ac-1255-46ed-92c5-9f4e94ed6050"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "16100404-bb58-4b87-841d-5c8394b1fdf4"]]  (0.3ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "5872fdab-97cb-40b3-9055-600b896da447"]]  (0.4ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "4b97b5d7-7db6-4b03-90bc-3593101a1f9a"]]  (0.5ms) SELECT COUNT(*) FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_new_node_button.html.haml (4.2ms) Completed 200 OK in 46ms (Views: 36.7ms | ActiveRecord: 3.0ms) PushType::Node Load (0.4ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 1 OFFSET 0  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN -------------------------------------------------------------------------------------- PushType::NodesController::POST #position::without reponsitioning: test_0002_anonymous --------------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-9' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.462073"], ["slug", "foo-bar-9"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.462073"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS te534f00b2c263bb9305e342495b725c8 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "ed0516f9-7a77-4f07-89be-3c2a7b55f012"], ["descendant_id", "ed0516f9-7a77-4f07-89be-3c2a7b55f012"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "ed0516f9-7a77-4f07-89be-3c2a7b55f012"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "ed0516f9-7a77-4f07-89be-3c2a7b55f012"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tf925f4e200ecacab74489f72e8aafa0e  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-10' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.471056"], ["slug", "foo-bar-10"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.471056"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS tabc99b59a98ee0ef63a040b69676b721 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "50fe02c4-f6be-4114-bed6-5ffee521ecbe"], ["descendant_id", "50fe02c4-f6be-4114-bed6-5ffee521ecbe"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "50fe02c4-f6be-4114-bed6-5ffee521ecbe"]] PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "50fe02c4-f6be-4114-bed6-5ffee521ecbe"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tf010ffea70a228797f9c9f15e8e796e0  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-11' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.480611"], ["slug", "foo-bar-11"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.480611"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t943c8d07c49d32ea109ef4a8f9480d71 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "89c8e15d-904b-4af2-8e3b-85d958bb809e"], ["descendant_id", "89c8e15d-904b-4af2-8e3b-85d958bb809e"], ["generations", 0]]  (0.9ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "89c8e15d-904b-4af2-8e3b-85d958bb809e"]] PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "89c8e15d-904b-4af2-8e3b-85d958bb809e"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t1a9d2e40997df74c1febff5f621cd6cd  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-12' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.7ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.491419"], ["slug", "foo-bar-12"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.491419"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS tf6904e3a43e22ecf1de47e7b10628d37 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "df77e365-d2db-42ab-bf8b-8540bb65a5e2"], ["descendant_id", "df77e365-d2db-42ab-bf8b-8540bb65a5e2"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "df77e365-d2db-42ab-bf8b-8540bb65a5e2"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "df77e365-d2db-42ab-bf8b-8540bb65a5e2"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tcda5a8bd938435d0cad9d38d4e0ba7f7  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-13' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.501635"], ["slug", "foo-bar-13"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.501635"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t81f84dbcbb71159d816ec2c67a8a96e5 SQL (0.1ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "47553109-c0a0-48ed-8776-f61fa461138f"], ["descendant_id", "47553109-c0a0-48ed-8776-f61fa461138f"], ["generations", 0]]  (0.9ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.4ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "47553109-c0a0-48ed-8776-f61fa461138f"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "47553109-c0a0-48ed-8776-f61fa461138f"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t6e019313b2fe5ab995ad214c63ca7cde  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#index as HTML  (0.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count  (0.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count PushType::Node Load (0.7ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 30 OFFSET 0  (0.4ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "ed0516f9-7a77-4f07-89be-3c2a7b55f012"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "50fe02c4-f6be-4114-bed6-5ffee521ecbe"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "89c8e15d-904b-4af2-8e3b-85d958bb809e"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "df77e365-d2db-42ab-bf8b-8540bb65a5e2"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "47553109-c0a0-48ed-8776-f61fa461138f"]]  (0.3ms) SELECT COUNT(*) FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_new_node_button.html.haml (1.1ms) Completed 200 OK in 25ms (Views: 21.6ms | ActiveRecord: 2.9ms) PushType::Node Load (0.6ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 30 OFFSET 0  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.2ms) BEGIN ---------------------------------------------------------------------------- PushType::UsersController::PUT #update::with valid user: test_0001_anonymous ----------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 PushType::User Exists (0.5ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-11@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.545519"], ["email", "joe-11@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.545519"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::UsersController#update as HTML Parameters: {"user"=>{"name"=>"Foo bar baz"}, "id"=>"9cefb62d-df21-4240-9caa-e639cf213a8f"} PushType::User Load (0.3ms) SELECT "push_type_users".* FROM "push_type_users" WHERE "push_type_users"."id" = $1 ORDER BY "push_type_users"."name" ASC LIMIT 1 [["id", "9cefb62d-df21-4240-9caa-e639cf213a8f"]]  (0.2ms) SAVEPOINT active_record_2 PushType::User Exists (0.4ms) SELECT 1 AS one FROM "push_type_users" WHERE ("push_type_users"."email" = 'joe-11@example.com' AND "push_type_users"."id" != '9cefb62d-df21-4240-9caa-e639cf213a8f') LIMIT 1 SQL (0.3ms) UPDATE "push_type_users" SET "name" = $1, "updated_at" = $2 WHERE "push_type_users"."id" = '9cefb62d-df21-4240-9caa-e639cf213a8f' [["name", "Foo bar baz"], ["updated_at", "2015-01-02 20:44:38.552222"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/users Completed 302 Found in 6ms (ActiveRecord: 1.2ms)  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------------------------- PushType::UsersController::PUT #update::with valid user: test_0002_anonymous ----------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-12@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.558456"], ["email", "joe-12@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.558456"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::UsersController#update as HTML Parameters: {"user"=>{"name"=>"Foo bar baz"}, "id"=>"f6569ffe-b6d4-4412-a376-738b8ec72e4e"} PushType::User Load (0.4ms) SELECT "push_type_users".* FROM "push_type_users" WHERE "push_type_users"."id" = $1 ORDER BY "push_type_users"."name" ASC LIMIT 1 [["id", "f6569ffe-b6d4-4412-a376-738b8ec72e4e"]]  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE ("push_type_users"."email" = 'joe-12@example.com' AND "push_type_users"."id" != 'f6569ffe-b6d4-4412-a376-738b8ec72e4e') LIMIT 1 SQL (0.3ms) UPDATE "push_type_users" SET "name" = $1, "updated_at" = $2 WHERE "push_type_users"."id" = 'f6569ffe-b6d4-4412-a376-738b8ec72e4e' [["name", "Foo bar baz"], ["updated_at", "2015-01-02 20:44:38.564241"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/users Completed 302 Found in 5ms (ActiveRecord: 1.1ms)  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------------------------- PushType::UsersController::PUT #update::with valid user: test_0003_anonymous ----------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-13@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.570143"], ["email", "joe-13@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.570143"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::UsersController#update as HTML Parameters: {"user"=>{"name"=>"Foo bar baz"}, "id"=>"1067acc0-9c52-4f9c-a6b3-b3191bb5679c"} PushType::User Load (0.4ms) SELECT "push_type_users".* FROM "push_type_users" WHERE "push_type_users"."id" = $1 ORDER BY "push_type_users"."name" ASC LIMIT 1 [["id", "1067acc0-9c52-4f9c-a6b3-b3191bb5679c"]]  (0.2ms) SAVEPOINT active_record_2 PushType::User Exists (0.4ms) SELECT 1 AS one FROM "push_type_users" WHERE ("push_type_users"."email" = 'joe-13@example.com' AND "push_type_users"."id" != '1067acc0-9c52-4f9c-a6b3-b3191bb5679c') LIMIT 1 SQL (0.3ms) UPDATE "push_type_users" SET "name" = $1, "updated_at" = $2 WHERE "push_type_users"."id" = '1067acc0-9c52-4f9c-a6b3-b3191bb5679c' [["name", "Foo bar baz"], ["updated_at", "2015-01-02 20:44:38.575936"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/users Completed 302 Found in 5ms (ActiveRecord: 1.3ms) PushType::User Load (0.2ms) SELECT "push_type_users".* FROM "push_type_users" WHERE "push_type_users"."id" = $1 LIMIT 1 [["id", "1067acc0-9c52-4f9c-a6b3-b3191bb5679c"]]  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------------- PushType::NodesController::DELETE #destroy: test_0001_anonymous ---------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-14' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2015-01-02 20:44:38.585973"], ["slug", "foo-bar-14"], ["status", 0], ["title", "Foo bar"], ["type", "Page"], ["updated_at", "2015-01-02 20:44:38.585973"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t419eb6c03fa83a451183daebb464d9df SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "3ebf2e48-bdc9-4cd7-b506-0a6912600802"], ["descendant_id", "3ebf2e48-bdc9-4cd7-b506-0a6912600802"], ["generations", 0]]  (0.9ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  Page Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "3ebf2e48-bdc9-4cd7-b506-0a6912600802"]] PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "3ebf2e48-bdc9-4cd7-b506-0a6912600802"]]  (0.3ms) SELECT pg_advisory_unlock(1213021721,0) AS tef6d7bd7ef40c7d1d612f0252c271587  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#destroy as HTML Parameters: {"id"=>"3ebf2e48-bdc9-4cd7-b506-0a6912600802"} PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "3ebf2e48-bdc9-4cd7-b506-0a6912600802"]]  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) UPDATE "push_type_nodes" SET "deleted_at" = $1, "updated_at" = $2 WHERE "push_type_nodes"."id" = '3ebf2e48-bdc9-4cd7-b506-0a6912600802' [["deleted_at", "2015-01-02 20:44:38.597401"], ["updated_at", "2015-01-02 20:44:38.598004"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/nodes Completed 302 Found in 4ms (ActiveRecord: 0.7ms)  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------------- PushType::NodesController::DELETE #destroy: test_0002_anonymous ---------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-15' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2015-01-02 20:44:38.605620"], ["slug", "foo-bar-15"], ["status", 0], ["title", "Foo bar"], ["type", "Page"], ["updated_at", "2015-01-02 20:44:38.605620"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t2dcff9c5f3701eb7e7c76badd1db2fa1 SQL (0.3ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "036aeb45-52dc-4051-aef0-e9ba567c1462"], ["descendant_id", "036aeb45-52dc-4051-aef0-e9ba567c1462"], ["generations", 0]]  (0.8ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  Page Load (0.5ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "036aeb45-52dc-4051-aef0-e9ba567c1462"]] PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "036aeb45-52dc-4051-aef0-e9ba567c1462"]]  (0.3ms) SELECT pg_advisory_unlock(1213021721,0) AS tdf4f96b8be0f8ea753a7c8264a46bc94  (0.2ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#destroy as HTML Parameters: {"id"=>"036aeb45-52dc-4051-aef0-e9ba567c1462"} PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "036aeb45-52dc-4051-aef0-e9ba567c1462"]]  (0.1ms) SAVEPOINT active_record_2 SQL (0.4ms) UPDATE "push_type_nodes" SET "deleted_at" = $1, "updated_at" = $2 WHERE "push_type_nodes"."id" = '036aeb45-52dc-4051-aef0-e9ba567c1462' [["deleted_at", "2015-01-02 20:44:38.619600"], ["updated_at", "2015-01-02 20:44:38.620312"]]  (0.2ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/nodes Completed 302 Found in 5ms (ActiveRecord: 0.9ms)  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------------- PushType::NodesController::DELETE #destroy: test_0003_anonymous ---------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-16' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.4ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2015-01-02 20:44:38.629252"], ["slug", "foo-bar-16"], ["status", 0], ["title", "Foo bar"], ["type", "Page"], ["updated_at", "2015-01-02 20:44:38.629252"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS tdc21d81c8ce2b3c3f8c7d4f943f68dfb SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "d7707be7-8a55-4bca-bf42-2f0c4d17660d"], ["descendant_id", "d7707be7-8a55-4bca-bf42-2f0c4d17660d"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  Page Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "d7707be7-8a55-4bca-bf42-2f0c4d17660d"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "d7707be7-8a55-4bca-bf42-2f0c4d17660d"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tb8e2f6611831d067674d86a0e75aca7d  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#destroy as HTML Parameters: {"id"=>"d7707be7-8a55-4bca-bf42-2f0c4d17660d"} PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "d7707be7-8a55-4bca-bf42-2f0c4d17660d"]]  (0.1ms) SAVEPOINT active_record_2 SQL (0.4ms) UPDATE "push_type_nodes" SET "deleted_at" = $1, "updated_at" = $2 WHERE "push_type_nodes"."id" = 'd7707be7-8a55-4bca-bf42-2f0c4d17660d' [["deleted_at", "2015-01-02 20:44:38.639009"], ["updated_at", "2015-01-02 20:44:38.639508"]]  (0.2ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/nodes Completed 302 Found in 5ms (ActiveRecord: 0.9ms) Page Load (0.5ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "d7707be7-8a55-4bca-bf42-2f0c4d17660d"]]  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.2ms) BEGIN ---------------------------------------------------------- PushType::NodesController::GET #index: test_0001_anonymous ----------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.4ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-17' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.652721"], ["slug", "foo-bar-17"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.652721"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t07374eeee744a292798a233a669910c9 SQL (0.1ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "e67400c6-84af-41fe-a21f-dea459f7a9f8"], ["descendant_id", "e67400c6-84af-41fe-a21f-dea459f7a9f8"], ["generations", 0]]  (0.9ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "e67400c6-84af-41fe-a21f-dea459f7a9f8"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "e67400c6-84af-41fe-a21f-dea459f7a9f8"]]  (0.3ms) SELECT pg_advisory_unlock(1213021721,0) AS t039f3402001b6c599c44dd792c6a0cd4  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.4ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-18' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.4ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.664733"], ["slug", "foo-bar-18"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.664733"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t574e776ec6fecadfdbad008b0a45dcf6 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "5f822469-a6de-4da4-a3a2-a1b1081a1f13"], ["descendant_id", "5f822469-a6de-4da4-a3a2-a1b1081a1f13"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "5f822469-a6de-4da4-a3a2-a1b1081a1f13"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "5f822469-a6de-4da4-a3a2-a1b1081a1f13"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t4cdb3c3f07d15dba5d40c16500b8f80f  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.4ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-19' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.674924"], ["slug", "foo-bar-19"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.674924"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS ta1d03f0fa6f688ae5aebc5b2b03d4647 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "ade79611-22ff-4919-aacc-8e0c911bacab"], ["descendant_id", "ade79611-22ff-4919-aacc-8e0c911bacab"], ["generations", 0]]  (0.7ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "ade79611-22ff-4919-aacc-8e0c911bacab"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "ade79611-22ff-4919-aacc-8e0c911bacab"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t9c01072e1fd7c6f5c10f68e7ae590103  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-20' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.684443"], ["slug", "foo-bar-20"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.684443"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS ta5edfc8ff66dbfe2258d634e6580eb02 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "f4a67123-c96e-4961-8e87-a6b4e77a2a7d"], ["descendant_id", "f4a67123-c96e-4961-8e87-a6b4e77a2a7d"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "f4a67123-c96e-4961-8e87-a6b4e77a2a7d"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "f4a67123-c96e-4961-8e87-a6b4e77a2a7d"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS td3ba646b6777f641b2b8aa909d4b096e  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.4ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-21' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.4ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.693839"], ["slug", "foo-bar-21"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.693839"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS ta8731ebda3bb23e36194786b7a424e37 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "65c81a26-2fe5-4ebc-ac5c-3810ddeb1c81"], ["descendant_id", "65c81a26-2fe5-4ebc-ac5c-3810ddeb1c81"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "65c81a26-2fe5-4ebc-ac5c-3810ddeb1c81"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "65c81a26-2fe5-4ebc-ac5c-3810ddeb1c81"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t261390570b80d0ce98d881c0b03d6d7c  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#index as HTML  (0.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count  (0.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 30 OFFSET 0  (0.3ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "e67400c6-84af-41fe-a21f-dea459f7a9f8"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "5f822469-a6de-4da4-a3a2-a1b1081a1f13"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "ade79611-22ff-4919-aacc-8e0c911bacab"]]  (0.4ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "f4a67123-c96e-4961-8e87-a6b4e77a2a7d"]]  (0.3ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "65c81a26-2fe5-4ebc-ac5c-3810ddeb1c81"]]  (0.4ms) SELECT COUNT(*) FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_new_node_button.html.haml (1.6ms) Completed 200 OK in 25ms (Views: 22.0ms | ActiveRecord: 2.7ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------- PushType::NodesController::GET #index: test_0002_anonymous ----------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-22' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.733982"], ["slug", "foo-bar-22"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.733982"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t41979cb8999e2076a3741121d9a49062 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "604290f2-e471-41f1-84da-b0ceb36e6c7c"], ["descendant_id", "604290f2-e471-41f1-84da-b0ceb36e6c7c"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "604290f2-e471-41f1-84da-b0ceb36e6c7c"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "604290f2-e471-41f1-84da-b0ceb36e6c7c"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t5efc6f691aeb6956fe79479a571a51d9  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-23' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.742732"], ["slug", "foo-bar-23"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.742732"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS tfa892c03f73e4a28f49b435a11308799 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "fc873287-7b7e-47a4-92a2-ddfd70e47871"], ["descendant_id", "fc873287-7b7e-47a4-92a2-ddfd70e47871"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "fc873287-7b7e-47a4-92a2-ddfd70e47871"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "fc873287-7b7e-47a4-92a2-ddfd70e47871"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tbf30f9dd73d906f71e2e234c10a2a545  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-24' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.751247"], ["slug", "foo-bar-24"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.751247"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t1c5c8a4b0b10f2251a0d63a32c1bb1af SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "8e16063f-8a60-4753-bb6f-70e623ac62fa"], ["descendant_id", "8e16063f-8a60-4753-bb6f-70e623ac62fa"], ["generations", 0]]  (0.9ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "8e16063f-8a60-4753-bb6f-70e623ac62fa"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "8e16063f-8a60-4753-bb6f-70e623ac62fa"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t29434b91943567ec7e3beff0b9fae610  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.5ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-25' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.761676"], ["slug", "foo-bar-25"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.761676"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS ta4a0af6a3775863fb3541e957b8cda9e SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "438eedd4-8293-4cb2-9da7-88218dbc5eda"], ["descendant_id", "438eedd4-8293-4cb2-9da7-88218dbc5eda"], ["generations", 0]]  (0.6ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "438eedd4-8293-4cb2-9da7-88218dbc5eda"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "438eedd4-8293-4cb2-9da7-88218dbc5eda"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tfa445837f51cb11b1a7583dbad992105  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-26' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:38.772355"], ["slug", "foo-bar-26"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:38.772355"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t7acb59e05d29c03519ca47b7b369dc2a SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "a1f304b5-f616-4822-b72b-8a2c364ca0e9"], ["descendant_id", "a1f304b5-f616-4822-b72b-8a2c364ca0e9"], ["generations", 0]]  (0.7ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "a1f304b5-f616-4822-b72b-8a2c364ca0e9"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "a1f304b5-f616-4822-b72b-8a2c364ca0e9"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t8f828332b02d5b000e8bb98920f9a068  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#index as HTML  (0.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count  (0.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 30 OFFSET 0  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "604290f2-e471-41f1-84da-b0ceb36e6c7c"]]  (0.4ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "fc873287-7b7e-47a4-92a2-ddfd70e47871"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "8e16063f-8a60-4753-bb6f-70e623ac62fa"]]  (0.3ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "438eedd4-8293-4cb2-9da7-88218dbc5eda"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "a1f304b5-f616-4822-b72b-8a2c364ca0e9"]]  (0.3ms) SELECT COUNT(*) FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_new_node_button.html.haml (1.0ms) Completed 200 OK in 24ms (Views: 20.7ms | ActiveRecord: 2.6ms)  (0.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.2ms) BEGIN ---------------------------------------------------------------- PushType::AssetsController::DELETE #destroy: test_0001_anonymous ----------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.2ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 SQL (0.4ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:38.816325"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "3"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:38.816325"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::AssetsController#destroy as HTML Parameters: {"id"=>"dc98cdde-05cc-44ae-9c42-3c789c16ed31"} PushType::Asset Load (0.4ms) SELECT "push_type_assets".* FROM "push_type_assets" WHERE "push_type_assets"."id" = $1 ORDER BY "push_type_assets"."created_at" DESC LIMIT 1 [["id", "dc98cdde-05cc-44ae-9c42-3c789c16ed31"]]  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) UPDATE "push_type_assets" SET "deleted_at" = $1, "updated_at" = $2 WHERE "push_type_assets"."id" = 'dc98cdde-05cc-44ae-9c42-3c789c16ed31' [["deleted_at", "2015-01-02 20:44:38.822406"], ["updated_at", "2015-01-02 20:44:38.823024"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/media Completed 302 Found in 5ms (ActiveRecord: 1.0ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------------- PushType::AssetsController::DELETE #destroy: test_0002_anonymous ----------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:38.831094"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "4"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:38.831094"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::AssetsController#destroy as HTML Parameters: {"id"=>"0339fadd-a0df-4136-8b04-e65db3f81f11"} PushType::Asset Load (0.3ms) SELECT "push_type_assets".* FROM "push_type_assets" WHERE "push_type_assets"."id" = $1 ORDER BY "push_type_assets"."created_at" DESC LIMIT 1 [["id", "0339fadd-a0df-4136-8b04-e65db3f81f11"]]  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) UPDATE "push_type_assets" SET "deleted_at" = $1, "updated_at" = $2 WHERE "push_type_assets"."id" = '0339fadd-a0df-4136-8b04-e65db3f81f11' [["deleted_at", "2015-01-02 20:44:38.835140"], ["updated_at", "2015-01-02 20:44:38.835671"]]  (0.2ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/media Completed 302 Found in 5ms (ActiveRecord: 1.0ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------------- PushType::AssetsController::DELETE #destroy: test_0003_anonymous ----------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:38.844004"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "5"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:38.844004"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::AssetsController#destroy as HTML Parameters: {"id"=>"653f092d-1528-45a9-86c2-419caa3592f3"} PushType::Asset Load (0.3ms) SELECT "push_type_assets".* FROM "push_type_assets" WHERE "push_type_assets"."id" = $1 ORDER BY "push_type_assets"."created_at" DESC LIMIT 1 [["id", "653f092d-1528-45a9-86c2-419caa3592f3"]]  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) UPDATE "push_type_assets" SET "deleted_at" = $1, "updated_at" = $2 WHERE "push_type_assets"."id" = '653f092d-1528-45a9-86c2-419caa3592f3' [["deleted_at", "2015-01-02 20:44:38.848209"], ["updated_at", "2015-01-02 20:44:38.848747"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/media Completed 302 Found in 4ms (ActiveRecord: 0.8ms) PushType::Asset Load (0.3ms) SELECT "push_type_assets".* FROM "push_type_assets" WHERE "push_type_assets"."id" = $1 LIMIT 1 [["id", "653f092d-1528-45a9-86c2-419caa3592f3"]]  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------------- PushType::UsersController::DELETE #destroy: test_0001_anonymous ---------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-14@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.857216"], ["email", "joe-14@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.857216"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::UsersController#destroy as HTML Parameters: {"id"=>"9f868e6c-d0e7-49cd-ab7d-7db560cbed64"} PushType::User Load (0.3ms) SELECT "push_type_users".* FROM "push_type_users" WHERE "push_type_users"."id" = $1 ORDER BY "push_type_users"."name" ASC LIMIT 1 [["id", "9f868e6c-d0e7-49cd-ab7d-7db560cbed64"]]  (0.2ms) SAVEPOINT active_record_2 SQL (0.3ms) DELETE FROM "push_type_users" WHERE "push_type_users"."id" = $1 [["id", "9f868e6c-d0e7-49cd-ab7d-7db560cbed64"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/users Completed 302 Found in 4ms (ActiveRecord: 0.9ms)  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.2ms) BEGIN --------------------------------------------------------------- PushType::UsersController::DELETE #destroy: test_0002_anonymous ---------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-15@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.867582"], ["email", "joe-15@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.867582"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::UsersController#destroy as HTML Parameters: {"id"=>"4b1cae2c-b26b-4da3-9487-566e3df1cedd"} PushType::User Load (0.3ms) SELECT "push_type_users".* FROM "push_type_users" WHERE "push_type_users"."id" = $1 ORDER BY "push_type_users"."name" ASC LIMIT 1 [["id", "4b1cae2c-b26b-4da3-9487-566e3df1cedd"]]  (0.1ms) SAVEPOINT active_record_2 SQL (0.2ms) DELETE FROM "push_type_users" WHERE "push_type_users"."id" = $1 [["id", "4b1cae2c-b26b-4da3-9487-566e3df1cedd"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/users Completed 302 Found in 3ms (ActiveRecord: 0.7ms)  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------------- PushType::UsersController::DELETE #destroy: test_0003_anonymous ---------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-16@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.876297"], ["email", "joe-16@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.876297"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::UsersController#destroy as HTML Parameters: {"id"=>"4ac7477b-5214-421f-a6f2-bd74da1acc91"} PushType::User Load (0.3ms) SELECT "push_type_users".* FROM "push_type_users" WHERE "push_type_users"."id" = $1 ORDER BY "push_type_users"."name" ASC LIMIT 1 [["id", "4ac7477b-5214-421f-a6f2-bd74da1acc91"]]  (0.1ms) SAVEPOINT active_record_2 SQL (0.4ms) DELETE FROM "push_type_users" WHERE "push_type_users"."id" = $1 [["id", "4ac7477b-5214-421f-a6f2-bd74da1acc91"]]  (0.2ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/users Completed 302 Found in 3ms (ActiveRecord: 0.9ms) PushType::User Load (0.3ms) SELECT "push_type_users".* FROM "push_type_users" WHERE "push_type_users"."id" = $1 LIMIT 1 [["id", "4ac7477b-5214-421f-a6f2-bd74da1acc91"]]  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------------------------------------------------------------ PushType::UsersController::POST #create::user count: test_0001_anonymous ------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.3ms) SELECT COUNT(*) FROM "push_type_users" Processing by PushType::UsersController#create as HTML Parameters: {"user"=>{"name"=>"Joe Bloggs", "email"=>"joe-17@example.com"}}  (0.2ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-17@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.891209"], ["email", "joe-17@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.891209"]]  (0.2ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/users Completed 302 Found in 4ms (ActiveRecord: 0.9ms)  (0.5ms) SELECT COUNT(*) FROM "push_type_users"  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN -------------------------------------------------------------------------- PushType::AssetsHelper::#asset_icon::with video asset: test_0001_anonymous --------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:38.904778"], ["file_ext", "mp4"], ["file_name", "video.mp4"], ["file_size", 424925], ["file_uid", "6"], ["mime_type", "video/mp4"], ["updated_at", "2015-01-02 20:44:38.904778"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------------------------------------------------- PushType::UsersController::POST #create::with valid user: test_0001_anonymous -----------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::UsersController#create as HTML Parameters: {"user"=>{"name"=>"Joe Bloggs", "email"=>"joe-18@example.com"}}  (0.2ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-18@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.914808"], ["email", "joe-18@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.914808"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/users Completed 302 Found in 4ms (ActiveRecord: 0.8ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------------------------------------------------- PushType::UsersController::POST #create::with valid user: test_0002_anonymous -----------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::UsersController#create as HTML Parameters: {"user"=>{"name"=>"Joe Bloggs", "email"=>"joe-19@example.com"}}  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-19@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:38.922750"], ["email", "joe-19@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:38.922750"]]  (0.2ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/users Completed 302 Found in 4ms (ActiveRecord: 0.8ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------- PushType::AdminController::GET #info: test_0001_anonymous ---------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.2ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::AdminController#info as HTML Completed 200 OK in 6ms (Views: 5.3ms | ActiveRecord: 0.0ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------- PushType::AdminController::GET #info: test_0002_anonymous ---------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::AdminController#info as HTML Completed 200 OK in 1ms (Views: 1.2ms | ActiveRecord: 0.0ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN -------------------------------------------------------------------------------- PushType::NodesController::POST #create::with in-valid node: test_0001_anonymous --------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::NodesController#create as HTML Parameters: {"kind"=>"page", "page"=>{}}  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" IS NULL AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1  (0.2ms) ROLLBACK TO SAVEPOINT active_record_2 Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_meta_table.html.haml (3.0ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_form_fields.html.haml (29.0ms) Completed 200 OK in 48ms (Views: 40.2ms | ActiveRecord: 0.7ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN -------------------------------------------------------------------------------- PushType::NodesController::POST #create::with in-valid node: test_0002_anonymous --------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::NodesController#create as HTML Parameters: {"kind"=>"page", "page"=>{}}  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.4ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" IS NULL AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1  (0.1ms) ROLLBACK TO SAVEPOINT active_record_2 Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_meta_table.html.haml (0.1ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_form_fields.html.haml (13.0ms) Completed 200 OK in 22ms (Views: 16.8ms | ActiveRecord: 0.6ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.2ms) BEGIN -------------------------------------------------------------------------- PushType::AssetsController::POST #create::asset count: test_0001_anonymous --------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.2ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_1  (0.3ms) SELECT COUNT(*) FROM "push_type_assets" Processing by PushType::AssetsController#create as HTML Parameters: {"asset"=>{"file"=>#>}}  (0.2ms) SAVEPOINT active_record_2 SQL (0.5ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:39.040255"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "7"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:39.040255"]]  (0.2ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/media Completed 302 Found in 7ms (ActiveRecord: 0.8ms)  (0.3ms) SELECT COUNT(*) FROM "push_type_assets"  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN -------------------------------------------------------- PushType::UsersController::GET #new: test_0001_anonymous --------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::UsersController#new as HTML Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_meta_table.html.haml (0.9ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_form.html.haml (9.3ms) Completed 200 OK in 16ms (Views: 15.3ms | ActiveRecord: 0.0ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN -------------------------------------------------------- PushType::UsersController::GET #new: test_0002_anonymous --------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::UsersController#new as HTML Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_meta_table.html.haml (0.1ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_form.html.haml (2.1ms) Completed 200 OK in 6ms (Views: 5.2ms | ActiveRecord: 0.0ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.4ms) BEGIN -------------------------------------------------------- PushType::UsersController::GET #new: test_0003_anonymous --------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::UsersController#new as HTML Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_meta_table.html.haml (0.1ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_form.html.haml (2.6ms) Completed 200 OK in 7ms (Views: 6.2ms | ActiveRecord: 0.0ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN -------------------------------------------------------------------------- PushType::AssetsHelper::#asset_icon::with image asset: test_0001_anonymous --------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:39.095573"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "8"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:39.095573"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.2ms) BEGIN -------------------------------------------------------------------------------- PushType::UsersController::POST #create::with in-valid user: test_0001_anonymous --------------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::UsersController#create as HTML Parameters: {"user"=>{}}  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.4ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" IS NULL LIMIT 1  (0.1ms) ROLLBACK TO SAVEPOINT active_record_2 Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_meta_table.html.haml (0.1ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_form.html.haml (2.5ms) Completed 200 OK in 10ms (Views: 6.4ms | ActiveRecord: 0.7ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.3ms) BEGIN -------------------------------------------------------------------------------- PushType::UsersController::POST #create::with in-valid user: test_0002_anonymous --------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.2ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_1 Processing by PushType::UsersController#create as HTML Parameters: {"user"=>{}}  (0.2ms) SAVEPOINT active_record_2 PushType::User Exists (0.4ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" IS NULL LIMIT 1  (0.2ms) ROLLBACK TO SAVEPOINT active_record_2 Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_meta_table.html.haml (0.1ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_form.html.haml (2.4ms) Completed 200 OK in 10ms (Views: 5.3ms | ActiveRecord: 0.7ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.2ms) BEGIN ------------------------------------------------------------------------------- PushType::UsersController::PUT #update::with in-valid user: test_0001_anonymous -------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-20@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:39.133690"], ["email", "joe-20@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:39.133690"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::UsersController#update as HTML Parameters: {"user"=>{"name"=>""}, "id"=>"237d6046-8e3d-4c8c-a000-38081ed4944a"} PushType::User Load (0.2ms) SELECT "push_type_users".* FROM "push_type_users" WHERE "push_type_users"."id" = $1 ORDER BY "push_type_users"."name" ASC LIMIT 1 [["id", "237d6046-8e3d-4c8c-a000-38081ed4944a"]]  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE ("push_type_users"."email" = 'joe-20@example.com' AND "push_type_users"."id" != '237d6046-8e3d-4c8c-a000-38081ed4944a') LIMIT 1  (0.2ms) ROLLBACK TO SAVEPOINT active_record_2 Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_meta_table.html.haml (0.1ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_form.html.haml (4.5ms) Completed 200 OK in 16ms (Views: 11.6ms | ActiveRecord: 0.9ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------------------------------------------------------------------- PushType::UsersController::PUT #update::with in-valid user: test_0002_anonymous -------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-21@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:39.156695"], ["email", "joe-21@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:39.156695"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::UsersController#update as HTML Parameters: {"user"=>{"name"=>""}, "id"=>"6db2b961-64a3-4141-ad1b-478c1242fbb0"} PushType::User Load (0.2ms) SELECT "push_type_users".* FROM "push_type_users" WHERE "push_type_users"."id" = $1 ORDER BY "push_type_users"."name" ASC LIMIT 1 [["id", "6db2b961-64a3-4141-ad1b-478c1242fbb0"]]  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE ("push_type_users"."email" = 'joe-21@example.com' AND "push_type_users"."id" != '6db2b961-64a3-4141-ad1b-478c1242fbb0') LIMIT 1  (0.1ms) ROLLBACK TO SAVEPOINT active_record_2 Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_meta_table.html.haml (0.1ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_form.html.haml (3.8ms) Completed 200 OK in 11ms (Views: 6.8ms | ActiveRecord: 0.8ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.2ms) BEGIN --------------------------------------------------------- PushType::AssetsController::GET #new: test_0001_anonymous ---------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_1 Processing by PushType::AssetsController#new as HTML Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/assets/_form.html.haml (3.9ms) Completed 200 OK in 11ms (Views: 9.9ms | ActiveRecord: 0.0ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------- PushType::AssetsController::GET #new: test_0002_anonymous ---------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.2ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::AssetsController#new as HTML Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/assets/_form.html.haml (4.4ms) Completed 200 OK in 10ms (Views: 8.3ms | ActiveRecord: 0.0ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.2ms) BEGIN --------------------------------------------------------- PushType::AssetsController::GET #new: test_0003_anonymous ---------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_1 Processing by PushType::AssetsController#new as HTML Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/assets/_form.html.haml (4.4ms) Completed 200 OK in 9ms (Views: 8.1ms | ActiveRecord: 0.0ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------- PushType::NodesController::GET #edit: test_0001_anonymous ---------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.3ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-27' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2015-01-02 20:44:39.224427"], ["slug", "foo-bar-27"], ["status", 0], ["title", "Foo bar"], ["type", "Page"], ["updated_at", "2015-01-02 20:44:39.224427"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t57e34fd7a30e94dc0a662c6279e44baa SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "791e19be-92c1-421e-a7f8-42df9b093a8e"], ["descendant_id", "791e19be-92c1-421e-a7f8-42df9b093a8e"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  Page Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "791e19be-92c1-421e-a7f8-42df9b093a8e"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "791e19be-92c1-421e-a7f8-42df9b093a8e"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t02a4edca6926567066716754125fe312  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#edit as HTML Parameters: {"id"=>"791e19be-92c1-421e-a7f8-42df9b093a8e"} PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "791e19be-92c1-421e-a7f8-42df9b093a8e"]] PushType::Node Load (0.6ms) SELECT "push_type_nodes".* FROM "push_type_nodes" INNER JOIN "push_type_node_hierarchies" ON "push_type_nodes"."id" = "push_type_node_hierarchies"."ancestor_id" WHERE "push_type_node_hierarchies"."descendant_id" = $1 AND ("push_type_nodes"."id" != '791e19be-92c1-421e-a7f8-42df9b093a8e') ORDER BY "push_type_node_hierarchies".generations asc [["descendant_id", "791e19be-92c1-421e-a7f8-42df9b093a8e"]] Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_meta_table.html.haml (0.2ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_form_fields.html.haml (16.6ms) Completed 200 OK in 33ms (Views: 31.4ms | ActiveRecord: 0.8ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------- PushType::NodesController::GET #edit: test_0002_anonymous ---------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-28' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2015-01-02 20:44:39.273492"], ["slug", "foo-bar-28"], ["status", 0], ["title", "Foo bar"], ["type", "Page"], ["updated_at", "2015-01-02 20:44:39.273492"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t77e61f394c946e11d4fec59557b226d2 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "7278fbb6-11db-4858-bdd6-722bae156038"], ["descendant_id", "7278fbb6-11db-4858-bdd6-722bae156038"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  Page Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "7278fbb6-11db-4858-bdd6-722bae156038"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "7278fbb6-11db-4858-bdd6-722bae156038"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS ta6d52aeaddd7d4928dc76f9b10ce1b30  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#edit as HTML Parameters: {"id"=>"7278fbb6-11db-4858-bdd6-722bae156038"} PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "7278fbb6-11db-4858-bdd6-722bae156038"]] PushType::Node Load (0.5ms) SELECT "push_type_nodes".* FROM "push_type_nodes" INNER JOIN "push_type_node_hierarchies" ON "push_type_nodes"."id" = "push_type_node_hierarchies"."ancestor_id" WHERE "push_type_node_hierarchies"."descendant_id" = $1 AND ("push_type_nodes"."id" != '7278fbb6-11db-4858-bdd6-722bae156038') ORDER BY "push_type_node_hierarchies".generations asc [["descendant_id", "7278fbb6-11db-4858-bdd6-722bae156038"]] Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_meta_table.html.haml (0.3ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_form_fields.html.haml (13.0ms) Completed 200 OK in 21ms (Views: 18.7ms | ActiveRecord: 0.8ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------------------------- PushType::NodesController::POST #position::prepend node: test_0001_anonymous ----------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.7ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-29' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.4ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.313014"], ["slug", "foo-bar-29"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.313014"]]  (0.3ms) SELECT pg_try_advisory_lock(1213021721,0) AS te9104d2a1bc8b61a3c144fd2b87b352d SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "58616c4d-0b67-4238-8b51-7dffc19afaa1"], ["descendant_id", "58616c4d-0b67-4238-8b51-7dffc19afaa1"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "58616c4d-0b67-4238-8b51-7dffc19afaa1"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "58616c4d-0b67-4238-8b51-7dffc19afaa1"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tc588069ae3a394593ec367534fbe43df  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-30' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.322590"], ["slug", "foo-bar-30"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.322590"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t11d9d2dbf78661aba2a1aa25934965d7 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "28f324c2-3444-43fe-a71f-11613c2d78f1"], ["descendant_id", "28f324c2-3444-43fe-a71f-11613c2d78f1"], ["generations", 0]]  (0.9ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "28f324c2-3444-43fe-a71f-11613c2d78f1"]] PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "28f324c2-3444-43fe-a71f-11613c2d78f1"]]  (0.3ms) SELECT pg_advisory_unlock(1213021721,0) AS t5368cbe26fbc52db1f597a8d5b9c763a  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.5ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-31' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.332929"], ["slug", "foo-bar-31"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.332929"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t3f2239d9a97c97f4a5c476b49f3b7047 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "6103f125-3947-4d50-bde1-7a49fc46983a"], ["descendant_id", "6103f125-3947-4d50-bde1-7a49fc46983a"], ["generations", 0]]  (0.6ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "6103f125-3947-4d50-bde1-7a49fc46983a"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "6103f125-3947-4d50-bde1-7a49fc46983a"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tc94b8808d2175b67c631a4d992e7dbb7  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-32' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.342202"], ["slug", "foo-bar-32"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.342202"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS tb8968237fb39cd59b59b10c416a41889 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "16f12bda-c7be-4d32-9621-5048c7ebc40d"], ["descendant_id", "16f12bda-c7be-4d32-9621-5048c7ebc40d"], ["generations", 0]]  (1.0ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "16f12bda-c7be-4d32-9621-5048c7ebc40d"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "16f12bda-c7be-4d32-9621-5048c7ebc40d"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t25c761fdd6d51e89dd069ebf93c85cb4  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-33' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.353021"], ["slug", "foo-bar-33"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.353021"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS te1674c65ac74f0a0a5b1ce4d7c3f3fc2 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "9787f7f1-7d4e-4357-a82c-69fa7aa9afb1"], ["descendant_id", "9787f7f1-7d4e-4357-a82c-69fa7aa9afb1"], ["generations", 0]]  (0.7ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "9787f7f1-7d4e-4357-a82c-69fa7aa9afb1"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "9787f7f1-7d4e-4357-a82c-69fa7aa9afb1"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tcb3dcd56d0c33fdc60977a14c6967a2f  (0.2ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#position as HTML Parameters: {"next"=>"58616c4d-0b67-4238-8b51-7dffc19afaa1", "id"=>"9787f7f1-7d4e-4357-a82c-69fa7aa9afb1"} PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "9787f7f1-7d4e-4357-a82c-69fa7aa9afb1"]] PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "58616c4d-0b67-4238-8b51-7dffc19afaa1"]]  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.4ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-29' AND "push_type_nodes"."id" != '58616c4d-0b67-4238-8b51-7dffc19afaa1' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t8dc8b56c434587bf34318092e3f889f0  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-33' AND "push_type_nodes"."id" != '9787f7f1-7d4e-4357-a82c-69fa7aa9afb1' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) UPDATE "push_type_nodes" SET "sort_order" = $1, "updated_at" = $2 WHERE "push_type_nodes"."id" = '9787f7f1-7d4e-4357-a82c-69fa7aa9afb1' [["sort_order", 0], ["updated_at", "2015-01-02 20:44:39.368746"]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL AND "push_type_nodes"."sort_order" >= 0 ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "58616c4d-0b67-4238-8b51-7dffc19afaa1"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "58616c4d-0b67-4238-8b51-7dffc19afaa1"]] PushType::Node Load (0.1ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "9787f7f1-7d4e-4357-a82c-69fa7aa9afb1"]] SQL (0.3ms) UPDATE "push_type_nodes" SET "sort_order" = 1 WHERE "push_type_nodes"."id" = '58616c4d-0b67-4238-8b51-7dffc19afaa1' SQL (0.2ms) UPDATE "push_type_nodes" SET "sort_order" = 0 WHERE "push_type_nodes"."id" = '9787f7f1-7d4e-4357-a82c-69fa7aa9afb1'  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t334cad8c47732c17c12871addbbc28f6 Completed 200 OK in 13ms (ActiveRecord: 4.0ms) Processing by PushType::NodesController#index as HTML  (0.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count  (0.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count PushType::Node Load (0.4ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 30 OFFSET 0  (0.3ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "9787f7f1-7d4e-4357-a82c-69fa7aa9afb1"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "58616c4d-0b67-4238-8b51-7dffc19afaa1"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "28f324c2-3444-43fe-a71f-11613c2d78f1"]]  (0.3ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "6103f125-3947-4d50-bde1-7a49fc46983a"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "16f12bda-c7be-4d32-9621-5048c7ebc40d"]]  (0.5ms) SELECT COUNT(*) FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_new_node_button.html.haml (1.3ms) Completed 200 OK in 26ms (Views: 22.7ms | ActiveRecord: 2.8ms) PushType::Node Load (0.5ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 30 OFFSET 0  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------------------------- PushType::NodesController::POST #position::prepend node: test_0002_anonymous ----------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-34' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.408723"], ["slug", "foo-bar-34"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.408723"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t99fc3d0d4b8a65fbf562aebb3752c534 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "bb460e4f-19d0-4182-bdf8-9b155f42e64a"], ["descendant_id", "bb460e4f-19d0-4182-bdf8-9b155f42e64a"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "bb460e4f-19d0-4182-bdf8-9b155f42e64a"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "bb460e4f-19d0-4182-bdf8-9b155f42e64a"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t7323a9c8706890db0d7fc2202421eac8  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-35' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.417721"], ["slug", "foo-bar-35"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.417721"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS td435fe54bd2d46b8eb105a52556203d3 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "1e600c22-8c5e-4362-9b9c-92ef5037f39a"], ["descendant_id", "1e600c22-8c5e-4362-9b9c-92ef5037f39a"], ["generations", 0]]  (0.9ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "1e600c22-8c5e-4362-9b9c-92ef5037f39a"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "1e600c22-8c5e-4362-9b9c-92ef5037f39a"]]  (0.3ms) SELECT pg_advisory_unlock(1213021721,0) AS t0f6656cecb5e3bade1e9e58e76b9728d  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.4ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-36' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.428695"], ["slug", "foo-bar-36"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.428695"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t3c0c9f38319da71c01e8a3104b18b1d8 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "c9044227-e6ba-4285-b245-f8dbbb710851"], ["descendant_id", "c9044227-e6ba-4285-b245-f8dbbb710851"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "c9044227-e6ba-4285-b245-f8dbbb710851"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "c9044227-e6ba-4285-b245-f8dbbb710851"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t7d4d876ccf5486e09c8368d7e7cb6a59  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-37' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.438433"], ["slug", "foo-bar-37"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.438433"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS te125e5d4c6efa468b7c44d8700b08b0b SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "b283012d-9d03-40d1-81b4-25b4f9ed2cfc"], ["descendant_id", "b283012d-9d03-40d1-81b4-25b4f9ed2cfc"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "b283012d-9d03-40d1-81b4-25b4f9ed2cfc"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "b283012d-9d03-40d1-81b4-25b4f9ed2cfc"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t8331789ed6460444b6291579d8e1710f  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.6ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-38' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.5ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.448244"], ["slug", "foo-bar-38"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.448244"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t51c918874006f68e7879e00a88cc763c SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "35bec837-1ba7-4d5f-b22a-464ff24126e0"], ["descendant_id", "35bec837-1ba7-4d5f-b22a-464ff24126e0"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "35bec837-1ba7-4d5f-b22a-464ff24126e0"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "35bec837-1ba7-4d5f-b22a-464ff24126e0"]]  (0.3ms) SELECT pg_advisory_unlock(1213021721,0) AS t44277293e0e11906ec04f1646ea35a45  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#position as HTML Parameters: {"next"=>"bb460e4f-19d0-4182-bdf8-9b155f42e64a", "id"=>"35bec837-1ba7-4d5f-b22a-464ff24126e0"} PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "35bec837-1ba7-4d5f-b22a-464ff24126e0"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "bb460e4f-19d0-4182-bdf8-9b155f42e64a"]]  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-34' AND "push_type_nodes"."id" != 'bb460e4f-19d0-4182-bdf8-9b155f42e64a' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS te86e9b390dbea19850010e0c07d40aea  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-38' AND "push_type_nodes"."id" != '35bec837-1ba7-4d5f-b22a-464ff24126e0' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) UPDATE "push_type_nodes" SET "sort_order" = $1, "updated_at" = $2 WHERE "push_type_nodes"."id" = '35bec837-1ba7-4d5f-b22a-464ff24126e0' [["sort_order", 0], ["updated_at", "2015-01-02 20:44:39.463039"]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL AND "push_type_nodes"."sort_order" >= 0 ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "bb460e4f-19d0-4182-bdf8-9b155f42e64a"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "bb460e4f-19d0-4182-bdf8-9b155f42e64a"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "35bec837-1ba7-4d5f-b22a-464ff24126e0"]] SQL (0.3ms) UPDATE "push_type_nodes" SET "sort_order" = 1 WHERE "push_type_nodes"."id" = 'bb460e4f-19d0-4182-bdf8-9b155f42e64a' SQL (0.3ms) UPDATE "push_type_nodes" SET "sort_order" = 0 WHERE "push_type_nodes"."id" = '35bec837-1ba7-4d5f-b22a-464ff24126e0'  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t1f539d5535048c1c9b8825269e8bce93 Completed 200 OK in 12ms (ActiveRecord: 3.8ms) Processing by PushType::NodesController#index as HTML  (0.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count  (0.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 30 OFFSET 0  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "35bec837-1ba7-4d5f-b22a-464ff24126e0"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "bb460e4f-19d0-4182-bdf8-9b155f42e64a"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "1e600c22-8c5e-4362-9b9c-92ef5037f39a"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "c9044227-e6ba-4285-b245-f8dbbb710851"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "b283012d-9d03-40d1-81b4-25b4f9ed2cfc"]]  (0.3ms) SELECT COUNT(*) FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_new_node_button.html.haml (1.0ms) Completed 200 OK in 20ms (Views: 17.0ms | ActiveRecord: 2.3ms) PushType::Node Load (0.5ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 1 OFFSET 0  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.2ms) BEGIN ----------------------------------------------------------------------------- PushType::AssetsHelper::#asset_icon::with document asset: test_0001_anonymous -----------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:39.500648"], ["file_ext", "pdf"], ["file_name", "document.pdf"], ["file_size", 15356], ["file_uid", "9"], ["mime_type", "application/pdf"], ["updated_at", "2015-01-02 20:44:39.500648"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------------------------- PushType::NodesController::POST #position::append node: test_0001_anonymous ---------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-39' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.4ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.508423"], ["slug", "foo-bar-39"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.508423"]]  (0.3ms) SELECT pg_try_advisory_lock(1213021721,0) AS t002175db94ffea5ec1e73b08dce92c66 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "fc4d7a68-8761-4b63-b73e-5087f0ced9c4"], ["descendant_id", "fc4d7a68-8761-4b63-b73e-5087f0ced9c4"], ["generations", 0]]  (0.7ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "fc4d7a68-8761-4b63-b73e-5087f0ced9c4"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "fc4d7a68-8761-4b63-b73e-5087f0ced9c4"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tded972c376872117174b6f5a6b4f9e9b  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-40' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.522069"], ["slug", "foo-bar-40"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.522069"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS tfa6b623e9e040b81b92795ed109d4c07 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "14b8c56b-4f10-4a32-809f-910d9a57cf56"], ["descendant_id", "14b8c56b-4f10-4a32-809f-910d9a57cf56"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "14b8c56b-4f10-4a32-809f-910d9a57cf56"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "14b8c56b-4f10-4a32-809f-910d9a57cf56"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t3f5ae63697366ae25d92c2fdef0f2887  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-41' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.530077"], ["slug", "foo-bar-41"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.530077"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t7cccd9a26266ba6f42e8fde637d5cf32 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "af3a91da-edf5-4127-a431-ff373cca98e3"], ["descendant_id", "af3a91da-edf5-4127-a431-ff373cca98e3"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "af3a91da-edf5-4127-a431-ff373cca98e3"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "af3a91da-edf5-4127-a431-ff373cca98e3"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t783a2378d195cbec94d26294df301683  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-42' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.539182"], ["slug", "foo-bar-42"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.539182"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS tf1dbbf64e9003d058f28ee0e2e671a87 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "722d694f-ad4b-4959-843c-22a256078425"], ["descendant_id", "722d694f-ad4b-4959-843c-22a256078425"], ["generations", 0]]  (0.9ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "722d694f-ad4b-4959-843c-22a256078425"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "722d694f-ad4b-4959-843c-22a256078425"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t82c213ea8bf7879eec16e79a967c402a  (0.4ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.5ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-43' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.550389"], ["slug", "foo-bar-43"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.550389"]]  (0.3ms) SELECT pg_try_advisory_lock(1213021721,0) AS t16ed701cfb927404cdbcf1278da050e2 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "57c59f00-7176-4c8f-8114-350db45e5f77"], ["descendant_id", "57c59f00-7176-4c8f-8114-350db45e5f77"], ["generations", 0]]  (0.6ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "57c59f00-7176-4c8f-8114-350db45e5f77"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "57c59f00-7176-4c8f-8114-350db45e5f77"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t44d95d0c5a55b8dd3b49c000b390a6ce  (0.2ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#position as HTML Parameters: {"prev"=>"fc4d7a68-8761-4b63-b73e-5087f0ced9c4", "id"=>"57c59f00-7176-4c8f-8114-350db45e5f77"} PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "57c59f00-7176-4c8f-8114-350db45e5f77"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "fc4d7a68-8761-4b63-b73e-5087f0ced9c4"]]  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-39' AND "push_type_nodes"."id" != 'fc4d7a68-8761-4b63-b73e-5087f0ced9c4' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS tb16b11e124cff1adbd966d4e9980a0d9  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-43' AND "push_type_nodes"."id" != '57c59f00-7176-4c8f-8114-350db45e5f77' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) UPDATE "push_type_nodes" SET "sort_order" = $1, "updated_at" = $2 WHERE "push_type_nodes"."id" = '57c59f00-7176-4c8f-8114-350db45e5f77' [["sort_order", 0], ["updated_at", "2015-01-02 20:44:39.566072"]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL AND "push_type_nodes"."sort_order" >= 0 ) AS t WHERE "push_type_nodes"."id" = t.id PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "fc4d7a68-8761-4b63-b73e-5087f0ced9c4"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "fc4d7a68-8761-4b63-b73e-5087f0ced9c4"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "57c59f00-7176-4c8f-8114-350db45e5f77"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tff56c72532a278c4e715225b3aa4f930 Completed 200 OK in 11ms (ActiveRecord: 3.2ms) Processing by PushType::NodesController#index as HTML  (0.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count  (0.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 30 OFFSET 0  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "fc4d7a68-8761-4b63-b73e-5087f0ced9c4"]]  (0.3ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "57c59f00-7176-4c8f-8114-350db45e5f77"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "14b8c56b-4f10-4a32-809f-910d9a57cf56"]]  (0.3ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "af3a91da-edf5-4127-a431-ff373cca98e3"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "722d694f-ad4b-4959-843c-22a256078425"]]  (0.3ms) SELECT COUNT(*) FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_new_node_button.html.haml (1.1ms) Completed 200 OK in 23ms (Views: 19.2ms | ActiveRecord: 2.4ms) PushType::Node Load (0.4ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 1 OFFSET 0  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.2ms) BEGIN --------------------------------------------------------------------------- PushType::NodesController::POST #position::append node: test_0002_anonymous ---------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.2ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-44' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.602039"], ["slug", "foo-bar-44"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.602039"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t107855f5b55b2a3725e8b4fdd34255dd SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "4c667f82-1b16-43e5-91e5-a4ce929337df"], ["descendant_id", "4c667f82-1b16-43e5-91e5-a4ce929337df"], ["generations", 0]]  (0.9ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "4c667f82-1b16-43e5-91e5-a4ce929337df"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "4c667f82-1b16-43e5-91e5-a4ce929337df"]]  (0.3ms) SELECT pg_advisory_unlock(1213021721,0) AS ta1432410acaaf870db25d6229b78fb06  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.4ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-45' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.612984"], ["slug", "foo-bar-45"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.612984"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS tfa626d46a1b32e05dae141c84bae6b7e SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "dca4a5a5-7104-4723-8529-5ea7b8195215"], ["descendant_id", "dca4a5a5-7104-4723-8529-5ea7b8195215"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "dca4a5a5-7104-4723-8529-5ea7b8195215"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "dca4a5a5-7104-4723-8529-5ea7b8195215"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS td90df0cfb0bdc426c901fd58e2a11a53  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-46' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.622664"], ["slug", "foo-bar-46"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.622664"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t9a704a14819006843d5939bff53bc36e SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "94c9a395-f07b-4695-b450-83fd152d4230"], ["descendant_id", "94c9a395-f07b-4695-b450-83fd152d4230"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "94c9a395-f07b-4695-b450-83fd152d4230"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "94c9a395-f07b-4695-b450-83fd152d4230"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t581f5f009a6d81d079c3b28bd4cd599f  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-47' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.631563"], ["slug", "foo-bar-47"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.631563"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS tc4243f8f3665fb935734e33ee15b9f28 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "96a979c7-7d9a-4bf3-b241-8a02a917e607"], ["descendant_id", "96a979c7-7d9a-4bf3-b241-8a02a917e607"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "96a979c7-7d9a-4bf3-b241-8a02a917e607"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "96a979c7-7d9a-4bf3-b241-8a02a917e607"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS td5c174f09bb96a26a955914097672684  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-48' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", "2015-01-02 20:44:39.640725"], ["slug", "foo-bar-48"], ["status", 0], ["title", "Foo bar"], ["updated_at", "2015-01-02 20:44:39.640725"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t66580c569b98b977c4e323e31dd69f72 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "fb83a911-9cd6-4bfa-9086-3986196e62ce"], ["descendant_id", "fb83a911-9cd6-4bfa-9086-3986196e62ce"], ["generations", 0]]  (0.9ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "fb83a911-9cd6-4bfa-9086-3986196e62ce"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "fb83a911-9cd6-4bfa-9086-3986196e62ce"]]  (0.3ms) SELECT pg_advisory_unlock(1213021721,0) AS t6ea220c82a1a0627fb2e773d7e47c58e  (0.2ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#position as HTML Parameters: {"prev"=>"4c667f82-1b16-43e5-91e5-a4ce929337df", "id"=>"fb83a911-9cd6-4bfa-9086-3986196e62ce"} PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "fb83a911-9cd6-4bfa-9086-3986196e62ce"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "4c667f82-1b16-43e5-91e5-a4ce929337df"]]  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-44' AND "push_type_nodes"."id" != '4c667f82-1b16-43e5-91e5-a4ce929337df' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t99a6c913dc2316448923a64e9c3bafe2  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-48' AND "push_type_nodes"."id" != 'fb83a911-9cd6-4bfa-9086-3986196e62ce' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) UPDATE "push_type_nodes" SET "sort_order" = $1, "updated_at" = $2 WHERE "push_type_nodes"."id" = 'fb83a911-9cd6-4bfa-9086-3986196e62ce' [["sort_order", 0], ["updated_at", "2015-01-02 20:44:39.657235"]]  (0.6ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL AND "push_type_nodes"."sort_order" >= 0 ) AS t WHERE "push_type_nodes"."id" = t.id  PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "4c667f82-1b16-43e5-91e5-a4ce929337df"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "4c667f82-1b16-43e5-91e5-a4ce929337df"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "fb83a911-9cd6-4bfa-9086-3986196e62ce"]] SQL (0.3ms) UPDATE "push_type_nodes" SET "sort_order" = 0 WHERE "push_type_nodes"."id" = '4c667f82-1b16-43e5-91e5-a4ce929337df' SQL (0.3ms) UPDATE "push_type_nodes" SET "sort_order" = 1 WHERE "push_type_nodes"."id" = 'fb83a911-9cd6-4bfa-9086-3986196e62ce'  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t00d2530407dd298841cee5ad8a192246 Completed 200 OK in 13ms (ActiveRecord: 4.1ms) Processing by PushType::NodesController#index as HTML  (0.5ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count  (0.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count PushType::Node Load (0.4ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 30 OFFSET 0  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "4c667f82-1b16-43e5-91e5-a4ce929337df"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "fb83a911-9cd6-4bfa-9086-3986196e62ce"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "dca4a5a5-7104-4723-8529-5ea7b8195215"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "94c9a395-f07b-4695-b450-83fd152d4230"]]  (0.2ms) SELECT "push_type_nodes"."id" FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "96a979c7-7d9a-4bf3-b241-8a02a917e607"]]  (0.3ms) SELECT COUNT(*) FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_new_node_button.html.haml (1.1ms) Completed 200 OK in 21ms (Views: 17.4ms | ActiveRecord: 2.4ms) PushType::Node Load (0.4ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" IS NULL AND "push_type_nodes"."deleted_at" IS NULL ORDER BY sort_order LIMIT 30 OFFSET 0  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------------------------------------------------------------------ PushType::AssetsController::PUT #update::with valid asset: test_0001_anonymous ------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:39.694400"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "10"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:39.694400"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::AssetsController#update as HTML Parameters: {"asset"=>{"description"=>"Foo bar baz"}, "id"=>"7e6db9b4-a93b-4215-b59b-401695a54890"} PushType::Asset Load (0.4ms) SELECT "push_type_assets".* FROM "push_type_assets" WHERE "push_type_assets"."id" = $1 ORDER BY "push_type_assets"."created_at" DESC LIMIT 1 [["id", "7e6db9b4-a93b-4215-b59b-401695a54890"]]  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) UPDATE "push_type_assets" SET "description" = $1, "updated_at" = $2 WHERE "push_type_assets"."id" = '7e6db9b4-a93b-4215-b59b-401695a54890' [["description", "Foo bar baz"], ["updated_at", "2015-01-02 20:44:39.701926"]]  (0.2ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/media Completed 302 Found in 6ms (ActiveRecord: 1.0ms)  (0.3ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN ------------------------------------------------------------------------------ PushType::AssetsController::PUT #update::with valid asset: test_0002_anonymous ------------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:39.710817"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "11"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:39.710817"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::AssetsController#update as HTML Parameters: {"asset"=>{"description"=>"Foo bar baz"}, "id"=>"27c3d636-fa40-4736-a335-899fe9dd2654"} PushType::Asset Load (0.2ms) SELECT "push_type_assets".* FROM "push_type_assets" WHERE "push_type_assets"."id" = $1 ORDER BY "push_type_assets"."created_at" DESC LIMIT 1 [["id", "27c3d636-fa40-4736-a335-899fe9dd2654"]]  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) UPDATE "push_type_assets" SET "description" = $1, "updated_at" = $2 WHERE "push_type_assets"."id" = '27c3d636-fa40-4736-a335-899fe9dd2654' [["description", "Foo bar baz"], ["updated_at", "2015-01-02 20:44:39.716660"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/media Completed 302 Found in 4ms (ActiveRecord: 0.8ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.2ms) BEGIN ------------------------------------------------------------------------------ PushType::AssetsController::PUT #update::with valid asset: test_0003_anonymous ------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:39.724724"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "12"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:39.724724"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::AssetsController#update as HTML Parameters: {"asset"=>{"description"=>"Foo bar baz"}, "id"=>"c753874b-5c33-46f8-b3d5-aa63f487f982"} PushType::Asset Load (0.2ms) SELECT "push_type_assets".* FROM "push_type_assets" WHERE "push_type_assets"."id" = $1 ORDER BY "push_type_assets"."created_at" DESC LIMIT 1 [["id", "c753874b-5c33-46f8-b3d5-aa63f487f982"]]  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) UPDATE "push_type_assets" SET "description" = $1, "updated_at" = $2 WHERE "push_type_assets"."id" = 'c753874b-5c33-46f8-b3d5-aa63f487f982' [["description", "Foo bar baz"], ["updated_at", "2015-01-02 20:44:39.729585"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/media Completed 302 Found in 4ms (ActiveRecord: 0.8ms) PushType::Asset Load (0.7ms) SELECT "push_type_assets".* FROM "push_type_assets" WHERE "push_type_assets"."id" = $1 LIMIT 1 [["id", "c753874b-5c33-46f8-b3d5-aa63f487f982"]]  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN -------------------------------------------------------- PushType::NodesController::GET #new: test_0001_anonymous --------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::NodesController#new as HTML Parameters: {"kind"=>"page"} Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_meta_table.html.haml (0.3ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_form_fields.html.haml (11.6ms) Completed 200 OK in 17ms (Views: 15.2ms | ActiveRecord: 0.0ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.2ms) BEGIN -------------------------------------------------------- PushType::NodesController::GET #new: test_0002_anonymous --------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.2ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_1 Processing by PushType::NodesController#new as HTML Parameters: {"kind"=>"page"} Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_meta_table.html.haml (0.3ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_form_fields.html.haml (15.0ms) Completed 200 OK in 25ms (Views: 22.2ms | ActiveRecord: 0.0ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN -------------------------------------------------------- PushType::NodesController::GET #new: test_0003_anonymous --------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.2ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_1 Processing by PushType::NodesController#new as HTML Parameters: {"kind"=>"page"} Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_meta_table.html.haml (0.1ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_form_fields.html.haml (11.7ms) Completed 200 OK in 18ms (Views: 15.8ms | ActiveRecord: 0.0ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.2ms) BEGIN ---------------------------------------------------------------------------------- PushType::AssetsController::POST #create::with in-valid asset: test_0001_anonymous ----------------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.2ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_1 Processing by PushType::AssetsController#create as HTML Parameters: {"asset"=>{}}  (0.2ms) SAVEPOINT active_record_2  (0.1ms) ROLLBACK TO SAVEPOINT active_record_2 Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/assets/_form.html.haml (3.4ms) Completed 200 OK in 10ms (Views: 6.4ms | ActiveRecord: 0.4ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ---------------------------------------------------------------------------------- PushType::AssetsController::POST #create::with in-valid asset: test_0002_anonymous ----------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::AssetsController#create as HTML Parameters: {"asset"=>{}}  (0.1ms) SAVEPOINT active_record_2  (0.1ms) ROLLBACK TO SAVEPOINT active_record_2 Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/assets/_form.html.haml (3.6ms) Completed 200 OK in 9ms (Views: 6.4ms | ActiveRecord: 0.3ms)  (0.3ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN -------------------------------------------------------------------------- PushType::AssetsHelper::#asset_icon::with audio asset: test_0001_anonymous --------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 SQL (0.4ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:39.847083"], ["file_ext", "m3u"], ["file_name", "audio.m3u"], ["file_size", 64], ["file_uid", "13"], ["mime_type", "audio/x-mpegurl"], ["updated_at", "2015-01-02 20:44:39.847083"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN --------------------------------------------------------- PushType::UsersController::GET #edit: test_0001_anonymous ---------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_1  (0.2ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-22@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:39.856250"], ["email", "joe-22@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:39.856250"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::UsersController#edit as HTML Parameters: {"id"=>"10bde4af-147b-4a40-8170-2fb5f957ba2d"} PushType::User Load (0.2ms) SELECT "push_type_users".* FROM "push_type_users" WHERE "push_type_users"."id" = $1 ORDER BY "push_type_users"."name" ASC LIMIT 1 [["id", "10bde4af-147b-4a40-8170-2fb5f957ba2d"]] Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_meta_table.html.haml (0.1ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_form.html.haml (2.7ms) Completed 200 OK in 7ms (Views: 5.6ms | ActiveRecord: 0.2ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.2ms) BEGIN --------------------------------------------------------- PushType::UsersController::GET #edit: test_0002_anonymous ---------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::User Exists (0.3ms) SELECT 1 AS one FROM "push_type_users" WHERE "push_type_users"."email" = 'joe-23@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_users" ("created_at", "email", "name", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", "2015-01-02 20:44:39.870414"], ["email", "joe-23@example.com"], ["name", "Joe Bloggs"], ["updated_at", "2015-01-02 20:44:39.870414"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::UsersController#edit as HTML Parameters: {"id"=>"9e847742-a120-4218-835a-51aa56c60cb9"} PushType::User Load (0.2ms) SELECT "push_type_users".* FROM "push_type_users" WHERE "push_type_users"."id" = $1 ORDER BY "push_type_users"."name" ASC LIMIT 1 [["id", "9e847742-a120-4218-835a-51aa56c60cb9"]] Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_meta_table.html.haml (0.1ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/users/_form.html.haml (3.4ms) Completed 200 OK in 7ms (Views: 6.1ms | ActiveRecord: 0.2ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.2ms) BEGIN ----------------------------------------------------------------------------- PushType::NodesController::POST #create::with valid node: test_0001_anonymous -----------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::NodesController#create as HTML Parameters: {"kind"=>"page", "page"=>{"title"=>"Foo bar", "slug"=>"foo-bar-49"}}  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.4ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-49' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2015-01-02 20:44:39.902749"], ["slug", "foo-bar-49"], ["status", 0], ["title", "Foo bar"], ["type", "Page"], ["updated_at", "2015-01-02 20:44:39.902749"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS tf843bb155b657db0194145b44a594b99 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "09774cee-ea7d-4128-974a-7a0e1789f130"], ["descendant_id", "09774cee-ea7d-4128-974a-7a0e1789f130"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  Page Load (2.8ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "09774cee-ea7d-4128-974a-7a0e1789f130"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "09774cee-ea7d-4128-974a-7a0e1789f130"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS td5c129f4691a4b7d765e12703a5fea53  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/nodes Completed 302 Found in 23ms (ActiveRecord: 5.5ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------------------------------------------------- PushType::NodesController::POST #create::with valid node: test_0002_anonymous -----------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::NodesController#create as HTML Parameters: {"kind"=>"page", "page"=>{"title"=>"Foo bar", "slug"=>"foo-bar-50"}}  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-50' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2015-01-02 20:44:39.932022"], ["slug", "foo-bar-50"], ["status", 0], ["title", "Foo bar"], ["type", "Page"], ["updated_at", "2015-01-02 20:44:39.932022"]]  (0.3ms) SELECT pg_try_advisory_lock(1213021721,0) AS t6faff92c535150450b35cc721a5bbe61 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "5746f011-3c72-425c-a810-7c2ced7cd87c"], ["descendant_id", "5746f011-3c72-425c-a810-7c2ced7cd87c"], ["generations", 0]]  (0.5ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  Page Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "5746f011-3c72-425c-a810-7c2ced7cd87c"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "5746f011-3c72-425c-a810-7c2ced7cd87c"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t901f31e4b92bafda5ff5f2f47cea64ec  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/nodes Completed 302 Found in 13ms (ActiveRecord: 3.2ms)  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------------------------------------------------------------------- PushType::NodesController::PUT #update::with in-valid node: test_0001_anonymous -------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-51' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2015-01-02 20:44:39.955793"], ["slug", "foo-bar-51"], ["status", 0], ["title", "Foo bar"], ["type", "Page"], ["updated_at", "2015-01-02 20:44:39.955793"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t8d38a4d58a35f5e07495c0efe5596b09 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "5a0eb47e-2ef3-4011-973f-a201be52b96b"], ["descendant_id", "5a0eb47e-2ef3-4011-973f-a201be52b96b"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id  Page Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "5a0eb47e-2ef3-4011-973f-a201be52b96b"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "5a0eb47e-2ef3-4011-973f-a201be52b96b"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS te7a28c70ab2aa88c9ac8f128c7c63e20  (0.3ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#update as HTML Parameters: {"page"=>{"title"=>""}, "id"=>"5a0eb47e-2ef3-4011-973f-a201be52b96b"} PushType::Node Load (0.4ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "5a0eb47e-2ef3-4011-973f-a201be52b96b"]]  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.4ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-51' AND "push_type_nodes"."id" != '5a0eb47e-2ef3-4011-973f-a201be52b96b' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1  (0.1ms) ROLLBACK TO SAVEPOINT active_record_2 PushType::Node Load (0.7ms) SELECT "push_type_nodes".* FROM "push_type_nodes" INNER JOIN "push_type_node_hierarchies" ON "push_type_nodes"."id" = "push_type_node_hierarchies"."ancestor_id" WHERE "push_type_node_hierarchies"."descendant_id" = $1 AND ("push_type_nodes"."id" != '5a0eb47e-2ef3-4011-973f-a201be52b96b') ORDER BY "push_type_node_hierarchies".generations asc [["descendant_id", "5a0eb47e-2ef3-4011-973f-a201be52b96b"]] Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_meta_table.html.haml (0.2ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_form_fields.html.haml (13.1ms) Completed 200 OK in 32ms (Views: 21.1ms | ActiveRecord: 1.8ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------------------------------------------------------------------- PushType::NodesController::PUT #update::with in-valid node: test_0002_anonymous -------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.3ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-52' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2015-01-02 20:44:40.009134"], ["slug", "foo-bar-52"], ["status", 0], ["title", "Foo bar"], ["type", "Page"], ["updated_at", "2015-01-02 20:44:40.009134"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t2cddf366e6b853692db496caf9fd59b2 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "247c3955-e3ab-4b76-a40a-e22613e0111b"], ["descendant_id", "247c3955-e3ab-4b76-a40a-e22613e0111b"], ["generations", 0]]  (0.9ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id Page Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "247c3955-e3ab-4b76-a40a-e22613e0111b"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "247c3955-e3ab-4b76-a40a-e22613e0111b"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS t04becfe58a5ba575b4b3c8d59dfd96eb  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::NodesController#update as HTML Parameters: {"page"=>{"title"=>""}, "id"=>"247c3955-e3ab-4b76-a40a-e22613e0111b"} PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."id" = $1 LIMIT 1 [["id", "247c3955-e3ab-4b76-a40a-e22613e0111b"]]  (0.1ms) SAVEPOINT active_record_2 PushType::Node Exists (0.4ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-52' AND "push_type_nodes"."id" != '247c3955-e3ab-4b76-a40a-e22613e0111b' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1  (0.1ms) ROLLBACK TO SAVEPOINT active_record_2 PushType::Node Load (0.4ms) SELECT "push_type_nodes".* FROM "push_type_nodes" INNER JOIN "push_type_node_hierarchies" ON "push_type_nodes"."id" = "push_type_node_hierarchies"."ancestor_id" WHERE "push_type_node_hierarchies"."descendant_id" = $1 AND ("push_type_nodes"."id" != '247c3955-e3ab-4b76-a40a-e22613e0111b') ORDER BY "push_type_node_hierarchies".generations asc [["descendant_id", "247c3955-e3ab-4b76-a40a-e22613e0111b"]] Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_meta_table.html.haml (0.2ms) Rendered /Users/aaron/dev/push_type/admin/app/views/push_type/nodes/_form_fields.html.haml (13.6ms) Completed 200 OK in 26ms (Views: 20.4ms | ActiveRecord: 1.2ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.2ms) BEGIN ------------------------------------------------------------------------ PushType::NodesController::POST #create::node count: test_0001_anonymous ------------------------------------------------------------------------  (0.2ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.5ms) SELECT COUNT(*) FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') Processing by PushType::NodesController#create as HTML Parameters: {"kind"=>"page", "page"=>{"title"=>"Foo bar", "slug"=>"foo-bar-53"}}  (0.2ms) SAVEPOINT active_record_2 PushType::Node Exists (0.4ms) SELECT 1 AS one FROM "push_type_nodes" WHERE ("push_type_nodes"."slug" = 'foo-bar-53' AND "push_type_nodes"."parent_id" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "push_type_nodes" ("created_at", "slug", "status", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2015-01-02 20:44:40.059321"], ["slug", "foo-bar-53"], ["status", 0], ["title", "Foo bar"], ["type", "Page"], ["updated_at", "2015-01-02 20:44:40.059321"]]  (0.2ms) SELECT pg_try_advisory_lock(1213021721,0) AS t4dc2ef9d81561a2efa2c5ad46801b025 SQL (0.2ms) INSERT INTO "push_type_node_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", "0f9a1aa1-e727-475e-9417-df61be645258"], ["descendant_id", "0f9a1aa1-e727-475e-9417-df61be645258"], ["generations", 0]]  (0.4ms) UPDATE "push_type_nodes" SET "sort_order" = t.seq + -1 FROM ( SELECT "id" AS id, row_number() OVER(ORDER BY sort_order) AS seq FROM "push_type_nodes" WHERE "parent_id" IS NULL ) AS t WHERE "push_type_nodes"."id" = t.id Page Load (0.3ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page') AND "push_type_nodes"."id" = $1 LIMIT 1 [["id", "0f9a1aa1-e727-475e-9417-df61be645258"]] PushType::Node Load (0.2ms) SELECT "push_type_nodes".* FROM "push_type_nodes" WHERE "push_type_nodes"."parent_id" = $1 ORDER BY sort_order [["parent_id", "0f9a1aa1-e727-475e-9417-df61be645258"]]  (0.2ms) SELECT pg_advisory_unlock(1213021721,0) AS tec5204e27a67034cbbe8097541caa333  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/nodes Completed 302 Found in 13ms (ActiveRecord: 3.0ms)  (0.4ms) SELECT COUNT(*) FROM "push_type_nodes" WHERE "push_type_nodes"."type" IN ('Page')  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------------------------------------------------------------------- PushType::AssetsController::POST #create::with valid asset: test_0001_anonymous -------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::AssetsController#create as HTML Parameters: {"asset"=>{"file"=>#>}}  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:40.079283"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "14"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:40.079283"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/media Completed 302 Found in 6ms (ActiveRecord: 0.6ms)  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.1ms) BEGIN ------------------------------------------------------------------------------- PushType::AssetsController::POST #create::with valid asset: test_0002_anonymous -------------------------------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 Processing by PushType::AssetsController#create as HTML Parameters: {"asset"=>{"file"=>#>}}  (0.2ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:40.089020"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "15"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:40.089020"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Redirected to http://test.host/push_type/media Completed 302 Found in 4ms (ActiveRecord: 0.6ms)  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK  (0.2ms) BEGIN ----------------------------------------------------------- PushType::AssetsController::GET #index: test_0001_anonymous -----------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:40.097985"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "16"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:40.097985"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:40.102656"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "17"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:40.102656"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:40.106788"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "18"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:40.106788"]]  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:40.111143"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "19"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:40.111143"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:40.114774"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "20"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:40.114774"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::AssetsController#index as HTML  (0.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_assets" WHERE "push_type_assets"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count PushType::Asset Load (0.4ms) SELECT "push_type_assets".* FROM "push_type_assets" WHERE "push_type_assets"."deleted_at" IS NULL ORDER BY "push_type_assets"."created_at" DESC LIMIT 30 OFFSET 0  (0.4ms) SELECT COUNT(*) FROM "push_type_assets" WHERE "push_type_assets"."deleted_at" IS NULL Completed 200 OK in 20ms (Views: 17.8ms | ActiveRecord: 1.1ms)  (0.2ms) ROLLBACK TO SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN ----------------------------------------------------------- PushType::AssetsController::GET #index: test_0002_anonymous -----------------------------------------------------------  (0.1ms) SAVEPOINT active_record_1  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:40.142994"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "21"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:40.142994"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:40.146695"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "22"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:40.146695"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:40.150430"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "23"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:40.150430"]]  (0.1ms) RELEASE SAVEPOINT active_record_2  (0.2ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:40.154961"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "24"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:40.154961"]]  (0.2ms) RELEASE SAVEPOINT active_record_2  (0.1ms) SAVEPOINT active_record_2 SQL (0.3ms) INSERT INTO "push_type_assets" ("created_at", "file_ext", "file_name", "file_size", "file_uid", "mime_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["created_at", "2015-01-02 20:44:40.159038"], ["file_ext", "png"], ["file_name", "image.png"], ["file_size", 2643], ["file_uid", "25"], ["mime_type", "image/png"], ["updated_at", "2015-01-02 20:44:40.159038"]]  (0.1ms) RELEASE SAVEPOINT active_record_2 Processing by PushType::AssetsController#index as HTML  (0.6ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_assets" WHERE "push_type_assets"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count PushType::Asset Load (0.5ms) SELECT "push_type_assets".* FROM "push_type_assets" WHERE "push_type_assets"."deleted_at" IS NULL ORDER BY "push_type_assets"."created_at" DESC LIMIT 30 OFFSET 0  (0.4ms) SELECT COUNT(*) FROM "push_type_assets" WHERE "push_type_assets"."deleted_at" IS NULL Completed 200 OK in 15ms (Views: 12.8ms | ActiveRecord: 1.4ms)  (0.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "push_type_assets" WHERE "push_type_assets"."deleted_at" IS NULL LIMIT 30 OFFSET 0) subquery_for_count  (0.1ms) ROLLBACK TO SAVEPOINT active_record_1  (0.1ms) ROLLBACK