blob: 2bbbfc9a26556923e14a8afab0970cfe947c71c7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
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;
"""
|
