def migrate_up(manager):
|
manager.execute_script(CREATE_INDICES)
|
|
|
def migrate_down(manager):
|
manager.execute_script(DROP_INDICES)
|
|
|
CREATE_INDICES = """
|
CREATE INDEX job_idx ON tests (job_idx);
|
CREATE INDEX reason ON tests (reason);
|
CREATE INDEX test ON tests (test);
|
CREATE INDEX subdir ON tests (subdir);
|
CREATE INDEX printable ON kernels (printable);
|
CREATE INDEX word ON status (word);
|
CREATE INDEX attribute ON test_attributes (attribute);
|
CREATE INDEX value ON test_attributes (value);
|
CREATE INDEX attribute ON iteration_result (attribute);
|
CREATE INDEX value ON iteration_result (value);
|
"""
|
|
|
DROP_INDICES = """
|
DROP INDEX job_idx ON tests;
|
DROP INDEX reason ON tests;
|
DROP INDEX test ON tests;
|
DROP INDEX subdir ON tests;
|
DROP INDEX printable ON kernels;
|
DROP INDEX word ON status;
|
DROP INDEX attribute ON test_attributes;
|
DROP INDEX value ON test_attributes;
|
DROP INDEX attribute ON iteration_result;
|
DROP INDEX value ON iteration_result;
|
"""
|
