def migrate_up(manager):
|
manager.execute_script(CREATE_TABLE_SQL)
|
|
def migrate_down(manager):
|
manager.execute_script(DROP_TABLE_SQL)
|
|
|
CREATE_TABLE_SQL = """
|
-- test iteration attributes (key value pairs at an iteration level)
|
CREATE TABLE iteration_attributes (
|
test_idx int(10) unsigned NOT NULL, -- ref to test table
|
FOREIGN KEY (test_idx) REFERENCES tests(test_idx) ON DELETE CASCADE,
|
iteration INTEGER, -- integer
|
attribute VARCHAR(30), -- attribute name (e.g. 'run_id')
|
value VARCHAR(100), -- attribute value
|
KEY `test_idx` (`test_idx`)
|
) TYPE=InnoDB;
|
"""
|
|
DROP_TABLE_SQL = """
|
DROP TABLE iteration_attributes;
|
"""
|
