如何彻底产出Bugfree中产品及Bug记录
-- 查看删除ProductSHOW CREATE TABLE bf_product\G;
SELECT id,name from bf_product;
-- ①删除BugHistory
DELETE FROM bf_bug_history WHERE bugaction_id IN (SELECT id FROM bf_bug_action WHERE buginfo_id IN (SELECT id FROM bf_bug_info WHERE product_id IN(7,8,9,10)));
-- ②删除BugAction
DELETE FROM bf_bug_action WHERE buginfo_id IN (SELECT id FROM bf_bug_info WHERE product_id IN(7,8,9,10));
-- ③删除BugInfo
DELETE FROM bf_bug_info WHERE product_id IN(9,7,8,10);
-- ④删除MapProductUser
DELETE FROM bf_map_product_user WHERE product_id IN(9,7,8,10);
-- ⑤删除MapProductGroup
DELETE FROM bf_map_product_group WHERE product_id IN(9,7,8,10);
-- 删除外键约束
ALTER table bf_product_module DROP FOREIGN KEY bf__fk_PRODUCTMODULE_PRODUCT1;
ALTER table bf_product_module DROP FOREIGN KEY bf__fk_PRODUCTMODULE_PRODUCTMODULE1;
-- ⑥删除ProductModule（需删除外键约束，然后添加外键约束）
DELETE FROM bf_product_module WHERE product_id IN(9,7,8,10);
-- 添加外键约束
ALTER TABLE bf_product_module ADD CONSTRAINT `bf__fk_PRODUCTMODULE_PRODUCT1` FOREIGN KEY (`product_id`) REFERENCES `bf_product` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE bf_product_module ADD CONSTRAINT `bf__fk_PRODUCTMODULE_PRODUCTMODULE1` FOREIGN KEY (`parent_id`) REFERENCES `bf_product_module` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
-- 删除CaseAction
DELETE FROM bf_case_action WHERE caseinfo_id IN (SELECT id from bf_case_info WHERE product_id IN(9,7,8,10));
-- 删除外键
ALTER table bf_case_info DROP FOREIGN KEY bf__fk_case_info_product1;
-- ⑧删除CaseInfo
DELETE FROM bf_case_info WHERE product_id IN(9,7,8,10);
-- 添加外键
ALTER TABLE bf_case_info ADD CONSTRAINT `bf__fk_case_info_product1` FOREIGN KEY (`product_id`) REFERENCES `bf_product` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
-- 删除Product
DELETE FROM bf_product WHERE id IN (9,7,8,10);
不用bugfree，哈 正在学习怎么测试
正在学习怎么测试
页:
[1]
