Python3+Requests+Excel完整接口自动化测试框架的实现

框架整体使用Python3+Requests+Excel：包含对实时token的获取

1、------base

-------runmethond.py

runmethond：对不同的请求方式进行封装

    import json
    import requests
    
    requests.packages.urllib3.disable_warnings()
    
    class RunMethod:
      def post_main(self, url, data, header=None):
        res = None
        if header != None:
          res = requests.post(url=url, data=data, headers=header,verify=False)
        else:
          res = requests.post(url=url, data=data,verify=False)
        return res.json()
    
      def get_main(self, url, data=None, header=None):
        res = None
        if header != None:
          res = requests.get(url=url, params=data, headers=header, verify=False)
        else:
          res = requests.get(url=url, params=data, verify=False)
        return res.json()
    
      def run_main(self, method, url, data=None, header=None):
        res = None
        if method == 'Post':
          res = self.post_main(url, data, header)
        else:
          res = self.get_main(url, data, header)
        return json.dumps(res, indent=2, sort_keys=True, ensure_ascii=False)
    
    
    if __name__ == '__main__':
      url = 'http://httpbin.org/post'
      data = {
   
        'cart': '11'
      }
      run = RunMethod()
      run_test = run.run_main(method="Post", url=url, data=data)
      print(run_test)

2、------data

------data_config.py

data_config：获取excel模块中数据

    class global_val:
      Id = '0'
      request_name = '1'
      url = '2'
      run = '3'
      request_way = '4'
      header = '5'
      case_depend = '6'
      data_depend = '7'
      field_depend = '8'
      data = '9'
      expect = '10'
      result = '11'
    
    
    def get_id():
      """获取case_id"""
      return global_val.Id
    
    
    def get_request_name():
      """获取请求模块名称"""
      return global_val.request_name
    
    
    def get_url():
      """获取请求url"""
      return global_val.url
    
    
    def get_run():
      """获取是否运行"""
      return global_val.run
    
    
    def get_run_way():
      """获取请求方式"""
      return global_val.request_way
    
    
    def get_header():
      """获取是否携带header"""
      return global_val.header
    
    
    def get_case_depend():
      """case依赖"""
      return global_val.case_depend
    
    
    def get_data_depend():
      """依赖的返回数据"""
      return global_val.data_depend
    
    
    def get_field_depend():
      """数据依赖字段"""
      return global_val.field_depend
    
    
    def get_data():
      """获取请求数据"""
      return global_val.data
    
    
    def get_expect():
      """获取预期结果"""
      return global_val.expect
    
    
    def get_result():
      """获取返回结果"""
      return global_val.result

3、-----data

-----dependent_data.py

dependent_data：解决数据依赖问题

    from util.operation_excel import OperationExcel
    from base.runmethod import RunMethod