[autotest] Add new columns to JobHandoff
Migration has to run before schema change.
Make existing rows be completed. Nothing is using JobHandoff except
for testing, but old handoffs should not trigger job_aborter.
BUG=chromium:748234
TEST=/usr/local/autotest/database/migrate.py sync
Change-Id: If95c7bc84130b2c6cb141df5d1424490caa5caf1
Reviewed-on: https://chromium-review.googlesource.com/780766
Commit-Ready: Allen Li <ayatane@chromium.org>
Tested-by: Allen Li <ayatane@chromium.org>
Reviewed-by: Prathmesh Prabhu <pprabhu@chromium.org>
Reviewed-by: Dan Shi <dshi@google.com>
diff --git a/frontend/migrations/122_add_job_handoff_completed_columns.py b/frontend/migrations/122_add_job_handoff_completed_columns.py
new file mode 100644
index 0000000..091ca46
--- /dev/null
+++ b/frontend/migrations/122_add_job_handoff_completed_columns.py
@@ -0,0 +1,11 @@
+UP_SQL = """
+ALTER TABLE afe_job_handoffs ADD COLUMN (
+ created datetime NOT NULL,
+ completed tinyint(1) NOT NULL
+);
+UPDATE afe_job_handoffs SET completed = 1;
+"""
+
+DOWN_SQL = """
+ALTER TABLE afe_job_handoffs DROP COLUMN created, DROP COLUMN completed;
+"""