test/dummy/db/test.sqlite3 in shipit-engine-0.22.0 vs test/dummy/db/test.sqlite3 in shipit-engine-0.23.0

- old
+ new

@@ -1,68 +1,69 @@ -SQLite format 3@ =?7=. (8 +SQLite format 3@ [?7[. 8 q*#iaY!Cindexindex_deliveries_on_hook_id_and_statusdeliveriesCREATE INDEX "index_deliveries_on_hook_id_and_status" ON "deliveries" ("hook_id", "status")5m!iindexindex_deliveries_on_hook_id_and_event_and_statusdeliveriesCREATE INDEX "index_deliveries_on_hook_id_and_event_and_status" ON "deliveries" ("hook_id", "event", "status")s!!1tabledeliveriesdeliveriesCREATE TABLE "deliveries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "hook_id" integer(4) NOT NULL, "status" varchar(50) DEFAULT 'pending' NOT NULL, "url" varchar(4096) NOT NULL, "content_type" varchar(255) NOT NULL, "event" varchar(50) NOT NULL, "payload" text(16777215) NOT NULL, "response_code" integer(4), "response_headers" text(65535), "response_body" text(65535), "delivered_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)o?indexindex_commits_on_stack_idcommitsCREATE INDEX "index_commits_on_stack_id" ON "commits" ("stack_id") O=indexindex_commits_on_sha_and_stack_idcommitsCREATE UNIQUE INDEX "index_commits_on_sha_and_stack_id" ON "commits" ("sha", "stack_id")u Cindexindex_commits_on_created_atcommits CREATE INDEX "index_commits_on_created_at" ON "commits" ("created_at"){ G!indexindex_commits_on_committer_idcommits CREATE INDEX "index_commits_on_committer_id" ON "commits" ("committer_id")r Aindexindex_commits_on_author_idcommits CREATE INDEX "index_commits_on_author_id" ON "commits" ("author_id")S }tablecommitscommits CREATE TABLE "commits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4) NOT NULL, "author_id" integer(4) NOT NULL, "committer_id" integer(4) NOT NULL, "sha" varchar(40) NOT NULL, "message" text(65535) NOT NULL, "created_at" datetime, "updated_at" datetime, "detached" boolean DEFAULT 'f' NOT NULL, "authored_at" datetime NOT NULL, "committed_at" datetime NOT NULL, "additions" integer(4), "deletions" integer(4), "pull_request_number" integer, "pull_request_title" varchar(1024), "pull_request_id" integer, "locked" boolean DEFAULT 'f' NOT NULL)S19indexindex_commit_deployments_on_task_idcommit_deployments CREATE INDEX "index_commit_deployments_on_task_id" ON "commit_deployments" ("task_id")Ho1}indexindex_commit_deployments_on_commit_id_and_task_idcommit_deploymentsCREATE UNIQUE INDEX "index_commit_deployments_on_commit_id_and_task_id" ON "commit_deployments" ("commit_id", "task_id")11Stablecommit_deploymentscommit_deploymentsCREATE TABLE "commit_deployments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commit_id" integer, "task_id" integer, "github_id" integer, "api_url" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)_}A indexindex_commit_deployment_statuses_on_commit_deployment_idcommit_deployment_statusesCREATE INDEX "index_commit_deployment_statuses_on_commit_deployment_id" ON "commit_deployment_statuses" ("commit_deployment_id")6AAwtablecommit_deployment_statusescommit_deployment_statusesCREATE TABLE "commit_deployment_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commit_deployment_id" integer, "status" varchar, "github_id" integer, "api_url" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)K#)indexindex_api_clients_on_creator_idapi_clientsCREATE INDEX "index_api_clients_on_creator_id" ON "api_clients" ("creator_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)##{tableapi_clientsapi_clientsCREATE TABLE "api_clients" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permissions" text(65535), "creator_id" integer(4), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(255) DEFAULT '', "stack_(( aiǭG/AA5--- - read:stack ->v2018-04-26 13:47:49.9267972018-04-26 13:47:49.926797Here Come The Walrus$WSw 5AA--- +>v2018-06-12 09:20:45.9029212018-06-12 09:20:45.902921Here Come The Walrus$WSw 5AA--- - read:stack - write:stack - deploy:stack - lock:stack - read:hook - write:hook ->v2018-04-26 13:47:49.9267972018-04-26 13:47:49.926797Spy vkX=/  #membershipsstatuses>S԰ #api_clients/w stacks?N hooks>I -1commit_deployments7P !deliveries tasks 'output_chunks>X|& commitsg!Acommit_deployment_statuses4Z users>v%github_hooks= teams'pull_requests;e4 - >v$ >v/w /e/|G֚kAASfailure2018-04-26 13:47:49.8860582018-04-26 13:47:49.886058GAASpending2018-04-26 13:47:49.8860582018-04-26 13:47:49.886058 %AAusuccess+https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/432018-04-26 13:47:49.8860582018-04-26 13:47:49.886058 %AAupending*https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/422018-04-26 13:47:49.8860582018-04-26 13:47:49.886058 - Sk S! u4Z u3   }o  `+>ǦEAA2018-04-26 13:47:49.9146252018-04-26 13:47:49.914625> AA2018-04-26 13:47:49.9146252018-04-26 13:47:49.914625>lAA2018-04-26 13:47:49.9146252018-04-26 13:47:49.914625>=AA2018-04-26 13:47:49.9146252018-04-26 13:47:49.914625>PAA2018-04-26 13:47:49.9146252018-04-26 13:47:49.914625  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/32018-04-26 13:47:49.9146252018-04-26 13:47:49.914625S  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/22018-04-26 13:47:49.9146252018-04-26 13:47:49.914625~u  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/12018-04-26 13:47:49.9146252018-04-26 13:47:49.914625 +>v2018-06-12 09:20:45.9029212018-06-12 09:20:45.902921Spy vkX=/  #membershipsstatuses>S԰ #api_clients/w stacks?N hooks>I +1commit_deployments7P !deliveries tasks +'output_chunks>X|& commitsg!Acommit_deployment_statuses4Z users>v%github_hooks= teams'pull_requests;e4 + >v$ >v/w /e/|G֚kAASfailure2018-06-12 09:20:45.8619202018-06-12 09:20:45.861920GAASpending2018-06-12 09:20:45.8619202018-06-12 09:20:45.861920 %AAusuccess+https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/432018-06-12 09:20:45.8619202018-06-12 09:20:45.861920 %AAupending*https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/422018-06-12 09:20:45.8619202018-06-12 09:20:45.861920 + Sk S! u4Z u3   }o  `+>ǦEAA2018-06-12 09:20:45.8908542018-06-12 09:20:45.890854> AA2018-06-12 09:20:45.8908542018-06-12 09:20:45.890854>lAA2018-06-12 09:20:45.8908542018-06-12 09:20:45.890854>=AA2018-06-12 09:20:45.8908542018-06-12 09:20:45.890854>PAA2018-06-12 09:20:45.8908542018-06-12 09:20:45.890854  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/32018-06-12 09:20:45.8908542018-06-12 09:20:45.890854S  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/22018-06-12 09:20:45.8908542018-06-12 09:20:45.890854~u  AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/12018-06-12 09:20:45.8908542018-06-12 09:20:45.890854  E 2D 2:X  ɽ 7P  S  u E2D2:X ɽ7PS u Y ( w . - [$g]A333(H>v>v477578b362bf2b4df5903e1c7960929361c39074fix it!2018-04-26 13:47:49.8896412018-04-18 13:47:49f2018-04-20 13:47:492018-04-21 13:47:49 @f$f]A333 (H>v>ve790fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2018-04-26 13:47:49.8896412018-04-18 13:47:49f2018-04-18 13:47:492018-04-19 13:47:49f$e]A333(H>v>v5e9278037b872fd9a6690523e411ecb3aa181355lets go2018-04-26 13:47:49.8896412018-04-18 13:47:49f2018-04-16 13:47:492018-04-17 13:47:49*fU MA333/Uk>v>v772b4795871e4a45aa17d53f02aa45d0Merge pull request #66 from cyclimse/yoloshipit + [$g]A333(H>v>v477578b362bf2b4df5903e1c7960929361c39074fix it!2018-06-12 09:20:45.8663862018-06-04 09:20:45f2018-06-06 09:20:452018-06-07 09:20:45 @f$f]A333 (H>v>ve790fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2018-06-12 09:20:45.8663862018-06-04 09:20:45f2018-06-04 09:20:452018-06-05 09:20:45f$e]A333(H>v>v5e9278037b872fd9a6690523e411ecb3aa181355lets go2018-06-12 09:20:45.8663862018-06-04 09:20:45f2018-06-02 09:20:452018-06-03 09:20:45*fU MA333/Uk>v>v772b4795871e4a45aa17d53f02aa45d0Merge pull request #66 from cyclimse/yoloshipit -yoloshipit!2018-04-26 13:47:49.8896412018-04-18 13:47:49f2018-04-22 13:47:492018-04-23 13:47:49Vcf*]'A333$WS>v>v424278037b872fd9a6690523e411ecb3aa181355Super feature2018-04-26 13:47:49.8896412018-04-18 13:47:49t2018-04-16 13:47:492018-04-17 13:47:49*f!]A333 ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2018-04-26 13:47:49.8896412018-04-18 13:47:49f2018-04-24 13:47:492018-04-25 13:47:49f"]A333 /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2018-04-26 13:47:49.8896412018-04-18 13:47:49f2018-04-24 13:47:492018-04-25 13:47:49f.]1A333 $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all the things2018-04-26 13:47:49.8896412018-04-18 13:47:49f2018-04-24 13:47:492018-04-25 13:47:49f`] A333$WS>v>v467578b362bf2b4df5903e1c7960929361c3435aMerge pull request #7 from shipit-engine/yoloshipit +yoloshipit!2018-06-12 09:20:45.8663862018-06-04 09:20:45f2018-06-08 09:20:452018-06-09 09:20:45Vcf*]'A333$WS>v>v424278037b872fd9a6690523e411ecb3aa181355Super feature2018-06-12 09:20:45.8663862018-06-04 09:20:45t2018-06-02 09:20:452018-06-03 09:20:45*f!]A333 ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2018-06-12 09:20:45.8663862018-06-04 09:20:45f2018-06-10 09:20:452018-06-11 09:20:45f"]A333 /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2018-06-12 09:20:45.8663862018-06-04 09:20:45f2018-06-10 09:20:452018-06-11 09:20:45f.]1A333 $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all the things2018-06-12 09:20:45.8663862018-06-04 09:20:45f2018-06-10 09:20:452018-06-11 09:20:45f`] A333$WS>v>v467578b362bf2b4df5903e1c7960929361c3435aMerge pull request #7 from shipit-engine/yoloshipit -yoloshipit!2018-04-26 13:47:49.8896412018-04-18 13:47:49f2018-04-22 13:47:492018-04-23 13:47:49Vf$]A333$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2018-04-26 13:47:49.8896412018-04-18 13:47:49f2018-04-20 13:47:492018-04-21 13:47:49 @f$]A333 $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2018-04-26 13:47:49.8896412018-04-18 13:47:49f2018-04-18 13:47:492018-04-19 13:47:49f$]A333$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2018-04-26 13:47:49.8896412018-04-18 13:47:49f2018-04-16 13:47:492018-04-17 13:47:49*f +yoloshipit!2018-06-12 09:20:45.8663862018-06-04 09:20:45f2018-06-08 09:20:452018-06-09 09:20:45Vf$]A333$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2018-06-12 09:20:45.8663862018-06-04 09:20:45f2018-06-06 09:20:452018-06-07 09:20:45 @f$]A333 $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2018-06-12 09:20:45.8663862018-06-04 09:20:45f2018-06-04 09:20:452018-06-05 09:20:45f$]A333$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2018-06-12 09:20:45.8663862018-06-04 09:20:45f2018-06-02 09:20:452018-06-03 09:20:45*f >vg>vf>ve>v >v5˱C5˱C>v>v>v>v >v >vg>vf>ve>v >v5˱C5˱C>v>v>v>v >v - fG( A2018-04-26 13:47:49.889641gA2018-04-26 13:47:49.889641fA2018-04-26 13:47:49.889641eA2018-04-26 13:47:49.889641 A2018-04-26 13:47:49.889641A2018-04-26 13:47:49.889641A2018-04-26 13:47:49.889641A2018-04-26 13:47:49.889641A2018-04-26 13:47:49.889641A2018-04-26 13:47:49.889641A2018-04-26 13:47:49.889641A 2018-04-26 13:47:49.889641 + fG( A2018-06-12 09:20:45.866386gA2018-06-12 09:20:45.866386fA2018-06-12 09:20:45.866386eA2018-06-12 09:20:45.866386 A2018-06-12 09:20:45.866386A2018-06-12 09:20:45.866386A2018-06-12 09:20:45.866386A2018-06-12 09:20:45.866386A2018-06-12 09:20:45.866386A2018-06-12 09:20:45.866386A2018-06-12 09:20:45.866386A 2018-06-12 09:20:45.866386 kq9 G 1]477578b362bf2b4df5903e1c7960929361c39074(Hg1]e790fd8b5f2be05d1fedb763a3605ee461c39074(Hf1]5e9278037b872fd9a6690523e411ecb3aa181355(He)M772b4795871e4a45aa17d53f02aa45d0/Uk 1]424278037b872fd9a6690523e411ecb3aa181355$WS1]44b3833d39def7ec65b57b42f496eb27ab4980b6?N1]8e859b4c19ea7638443d43d612086948bce51701/Uk1]567578b362bf2b4df5903e1c7960929361c3abcd$WS1]467578b362bf2b4df5903e1c7960929361c3435a$WS1]367578b362bf2b4df5903e1c7960929361c39074$WS1]f890fd8b5f2be05d1fedb763a3605ee461c39074$WS0] 6d9278037b872fd9a6690523e411ecb3aa181355$WS (Hg(Hf(He/Uk $WS?N/Uk$WS$WS$WS$WS $WS SS&\O-[3AHscheduledhttps://example.com/events/deployapplication/jsondeploy{ "stack": { }, "deploy": { } -}2018-04-26 13:42:492018-04-26 13:47:49.912217 +}2018-06-12 09:15:452018-06-12 09:20:45.887804 Hdeployscheduled -Hscheduled GG*t{ !AAMmembership2018-04-26 13:47:49.8785242018-04-26 13:47:49.8785241234Shipit::GithubHook::Organizationshopifyc擄 AA=/Ukpush2018-04-26 13:47:49.8785242018-04-26 13:47:49.8785241234Shipit::GithubHook::Repof↨o AA=$WS+status2018-04-26 13:47:49.8785242018-04-26 13:47:49.8785241234Shipit::GithubHook::Repodžy AA=$WS*push2018-04-26 13:47:49.8785242018-04-26 13:47:49.8785241234Shipit::GithubHook::Repo  +Hscheduled GG*t{ !AAMmembership2018-06-12 09:20:45.8517952018-06-12 09:20:45.8517951234Shipit::GithubHook::Organizationshopifyc擄 AA=/Ukpush2018-06-12 09:20:45.8517952018-06-12 09:20:45.8517951234Shipit::GithubHook::Repof↨o AA=$WS+status2018-06-12 09:20:45.8517952018-06-12 09:20:45.8517951234Shipit::GithubHook::Repodžy AA=$WS*push2018-06-12 09:20:45.8517952018-06-12 09:20:45.8517951234Shipit::GithubHook::Repo  q*#iaY!Cindexindex_deliveries_on_hook_id_and_statusdeliveriesCREATE INDEX "index_deliveries_on_hook_id_and_status" ON "deliveries" ("hook_id", "status")5m!iindexindex_deliveries_on_hook_id_and_event_and_statusdeliveriesCREATE INDEX "index_deliveries_on_hook_id_and_event_and_status" ON "deliveries" ("hook_id", "event", "status")s!!1tabledeliveriesdeliveriesCREATE TABLE "deliveries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "hook_id" integer(4) NOT NULL, "status" varchar(50) DEFAULT 'pending' NOT NULL, "url" varchar(4096) NOT NULL, "content_type" varchar(255) NOT NULL, "event" varchar(50) NOT NULL, "payload" text(16777215) NOT NULL, "response_code" integer(4), "response_headers" text(65535), "response_body" text(65535), "delivered_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)o?indexindex_commits_on_stack_idcommitsCREATE INDEX "index_commits_on_stack_id" ON "commits" ("stack_id") O=indexindex_commits_on_sha_and_stack_idcommitsCREATE UNIQUE INDEX "index_commits_on_sha_and_stack_id" ON "commits" ("sha", "stack_id")u Cindexindex_commits_on_created_atcommits CREATE INDEX "index_commits_on_created_at" ON "commits" ("created_at"){ G!indexindex_commits_on_committer_idcommits CREATE INDEX "index_commits_on_committer_id" ON "commits" ("committer_id")r Aindexindex_commits_on_author_idcommits CREATE INDEX "index_commits_on_author_id" ON "commits" ("author_id")S }tablecommitscommits CREATE TABLE "commits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4) NOT NULL, "author_id" integer(4) NOT NULL, "committer_id" integer(4) NOT NULL, "sha" varchar(40) NOT NULL, "message" text(65535) NOT NULL, "created_at" datetime, "updated_at" datetime, "detached" boolean DEFAULT 'f' NOT NULL, "authored_at" datetime NOT NULL, "committed_at" datetime NOT NULL, "additions" integer(4), "deletions" integer(4), "pull_request_number" integer, "pull_request_title" varchar(1024), "pull_request_id" integer, "locked" boolean DEFAULT 'f' NOT NULL)S19indexindex_commit_deployments_on_task_idcommit_deployments CREATE INDEX "index_commit_deployments_on_task_id" ON "commit_deployments" ("task_id")Ho1}indexindex_commit_deployments_on_commit_id_and_task_idcommit_deploymentsCREATE UNIQUE INDEX "index_commit_deployments_on_commit_id_and_task_id" ON "commit_deployments" ("commit_id", "task_id")11Stablecommit_deploymentscommit_deploymentsCREATE TABLE "commit_deployments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commit_id" integer, "task_id" integer, "github_id" integer, "api_url" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)_}A indexindex_commit_deployment_statuses_on_commit_deployment_idcommit_deployment_statusesCREATE INDEX "index_commit_deployment_statuses_on_commit_deployment_id" ON "commit_deployment_statuses" ("commit_deployment_id")6AAwtablecommit_deployment_statusescommit_deployment_statusesCREATE TABLE "commit_deployment_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commit_deployment_id" integer, "status" varchar, "github_id" integer, "api_url" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)K#)indexindex_api_clients_on_creator_idapi_clientsCREATE INDEX "index_api_clients_on_creator_id" ON "api_clients" ("creator_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)##{tableapi_clientsapi_clientsCREATE TABLE "api_clients" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permissions" text(65535), "creator_id" integer(4), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(255) DEFAULT '', "stack_id" integer(4)) NV H.V ?  q_ 9!m'kindexindex_#K')indexindex_pull_requests_on_stack_idpull_requests&CREATE INDEX "index_pull_requests_on_stack_id" ON "pull_requests" ("stack_id")."a'aindexindex_pull_requests_on_stack_id_and_numberpull_requests%CREATE UNIQUE INDEX "index_pull_requests_on_stack_id_and_number" ON "pull_requests" ("stack_id", "number")9!m'kindexindex_pull_requests_on_stack_id_and_merge_statuspull_requests$CREATE INDEX "index_pull_requests_on_stack_id_and_merge_status" ON "pull_requests" ("stack_id", "merge_status")I'%indexindex_output_chunks_on_task_idoutput_chunksCREATE INDEX "index_output_chunks_on_task_id" ON "output_chunks" ("task_id")P''_tableoutput_chunksoutput_chunksCREATE TABLE "output_chunks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "task_id" integer(4), "text" text(16777215), "created_at" datetime, "updated_at" datetime)|E#indexindex_memberships_on_user_idmembershipsCREATE INDEX "index_memberships_on_user_id" ON "memberships" ("user_id")&]#Yindexindex_memberships_on_team_id_and_user_idmembershipsCREATE UNIQUE INDEX "index_memberships_on_team_id_and_user_id" ON "memberships" ("team_id", "user_id")[##}tablemembershipsmembershipsCREATE TABLE "memberships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "team_id" integer(4), "user_id" integer(4), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)g; indexindex_hooks_on_stack_idhooksCREATE INDEX "index_hooks_on_stack_id" ON "hooks" ("stack_id")}YtablehookshooksCREATE TABLE "hooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4), "delivery_url" varchar(4096) NOT NULL, "content_type" varchar(4) DEFAULT 'json' NOT NULL, "secret" varchar(255), "events" varchar(255) DEFAULT '' NOT NULL, "insecure_ssl" boolean DEFAULT 'f' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)']%Yindexindex_github_hooks_on_stack_id_and_eventgithub_hooksCREATE UNIQUE INDEX "index_github_hooks_on_stack_id_and_event" ON "github_hooks" ("stack_id", "event")3e%iindexindex_github_hooks_on_organization_and_eventgithub_hooksCREATE UNIQUE INDEX "index_github_hooks_on_organization_and_event" ON "github_hooks" ("organization", "event")M%%]tablegithub_hooksgithub_hooksCREATE TABLE "github_hooks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4), "github_id" integer(4), "event" varchar(50) NOT NULL, "created_at" datetime, "updated_at" datetime, "secret" varchar(255), "api_url" varchar(255), "type" varchar(255), "organization" varchar(39))Y!Cindexindex_deliveries_on_hook_id_and_statusdeliveriesCREATE INDEX "index_deliveries_on_hook_id7 g'mindexindex_pull_requeY!Cindexindex_deliveries_on_hook_id_and_statusdeliveriesCREATE INDEX "index_deliveries_on_hook_id_and_status" ON "deliveries" ("hook_id", "status")S'9indexindex_pull_requests_on_merge_statuspull_requests"CREATE INDEX "index_pull_requests_on_merge_status" ON "pull_requests" ("merge_status").e']indexindex_pull_requests_on_merge_requested_by_idpull_requests!CREATE INDEX "index_pull_requests_on_merge_requested_by_id" ON "pull_requests" ("merge_requested_by_id")I'%indexindex_pull_requests_on_head_idpull_requests CREATE INDEX "index_pull_requests_on_head_id" ON "pull_requests" ("head_id")>'';tablepull_requestspull_requestsCREATE TABLE "pull_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer NOT NULL, "number" integer NOT NULL, "title" varchar(256), "github_id" integer(8), "api_url" varchar(1024), "state" varchar, "head_id" integer, "mergeable" boolean, "additions" integer DEFAULT 0 NOT NULL, "deletions" integer DEFAULT 0 NOT NULL, "merge_status" varchar(30) NOT NULL, "rejection_reason" varchar, "merge_requested_at" datetime NOT NULL, "merge_requested_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "branch" varchar, "revalidated_at" datetime, "merged_at" datetime, "base_ref" varchar(1024), "base_commit_id" integer) !shopifymembership{ push=status<Ao pushGy !membership{/Ukpush=$WSstatus<Ao$WSpushGy    |@ -]'AA/Ukhttps://example.com/events/deploy_statusjsondeploy_statusf2018-04-26 13:47:49.9185082018-04-26 13:47:49.918508| -]'AA$WShttps://example.com/events/commit_statusjsoncommit_statusf2018-04-26 13:47:49.9185082018-04-26 13:47:49.918508l{ -OAA$WShttps://example.com/events/deployjsontaskf2018-04-26 13:47:49.9185082018-04-26 13:47:49.918508s -O+AAhttps://example.com/events/deployformdeploy,rollbackf2018-04-26 13:47:49.9185082018-04-26 13:47:49.918508wH -O+AA$WShttps://example.com/events/deployjsondeploy,rollbackf2018-04-26 13:47:49.9185082018-04-26 13:47:49.918508 - /Uk&NI $WS>I $WS#fi{Ͽ $WSH >H AA>v2018-04-26 13:47:49.9361492018-04-26 13:47:49.936149 +]'AA/Ukhttps://example.com/events/deploy_statusjsondeploy_statusf2018-06-12 09:20:45.8945662018-06-12 09:20:45.894566| +]'AA$WShttps://example.com/events/commit_statusjsoncommit_statusf2018-06-12 09:20:45.8945662018-06-12 09:20:45.894566l{ +OAA$WShttps://example.com/events/deployjsontaskf2018-06-12 09:20:45.8945662018-06-12 09:20:45.894566s +O+AAhttps://example.com/events/deployformdeploy,rollbackf2018-06-12 09:20:45.8945662018-06-12 09:20:45.894566wH +O+AA$WShttps://example.com/events/deployjsondeploy,rollbackf2018-06-12 09:20:45.8945662018-06-12 09:20:45.894566 + /Uk&NI $WS>I $WS#fi{Ͽ $WSH >H AA>v2018-06-12 09:20:45.9124462018-06-12 09:20:45.912446   >v - >v q` q  P   aNʑ*3AAsudo chmod -R 777 /2018-04-26 13:47:49.8983902018-04-26 13:47:49.898390H'AAsudo rm -rf /2018-04-26 13:47:49.8983902018-04-26 13:47:49.898390I )AAMaking ops cry2018-04-26 13:47:49.8983902018-04-26 13:47:49.898390Q&9AACompiling all the sass2018-04-26 13:47:49.8983902018-04-26 13:47:49.898390O5AAMigrating some stuff2018-04-26 13:47:49.8983902018-04-26 13:47:49.898390M 3AAsudo chmod -R 777 /2018-04-26 13:47:49.8983902018-04-26 13:47:49.898390G! 'AAsudo rm -rf /2018-04-26 13:47:49.8983902018-04-26 13:47:49.898390Hޫ8 )AAMaking ops cry2018-04-26 13:47:49.8983902018-04-26 13:47:49.898390P̀ 9AACompiling all the sass2018-04-26 13:47:49.8983902018-04-26 13:47:49.898390N 5AAMigrating some stuff2018-04-26 13:47:49.8983902018-04-26 13:47:49.898390VS EAAdeploy deploy deploy, faiiil2018-04-26 13:47:49.8983902018-04-26 13:47:49.898390 + >v q` q  P   aNʑ*3AAsudo chmod -R 777 /2018-06-12 09:20:45.8738802018-06-12 09:20:45.873880H'AAsudo rm -rf /2018-06-12 09:20:45.8738802018-06-12 09:20:45.873880I )AAMaking ops cry2018-06-12 09:20:45.8738802018-06-12 09:20:45.873880Q&9AACompiling all the sass2018-06-12 09:20:45.8738802018-06-12 09:20:45.873880O5AAMigrating some stuff2018-06-12 09:20:45.8738802018-06-12 09:20:45.873880M 3AAsudo chmod -R 777 /2018-06-12 09:20:45.8738802018-06-12 09:20:45.873880G! 'AAsudo rm -rf /2018-06-12 09:20:45.8738802018-06-12 09:20:45.873880Hޫ8 )AAMaking ops cry2018-06-12 09:20:45.8738802018-06-12 09:20:45.873880P̀ 9AACompiling all the sass2018-06-12 09:20:45.8738802018-06-12 09:20:45.873880N 5AAMigrating some stuff2018-06-12 09:20:45.8738802018-06-12 09:20:45.873880VS EAAdeploy deploy deploy, faiiil2018-06-12 09:20:45.8738802018-06-12 09:20:45.873880 2; <>X|&&j  ! 6 ( 0 $WS EE  * - bcy3AA!33/UkB'TZ'https://api.github.com/repos/shopify/cyclimse/pulls/66closed+merged2018-04-26 13:44:49>v2018-04-26 13:47:49.8539132018-04-26 13:47:49.853913feature-642018-04-26 13:44:492018-04-26 13:45:49\Ǻ -3AA!3$WSDNoice !,+https://api.github.com/repos/shopify/shipit-engine/pulls/68opent+pending2018-04-26 12:57:49>v2018-04-26 13:47:49.8539132018-04-26 13:47:49.853913feature-682018-04-26 13:22:49o=3AA!3$WSCSuper duper nice feature^!https://api.github.com/repos/shopify/shipit-engine/pulls/67opent+pending2018-04-26 13:42:49>v2018-04-26 13:47:49.8539132018-04-26 13:47:49.853913feature-672018-04-26 13:42:49i֐63AA!33$WSB'TZ'https://api.github.com/repos/shopify/shipit-engine/pulls/66closed+pending2018-04-26 13:44:49>v2018-04-26 13:47:49.8539132018-04-26 13:47:49.853913feature-642018-04-26 13:44:492018-04-26 13:45:49V]3AA!3$WSA'TZ'https://api.github.com/repos/shopify/shipit-engine/pulls/65closed+pending2018-04-26 13:44:49>v2018-04-26 13:47:49.8539132018-04-26 13:47:49.853913feature-642018-04-26 13:44:49T 3AA!3$WS@)W0.https://api.github.com/repos/shopify/shipit-engine/pulls/64open+pending2018-04-26 13:44:49>v2018-04-26 13:47:49.8539132018-04-26 13:47:49.853913feature-642018-04-26 13:44:49g;13AA!3$WS=Other cool feature' -https://api.github.com/repos/shopify/shipit-engine/pulls/61openf+pending2018-04-26 13:43:49>v2018-04-26 13:47:49.8539132018-04-26 13:47:49.853913feature-612018-04-26 13:43:49mN=3AA!3$WS>Super duper nice feature&https://api.github.com/repos/shopify/shipit-engine/pulls/62opent+pending2018-04-26 13:42:49>v2018-04-26 13:47:49.8539132018-04-26 13:47:49.853913feature-622018-04-26 13:42:49o43AA$WS?fetching2018-04-26 13:46:49>v2018-04-26 13:47:49.8539132018-04-26 13:47:49.853913 + bcy3AA!33/UkB'TZ'https://api.github.com/repos/shopify/cyclimse/pulls/66closed+merged2018-06-12 09:17:45>v2018-06-12 09:20:45.8387182018-06-12 09:20:45.838718feature-642018-06-12 09:17:452018-06-12 09:18:45\Ǻ +3AA!3$WSDNoice !,+https://api.github.com/repos/shopify/shipit-engine/pulls/68opent+pending2018-06-12 08:30:45>v2018-06-12 09:20:45.8387182018-06-12 09:20:45.838718feature-682018-06-12 08:55:45o=3AA!3$WSCSuper duper nice feature^!https://api.github.com/repos/shopify/shipit-engine/pulls/67opent+pending2018-06-12 09:15:45>v2018-06-12 09:20:45.8387182018-06-12 09:20:45.838718feature-672018-06-12 09:15:45i֐63AA!33$WSB'TZ'https://api.github.com/repos/shopify/shipit-engine/pulls/66closed+pending2018-06-12 09:17:45>v2018-06-12 09:20:45.8387182018-06-12 09:20:45.838718feature-642018-06-12 09:17:452018-06-12 09:18:45V]3AA!3$WSA'TZ'https://api.github.com/repos/shopify/shipit-engine/pulls/65closed+pending2018-06-12 09:17:45>v2018-06-12 09:20:45.8387182018-06-12 09:20:45.838718feature-642018-06-12 09:17:45T 3AA!3$WS@)W0.https://api.github.com/repos/shopify/shipit-engine/pulls/64open+pending2018-06-12 09:17:45>v2018-06-12 09:20:45.8387182018-06-12 09:20:45.838718feature-642018-06-12 09:17:45g;13AA!3$WS=Other cool feature' +https://api.github.com/repos/shopify/shipit-engine/pulls/61openf+pending2018-06-12 09:16:45>v2018-06-12 09:20:45.8387182018-06-12 09:20:45.838718feature-612018-06-12 09:16:45mN=3AA!3$WS>Super duper nice feature&https://api.github.com/repos/shopify/shipit-engine/pulls/62opent+pending2018-06-12 09:15:45>v2018-06-12 09:20:45.8387182018-06-12 09:20:45.838718feature-622018-06-12 09:15:45o43AA$WS?fetching2018-06-12 09:19:45>v2018-06-12 09:20:45.8387182018-06-12 09:20:45.838718 c + -6#4>5dl;;e4 >vc >v >v+ >v @@ -83,11 +84,11 @@ $WSC+ $WSB -6 $WSA $WS@#4> $WS=5dl; $WS> $WS?;e4 /Ukc $WS $WS+ $WS -6 $WS $WS#4> $WS5dl; $WS $WS;e4 ;; -4!A33 socshopifyproduction2018-04-26 13:47:49.9223122018-04-18 13:47:49masterf{ +4!A33 socshopifyproduction2018-06-12 09:20:45.8983682018-06-04 09:20:45masterf{ "machine": {"environment": {}}, "review": { "checklist": ["foo", "bar", "baz"], "monitoring": [ {"image": "https://example.com/monitor.png", "width": 200, "height": 300} @@ -108,11 +109,11 @@ }, "ci": { "blocking": ["soc/compliance"] } } -fX:!A3 s foo-barshopifyproduction2018-04-26 13:47:49.9223122018-04-18 13:47:49masterf{ +fX:!A3 s foo-barshopifyproduction2018-06-12 09:20:45.8983682018-06-04 09:20:45masterf{ "machine": {"environment": {}}, "review": { "checklist": ["foo", "bar", "baz"], "monitoring": [ {"image": "https://example.com/monitor.png", "width": 200, "height": 300} @@ -134,11 +135,11 @@ "ci": { "hide": ["ci/hidden"], "allow_failures": ["ci/ok_to_fail"] } } -tf;k!A3  3cyclimsegeorgeproduction2018-04-26 13:47:49.9223122018-04-18 13:47:49masterf{ +tf;k!A3  3cyclimsegeorgeproduction2018-06-12 09:20:45.8983682018-06-04 09:20:45masterf{ "machine": {"environment": {}}, "review": { "checklist": ["foo", "bar", "baz"], "monitoring": [ {"image": "https://example.com/monitor.png", "width": 200, "height": 300} @@ -156,11 +157,11 @@ "cap $ENVIRONMENT deploy:restart" ] } } } -ff2018-04-18 13:47:49bS'!A3 S 3shipit-engineshopifyproduction2018-04-26 13:47:49.9223122018-04-18 13:47:49masterf{ +ff2018-06-04 09:20:45bS'!A3 S 3shipit-engineshopifyproduction2018-06-12 09:20:45.8983682018-06-04 09:20:45masterf{ "machine": {"environment": {}}, "review": { "checklist": ["foo", "bar", "baz"], "monitoring": [ {"image": "https://example.com/monitor.png", "width": 200, "height": 300} @@ -198,31 +199,47 @@ "ci": { "hide": ["ci/hidden"], "allow_failures": ["ci/ok_to_fail"] } } -ft2018-04-18 13:47:49 F O(atg U M(,g_indexindex_tasks_on_stack_id_and_allow_concurrencytasks0CREATE INDEX "index_tasks_on_stack_id_and_allow_concurrency" ON "tasks" ("stack_id", "allow_concurrency")|+1=indexindex_active_taskstasks/CREATE INDEX "index_active_tasks" ON "tasks" ("stack_id", "allow_concurrency", "status")|*I%indexindex_tasks_on_since_commit_idtasks.CREATE INDEX "index_tasks_on_since_commit_id" ON "tasks" ("since_commit_id")6)qqindexindex_tasks_on_rolled_up_and_created_at_and_statustasks-CREATE INDEX "index_tasks_on_rolled_up_and_created_at_and_status" ON "tasks" ("rolled_up", "created_at", "status")(tabletaskstasks,CREATE TABLE "tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4) NOT NULL, "since_commit_id" integer(4) NOT NULL, "until_commit_id" integer(4) NOT NULL, "status" varchar(10) DEFAULT 'pending' NOT NULL, "created_at" datetime, "updated_at" datetime, "user_id" integer(4), "rolled_up" boolean DEFAULT 'f' NOT NULL, "type" varchar(20), "parent_id" integer(4), "additions" integer(4) DEFAULT 0, "deletions" integer(4) DEFAULT 0, "definition" text(65535), "gzip_output" blob, "rollback_once_aborted" boolean DEFAULT 'f' NOT NULL, "env" text, "confirmations" integer DEFAULT 0 NOT NULL, "allow_concurrency" boolean DEFAULT 'f' NOT NULL, "started_at" datetime, "ended_at" datetime, "ignored_safeties" boolean DEFAULT 'f' NOT NULL, "aborted_by_id" integer)v'Cindexindex_statuses_on_commit_idstatuses+CREATE INDEX "index_statuses_on_commit_id" ON "statuses" ("commit_id")H&ctablestatusesstatuses*CREATE TABLE "statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "state" varchar(255), "target_url" varchar(255), "description" text(65535), "context" varchar(255) DEFAULT 'default' NOT NULL, "commit_id" integer(4), "created_at" datetime, "updated_at" datetime, "stack_id" integer NOT NULL)z%'Aindexstack_unicitystacks)CREATE UNIQUE INDEX "stack_unicity" ON "stacks" ("repo_owner", "repo_name", "environment")V$tablestacksstacks'CREATE TABLE "stacks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "repo_name" varchar(100) NOT NULL, "repo_owner" varchar(39) NOT NULL, "environment" varchar(50) DEFAULT 'production' NOT NULL, "created_at" datetime, "updated_at" datetime, "branch" varchar(255) DEFAULT 'master' NOT NULL, "deploy_url" varchar(255), "lock_reason" varchar(4096), "tasks_count" integer(4) DEFAULT 0 NOT NULL, "continuous_deployment" boolean DEFAULT 'f' NOT NULL, "undeployed_commits_count" integer(4) DEFAULT 0 NOT NULL, "cached_deploy_spec" text(65535), "lock_author_id" integer(4), "ignore_ci" boolean, "inaccessible_since" datetime, "estimated_deploy_duration" integer DEFAULT 1 NOT NULL, "continuous_delivery_delayed_since" datetime, "locked_since" datetime, "merge_queue_enabled" boolean DEFAULT 'f' NOT NULL, "last_deployed_at" datetime)K')indexindex_pull_requests_on_stack_idpull_requests&CREATE INDEX "index_pull_requests_on_stack_id" ON "pull_requests" ("stack_id")."a'aindexindex_pull_requests_on_stack_id_and_numberpull_requ32UIindexindex_teams_on_organization_and_slugteams6CREATE UNIQUE INDEX "index_teams_on_organization_and_slug" ON "teams" ("organization", "slug")1tableteamsteams5CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "g#K')indexindex_pull_requests_on_stack_idpull_requests&CREATE INDEX "index_pull_requests_on_stack_id" ON "pull_requests" ("stack_id")."a'aindexindex_pull_requests_on_stack_id_and_numberpull_requests%CREATE UNIQUE INDEX "index_pull_requests_on_stack_id_and_number" ON "pull_requests" ("stack_id", "number")9!m'kindexindex_pull_requests_on_stack_id_and_merge_statuspull_requests$CREATE INDEX "index_pull_requests_on_stack_id_and_merge_status" ON "pull_requests" ("stack_id", "merge_status")7 g'mindexindex_pull_requests_on_stack_id_and_github_idpull_requests#CREATE UNIQUE INDEX "index_pull_requests_on_stack_id_and_github_id" ON "pull_requests" ("stack_id", "github_id") +ft2018-06-04 09:20:45 F O(atg U M(,g_indexindex_tasks_on_stack_id_and_allow_concurrencytasks0CREATE INDEX "index_tasks_on_stack_id_and_allow_concurrency" ON "tasks" ("stack_id", "allow_concurrency")|+1=indexindex_active_taskstasks/CREATE INDEX "index_active_tasks" ON "tasks" ("stack_id", "allow_concurrency", "status")|*I%indexindex_tasks_on_since_commit_idtasks.CREATE INDEX "index_tasks_on_since_commit_id" ON "tasks" ("since_commit_id")6)qqindexindex_tasks_on_rolled_up_and_created_at_and_statustasks-CREATE INDEX "index_tasks_on_rolled_up_and_created_at_and_status" ON "tasks" ("rolled_up", "created_at", "status")(tabletaskstasks,CREATE TABLE "tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stack_id" integer(4) NOT NULL, "since_commit_id" integer(4) NOT NULL, "until_commit_id" integer(4) NOT NULL, "status" varchar(10) DEFAULT 'pending' NOT NULL, "created_at" datetime, "updated_at" datetime, "user_id" integer(4), "rolled_up" boolean DEFAULT 'f' NOT NULL, "type" varchar(20), "parent_id" integer(4), "additions" integer(4) DEFAULT 0, "deletions" integer(4) DEFAULT 0, "definition" text(65535), "gzip_output" blob, "rollback_once_aborted" boolean DEFAULT 'f' NOT NULL, "env" text, "confirmations" integer DEFAULT 0 NOT NULL, "allow_concurrency" boolean DEFAULT 'f' NOT NULL, "started_at" datetime, "ended_at" datetime, "ignored_safeties" boolean DEFAULT 'f' NOT NULL, "aborted_by_id" integer)v'Cindexindex_statuses_on_commit_idstatuses+CREATE INDEX "index_statuses_on_commit_id" ON "statuses" ("commit_id")H&ctablestatusesstatuses*CREATE TABLE "statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "state" varchar(255), "target_url" varchar(255), "description" text(65535), "context" varchar(255) DEFAULT 'default' NOT NULL, "commit_id" integer(4), "created_at" datetime, "updated_at" datetime, "stack_id" integer NOT NULL)z%'Aindexstack_unicitystacks)CREATE UNIQUE INDEX "stack_unicity" ON "stacks" ("repo_owner", "repo_name", "environment")V$tablestacksstacks'CREATE TABLE "stacks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "repo_name" varchar(100) NOT NULL, "repo_owner" varchar(39) NOT NULL, "environment" varchar(50) DEFAULT 'production' NOT NULL, "created_at" datetime, "updated_at" datetime, "branch" varchar(255) DEFAULT 'master' NOT NULL, "deploy_url" varchar(255), "lock_reason" varchar(4096), "tasks_count" integer(4) DEFAULT 0 NOT NULL, "continuous_deployment" boolean DEFAULT 'f' NOT NULL, "undeployed_commits_count" integer(4) DEFAULT 0 NOT NULL, "cached_deploy_spec" text(65535), "lock_author_id" integer(4), "ignore_ci" boolean, "inaccessible_since" datetime, "estimated_deploy_duration" integer DEFAULT 1 NOT NULL, "continuous_delivery_delayed_since" datetime, "locked_since" datetime, "merge_queue_enabled" boolean DEFAULT 'f' NOT NULL, "last_deployed_at" datetime)K')indexindex_pull_requests_on_stack_idpull_requests&CREATE INDEX "index_pull_requests_on_stack_id" ON "pull_requests" ("stack_id")."a'aindexindex_pull_requests_on_stack_id_and_numberpull_requ32UIindexindex_teams_on_organization_and_slugteams6CREATE UNIQUE INDEX "index_teams_on_organization_and_slug" ON "teams" ("organization", "slug")1tableteamsteams5CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "g#K')indexindex_pull_requests_on_stack_idpull_requests&CREATE INDEX "index_pull_requests_on_stack_id" ON "pull_requests" ("stack_id")."a'aindexindex_pull_requests_on_stack_id_and_numberpull_requests%CREATE UNIQUE INDEX "index_pull_requests_on_stack_id_and_number" ON "pull_requests" ("stack_id", "number")9!m'kindexindex_pull_requests_on_stack_id_and_merge_statuspull_requests$CREATE INDEX "index_pull_requests_on_stack_id_and_merge_status" ON "pull_requests" ("stack_id", "merge_status")7 g'mindexindex_pull_requests_on_stack_id_and_github_idpull_requests#CREATE UNIQUE INDEX "index_pull_requests_on_stack_id_and_github_id" ON "pull_requests" ("stack_id", "github_id") vv!shopifysocproduction(H!!shopifyfoo-barproduction?N!!georgecyclimseproduction/Uk''!shopifyshipit-engineproduction$WS   > r$ X 0  o -9)3Asuccesshttp://www.example.comAll goodsoc/complianceg2018-04-19 13:47:492018-04-26 13:47:49.929824(HoW -9)3Asuccesshttp://www.example.comAll goodsoc/compliancef2018-04-19 13:47:492018-04-26 13:47:49.929824(Hl9 -9)3Afailurehttp://www.example.comWoopssoc/compliancee2018-04-17 13:47:492018-04-26 13:47:49.929824(HoѲ$ -9'3Asuccesshttp://www.example.comSuper featureci/travis2018-04-17 13:47:492018-04-26 13:47:49.929824$WSiϩ0 -93Asuccesshttp://www.example.comlets goci/travis2018-04-17 13:47:492018-04-26 13:47:49.929824/Ukq- -9/3Asuccesshttp://www.example.comlets gometrics/coveralls2018-04-17 13:47:492018-04-26 13:47:49.929824$WSiΕ -93Apendinghttp://www.example.comlets goci/travis2018-04-17 13:47:492018-04-26 13:47:49.929824$WSq޺L -9/3Asuccesshttp://www.example.comlets gometrics/coveralls2018-04-17 13:47:492018-04-26 13:47:49.929824$WSi' -93Asuccesshttp://www.example.comlets goci/travis2018-04-17 13:47:492018-04-26 13:47:49.929824$WSq -9/3Afailurehttp://www.example.comlets gometrics/coveralls2018-04-17 13:47:492018-04-26 13:47:49.929824$WSi˺c -93Asuccesshttp://www.example.comlets goci/travis2018-04-17 13:47:492018-04-26 13:47:49.929824$WSq劔W -9/3Apendinghttp://www.example.comlets gometrics/coveralls2018-04-16 13:47:492018-04-26 13:47:49.929824$WSiu -93Apendinghttp://www.example.comlets goci/travis2018-04-16 13:47:492018-04-26 13:47:49.929824$WShH -9 3Apendinghttp://www.example.comlets goci/travis2018-04-16 13:47:492018-04-26 13:47:49.929824$WS +9)3Asuccesshttp://www.example.comAll goodsoc/complianceg2018-06-05 09:20:452018-06-12 09:20:45.905680(HoW +9)3Asuccesshttp://www.example.comAll goodsoc/compliancef2018-06-05 09:20:452018-06-12 09:20:45.905680(Hl9 +9)3Afailurehttp://www.example.comWoopssoc/compliancee2018-06-03 09:20:452018-06-12 09:20:45.905680(HoѲ$ +9'3Asuccesshttp://www.example.comSuper featureci/travis2018-06-03 09:20:452018-06-12 09:20:45.905680$WSiϩ0 +93Asuccesshttp://www.example.comlets goci/travis2018-06-03 09:20:452018-06-12 09:20:45.905680/Ukq- +9/3Asuccesshttp://www.example.comlets gometrics/coveralls2018-06-03 09:20:452018-06-12 09:20:45.905680$WSiΕ +93Apendinghttp://www.example.comlets goci/travis2018-06-03 09:20:452018-06-12 09:20:45.905680$WSq޺L +9/3Asuccesshttp://www.example.comlets gometrics/coveralls2018-06-03 09:20:452018-06-12 09:20:45.905680$WSi' +93Asuccesshttp://www.example.comlets goci/travis2018-06-03 09:20:452018-06-12 09:20:45.905680$WSq +9/3Afailurehttp://www.example.comlets gometrics/coveralls2018-06-03 09:20:452018-06-12 09:20:45.905680$WSi˺c +93Asuccesshttp://www.example.comlets goci/travis2018-06-03 09:20:452018-06-12 09:20:45.905680$WSq劔W +9/3Apendinghttp://www.example.comlets gometrics/coveralls2018-06-02 09:20:452018-06-12 09:20:45.905680$WSiu +93Apendinghttp://www.example.comlets goci/travis2018-06-02 09:20:452018-06-12 09:20:45.905680$WShH +9 3Apendinghttp://www.example.comlets goci/travis2018-06-02 09:20:452018-06-12 09:20:45.905680$WS gzbf1 -We59=Y$>S԰3VjL'd/mncWiu YH p  /  -m  3A) 33(Heesuccess2018-04-26 12:48:492018-04-26 13:47:49.903257>vfShipit::Deployff2018-04-26 12:48:492018-04-26 12:50:49f3A-33$WSaborted2018-04-26 12:55:492018-04-26 13:47:49.9032575˱CfShipit::RollbackVff2018-04-26 12:55:492018-04-26 12:54:49f3A)33$WSaborted2018-04-26 12:54:492018-04-26 13:47:49.9032575˱CfShipit::DeployVtf2018-04-26 12:54:492018-04-26 12:53:49f3A)33$WSsuccess2018-04-26 12:53:492018-04-26 13:47:49.9032575˱CfShipit::DeployVff2018-04-26 12:53:492018-04-26 12:55:49f3A)3$WSrunning2018-04-26 12:52:492018-04-26 13:47:49.903257>vfShipit::DeployVft2018-04-26 12:52:49fh3A)$WSpending2018-04-26 12:51:492018-04-26 13:47:49.903257fShipit::DeployftfA3A%u33$WSsuccess2018-04-26 12:50:492018-04-26 13:47:49.903257>vfShipit::Task{ +We59=Y$>S԰3VjL'd/mncWiu YH +(p  /  +m (1 +3A%3/33$WSsuccess2018-06-12 08:23:452018-06-12 09:20:45.878293>vfShipit::Task{ + "id": "failover", + "action": "Failover a pod", + "title": "Failover pod %{POD_ID}", + "description": "Restart app and job servers", + "variables": [ + {"name": "POD_ID", "title": "Id of the pod to failover"} + ], + "steps": [ + "cap $ENVIRONMENT pod:failover" + ] +} +f--- +POD_ID: '12' +f2018-06-12 08:23:452018-06-12 08:24:45f 3A) 33(Heesuccess2018-06-12 08:21:452018-06-12 09:20:45.878293>vfShipit::Deployff2018-06-12 08:21:452018-06-12 08:23:45f3A-33$WSaborted2018-06-12 08:28:452018-06-12 09:20:45.8782935˱CfShipit::RollbackVff2018-06-12 08:28:452018-06-12 08:27:45f3A)33$WSaborted2018-06-12 08:27:452018-06-12 09:20:45.8782935˱CfShipit::DeployVtf2018-06-12 08:27:452018-06-12 08:26:45f3A)33$WSsuccess2018-06-12 08:26:452018-06-12 09:20:45.8782935˱CfShipit::DeployVff2018-06-12 08:26:452018-06-12 08:28:45f3A)3$WSrunning2018-06-12 08:25:452018-06-12 09:20:45.878293>vfShipit::DeployVft2018-06-12 08:25:45fh3A)$WSpending2018-06-12 08:24:452018-06-12 09:20:45.878293fShipit::DeployftfA3A%u33$WSsuccess2018-06-12 08:23:452018-06-12 09:20:45.878293>vfShipit::Task{ "id": "restart", "action": "Restart application", "description": "Restart app and job servers", "variables": [ {"name": "FOO", "title": "Set to 0 to foo", "default": 1}, @@ -230,35 +247,52 @@ ], "steps": [ "cap $ENVIRONMENT deploy:restart" ] } -ff2018-04-26 12:50:492018-04-26 12:51:49f3A)33$WSfailed2018-04-26 12:49:492018-04-26 13:47:49.903257>vfShipit::Deploy @ff2018-04-26 12:49:492018-04-26 12:51:49f  3A) 33$WSsuccess2018-04-26 12:48:492018-04-26 13:47:49.903257>vfShipit::Deployff2018-04-26 12:48:492018-04-26 12:50:49f - zX6!3f2018-04-26 12:48:49success !3f2018-04-26 12:55:49aborted!3f2018-04-26 12:54:49aborted!3f2018-04-26 12:53:49success!3f2018-04-26 12:52:49running!3f2018-04-26 12:51:49pending!3f2018-04-26 12:50:49success 3f2018-04-26 12:49:49failed 3 f2018-04-26 12:48:49success - e  - WW}j(Hfsuccess $WSfaborted$WSfaborted$WSfsuccess$WStrunning$WStpending$WSfsuccess$WSffailed $WSfsuccess -  +ff2018-06-12 08:23:452018-06-12 08:24:45f3A)33$WSfailed2018-06-12 08:22:452018-06-12 09:20:45.878293>vfShipit::Deploy @ff2018-06-12 08:22:452018-06-12 08:24:45f  3A) 33$WSsuccess2018-06-12 08:21:452018-06-12 09:20:45.878293>vfShipit::Deployff2018-06-12 08:21:452018-06-12 08:23:45f + +zX6!3f2018-06-12 08:23:45success +!3f2018-06-12 08:21:45success !3f2018-06-12 08:28:45aborted!3f2018-06-12 08:27:45aborted!3f2018-06-12 08:26:45success!3f2018-06-12 08:25:45running!3f2018-06-12 08:24:45pending!3f2018-06-12 08:23:45success 3f2018-06-12 08:22:45failed 3 f2018-06-12 08:21:45success + + +e  + +DW}jD$WSfsuccess +(Hfsuccess $WSfaborted$WSfaborted$WSfsuccess$WStrunning$WStpending$WSfsuccess$WSffailed $WSfsuccess + + +$WSf + (Hf $WSf $WSf $WSf $WSt $WSt $WSf $WSf  $WSf - $dD)(HsuccessShipit::Deploy !-$WSabortedShipit::Rollback)$WSabortedShipit::Deploy)$WSsuccessShipit::Deploy)$WSrunningShipit::Deploy)$WSpendingShipit::Deploy%$WSsuccessShipit::Task)$WSfailedShipit::Deploy) $WSsuccessShipit::Deploy - mT8)Shipit::Deploy(H -Shipit::Rollback$WS)Shipit::Deploy$WS)Shipit::Deploy$WS)Shipit::Deploy$WS)Shipit::Deploy$WS%Shipit::Task$WS)Shipit::Deploy$WS) Shipit::Deploy$WS - e   - >v 5˱C5˱C5˱C>v>v>v >v   r QAAhttps://example.com/cyclimse/cookscooksCookscyclimse2018-04-26 13:47:49.8756032018-04-26 13:47:49.875603~ Y!!AAhttps://example.com/shopify/developersdevelopersDevelopersshopify2018-04-26 13:47:49.8756032018-04-26 13:47:49.875603 -cyclimsecooks! shopifydevelopers   9cn /1AAE/Legacy Walrussianlegacy@shopify.comlegacy2018-04-26 13:47:49.8822892018-04-26 13:47:49.882289FuQv9jpHmMZ8Px64xmqASJtKlefvQNS4smChXEXtOjxb -US #AAI4Shipitshipit[bot]2018-04-26 13:47:49.8822892018-04-26 13:47:49.882289e1 -7AAAnonymous Legionanonymous@example.com2018-04-26 13:47:49.8822892018-04-26 13:47:49.882289_C +#AABob the Builderbob@bob.combob2018-04-26 13:47:49.8822892018-04-26 13:47:49.882289ڷ -1AAG/Lando Walrussianwalrus@shopify.comwalrus2018-04-26 13:47:49.8822892018-04-26 13:47:49.882289ffHk4diyVKppJGfwfJefMizxF45H + +$dD%$WSsuccessShipit::Task +)(HsuccessShipit::Deploy !-$WSabortedShipit::Rollback)$WSabortedShipit::Deploy)$WSsuccessShipit::Deploy)$WSrunningShipit::Deploy)$WSpendingShipit::Deploy%$WSsuccessShipit::Task)$WSfailedShipit::Deploy) $WSsuccessShipit::Deploy + +mT8%Shipit::Task$WS +)Shipit::Deploy(H -Shipit::Rollback$WS)Shipit::Deploy$WS)Shipit::Deploy$WS)Shipit::Deploy$WS)Shipit::Deploy$WS%Shipit::Task$WS)Shipit::Deploy$WS) Shipit::Deploy$WS + + +e   + +>v +>v 5˱C5˱C5˱C>v>v>v >v   r QAAhttps://example.com/cyclimse/cookscooksCookscyclimse2018-06-12 09:20:45.8494092018-06-12 09:20:45.849409~ Y!!AAhttps://example.com/shopify/developersdevelopersDevelopersshopify2018-06-12 09:20:45.8494092018-06-12 09:20:45.849409 +cyclimsecooks! shopifydevelopers   9cn /1AAE/Legacy Walrussianlegacy@shopify.comlegacy2018-06-12 09:20:45.8553622018-06-12 09:20:45.855362FuQv9jpHmMZ8Px64xmqASJtKlefvQNS4smChXEXtOjxb +US #AAI4Shipitshipit[bot]2018-06-12 09:20:45.8553622018-06-12 09:20:45.855362e1 -7AAAnonymous Legionanonymous@example.com2018-06-12 09:20:45.8553622018-06-12 09:20:45.855362_C +#AABob the Builderbob@bob.combob2018-06-12 09:20:45.8553622018-06-12 09:20:45.855362ڷ -1AAG/Lando Walrussianwalrus@shopify.comwalrus2018-06-12 09:20:45.8553622018-06-12 09:20:45.855362ffHk4diyVKppJGfwfJefMizxF45H gRSldoTZ+fmrIDoY <eGK   ~De6N955?tablear_internal_metadataar_internal_metadata>CREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G:[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadata?x7//tableschema_migrationsschema_migrations<CREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)A8U/indexsqlite_autoindex_schema_migrations_1schema_migrations=m6?indexindex_users_on_updated_atusers;CREATE INDEX "index_users_on_updated_at" ON "users" ("updated_at")]55}indexindex_users_on_loginusers:CREATE INDEX "index_users_on_login" ON "users" ("login")j4= indexindex_users_on_github_idusers9CREATE INDEX "index_users_on_github_id" ON "users" ("github_id")t3Gtableusersusers7CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "github_id" integer(4), "name" varchar(255) NOT NULL, "email" varchar(255), "login" varchar(39), "api_url" varchar(255), "created_at" datetime, "updated_at" datetime, "avatar_url" varchar(255), "encrypted_github_access_token" varchar, "encrypted_github_access_token_iv" varchar)2UIindexindex_teams_on_organization_and_slugteams6CREATE UNIQUE INDEX "index_teams_on_organization_and_slug" ON "teams" ("organization", "slug")1tableteamsteams5CREATE TABLE "teams" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "github_id" integer(4), "api_url" varchar(255), "slug" varchar(50), "name" varchar(255), "organization" varchar(39), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)d09indexindex_tasks_on_user_idtasks4CREATE INDEX "index_tasks_on_user_id" ON "tasks" ("user_id")|/I%indexindex_tasks_on_until_commit_idtasks3CREATE INDEX "index_tasks_on_until_commit_id" ON "tasks" ("until_commit_id") .KCindexindex_tasks_by_stack_and_parenttasks2CREATE INDEX "index_tasks_by_stack_and_parent" ON "tasks" ("type", "stack_id", "parent_id") -K=indexindex_tasks_by_stack_and_statustasks1CREATE INDEX "index_tasks_by_stack_and_status" ON "tasks" ("stack_id", "status", "type")(,g_indexindex_tasks_on_stack_id_and_allow_concurrencytasks0CREATE INDEX "index_tasks_on_stack_id_and_allow_concurrency" ON "tasks" ("stack_id", "allow_concurrency")|+1=indexindex_active_taskstasks/CREATE INDEX "index_active_tasks" ON "tasks" ("stack_id", "allow_concurrency", "status")|*I%indexindex_tasks_on_since_commit_idtasks.CREATE INDEX "index_tasks_on_since_commit_id" ON "tasks" ("since_commit_id")6)qqindexindex_tasks_on_rolled_up_and_created_at_and_statustasks-CREATE INDEX "index_tasks_on_rolled_up_and_created_at_and_status" ON "tasks" ("rolled_up", "created_at", "status")  I4$WS1 5˱C>v  legacy #shipit[bot]$WS1 bob5˱C walrus>v -VVx!A2018-04-26 13:47:49.882289 !A2018-04-26 13:47:49.882289$WS!A2018-04-26 13:47:49.8822891!A2018-04-26 13:47:49.8822895˱C!A2018-04-26 13:47:49.882289>v 1 p^L:(tbP>, x f T B 0  1)201701301136330)20160502150713/)20170320124156.)20151102201634-)20170209160355,)20170524104615+)20150708143032*)20150518214944))20160802092812()20160303163611')20170215123538&)20170524084548%)20170314145604$)20160303203940#)20170310164315")20170208143657!)20150630154640 )20160210183823)20151112152112)20170629141736)20161206104224)20160426155146)20161206104100)20151113151323)20151103144716)20160104151742)20161205144522)20150918190012)20161206105318)20170221102128)20150515190352)20171120161420)20161206104817)20170904103242)20170208154609)20160122165559 )20170221130336 )20160526192650 )20160822131405 +VVx!A2018-06-12 09:20:45.855362 !A2018-06-12 09:20:45.855362$WS!A2018-06-12 09:20:45.8553621!A2018-06-12 09:20:45.8553625˱C!A2018-06-12 09:20:45.855362>v 1 p^L:(tbP>, x f T B 0  1)201701301136330)20160502150713/)20170320124156.)20151102201634-)20170209160355,)20170524104615+)20150708143032*)20150518214944))20160802092812()20160303163611')20170215123538&)20170524084548%)20170314145604$)20160303203940#)20170310164315")20170208143657!)20150630154640 )20160210183823)20151112152112)20170629141736)20161206104224)20160426155146)20161206104100)20151113151323)20151103144716)20160104151742)20161205144522)20150918190012)20161206105318)20170221102128)20150515190352)20171120161420)20161206104817)20170904103242)20170208154609)20160122165559 )20170221130336 )20160526192650 )20160822131405 )20180202220850 )20160303170913)20170524125249)20150814182557)20160104151833)20151112152113)20160324155046)20140226233935)20170220152410)20180417130436 1 ^ |_ & 9 V U q 0L r ^ {  h B / i C)201701301136331)201605021507130)20170320124156/)20151102201634.)20170209160355-)20170524104615,)20150708143032+)20150518214944*)20160802092812))20160303163611()20170215123538')20170524084548&)20170314145604%)20160303203940$)20170310164315#)20170208143657")20150630154640!)20160210183823 )20151112152112)20170629141736)20161206104224)20160426155146)20161206104100)20151113151323)20151103144716)20160104151742)20161205144522)20150918190012)20161206105318)20170221102128)20150515190352)20171120161420)20161206104817)20170904103242)20170208154609)20160122165559)20170221130336 )20160526192650 )20160822131405 )20180202220850 )20160303170913 )20170524125249)20150814182557)20160104151833)20151112152113)20160324155046)20140226233935)20170220152410) 20180417130436 O##AAH#AAenvironmenttest2018-04-26 13:45:50.8974512018-04-26 13:45:50.900894 # environment \ No newline at end of file