有没有什么方法能把 excel 里写的接口测试用例通过代码自动生成

乐哈哈yoyo

而不是一个接口写一个test开头的方法

1. <span class="nd">@allure.feature</span><span class="p">(</span><span class="s">'注册'</span><span class="p">)</span>
   
2. <span class="nd">@pytest.mark.parametrize</span><span class="p">(</span><span class="s">'realCode, realMessage, expeCode, expeMessage, testCaseName'</span><span class="p">,</span> <span class="n">ResultParam</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">.</span><span class="n">value</span><span class="p">)</span>
   
3. <span class="k">def</span> <span class="nf">test_register</span><span class="p">(</span><span class="n">realCode</span><span class="p">,</span> <span class="n">realMessage</span><span class="p">,</span> <span class="n">expeCode</span><span class="p">,</span> <span class="n">expeMessage</span><span class="p">,</span> <span class="n">testCaseName</span><span class="p">):</span>
   
4.      <span class="k">assert</span> <span class="n">realCode</span> <span class="o">==</span> <span class="n">expeCode</span>
   
5.      <span class="k">assert</span> <span class="n">realMessage</span> <span class="o">==</span> <span class="n">expeMessage</span>
   
6.     <span class="n">logging</span><span class="o">.</span><span class="n">info</span><span class="p">(</span><span class="n">testCaseName</span><span class="p">)</span>
   
7. 
   
8. 
   
9. <span class="nd">@allure.feature</span><span class="p">(</span><span class="s">'登录'</span><span class="p">)</span>
   
10. <span class="nd">@pytest.mark.parametrize</span><span class="p">(</span><span class="s">'realCode, realMessage, expeCode, expeMessage, testCaseName'</span><span class="p">,</span> <span class="n">ResultParam</span><span class="p">(</span><span class="mi">1</span><span class="p">)</span><span class="o">.</span><span class="n">value</span><span class="p">)</span>
    
11. <span class="k">def</span> <span class="nf">test_login</span><span class="p">(</span><span class="n">realCode</span><span class="p">,</span> <span class="n">realMessage</span><span class="p">,</span> <span class="n">expeCode</span><span class="p">,</span> <span class="n">expeMessage</span><span class="p">,</span> <span class="n">testCaseName</span><span class="p">):</span>
    
12.      <span class="k">assert</span> <span class="n">realCode</span> <span class="o">==</span> <span class="n">expeCode</span>
    
13.      <span class="k">assert</span> <span class="n">realMessage</span> <span class="o">==</span> <span class="n">expeMessage</span>
    
14.      <span class="n">logging</span><span class="o">.</span><span class="n">info</span><span class="p">(</span><span class="n">testCaseName</span><span class="p">)</span>

复制代码

草帽路飞UU

用Apache POI 获取excel。

乐哈哈yoyo

草帽路飞UU 发表于 2017-6-15 16:05
用Apache POI 获取excel。

嗯，谢谢了！

岛屿soliloquy

涨知识了。