Un-hardcode the TKO database name in AUTOTEST_WEB migration 45
Signed-off-by: James Ren <[email protected]>
--- autotest/frontend/migrations/045_test_planner_framework.py 2010-02-10
20:32:29.000000000 -0800
+++ autotest/frontend/migrations/045_test_planner_framework.py 2010-02-10
20:32:29.000000000 -0800
@@ -79,7 +79,7 @@
;
ALTER TABLE `planner_test_runs` ADD CONSTRAINT test_runs_plan_id_fk FOREIGN
KEY (`plan_id`) REFERENCES `planner_plans` (`id`);
ALTER TABLE `planner_test_runs` ADD CONSTRAINT test_runs_test_job_id_fk
FOREIGN KEY (`test_job_id`) REFERENCES `planner_test_jobs` (`id`);
-ALTER TABLE `planner_test_runs` ADD CONSTRAINT test_runs_tko_test_id_fk
FOREIGN KEY (`tko_test_id`) REFERENCES `tko`.`tko_tests` (`test_idx`);
+ALTER TABLE `planner_test_runs` ADD CONSTRAINT test_runs_tko_test_id_fk
FOREIGN KEY (`tko_test_id`) REFERENCES `%(tko_db_name)s`.`tko_tests`
(`test_idx`);
CREATE TABLE `planner_data_types` (
@@ -178,7 +178,7 @@
)
;
ALTER TABLE `planner_autoprocess_labels` ADD CONSTRAINT
autoprocess_labels_autoprocess_id_fk FOREIGN KEY (`autoprocess_id`) REFERENCES
`planner_autoprocess` (`id`);
-ALTER TABLE `planner_autoprocess_labels` ADD CONSTRAINT
autoprocess_labels_testlabel_id_fk FOREIGN KEY (`testlabel_id`) REFERENCES
`tko`.`tko_test_labels` (`id`);
+ALTER TABLE `planner_autoprocess_labels` ADD CONSTRAINT
autoprocess_labels_testlabel_id_fk FOREIGN KEY (`testlabel_id`) REFERENCES
`%(tko_db_name)s`.`tko_test_labels` (`id`);
CREATE TABLE `planner_autoprocess_keyvals` (
@@ -252,4 +252,4 @@
raise Exception('You must update the TKO database to at least version '
'31 before applying AUTOTEST_WEB migration 45')
- manager.execute_script(UP_SQL)
+ manager.execute_script(UP_SQL %
dict(tko_db_name=tko_manager.get_db_name()))
_______________________________________________
Autotest mailing list
[email protected]
http://test.kernel.org/cgi-bin/mailman/listinfo/autotest
