1def migrate_up(manager): 2 manager.execute_script(CREATE_INDICES) 3 4 5def migrate_down(manager): 6 manager.execute_script(DROP_INDICES) 7 8 9CREATE_INDICES = """ 10CREATE INDEX job_idx ON tests (job_idx); 11CREATE INDEX reason ON tests (reason); 12CREATE INDEX test ON tests (test); 13CREATE INDEX subdir ON tests (subdir); 14CREATE INDEX printable ON kernels (printable); 15CREATE INDEX word ON status (word); 16CREATE INDEX attribute ON test_attributes (attribute); 17CREATE INDEX value ON test_attributes (value); 18CREATE INDEX attribute ON iteration_result (attribute); 19CREATE INDEX value ON iteration_result (value); 20""" 21 22 23DROP_INDICES = """ 24DROP INDEX job_idx ON tests; 25DROP INDEX reason ON tests; 26DROP INDEX test ON tests; 27DROP INDEX subdir ON tests; 28DROP INDEX printable ON kernels; 29DROP INDEX word ON status; 30DROP INDEX attribute ON test_attributes; 31DROP INDEX value ON test_attributes; 32DROP INDEX attribute ON iteration_result; 33DROP INDEX value ON iteration_result; 34""" 35