test/dummy/db/test.sqlite3 in shipit-engine-0.12.0 vs test/dummy/db/test.sqlite3 in shipit-engine-0.12.1
- old
+ new
@@ -1,57 +1,57 @@
-SQLite format 3 @ d . ) d -r &
+SQLite format 3 @ e . ) e -r &
q,8 ']%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))u!!5tabledeliveriesdeliveriesCREATE TABLE "deliveries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "hook_id" integer(4) NOT NULL, "status" varchar(255) DEFAULT 'pending' NOT NULL, "url" varchar(4096) NOT NULL, "content_type" varchar(255) NOT NULL, "event" varchar(255) 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")uCindexindex_commits_on_created_atcommits
CREATE INDEX "index_commits_on_created_at" ON "commits" ("created_at"){G!indexindex_commits_on_committer_idcommitsCREATE INDEX "index_commits_on_committer_id" ON "commits" ("committer_id")r
Aindexindex_commits_on_author_idcommitsCREATE INDEX "index_commits_on_author_id" ON "commits" ("author_id")N stablecommitscommits
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))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" i
a iǭG /AA5---
- read:stack
->v2016-09-20 10:28:21.9323332016-09-20 10:28:21.932333Here Come The Walrus$WSw 5AA ---
+>v2016-09-22 08:40:13.2010062016-09-22 08:40:13.201006Here Come The Walrus$WSw 5AA ---
- read:stack
- write:stack
- deploy:stack
- lock:stack
- read:hook
- write:hook
->v2016-09-20 10:28:21.9323332016-09-20 10:28:21.932333Spy
ykWA2! users>v
teams tasksstatuses>S
+>v2016-09-22 08:40:13.2010062016-09-22 08:40:13.201006Spy
ykWA2! users>v
teams tasksstatuses>S
stacks?N 'output_chunks>X|&#membershipshooks>I%github_hooks=!deliveriescommits1commit_deployments7P!Acommit_deployment_statuses4Z#api_clients/w
- >v$>v/w
/ e/| G֚k AASfailure2016-09-20 10:28:21.9516932016-09-20 10:28:21.951693G AASpending2016-09-20 10:28:21.9516932016-09-20 10:28:21.951693 %AAusuccess+https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/432016-09-20 10:28:21.9516932016-09-20 10:28:21.951693 %AAupending*https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/422016-09-20 10:28:21.9516932016-09-20 10:28:21.951693
- SkS!u4Zu3
}o
`+ >ǦE AA2016-09-20 10:28:21.9559472016-09-20 10:28:21.955947>
AA2016-09-20 10:28:21.9559472016-09-20 10:28:21.955947>l AA2016-09-20 10:28:21.9559472016-09-20 10:28:21.955947>= AA2016-09-20 10:28:21.9559472016-09-20 10:28:21.955947>P AA2016-09-20 10:28:21.9559472016-09-20 10:28:21.955947
AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/32016-09-20 10:28:21.9559472016-09-20 10:28:21.955947 S
AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/22016-09-20 10:28:21.9559472016-09-20 10:28:21.955947~u
AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/12016-09-20 10:28:21.9559472016-09-20 10:28:21.955947
+ >v$>v/w
/ e/| G֚k AASfailure2016-09-22 08:40:13.2080602016-09-22 08:40:13.208060G AASpending2016-09-22 08:40:13.2080602016-09-22 08:40:13.208060 %AAusuccess+https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/432016-09-22 08:40:13.2080602016-09-22 08:40:13.208060 %AAupending*https://api.github.com/repos/shopify/shipit-engine/deployments/1/statuses/422016-09-22 08:40:13.2080602016-09-22 08:40:13.208060
+ SkS!u4Zu3
}o
`+ >ǦE AA2016-09-22 08:40:13.2179522016-09-22 08:40:13.217952>
AA2016-09-22 08:40:13.2179522016-09-22 08:40:13.217952>l AA2016-09-22 08:40:13.2179522016-09-22 08:40:13.217952>= AA2016-09-22 08:40:13.2179522016-09-22 08:40:13.217952>P AA2016-09-22 08:40:13.2179522016-09-22 08:40:13.217952
AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/32016-09-22 08:40:13.2179522016-09-22 08:40:13.217952 S
AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/22016-09-22 08:40:13.2179522016-09-22 08:40:13.217952~u
AAhttps://api.github.com/repos/shopify/shipit-engine/deployments/12016-09-22 08:40:13.2179522016-09-22 08:40:13.217952
E
2D
2:X ɽ
7P
S u
- E2D2:X ɽ7PS u
Q ^
<Q * ]3AAA ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2016-09-16 11:44:472016- ]A333 ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2016-09-20 10:28:21.9620452016-09-12 10:28:21f2016-09-18 10:28:212016-09-19 10:28:21 ]A333 /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2016-09-20 10:28:21.9620452016-09-12 10:28:21f2016-09-18 10:28:212016-09-19 10:28:21) ]1A333 $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all teh things2016-09-20 10:28:21.9620452016-09-12 10:28:21f2016-09-18 10:28:212016-09-19 10:28:21[ ]
A333$WS>v>v467578b362bf2b4df5903e1c7960929361c3435aMerge pull request #7 from shipit-engine/yoloshipit
+ E2D2:X ɽ7PS u
Q ^
<Q * ]3AAA ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2016-09-16 11:44:472016- ]A333 ?N5˱C5˱C44b3833d39def7ec65b57b42f496eb27ab4980b6Cake!2016-09-22 08:40:13.2238822016-09-14 08:40:13f2016-09-20 08:40:132016-09-21 08:40:13 ]A333 /Uk5˱C5˱C8e859b4c19ea7638443d43d612086948bce51701Chips!2016-09-22 08:40:13.2238822016-09-14 08:40:13f2016-09-20 08:40:132016-09-21 08:40:13) ]1A333 $WS>v>v567578b362bf2b4df5903e1c7960929361c3abcdfix all teh things2016-09-22 08:40:13.2238822016-09-14 08:40:13f2016-09-20 08:40:132016-09-21 08:40:13[ ]
A333$WS>v>v467578b362bf2b4df5903e1c7960929361c3435aMerge pull request #7 from shipit-engine/yoloshipit
-yoloshipit!2016-09-20 10:28:21.9620452016-09-12 10:28:21f2016-09-16 10:28:212016-09-17 10:28:21V ]A333$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2016-09-20 10:28:21.9620452016-09-12 10:28:21f2016-09-14 10:28:212016-09-15 10:28:21@ ]A333 $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2016-09-20 10:28:21.9620452016-09-12 10:28:21f2016-09-12 10:28:212016-09-13 10:28:21 ]A333$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2016-09-20 10:28:21.9620452016-09-12 10:28:21f2016-09-10 10:28:212016-09-11 10:28:21*
+yoloshipit!2016-09-22 08:40:13.2238822016-09-14 08:40:13f2016-09-18 08:40:132016-09-19 08:40:13V ]A333$WS>v>v367578b362bf2b4df5903e1c7960929361c39074fix it!2016-09-22 08:40:13.2238822016-09-14 08:40:13f2016-09-16 08:40:132016-09-17 08:40:13@ ]A333 $WS>v>vf890fd8b5f2be05d1fedb763a3605ee461c39074sheep it!2016-09-22 08:40:13.2238822016-09-14 08:40:13f2016-09-14 08:40:132016-09-15 08:40:13 ]A333$WS>v>v6d9278037b872fd9a6690523e411ecb3aa181355lets go2016-09-22 08:40:13.2238822016-09-14 08:40:13f2016-09-12 08:40:132016-09-13 08:40:13*
5˱C5˱C>v>v>v>v >v
5˱C5˱C>v>v>v>v >v
- ( fG( A2016-09-20 10:28:21.962045A2016-09-20 10:28:21.962045A2016-09-20 10:28:21.962045A2016-09-20 10:28:21.962045A2016-09-20 10:28:21.962045A2016-09-20 10:28:21.962045A 2016-09-20 10:28:21.962045
+ ( fG( A2016-09-22 08:40:13.223882A2016-09-22 08:40:13.223882A2016-09-22 08:40:13.223882A2016-09-22 08:40:13.223882A2016-09-22 08:40:13.223882A2016-09-22 08:40:13.223882A 2016-09-22 08:40:13.223882
?N/Uk$WS$WS$WS$WS $WS
L L -\ O-[ AAHscheduledhttps://example.com/events/deployapplication/jsondeploy{
"stack": {
},
"deploy": {
}
-}2016-09-20 10:28:21.9704382016-09-20 10:28:21.970438
G G* t{ !AA Mmembership2016-09-20 10:28:21.9729122016-09-20 10:28:21.9729121234Shipit::GithubHook::Organizationshopifyc擄 AA = /Ukpush2016-09-20 10:28:21.9729122016-09-20 10:28:21.9729121234Shipit::GithubHook::Repof↨o AA = $WS+status2016-09-20 10:28:21.9729122016-09-20 10:28:21.9729121234Shipit::GithubHook::Repody AA = $WS*push2016-09-20 10:28:21.9729122016-09-20 10:28:21.9729121234Shipit::GithubHook::Repo
+}2016-09-22 08:40:13.2309212016-09-22 08:40:13.230921
G G* t{ !AA Mmembership2016-09-22 08:40:13.2336272016-09-22 08:40:13.2336271234Shipit::GithubHook::Organizationshopifyc擄 AA = /Ukpush2016-09-22 08:40:13.2336272016-09-22 08:40:13.2336271234Shipit::GithubHook::Repof↨o AA = $WS+status2016-09-22 08:40:13.2336272016-09-22 08:40:13.2336271234Shipit::GithubHook::Repody AA = $WS*push2016-09-22 08:40:13.2336272016-09-22 08:40:13.2336271234Shipit::GithubHook::Repo
!shopifymembership{ push= status<Ao pushGy
!membership{/Ukpush=$WSstatus<Ao$WSpushGy
|@
- ] 'AA/Ukhttps://example.com/events/deploy_statusjsondeploy_statusf2016-09-20 10:28:21.9778962016-09-20 10:28:21.977896|
- ] 'AA$WShttps://example.com/events/commit_statusjsoncommit_statusf2016-09-20 10:28:21.9778962016-09-20 10:28:21.977896l{
- O AA$WShttps://example.com/events/deployjsontaskf2016-09-20 10:28:21.9778962016-09-20 10:28:21.977896s
- O +AAhttps://example.com/events/deployformdeploy,rollbackf2016-09-20 10:28:21.9778962016-09-20 10:28:21.977896wH
- O +AA$WShttps://example.com/events/deployjsondeploy,rollbackf2016-09-20 10:28:21.9778962016-09-20 10:28:21.977896
+ ] 'AA/Ukhttps://example.com/events/deploy_statusjsondeploy_statusf2016-09-22 08:40:13.2377532016-09-22 08:40:13.237753|
+ ] 'AA$WShttps://example.com/events/commit_statusjsoncommit_statusf2016-09-22 08:40:13.2377532016-09-22 08:40:13.237753l{
+ O AA$WShttps://example.com/events/deployjsontaskf2016-09-22 08:40:13.2377532016-09-22 08:40:13.237753s
+ O +AAhttps://example.com/events/deployformdeploy,rollbackf2016-09-22 08:40:13.2377532016-09-22 08:40:13.237753wH
+ O +AA$WShttps://example.com/events/deployjsondeploy,rollbackf2016-09-22 08:40:13.2377532016-09-22 08:40:13.237753
q,8 ']%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))u!!5tabledeliveriesdeliveriesCREATE TABLE "deliveries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "hook_id" integer(4) NOT NULL, "status" varchar(255) DEFAULT 'pending' NOT NULL, "url" varchar(4096) NOT NULL, "content_type" varchar(255) NOT NULL, "event" varchar(255) 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")uCindexindex_commits_on_created_atcommits
CREATE INDEX "index_commits_on_created_at" ON "commits" ("created_at"){G!indexindex_commits_on_committer_idcommitsCREATE INDEX "index_commits_on_committer_id" ON "commits" ("committer_id")r
Aindexindex_commits_on_author_idcommitsCREATE INDEX "index_commits_on_author_id" ON "commits" ("author_id")N stablecommitscommits
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))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))
`
9?
s !KCindexindex_tasks_by_stack_and_parenttasks$CREATE INDEX "index_tasks_by_stack_and_parent" ON "tasks" ("type", "stack_id", "parent_id")| 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")6qqindexindex_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")Ttabletaskstasks 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" t']%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))etablestacksstacksCREATE 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)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)
- /Uk&NI$WS>I$WS#fi{ Ͽ$WSH
>H AA>v2016-09-20 10:28:21.9834132016-09-20 10:28:21.983413
+ /Uk&NI$WS>I$WS#fi{ Ͽ$WSH
>H AA>v2016-09-22 08:40:13.2435992016-09-22 08:40:13.243599
>v
- >v
q `q
P
a Nʑ* 3AAsudo chmod -R 777 /2016-09-20 10:28:21.9871542016-09-20 10:28:21.987154H 'AAsudo rm -rf /2016-09-20 10:28:21.9871542016-09-20 10:28:21.987154I )AAMaking ops cry2016-09-20 10:28:21.9871542016-09-20 10:28:21.987154Q& 9AACompiling all the sass2016-09-20 10:28:21.9871542016-09-20 10:28:21.987154O 5AAMigrating some stuff2016-09-20 10:28:21.9871542016-09-20 10:28:21.987154M 3AAsudo chmod -R 777 /2016-09-20 10:28:21.9871542016-09-20 10:28:21.987154G! 'AAsudo rm -rf /2016-09-20 10:28:21.9871542016-09-20 10:28:21.987154Hޫ8 )AAMaking ops cry2016-09-20 10:28:21.9871542016-09-20 10:28:21.987154P̀ 9AACompiling all the sass2016-09-20 10:28:21.9871542016-09-20 10:28:21.987154N 5AAMigrating some stuff2016-09-20 10:28:21.9871542016-09-20 10:28:21.987154VS EAAdeploy deploy deploy, faiiil2016-09-20 10:28:21.9871542016-09-20 10:28:21.987154
- 2; <>X|&&j ! 6 ( 0 $WS
4 U: !A3 s foo-barshopifyproduction2016-09-20 10:28:21.9919032016-09-12 10:28:21masterf{
+ >v
q `q
P
a Nʑ* 3AAsudo chmod -R 777 /2016-09-22 08:40:13.2457322016-09-22 08:40:13.245732H 'AAsudo rm -rf /2016-09-22 08:40:13.2457322016-09-22 08:40:13.245732I )AAMaking ops cry2016-09-22 08:40:13.2457322016-09-22 08:40:13.245732Q& 9AACompiling all the sass2016-09-22 08:40:13.2457322016-09-22 08:40:13.245732O 5AAMigrating some stuff2016-09-22 08:40:13.2457322016-09-22 08:40:13.245732M 3AAsudo chmod -R 777 /2016-09-22 08:40:13.2457322016-09-22 08:40:13.245732G! 'AAsudo rm -rf /2016-09-22 08:40:13.2457322016-09-22 08:40:13.245732Hޫ8 )AAMaking ops cry2016-09-22 08:40:13.2457322016-09-22 08:40:13.245732P̀ 9AACompiling all the sass2016-09-22 08:40:13.2457322016-09-22 08:40:13.245732N 5AAMigrating some stuff2016-09-22 08:40:13.2457322016-09-22 08:40:13.245732VS EAAdeploy deploy deploy, faiiil2016-09-22 08:40:13.2457322016-09-22 08:40:13.245732
+ 2; <>X|&&j ! 6 ( 0 $WS
4 U: !A3 s foo-barshopifyproduction2016-09-22 08:40:13.2498102016-09-14 08:40:13masterf{
"machine": {"environment": {}},
"review": {
"checklist": ["foo", "bar", "baz"],
"monitoring": [
{"image": "https://example.com/monitor.png", "width": 200, "height": 300}
@@ -73,11 +73,11 @@
"ci": {
"hide": ["ci/hidden"],
"allow_failures": ["ci/ok_to_fail"]
}
}
-t%k !A3 cyclimsegeorgeproduction2016-09-20 10:28:21.9919032016-09-12 10:28:21masterf{
+t%k !A3 cyclimsegeorgeproduction2016-09-22 08:40:13.2498102016-09-14 08:40:13masterf{
"machine": {"environment": {}},
"review": {
"checklist": ["foo", "bar", "baz"],
"monitoring": [
{"image": "https://example.com/monitor.png", "width": 200, "height": 300}
@@ -95,11 +95,11 @@
"cap $ENVIRONMENT deploy:restart"
]
}
}
}
-fES '!A3 E shipit-engineshopifyproduction2016-09-20 10:28:21.9919032016-09-12 10:28:21masterf{
+fES '!A3 E shipit-engineshopifyproduction2016-09-22 08:40:13.2498102016-09-14 08:40:13masterf{
"machine": {"environment": {}},
"review": {
"checklist": ["foo", "bar", "baz"],
"monitoring": [
{"image": "https://example.com/monitor.png", "width": 200, "height": 300}
@@ -135,15 +135,15 @@
"allow_failures": ["ci/ok_to_fail"]
}
}
f
!!shopifyfoo-barproduction?N!!georgecyclimseproduction/Uk''!shopifyshipit-engineproduction$WS
-
R.
v
( dϩ0 93Asuccesshttp://www.example.comlets goci/travis2016-09-11 10:28:212016-09-20 10:28:21.995758l- 9/3Asuccesshttp://www.example.comlets gometrics/coveralls2016-09-11 10:28:212016-09-20 10:28:21.995758dΕ 93Apendinghttp://www.example.comlets goci/travis2016-09-11 10:28:212016-09-20 10:28:21.995758lL 9/3Asuccesshttp://www.example.comlets gometrics/coveralls2016-09-11 10:28:212016-09-20 10:28:21.995758d' 93Asuccesshttp://www.example.comlets goci/travis2016-09-11 10:28:212016-09-20 10:28:21.995758l 9/3Afailurehttp://www.example.comlets gometrics/coveralls2016-09-11 10:28:212016-09-20 10:28:21.995758d˺c 93Asuccesshttp://www.example.comlets goci/travis2016-09-11 10:28:212016-09-20 10:28:21.995758l劔W 9/3Apendinghttp://www.example.comlets gometrics/coveralls2016-09-10 10:28:212016-09-20 10:28:21.995758du 93Apendinghttp://www.example.comlets goci/travis2016-09-10 10:28:212016-09-20 10:28:21.995758cH 9 3Apendinghttp://www.example.comlets goci/travis2016-09-10 10:28:212016-09-20 10:28:21.995758
+
R.
v
( dϩ0 93Asuccesshttp://www.example.comlets goci/travis2016-09-13 08:40:132016-09-22 08:40:13.253413l- 9/3Asuccesshttp://www.example.comlets gometrics/coveralls2016-09-13 08:40:132016-09-22 08:40:13.253413dΕ 93Apendinghttp://www.example.comlets goci/travis2016-09-13 08:40:132016-09-22 08:40:13.253413lL 9/3Asuccesshttp://www.example.comlets gometrics/coveralls2016-09-13 08:40:132016-09-22 08:40:13.253413d' 93Asuccesshttp://www.example.comlets goci/travis2016-09-13 08:40:132016-09-22 08:40:13.253413l 9/3Afailurehttp://www.example.comlets gometrics/coveralls2016-09-13 08:40:132016-09-22 08:40:13.253413d˺c 93Asuccesshttp://www.example.comlets goci/travis2016-09-13 08:40:132016-09-22 08:40:13.253413l劔W 9/3Apendinghttp://www.example.comlets gometrics/coveralls2016-09-12 08:40:132016-09-22 08:40:13.253413du 93Apendinghttp://www.example.comlets goci/travis2016-09-12 08:40:132016-09-22 08:40:13.253413cH 9 3Apendinghttp://www.example.comlets goci/travis2016-09-12 08:40:132016-09-22 08:40:13.253413
>S3VjL'd/mncWiu YH
s
#>
- A3- AA$WSaborted2016-09-16 10:52:47.0000002016-09-16 11:44:475˱CfShip 3A- 33$WSaborted2016-09-20 09:36:212016-09-20 10:28:22.0003635˱CfShipit::RollbackVff2016-09-20 09:36:212016-09-20 09:35:21 3A) 33$WSaborted2016-09-20 09:35:212016-09-20 10:28:22.0003635˱CfShipit::DeployVtf2016-09-20 09:35:212016-09-20 09:34:21 3A) 33$WSsuccess2016-09-20 09:34:212016-09-20 10:28:22.0003635˱CfShipit::DeployVff2016-09-20 09:34:212016-09-20 09:36:21| 3A) 3 $WSrunning2016-09-20 09:33:212016-09-20 10:28:22.000363>vfShipit::DeployVff2016-09-20 09:33:21e 3A ) $WSpending2016-09-20 09:32:212016-09-20 10:28:22.000363fShipit::Deployff> 3A% u 33$WSsuccess2016-09-20 09:31:212016-09-20 10:28:22.000363>vfShipit::Task{
+ A3- AA$WSaborted2016-09-16 10:52:47.0000002016-09-16 11:44:475˱CfShip 3A- 33$WSaborted2016-09-22 07:48:132016-09-22 08:40:13.2580775˱CfShipit::RollbackVff2016-09-22 07:48:132016-09-22 07:47:13 3A) 33$WSaborted2016-09-22 07:47:132016-09-22 08:40:13.2580775˱CfShipit::DeployVtf2016-09-22 07:47:132016-09-22 07:46:13 3A) 33$WSsuccess2016-09-22 07:46:132016-09-22 08:40:13.2580775˱CfShipit::DeployVff2016-09-22 07:46:132016-09-22 07:48:13| 3A) 3 $WSrunning2016-09-22 07:45:132016-09-22 08:40:13.258077>vfShipit::DeployVff2016-09-22 07:45:13e 3A ) $WSpending2016-09-22 07:44:132016-09-22 08:40:13.258077fShipit::Deployff> 3A% u 33$WSsuccess2016-09-22 07:43:132016-09-22 08:40:13.258077>vfShipit::Task{
"id": "restart",
"action": "Restart application",
"description": "Restart app and job servers",
"variables": [
{"name": "FOO", "title": "Set to 0 to foo", "default": 1},
@@ -151,21 +151,21 @@
],
"steps": [
"cap $ENVIRONMENT deploy:restart"
]
}
-ff2016-09-20 09:31:212016-09-20 09:32:21 3A) 33$WSfailed2016-09-20 09:30:212016-09-20 10:28:22.000363>vfShipit::Deploy@ff2016-09-20 09:30:212016-09-20 09:32:21
- 3A) 33$WSsuccess2016-09-20 09:29:212016-09-20 10:28:22.000363>vfShipit::Deployff2016-09-20 09:29:212016-09-20 09:31:21
- zX6 (Af2016-09-16 10:52:47.000000aborted(Af2016-09-!3f2016-09-20 09:36:21aborted!3f2016-09-20 09:35:21aborted!3f2016-09-20 09:34:21success!3f2016-09-20 09:33:21running!3f2016-09-20 09:32:21pending!3f2016-09-20 09:31:21success 3f2016-09-20 09:30:21failed 3 f2016-09-20 09:29:21success
+ff2016-09-22 07:43:132016-09-22 07:44:13 3A) 33$WSfailed2016-09-22 07:42:132016-09-22 08:40:13.258077>vfShipit::Deploy@ff2016-09-22 07:42:132016-09-22 07:44:13
+ 3A) 33$WSsuccess2016-09-22 07:41:132016-09-22 08:40:13.258077>vfShipit::Deployff2016-09-22 07:41:132016-09-22 07:43:13
+ zX6 (Af2016-09-16 10:52:47.000000aborted(Af2016-09-!3f2016-09-22 07:48:13aborted!3f2016-09-22 07:47:13aborted!3f2016-09-22 07:46:13success!3f2016-09-22 07:45:13running!3f2016-09-22 07:44:13pending!3f2016-09-22 07:43:13success 3f2016-09-22 07:42:13failed 3 f2016-09-22 07:41:13success
j }j $WSfaborted$WSfaborted$WSfsuccess$WSfrunning$WSfpending$WSfsuccess$WSffailed $WSfsuccess
8 mT8 -Shipit::Rollback$WS) Shipit::Deploy$WS) Shipit::Deploy$WS) Shipit::Deploy$WS) Shipit::Deploy$WS% Shipit::Task$WS) Shipit::Deploy$WS) Shipit::Deploy$WS
$dD !-Shipit::Rollback$WSaborted)Shipit::Deploy$WSaborted)Shipit::Deploy$WSsuccess)Shipit::Deploy$WSrunning)Shipit::Deploy$WSpending%Shipit::Task$WSsuccess)Shipit::Deploy$WSfailed) Shipit::Deploy$WSsuccess
V
N R7S>0c *=//indexunique_schema_migrationsschema_migrations.CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l)//tableschema_migrationsschema_migrations-CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)](5}indexindex_users_on_loginusers,CREATE INDEX "index_users_on_login" ON "users" ("login")t'Gtableusersusers+CREATE 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)&UIindexindex_teams_on_organization_and_slugteams*CREATE UNIQUE INDEX "index_teams_on_organization_and_slug" ON "teams" ("organization", "slug")%tableteamsteams)CREATE 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)d$9indexindex_tasks_on_user_idtasks(CREATE INDEX "index_tasks_on_user_id" ON "tasks" ("user_id")|#I%indexindex_tasks_on_until_commit_idtasks'CREATE INDEX "index_tasks_on_until_commit_id" ON "tasks" ("until_commit_id") "K=indexindex_tasks_by_stack_and_statustasks%CREATE INDEX "index_tasks_by_stack_and_status" ON "tasks" ("type", "stack_id", "status")!KCindexindex_tasks_by_stack_and_parenttasks$CREATE INDEX "index_tasks_by_stack_and_parent" ON "tasks" ("type", "stack_id", "parent_id")| 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")6qqindexindex_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")Ttabletaskstasks 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)vCindexindex_statuses_on_commit_idstatusesCREATE INDEX "index_statuses_on_commit_id" ON "statuses" ("commit_id")+)tablestatusesstatusesCREATE 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)z'Aindexstack_unicitystacksCREATE UNIQUE INDEX "stack_unicity" ON "stacks" ("repo_owner", "repo_name", "environment")
- 5˱C5˱C5˱C>v >v>v >v
r QAAhttps://example.com/cyclimse/cookscooksCookscyclimse2016-09-20 10:28:22.0092322016-09-20 10:28:22.009232~ Y!!AAhttps://example.com/shopify/developersdevelopersDevelopersshopify2016-09-20 10:28:22.0092322016-09-20 10:28:22.009232
- cyclimsecooks! shopifydevelopers
0c n /1 AA E/Legacy Walrussianlegacy@shopify.comlegacy2016-09-20 10:28:22.0133362016-09-20 10:28:22.013336FuQv9jpHmMZ8Px64xmqASJtKlefvQNS4smChXEXtOjxb
-^S 1 AA Shipitshipit@example.comshipit2016-09-20 10:28:22.0133362016-09-20 10:28:22.013336e1 -7 AA Anonymous Legionanonymous@example.com2016-09-20 10:28:22.0133362016-09-20 10:28:22.013336_C +# AA Bob the Builderbob@bob.combob2016-09-20 10:28:22.0133362016-09-20 10:28:22.013336ڷ -1 AA G/Lando Walrussianwalrus@shopify.comwalrus2016-09-20 10:28:22.0133362016-09-20 10:28:22.013336ffHk4diyVKppJGfwfJefMizxF45H
+ 5˱C5˱C5˱C>v >v>v >v
r QAAhttps://example.com/cyclimse/cookscooksCookscyclimse2016-09-22 08:40:13.2715792016-09-22 08:40:13.271579~ Y!!AAhttps://example.com/shopify/developersdevelopersDevelopersshopify2016-09-22 08:40:13.2715792016-09-22 08:40:13.271579
+ cyclimsecooks! shopifydevelopers
0c n /1 AA E/Legacy Walrussianlegacy@shopify.comlegacy2016-09-22 08:40:13.2750542016-09-22 08:40:13.275054FuQv9jpHmMZ8Px64xmqASJtKlefvQNS4smChXEXtOjxb
+^S 1 AA Shipitshipit@example.comshipit2016-09-22 08:40:13.2750542016-09-22 08:40:13.275054e1 -7 AA Anonymous Legionanonymous@example.com2016-09-22 08:40:13.2750542016-09-22 08:40:13.275054_C +# AA Bob the Builderbob@bob.combob2016-09-22 08:40:13.2750542016-09-22 08:40:13.275054ڷ -1 AA G/Lando Walrussianwalrus@shopify.comwalrus2016-09-22 08:40:13.2750542016-09-22 08:40:13.275054ffHk4diyVKppJGfwfJefMizxF45H
gRSldoTZ+fmrIDoY
legacy
shipit$WS 1
bob5˱C
walrus>v
>