Test Director(TD)的二次开发(1)

2010-01-31  毕泽明 

1,当日执行了哪些案例

2,执行结果

3,执行次数

于是乎,找了个时间对TD的数据库进行了分析,结果发现test表中的ts_subject列,找不到其对应的父表,没办法,找google帮忙了,搜索一番,找到下面这个sql:

SELECT
td.ALL_LISTS.AL_DESCRIPTION AS Subject,
td.TEST.TS_NAME AS Name,
td.TEST.TS_STATUS AS Status,
td.TEST.TS_CREATION_DATE AS [Creation Date],
td.TEST.TS_DESCRIPTION AS [Test Description],
td.DESSTEPS.DS_STEP_NAME AS [Step No.],
td.DESSTEPS.DS_DESCRIPTION AS [Step Description],
td.DESSTEPS.DS_EXPECTED AS [Expected Results]
FROM td.ALL_LISTS INNER JOIN
td.TEST ON td.ALL_LISTS.AL_ITEM_ID = td.TEST.TS_SUBJECT INNER JOIN
td.DESSTEPS ON td.TEST.TS_TEST_ID = td.DESSTEPS.DS_TEST_ID
ORDER BY td.ALL_LISTS.AL_DESCRIPTION, td.TEST.TS_NAME, td.DESSTEPS.DS_STEP_ORDER

可以从sql中分析出字段的关系了,成功踏出了第一步。

500°/5009 人阅读/0 条评论 发表评论

登录 后发表评论