(1.8ms) SELECT sqlite_version(*)  (1.1ms) CREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)  (1.0ms) CREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC Migrating to SetUpTestTables (20210128155312) TRANSACTION (0.0ms) begin transaction  (0.3ms) CREATE TABLE "posts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "a" integer, "b" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)  (0.1ms) CREATE TABLE "comments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "content" varchar, "post_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)  (0.1ms) CREATE INDEX "index_comments_on_post_id" ON "comments" ("post_id")  (0.1ms) CREATE TABLE "notes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar, "post_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)  (0.1ms) CREATE INDEX "index_notes_on_post_id" ON "notes" ("post_id") ActiveRecord::SchemaMigration Create (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20210128155312"]] TRANSACTION (0.7ms) commit transaction Migrating to CreateSnapshotsTables (20210306100122) TRANSACTION (0.1ms) begin transaction  (0.3ms) CREATE TABLE "snapshots" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar NOT NULL, "item_id" integer NOT NULL, "identifier" varchar NOT NULL, "user_type" varchar, "user_id" integer, "metadata" text, "created_at" datetime NOT NULL)  (0.1ms) CREATE INDEX "index_snapshots_on_item" ON "snapshots" ("item_type", "item_id")  (0.1ms) CREATE INDEX "index_snapshots_on_identifier" ON "snapshots" ("identifier")  (0.1ms) CREATE INDEX "index_snapshots_on_user" ON "snapshots" ("user_type", "user_id")  (0.1ms) CREATE TABLE "snapshot_items" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "snapshot_id" integer NOT NULL, "item_type" varchar NOT NULL, "item_id" integer NOT NULL, "object" text NOT NULL, "created_at" datetime NOT NULL, "child_group_name" varchar)  (0.1ms) CREATE INDEX "index_snapshot_items_on_snapshot_id" ON "snapshot_items" ("snapshot_id")  (0.1ms) CREATE INDEX "index_snapshot_items_on_item" ON "snapshot_items" ("item_type", "item_id") ActiveRecord::SchemaMigration Create (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20210306100122"]] TRANSACTION (0.6ms) commit transaction ActiveRecord::InternalMetadata Load (0.1ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = ? LIMIT ? [["key", "environment"], ["LIMIT", 1]] TRANSACTION (0.0ms) begin transaction ActiveRecord::InternalMetadata Create (0.2ms) INSERT INTO "ar_internal_metadata" ("key", "value", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["key", "environment"], ["value", "test"], ["created_at", "2021-08-19 23:28:07.589659"], ["updated_at", "2021-08-19 23:28:07.589659"]] TRANSACTION (0.6ms) commit transaction  (0.7ms) DELETE FROM posts;  (0.1ms) UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'posts';  (0.7ms) DELETE FROM snapshots;  (0.1ms) UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'snapshots';  (0.7ms) DELETE FROM snapshot_items;  (0.1ms) UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'snapshot_items'; Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."a" = ? AND "posts"."b" = ? LIMIT ? [["a", 1], ["b", 3], ["LIMIT", 1]] TRANSACTION (0.1ms) begin transaction Post Create (0.3ms) INSERT INTO "posts" ("a", "b", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["a", 1], ["b", 3], ["created_at", "2021-08-19 23:28:07.601363"], ["updated_at", "2021-08-19 23:28:07.601363"]] TRANSACTION (0.7ms) commit transaction TRANSACTION (0.0ms) begin transaction ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "v1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.3ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "v1"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:28:07.616280"]] TRANSACTION (1.2ms) commit transaction Post Load (0.2ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.1ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.1ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]]  (0.0ms) SELECT sqlite_version(*) TRANSACTION (0.0ms) begin transaction ActiveSnapshot::SnapshotItem Create Many (0.3ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,1,'Post',1,'--- id: 1 a: 1 b: 3 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: &1 2021-08-19 23:28:07.601363000 Z zone: &2 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:07.601363000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: *1 zone: *2 time: 2021-08-19 23:28:07.601363000 Z ','2021-08-19 23:28:07.639023',NULL) TRANSACTION (0.8ms) commit transaction Post Update (0.8ms) UPDATE "posts" SET "a" = ?, "b" = ? WHERE "posts"."id" = ? [["a", 2], ["b", 4], ["id", 1]] TRANSACTION (0.0ms) begin transaction ActiveSnapshot::Snapshot Exists? (0.2ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "v2"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.3ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "v2"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:28:07.643299"]] TRANSACTION (0.5ms) commit transaction Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.1ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.1ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) begin transaction ActiveSnapshot::SnapshotItem Create Many (0.3ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,2,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: &1 2021-08-19 23:28:07.601363000 Z zone: &2 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:07.601363000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: *1 zone: *2 time: 2021-08-19 23:28:07.601363000 Z ','2021-08-19 23:28:07.646425',NULL) TRANSACTION (0.8ms) commit transaction TRANSACTION (0.1ms) begin transaction -------------------------------------------- ActiveSnapshotTest: test_exposes_main_module -------------------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ---------------------------------------- ActiveSnapshotTest: test_exposes_version ---------------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------------- ActiveSnapshotTest: test_snapshot_lifecycle ------------------------------------------- Post Load (0.1ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Create (0.2ms) INSERT INTO "comments" ("content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["content", "foo"], ["post_id", 1], ["created_at", "2021-08-19 23:28:07.688491"], ["updated_at", "2021-08-19 23:28:07.688491"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "snapshots"  (0.0ms) SELECT COUNT(*) FROM "snapshot_items" TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "snapshot-1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.2ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "snapshot-1"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:28:07.691182"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.1ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,3,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:07.601363000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:07.601363000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:07.601363000 Z zone: *1 time: 2021-08-19 23:28:07.601363000 Z ','2021-08-19 23:28:07.694320',NULL),(NULL,3,'Comment',1,'--- id: 1 content: foo post_id: 1 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:07.688491000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:07.688491000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:07.688491000 Z zone: *1 time: 2021-08-19 23:28:07.688491000 Z ','2021-08-19 23:28:07.694320','comments') TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT COUNT(*) FROM "snapshot_items"  (0.0ms) SELECT COUNT(*) FROM "snapshots" Post Update (0.1ms) UPDATE "posts" SET "updated_at" = ? WHERE "posts"."id" = ? [["updated_at", "2021-08-20 23:28:07.695499"], ["id", 1]] Post Update (0.0ms) UPDATE "posts" SET "updated_at" = ? WHERE "posts"."id" = ? [["updated_at", "2021-08-20 23:28:07.695924"], ["id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Destroy (0.1ms) DELETE FROM "comments" WHERE "comments"."id" = ? [["id", 1]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Create (0.1ms) INSERT INTO "comments" ("content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["content", "foo"], ["post_id", 1], ["created_at", "2021-08-19 23:28:07.696917"], ["updated_at", "2021-08-19 23:28:07.696917"]] TRANSACTION (0.1ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Create (0.1ms) INSERT INTO "comments" ("content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["content", "bar"], ["post_id", 1], ["created_at", "2021-08-19 23:28:07.697739"], ["updated_at", "2021-08-19 23:28:07.697739"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "snapshots"  (0.0ms) SELECT COUNT(*) FROM "snapshot_items" TRANSACTION (0.0ms) SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] ActiveSnapshot::SnapshotItem Load (0.1ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 3]] Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? [["id", 1]] Comment Load (0.1ms) SELECT "comments".* FROM "comments" WHERE "comments"."id" = ? [["id", 1]] Comment Destroy (0.1ms) DELETE FROM "comments" WHERE "comments"."id" = ? [["id", 2]] Comment Destroy (0.0ms) DELETE FROM "comments" WHERE "comments"."id" = ? [["id", 3]] Post Update (0.1ms) UPDATE "posts" SET "updated_at" = ? WHERE "posts"."id" = ? [["updated_at", "2021-08-19 23:28:07.601363"], ["id", 1]] Comment Create (0.1ms) INSERT INTO "comments" ("id", "content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["id", 1], ["content", "foo"], ["post_id", 1], ["created_at", "2021-08-19 23:28:07.688491"], ["updated_at", "2021-08-19 23:28:07.688491"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT COUNT(*) FROM "snapshot_items"  (0.1ms) SELECT COUNT(*) FROM "snapshots"  (0.1ms) SELECT COUNT(*) FROM "snapshots" WHERE "snapshots"."identifier" = ? [["identifier", "snapshot-1"]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]]  (0.1ms) SELECT COUNT(*) FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.3ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------- SnapshotTest: test_restore -------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] ActiveSnapshot::SnapshotItem Load (0.0ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? [["id", 1]] Post Update (0.2ms) UPDATE "posts" SET "a" = ?, "b" = ? WHERE "posts"."id" = ? [["a", 1], ["b", 3], ["id", 1]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.3ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------------- SnapshotTest: test_build_snapshot_item -------------------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] Post Load (0.1ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.1ms) begin transaction -------------------------------------- SnapshotTest: test_fetch_reified_items -------------------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Load (0.1ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------ SnapshotTest: test_validations ------------------------------ ActiveSnapshot::Snapshot Load (0.2ms) SELECT "snapshots".* FROM "snapshots" WHERE "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? ORDER BY "snapshots"."id" ASC LIMIT ? [["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" IS NULL AND "snapshots"."item_id" IS NULL AND "snapshots"."item_type" IS NULL LIMIT ? [["LIMIT", 1]] ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "v1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "random"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction --------------------------- SnapshotTest: test_metadata --------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------- SnapshotTest: test_relationships -------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------ SnapshotItemTest: test_relationships ------------------------------------ TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ---------------------------------- SnapshotItemTest: test_validations ---------------------------------- ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_id" IS NULL AND "snapshot_items"."snapshot_id" IS NULL AND "snapshot_items"."item_type" IS NULL LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_type" IS NULL AND "snapshot_items"."snapshot_id" IS NULL AND "snapshot_items"."item_id" IS NULL LIMIT ? [["LIMIT", 1]] ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" WHERE "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? ORDER BY "snapshots"."id" ASC LIMIT ? [["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_id" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_type" = ? LIMIT ? [["item_id", 1], ["snapshot_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_type" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_id" = ? LIMIT ? [["item_type", "Post"], ["snapshot_id", 1], ["item_id", 1], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_id" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_type" = ? LIMIT ? [["item_id", 1], ["snapshot_id", 1], ["item_type", "Foobar"], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_type" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_id" = ? LIMIT ? [["item_type", "Foobar"], ["snapshot_id", 1], ["item_id", 1], ["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ----------------------------- SnapshotItemTest: test_object ----------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Load (0.0ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------ SnapshotItemTest: test_restore_item! ------------------------------------ ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Load (0.0ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Post Update (0.2ms) UPDATE "posts" SET "a" = ?, "b" = ? WHERE "posts"."id" = ? [["a", 1], ["b", 3], ["id", 1]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.6ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------------------ SnapshotsConcernTest: test_has_snapshot_children ------------------------------------------------ TRANSACTION (0.1ms) rollback transaction TRANSACTION (0.0ms) begin transaction ---------------------------------------- SnapshotsConcernTest: test_relationships ---------------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------------- SnapshotsConcernTest: test_create_snapshot! ------------------------------------------- Post Load (0.1ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.1ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.3ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "foobar 1"], ["metadata", "---\n:foo: :bar\n"], ["created_at", "2021-08-19 23:28:07.754325"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.2ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,3,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:07.601363000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:07.601363000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:07.601363000 Z zone: *1 time: 2021-08-19 23:28:07.601363000 Z ','2021-08-19 23:28:07.757455',NULL) TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 2"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.1ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "foobar 2"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:28:07.759398"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.1ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,4,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:07.601363000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:07.601363000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:07.601363000 Z zone: *1 time: 2021-08-19 23:28:07.601363000 Z ','2021-08-19 23:28:07.762080',NULL) TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.1ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 3"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.1ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "foobar 3"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:28:07.764341"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.1ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,5,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:07.601363000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:07.601363000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:07.601363000 Z zone: *1 time: 2021-08-19 23:28:07.601363000 Z ','2021-08-19 23:28:07.767417',NULL) TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 3"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] TRANSACTION (0.0ms) ROLLBACK TO SAVEPOINT active_record_1 TRANSACTION (0.3ms) rollback transaction TRANSACTION (0.0ms) begin transaction ----------------------------------------------- InstallGeneratorTest: test_should_add_migration ----------------------------------------------- TRANSACTION (0.0ms) rollback transaction  (1.5ms) SELECT sqlite_version(*)  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC ActiveRecord::InternalMetadata Load (0.1ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = ? LIMIT ? [["key", "environment"], ["LIMIT", 1]]  (1.9ms) DELETE FROM posts;  (1.4ms) UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'posts';  (1.2ms) DELETE FROM snapshots;  (1.1ms) UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'snapshots';  (1.0ms) DELETE FROM snapshot_items;  (1.0ms) UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'snapshot_items'; Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."a" = ? AND "posts"."b" = ? LIMIT ? [["a", 1], ["b", 3], ["LIMIT", 1]] TRANSACTION (0.0ms) begin transaction Post Create (0.3ms) INSERT INTO "posts" ("a", "b", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["a", 1], ["b", 3], ["created_at", "2021-08-19 23:28:46.603059"], ["updated_at", "2021-08-19 23:28:46.603059"]] TRANSACTION (0.8ms) commit transaction TRANSACTION (0.0ms) begin transaction ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "v1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.3ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "v1"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:28:46.616208"]] TRANSACTION (0.8ms) commit transaction Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.1ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.1ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]]  (0.0ms) SELECT sqlite_version(*) TRANSACTION (0.0ms) begin transaction ActiveSnapshot::SnapshotItem Create Many (0.2ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,1,'Post',1,'--- id: 1 a: 1 b: 3 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: &1 2021-08-19 23:28:46.603059000 Z zone: &2 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:46.603059000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: *1 zone: *2 time: 2021-08-19 23:28:46.603059000 Z ','2021-08-19 23:28:46.631882',NULL) TRANSACTION (0.6ms) commit transaction Post Update (0.7ms) UPDATE "posts" SET "a" = ?, "b" = ? WHERE "posts"."id" = ? [["a", 2], ["b", 4], ["id", 1]] TRANSACTION (0.0ms) begin transaction ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "v2"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.3ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "v2"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:28:46.635496"]] TRANSACTION (0.6ms) commit transaction Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.1ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.1ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) begin transaction ActiveSnapshot::SnapshotItem Create Many (0.3ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,2,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: &1 2021-08-19 23:28:46.603059000 Z zone: &2 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:46.603059000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: *1 zone: *2 time: 2021-08-19 23:28:46.603059000 Z ','2021-08-19 23:28:46.638687',NULL) TRANSACTION (0.5ms) commit transaction TRANSACTION (0.0ms) begin transaction ---------------------------------------- ActiveSnapshotTest: test_exposes_version ---------------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------------- ActiveSnapshotTest: test_snapshot_lifecycle ------------------------------------------- Post Load (0.1ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Create (0.2ms) INSERT INTO "comments" ("content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["content", "foo"], ["post_id", 1], ["created_at", "2021-08-19 23:28:46.668148"], ["updated_at", "2021-08-19 23:28:46.668148"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "snapshots"  (0.0ms) SELECT COUNT(*) FROM "snapshot_items" TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "snapshot-1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.1ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "snapshot-1"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:28:46.670427"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.1ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,3,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:46.603059000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:46.603059000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:46.603059000 Z zone: *1 time: 2021-08-19 23:28:46.603059000 Z ','2021-08-19 23:28:46.672991',NULL),(NULL,3,'Comment',1,'--- id: 1 content: foo post_id: 1 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:46.668148000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:46.668148000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:46.668148000 Z zone: *1 time: 2021-08-19 23:28:46.668148000 Z ','2021-08-19 23:28:46.672991','comments') TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "snapshot_items"  (0.0ms) SELECT COUNT(*) FROM "snapshots" Post Update (0.1ms) UPDATE "posts" SET "updated_at" = ? WHERE "posts"."id" = ? [["updated_at", "2021-08-20 23:28:46.673978"], ["id", 1]] Post Update (0.0ms) UPDATE "posts" SET "updated_at" = ? WHERE "posts"."id" = ? [["updated_at", "2021-08-20 23:28:46.674338"], ["id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Destroy (0.0ms) DELETE FROM "comments" WHERE "comments"."id" = ? [["id", 1]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Create (0.1ms) INSERT INTO "comments" ("content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["content", "foo"], ["post_id", 1], ["created_at", "2021-08-19 23:28:46.675175"], ["updated_at", "2021-08-19 23:28:46.675175"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Create (0.1ms) INSERT INTO "comments" ("content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["content", "bar"], ["post_id", 1], ["created_at", "2021-08-19 23:28:46.675840"], ["updated_at", "2021-08-19 23:28:46.675840"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "snapshots"  (0.0ms) SELECT COUNT(*) FROM "snapshot_items" TRANSACTION (0.0ms) SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] ActiveSnapshot::SnapshotItem Load (0.1ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 3]] Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? [["id", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."id" = ? [["id", 1]] Comment Destroy (0.0ms) DELETE FROM "comments" WHERE "comments"."id" = ? [["id", 2]] Comment Destroy (0.0ms) DELETE FROM "comments" WHERE "comments"."id" = ? [["id", 3]] Post Update (0.0ms) UPDATE "posts" SET "updated_at" = ? WHERE "posts"."id" = ? [["updated_at", "2021-08-19 23:28:46.603059"], ["id", 1]] Comment Create (0.1ms) INSERT INTO "comments" ("id", "content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["id", 1], ["content", "foo"], ["post_id", 1], ["created_at", "2021-08-19 23:28:46.668148"], ["updated_at", "2021-08-19 23:28:46.668148"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "snapshot_items"  (0.1ms) SELECT COUNT(*) FROM "snapshots"  (0.1ms) SELECT COUNT(*) FROM "snapshots" WHERE "snapshots"."identifier" = ? [["identifier", "snapshot-1"]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]]  (0.1ms) SELECT COUNT(*) FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.2ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------------------- ActiveSnapshotTest: test_exposes_main_module -------------------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------------- SnapshotTest: test_fetch_reified_items -------------------------------------- ActiveSnapshot::Snapshot Load (0.2ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Load (0.1ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------- SnapshotTest: test_relationships -------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------ SnapshotTest: test_validations ------------------------------ ActiveSnapshot::Snapshot Load (0.2ms) SELECT "snapshots".* FROM "snapshots" WHERE "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? ORDER BY "snapshots"."id" ASC LIMIT ? [["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" IS NULL AND "snapshots"."item_id" IS NULL AND "snapshots"."item_type" IS NULL LIMIT ? [["LIMIT", 1]] ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "v1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "random"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction --------------------------- SnapshotTest: test_metadata --------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------- SnapshotTest: test_restore -------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] ActiveSnapshot::SnapshotItem Load (0.0ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? [["id", 1]] Post Update (0.3ms) UPDATE "posts" SET "a" = ?, "b" = ? WHERE "posts"."id" = ? [["a", 1], ["b", 3], ["id", 1]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.3ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------------- SnapshotTest: test_build_snapshot_item -------------------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ----------------------------------------------- InstallGeneratorTest: test_should_add_migration ----------------------------------------------- TRANSACTION (0.1ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------------------ SnapshotsConcernTest: test_has_snapshot_children ------------------------------------------------ TRANSACTION (0.1ms) rollback transaction TRANSACTION (0.0ms) begin transaction ---------------------------------------- SnapshotsConcernTest: test_relationships ---------------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------------- SnapshotsConcernTest: test_create_snapshot! ------------------------------------------- Post Load (0.1ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.3ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "foobar 1"], ["metadata", "---\n:foo: :bar\n"], ["created_at", "2021-08-19 23:28:46.720422"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.2ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,3,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:46.603059000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:46.603059000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:46.603059000 Z zone: *1 time: 2021-08-19 23:28:46.603059000 Z ','2021-08-19 23:28:46.723268',NULL) TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 2"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.1ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "foobar 2"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:28:46.725154"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.1ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,4,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:46.603059000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:46.603059000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:46.603059000 Z zone: *1 time: 2021-08-19 23:28:46.603059000 Z ','2021-08-19 23:28:46.727906',NULL) TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 3"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.1ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "foobar 3"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:28:46.729775"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.1ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,5,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:46.603059000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:28:46.603059000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:28:46.603059000 Z zone: *1 time: 2021-08-19 23:28:46.603059000 Z ','2021-08-19 23:28:46.732939',NULL) TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 3"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] TRANSACTION (0.1ms) ROLLBACK TO SAVEPOINT active_record_1 TRANSACTION (0.4ms) rollback transaction TRANSACTION (0.0ms) begin transaction ----------------------------- SnapshotItemTest: test_object ----------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Load (0.0ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ---------------------------------- SnapshotItemTest: test_validations ---------------------------------- ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_id" IS NULL AND "snapshot_items"."snapshot_id" IS NULL AND "snapshot_items"."item_type" IS NULL LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_type" IS NULL AND "snapshot_items"."snapshot_id" IS NULL AND "snapshot_items"."item_id" IS NULL LIMIT ? [["LIMIT", 1]] ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" WHERE "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? ORDER BY "snapshots"."id" ASC LIMIT ? [["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_id" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_type" = ? LIMIT ? [["item_id", 1], ["snapshot_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_type" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_id" = ? LIMIT ? [["item_type", "Post"], ["snapshot_id", 1], ["item_id", 1], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_id" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_type" = ? LIMIT ? [["item_id", 1], ["snapshot_id", 1], ["item_type", "Foobar"], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_type" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_id" = ? LIMIT ? [["item_type", "Foobar"], ["snapshot_id", 1], ["item_id", 1], ["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------ SnapshotItemTest: test_restore_item! ------------------------------------ ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Load (0.0ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] TRANSACTION (0.1ms) SAVEPOINT active_record_1 Post Update (0.3ms) UPDATE "posts" SET "a" = ?, "b" = ? WHERE "posts"."id" = ? [["a", 1], ["b", 3], ["id", 1]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.3ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------ SnapshotItemTest: test_relationships ------------------------------------ TRANSACTION (0.0ms) rollback transaction  (1.5ms) SELECT sqlite_version(*)  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC ActiveRecord::InternalMetadata Load (0.1ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = ? LIMIT ? [["key", "environment"], ["LIMIT", 1]]  (1.9ms) DELETE FROM posts;  (1.3ms) UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'posts';  (1.2ms) DELETE FROM snapshots;  (1.0ms) UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'snapshots';  (1.1ms) DELETE FROM snapshot_items;  (1.0ms) UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'snapshot_items'; Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."a" = ? AND "posts"."b" = ? LIMIT ? [["a", 1], ["b", 3], ["LIMIT", 1]] TRANSACTION (0.0ms) begin transaction Post Create (0.3ms) INSERT INTO "posts" ("a", "b", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["a", 1], ["b", 3], ["created_at", "2021-08-19 23:29:11.308109"], ["updated_at", "2021-08-19 23:29:11.308109"]] TRANSACTION (0.6ms) commit transaction TRANSACTION (0.0ms) begin transaction ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "v1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.2ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "v1"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:29:11.320795"]] TRANSACTION (0.6ms) commit transaction Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.1ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.1ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]]  (0.0ms) SELECT sqlite_version(*) TRANSACTION (0.0ms) begin transaction ActiveSnapshot::SnapshotItem Create Many (0.2ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,1,'Post',1,'--- id: 1 a: 1 b: 3 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: &1 2021-08-19 23:29:11.308109000 Z zone: &2 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:11.308109000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: *1 zone: *2 time: 2021-08-19 23:29:11.308109000 Z ','2021-08-19 23:29:11.336271',NULL) TRANSACTION (0.6ms) commit transaction Post Update (0.6ms) UPDATE "posts" SET "a" = ?, "b" = ? WHERE "posts"."id" = ? [["a", 2], ["b", 4], ["id", 1]] TRANSACTION (0.0ms) begin transaction ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "v2"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.2ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "v2"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:29:11.339527"]] TRANSACTION (0.5ms) commit transaction Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) begin transaction ActiveSnapshot::SnapshotItem Create Many (0.2ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,2,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: &1 2021-08-19 23:29:11.308109000 Z zone: &2 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:11.308109000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: *1 zone: *2 time: 2021-08-19 23:29:11.308109000 Z ','2021-08-19 23:29:11.342050',NULL) TRANSACTION (0.4ms) commit transaction TRANSACTION (0.0ms) begin transaction ------------------------------ SnapshotTest: test_validations ------------------------------ ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" WHERE "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? ORDER BY "snapshots"."id" ASC LIMIT ? [["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Exists? (0.0ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" IS NULL AND "snapshots"."item_id" IS NULL AND "snapshots"."item_type" IS NULL LIMIT ? [["LIMIT", 1]] ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "v1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "random"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction --------------------------- SnapshotTest: test_metadata --------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------- SnapshotTest: test_relationships -------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------- SnapshotTest: test_restore -------------------------- ActiveSnapshot::Snapshot Load (0.0ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] ActiveSnapshot::SnapshotItem Load (0.1ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? [["id", 1]] Post Update (0.2ms) UPDATE "posts" SET "a" = ?, "b" = ? WHERE "posts"."id" = ? [["a", 1], ["b", 3], ["id", 1]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.2ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------------- SnapshotTest: test_fetch_reified_items -------------------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Load (0.0ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------------- SnapshotTest: test_build_snapshot_item -------------------------------------- ActiveSnapshot::Snapshot Load (0.0ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] Post Load (0.1ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------------- ActiveSnapshotTest: test_snapshot_lifecycle ------------------------------------------- Post Load (0.0ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Create (0.2ms) INSERT INTO "comments" ("content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["content", "foo"], ["post_id", 1], ["created_at", "2021-08-19 23:29:11.384159"], ["updated_at", "2021-08-19 23:29:11.384159"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "snapshots"  (0.0ms) SELECT COUNT(*) FROM "snapshot_items" TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "snapshot-1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.1ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "snapshot-1"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:29:11.386301"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.1ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,3,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:11.308109000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:11.308109000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:11.308109000 Z zone: *1 time: 2021-08-19 23:29:11.308109000 Z ','2021-08-19 23:29:11.389012',NULL),(NULL,3,'Comment',1,'--- id: 1 content: foo post_id: 1 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:11.384159000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:11.384159000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:11.384159000 Z zone: *1 time: 2021-08-19 23:29:11.384159000 Z ','2021-08-19 23:29:11.389012','comments') TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "snapshot_items"  (0.0ms) SELECT COUNT(*) FROM "snapshots" Post Update (0.1ms) UPDATE "posts" SET "updated_at" = ? WHERE "posts"."id" = ? [["updated_at", "2021-08-20 23:29:11.390035"], ["id", 1]] Post Update (0.0ms) UPDATE "posts" SET "updated_at" = ? WHERE "posts"."id" = ? [["updated_at", "2021-08-20 23:29:11.390390"], ["id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Destroy (0.0ms) DELETE FROM "comments" WHERE "comments"."id" = ? [["id", 1]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Create (0.1ms) INSERT INTO "comments" ("content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["content", "foo"], ["post_id", 1], ["created_at", "2021-08-19 23:29:11.391260"], ["updated_at", "2021-08-19 23:29:11.391260"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Create (0.0ms) INSERT INTO "comments" ("content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["content", "bar"], ["post_id", 1], ["created_at", "2021-08-19 23:29:11.391968"], ["updated_at", "2021-08-19 23:29:11.391968"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "snapshots"  (0.0ms) SELECT COUNT(*) FROM "snapshot_items" TRANSACTION (0.0ms) SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] ActiveSnapshot::SnapshotItem Load (0.0ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 3]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? [["id", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."id" = ? [["id", 1]] Comment Destroy (0.0ms) DELETE FROM "comments" WHERE "comments"."id" = ? [["id", 2]] Comment Destroy (0.0ms) DELETE FROM "comments" WHERE "comments"."id" = ? [["id", 3]] Post Update (0.0ms) UPDATE "posts" SET "updated_at" = ? WHERE "posts"."id" = ? [["updated_at", "2021-08-19 23:29:11.308109"], ["id", 1]] Comment Create (0.1ms) INSERT INTO "comments" ("id", "content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["id", 1], ["content", "foo"], ["post_id", 1], ["created_at", "2021-08-19 23:29:11.384159"], ["updated_at", "2021-08-19 23:29:11.384159"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "snapshot_items"  (0.0ms) SELECT COUNT(*) FROM "snapshots"  (0.1ms) SELECT COUNT(*) FROM "snapshots" WHERE "snapshots"."identifier" = ? [["identifier", "snapshot-1"]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]]  (0.0ms) SELECT COUNT(*) FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.3ms) rollback transaction TRANSACTION (0.0ms) begin transaction ---------------------------------------- ActiveSnapshotTest: test_exposes_version ---------------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------------------- ActiveSnapshotTest: test_exposes_main_module -------------------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------ SnapshotItemTest: test_relationships ------------------------------------ TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------ SnapshotItemTest: test_restore_item! ------------------------------------ ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Load (0.0ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Post Update (0.2ms) UPDATE "posts" SET "a" = ?, "b" = ? WHERE "posts"."id" = ? [["a", 1], ["b", 3], ["id", 1]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.2ms) rollback transaction TRANSACTION (0.0ms) begin transaction ---------------------------------- SnapshotItemTest: test_validations ---------------------------------- ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_id" IS NULL AND "snapshot_items"."snapshot_id" IS NULL AND "snapshot_items"."item_type" IS NULL LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_type" IS NULL AND "snapshot_items"."snapshot_id" IS NULL AND "snapshot_items"."item_id" IS NULL LIMIT ? [["LIMIT", 1]] ActiveSnapshot::Snapshot Load (0.0ms) SELECT "snapshots".* FROM "snapshots" WHERE "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? ORDER BY "snapshots"."id" ASC LIMIT ? [["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_id" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_type" = ? LIMIT ? [["item_id", 1], ["snapshot_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_type" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_id" = ? LIMIT ? [["item_type", "Post"], ["snapshot_id", 1], ["item_id", 1], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_id" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_type" = ? LIMIT ? [["item_id", 1], ["snapshot_id", 1], ["item_type", "Foobar"], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_type" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_id" = ? LIMIT ? [["item_type", "Foobar"], ["snapshot_id", 1], ["item_id", 1], ["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ----------------------------- SnapshotItemTest: test_object ----------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Load (0.0ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------------- SnapshotsConcernTest: test_create_snapshot! ------------------------------------------- Post Load (0.0ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.3ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "foobar 1"], ["metadata", "---\n:foo: :bar\n"], ["created_at", "2021-08-19 23:29:11.411538"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.1ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,3,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:11.308109000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:11.308109000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:11.308109000 Z zone: *1 time: 2021-08-19 23:29:11.308109000 Z ','2021-08-19 23:29:11.413742',NULL) TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 2"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.1ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "foobar 2"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:29:11.415146"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.1ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,4,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:11.308109000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:11.308109000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:11.308109000 Z zone: *1 time: 2021-08-19 23:29:11.308109000 Z ','2021-08-19 23:29:11.417040',NULL) TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 3"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.1ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "foobar 3"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:29:11.418345"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.1ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,5,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:11.308109000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:11.308109000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:11.308109000 Z zone: *1 time: 2021-08-19 23:29:11.308109000 Z ','2021-08-19 23:29:11.420235',NULL) TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 3"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] TRANSACTION (0.1ms) ROLLBACK TO SAVEPOINT active_record_1 TRANSACTION (0.3ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------------------ SnapshotsConcernTest: test_has_snapshot_children ------------------------------------------------ Post Load (0.2ms) SELECT "posts".* FROM "posts" LIMIT ? [["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ---------------------------------------- SnapshotsConcernTest: test_relationships ---------------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ----------------------------------------------- InstallGeneratorTest: test_should_add_migration ----------------------------------------------- TRANSACTION (0.1ms) rollback transaction  (1.4ms) SELECT sqlite_version(*)  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC ActiveRecord::InternalMetadata Load (0.1ms) SELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = ? LIMIT ? [["key", "environment"], ["LIMIT", 1]]  (1.8ms) DELETE FROM posts;  (1.2ms) UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'posts';  (1.1ms) DELETE FROM snapshots;  (0.9ms) UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'snapshots';  (0.9ms) DELETE FROM snapshot_items;  (0.9ms) UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'snapshot_items'; Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."a" = ? AND "posts"."b" = ? LIMIT ? [["a", 1], ["b", 3], ["LIMIT", 1]] TRANSACTION (0.0ms) begin transaction Post Create (0.3ms) INSERT INTO "posts" ("a", "b", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["a", 1], ["b", 3], ["created_at", "2021-08-19 23:29:21.079132"], ["updated_at", "2021-08-19 23:29:21.079132"]] TRANSACTION (0.8ms) commit transaction TRANSACTION (0.0ms) begin transaction ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "v1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.3ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "v1"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:29:21.092194"]] TRANSACTION (0.8ms) commit transaction Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.1ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.1ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]]  (0.0ms) SELECT sqlite_version(*) TRANSACTION (0.0ms) begin transaction ActiveSnapshot::SnapshotItem Create Many (0.2ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,1,'Post',1,'--- id: 1 a: 1 b: 3 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: &1 2021-08-19 23:29:21.079132000 Z zone: &2 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:21.079132000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: *1 zone: *2 time: 2021-08-19 23:29:21.079132000 Z ','2021-08-19 23:29:21.107905',NULL) TRANSACTION (1.0ms) commit transaction Post Update (1.0ms) UPDATE "posts" SET "a" = ?, "b" = ? WHERE "posts"."id" = ? [["a", 2], ["b", 4], ["id", 1]] TRANSACTION (0.0ms) begin transaction ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "v2"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.4ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "v2"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:29:21.113375"]] TRANSACTION (0.8ms) commit transaction Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.1ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.1ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) begin transaction ActiveSnapshot::SnapshotItem Create Many (0.3ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,2,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: &1 2021-08-19 23:29:21.079132000 Z zone: &2 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:21.079132000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: *1 zone: *2 time: 2021-08-19 23:29:21.079132000 Z ','2021-08-19 23:29:21.117615',NULL) TRANSACTION (0.6ms) commit transaction TRANSACTION (0.0ms) begin transaction ---------------------------------------- ActiveSnapshotTest: test_exposes_version ---------------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------------- ActiveSnapshotTest: test_snapshot_lifecycle ------------------------------------------- Post Load (0.1ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Create (0.2ms) INSERT INTO "comments" ("content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["content", "foo"], ["post_id", 1], ["created_at", "2021-08-19 23:29:21.148886"], ["updated_at", "2021-08-19 23:29:21.148886"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "snapshots"  (0.0ms) SELECT COUNT(*) FROM "snapshot_items" TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "snapshot-1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.1ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "snapshot-1"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:29:21.151063"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.1ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,3,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:21.079132000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:21.079132000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:21.079132000 Z zone: *1 time: 2021-08-19 23:29:21.079132000 Z ','2021-08-19 23:29:21.153591',NULL),(NULL,3,'Comment',1,'--- id: 1 content: foo post_id: 1 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:21.148886000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:21.148886000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:21.148886000 Z zone: *1 time: 2021-08-19 23:29:21.148886000 Z ','2021-08-19 23:29:21.153591','comments') TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "snapshot_items"  (0.0ms) SELECT COUNT(*) FROM "snapshots" Post Update (0.1ms) UPDATE "posts" SET "updated_at" = ? WHERE "posts"."id" = ? [["updated_at", "2021-08-20 23:29:21.154558"], ["id", 1]] Post Update (0.0ms) UPDATE "posts" SET "updated_at" = ? WHERE "posts"."id" = ? [["updated_at", "2021-08-20 23:29:21.154916"], ["id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Destroy (0.0ms) DELETE FROM "comments" WHERE "comments"."id" = ? [["id", 1]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Create (0.1ms) INSERT INTO "comments" ("content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["content", "foo"], ["post_id", 1], ["created_at", "2021-08-19 23:29:21.155758"], ["updated_at", "2021-08-19 23:29:21.155758"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 Comment Create (0.0ms) INSERT INTO "comments" ("content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["content", "bar"], ["post_id", 1], ["created_at", "2021-08-19 23:29:21.156425"], ["updated_at", "2021-08-19 23:29:21.156425"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SELECT COUNT(*) FROM "snapshots"  (0.0ms) SELECT COUNT(*) FROM "snapshot_items" TRANSACTION (0.0ms) SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] ActiveSnapshot::SnapshotItem Load (0.1ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 3]] Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? [["id", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."id" = ? [["id", 1]] Comment Destroy (0.0ms) DELETE FROM "comments" WHERE "comments"."id" = ? [["id", 2]] Comment Destroy (0.0ms) DELETE FROM "comments" WHERE "comments"."id" = ? [["id", 3]] Post Update (0.1ms) UPDATE "posts" SET "updated_at" = ? WHERE "posts"."id" = ? [["updated_at", "2021-08-19 23:29:21.079132"], ["id", 1]] Comment Create (0.1ms) INSERT INTO "comments" ("id", "content", "post_id", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["id", 1], ["content", "foo"], ["post_id", 1], ["created_at", "2021-08-19 23:29:21.148886"], ["updated_at", "2021-08-19 23:29:21.148886"]] TRANSACTION (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SELECT COUNT(*) FROM "snapshot_items"  (0.0ms) SELECT COUNT(*) FROM "snapshots"  (0.1ms) SELECT COUNT(*) FROM "snapshots" WHERE "snapshots"."identifier" = ? [["identifier", "snapshot-1"]] Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.1ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]]  (0.1ms) SELECT COUNT(*) FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.3ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------------------- ActiveSnapshotTest: test_exposes_main_module -------------------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------------------ SnapshotsConcernTest: test_has_snapshot_children ------------------------------------------------ Post Load (0.2ms) SELECT "posts".* FROM "posts" LIMIT ? [["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------------- SnapshotsConcernTest: test_create_snapshot! ------------------------------------------- Post Load (0.1ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.3ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "foobar 1"], ["metadata", "---\n:foo: :bar\n"], ["created_at", "2021-08-19 23:29:21.176506"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.1ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.1ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.2ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,3,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:21.079132000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:21.079132000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:21.079132000 Z zone: *1 time: 2021-08-19 23:29:21.079132000 Z ','2021-08-19 23:29:21.179444',NULL) TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.1ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 2"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.1ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "foobar 2"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:29:21.182276"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.1ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,4,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:21.079132000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:21.079132000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:21.079132000 Z zone: *1 time: 2021-08-19 23:29:21.079132000 Z ','2021-08-19 23:29:21.185087',NULL) TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 3"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Create (0.1ms) INSERT INTO "snapshots" ("item_type", "item_id", "identifier", "metadata", "created_at") VALUES (?, ?, ?, ?, ?) [["item_type", "Post"], ["item_id", 1], ["identifier", "foobar 3"], ["metadata", "--- {}\n"], ["created_at", "2021-08-19 23:29:21.186765"]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 Post Load (0.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.0ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::SnapshotItem Create Many (0.1ms) INSERT INTO "snapshot_items" ("id","snapshot_id","item_type","item_id","object","created_at","child_group_name") VALUES (NULL,5,'Post',1,'--- id: 1 a: 2 b: 4 created_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:21.079132000 Z zone: &1 !ruby/object:ActiveSupport::TimeZone name: Etc/UTC time: 2021-08-19 23:29:21.079132000 Z updated_at: !ruby/object:ActiveSupport::TimeWithZone utc: 2021-08-19 23:29:21.079132000 Z zone: *1 time: 2021-08-19 23:29:21.079132000 Z ','2021-08-19 23:29:21.189732',NULL) TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.0ms) SAVEPOINT active_record_1 ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "foobar 3"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] TRANSACTION (0.0ms) ROLLBACK TO SAVEPOINT active_record_1 TRANSACTION (0.3ms) rollback transaction TRANSACTION (0.0ms) begin transaction ---------------------------------------- SnapshotsConcernTest: test_relationships ---------------------------------------- TRANSACTION (0.1ms) rollback transaction TRANSACTION (0.1ms) begin transaction ----------------------------------------------- InstallGeneratorTest: test_should_add_migration ----------------------------------------------- TRANSACTION (0.1ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------------- SnapshotTest: test_fetch_reified_items -------------------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Load (0.0ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------- SnapshotTest: test_relationships -------------------------------- TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------------------- SnapshotTest: test_build_snapshot_item -------------------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" ORDER BY "posts"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction -------------------------- SnapshotTest: test_restore -------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) SAVEPOINT active_record_1 Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] Comment Load (0.0ms) SELECT "comments".* FROM "comments" WHERE "comments"."post_id" = ? [["post_id", 1]] Note Load (0.1ms) SELECT "notes".* FROM "notes" WHERE "notes"."post_id" = ? [["post_id", 1]] ActiveSnapshot::SnapshotItem Load (0.0ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? [["id", 1]] Post Update (0.3ms) UPDATE "posts" SET "a" = ?, "b" = ? WHERE "posts"."id" = ? [["a", 1], ["b", 3], ["id", 1]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.2ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------ SnapshotTest: test_validations ------------------------------ ActiveSnapshot::Snapshot Load (0.2ms) SELECT "snapshots".* FROM "snapshots" WHERE "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? ORDER BY "snapshots"."id" ASC LIMIT ? [["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" IS NULL AND "snapshots"."item_id" IS NULL AND "snapshots"."item_type" IS NULL LIMIT ? [["LIMIT", 1]] ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "v1"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::Snapshot Exists? (0.1ms) SELECT 1 AS one FROM "snapshots" WHERE "snapshots"."identifier" = ? AND "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? LIMIT ? [["identifier", "random"], ["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction --------------------------- SnapshotTest: test_metadata --------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ----------------------------- SnapshotItemTest: test_object ----------------------------- ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Load (0.1ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ---------------------------------- SnapshotItemTest: test_validations ---------------------------------- ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_id" IS NULL AND "snapshot_items"."snapshot_id" IS NULL AND "snapshot_items"."item_type" IS NULL LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_type" IS NULL AND "snapshot_items"."snapshot_id" IS NULL AND "snapshot_items"."item_id" IS NULL LIMIT ? [["LIMIT", 1]] ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" WHERE "snapshots"."item_id" = ? AND "snapshots"."item_type" = ? ORDER BY "snapshots"."id" ASC LIMIT ? [["item_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_id" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_type" = ? LIMIT ? [["item_id", 1], ["snapshot_id", 1], ["item_type", "Post"], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_type" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_id" = ? LIMIT ? [["item_type", "Post"], ["snapshot_id", 1], ["item_id", 1], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_id" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_type" = ? LIMIT ? [["item_id", 1], ["snapshot_id", 1], ["item_type", "Foobar"], ["LIMIT", 1]] ActiveSnapshot::SnapshotItem Exists? (0.1ms) SELECT 1 AS one FROM "snapshot_items" WHERE "snapshot_items"."item_type" = ? AND "snapshot_items"."snapshot_id" = ? AND "snapshot_items"."item_id" = ? LIMIT ? [["item_type", "Foobar"], ["snapshot_id", 1], ["item_id", 1], ["LIMIT", 1]] TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------ SnapshotItemTest: test_relationships ------------------------------------ TRANSACTION (0.0ms) rollback transaction TRANSACTION (0.0ms) begin transaction ------------------------------------ SnapshotItemTest: test_restore_item! ------------------------------------ ActiveSnapshot::Snapshot Load (0.1ms) SELECT "snapshots".* FROM "snapshots" ORDER BY "snapshots"."id" ASC LIMIT ? [["LIMIT", 1]] ActiveSnapshot::SnapshotItem Load (0.0ms) SELECT "snapshot_items".* FROM "snapshot_items" WHERE "snapshot_items"."snapshot_id" = ? [["snapshot_id", 1]] Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] TRANSACTION (0.1ms) SAVEPOINT active_record_1 Post Update (0.2ms) UPDATE "posts" SET "a" = ?, "b" = ? WHERE "posts"."id" = ? [["a", 1], ["b", 3], ["id", 1]] TRANSACTION (0.0ms) RELEASE SAVEPOINT active_record_1 TRANSACTION (0.2ms) rollback transaction