jira用到的幾張表

• 測試計劃，測試周期，測試用例，問題記錄

1. 測試計劃

# 記錄表，查計劃詳情
SELECT ID,issuenum,SUMMARY FROM  jiraissue where  issuenum = '22871'

# 測試計劃下，測試周期，查測試周期id，name
select ID,NAME,TP_ID from ao_69e499_testcycle where TP_ID='37872';

2.測試周期

# 測試周期下測試用例
SELECT ID, TC_ID, TEST_CYCLE_ID, SUMMARY FROM ao_69e499_testrun run WHERE run.TEST_CYCLE_ID ='319';

3. 測試用例

SELECT ID,issuenum,SUMMARY FROM  jiraissue where  ID in ('17216','17214','12883');

4. 新增表

自動化腳本編寫記錄表pytest_ready

與jira關聯關系記錄表pytest_jira

自動化測試運行結果記錄表pytest_result