import nnlog
import traceback
import xlrd
from config.setting import LOG_PATH,func_map
import jsonpath

log=nnlog.Logger(LOG_PATH)

# "$..key"是进行模糊查询
# jsonpath.jsonpath(d,"$..key")
# faker模板的使用

class ParamDeal():

    def read_excel(self,file_path):
        # case_list存放测试用例
        case_list=[]
        try:
            # 打开excel
            book=xlrd.open_workbook(file_path)
            sheet=book.sheet_by_index(0)
            # 从
            for row in range(1,sheet.nrows):
                # 只取有用的那几行
                line=sheet.row_values(row)[1:7]

                # 把参数先进行替换
                line[2]=self.replace_param(line[2])

                # 将header转换成字典
                line[3]=self.replace_param(line[3])
                # 再把参数进行转换成字典
                line[2]=self.str_to_dict(line[2])

                line[3]=self.str_to_dict(line[3])
                case_list.append(line)
        except Exception as e:
            log.error("读取文件出错，文件名是：%s"%file_path)
            log.error("具体的错误信息是%s"%traceback.format_exc())
        return case_list

    def replace_param(self,s):
        """
        进行参数替换
        :param s:
        :return:
        """
        for func_name,func in func_map.items():
            if func_name in s:
                result=func()
                s=s.replace(func_name,result)
        return s

    def str_to_dict(self,s):
        """
        字符串转换成字典，如果是空字符串直接返回空字典
        :param s:
        :return:
        """
        d={}
        # 判断参数是否为空
        if s.strip():
            # 字符串通过逗号进行分割后通过等号进行分割后再转换成字典
            for i in s.split(","):
                k,v=i.split("=")
                d[k]=v
        return d

import traceback

import requests
from config import setting
from urllib.parse import  urljoin
import nnlog


log=nnlog.Logger(setting.LOG_PATH)
class MyRequest:
    def __init__(self,url,method,data=None,headers=None,is_json='否'):
        # 拼接url，通过urljoin进行拼装url
        self.url=urljoin(setting.HOST,url)
        self.data=data
        self.headers=headers
        self.is_json=is_json
        self.method=method.lower()
        self.req()

    def req(self):
        try:
            if self.is_json=='是':
                response= requests.request(self.method,self.url,params=self.data,json=self.data,headers=self.headers).json()
            else:
                response= requests.request(self.method,self.url,params=self.data,data=self.data,headers=self.headers).json()
        except Exception as e:
            log.error("请求%s的时候出错了，请求参数是%s，错误信息是%s"%(self.url,self.data,traceback.format_exc()))
            self.result={"msg":"请求接口出错了","error_msg":traceback.format_exc()}
            self.text='{"msg":"请求接口出错了","error_msg":%s}'%(traceback.format_exc())
        else:
            self.result=response
            self.text=str(response)

from lib.utils import get_value
from config.setting import LOG_PATH
import nnlog

log=nnlog.Logger(LOG_PATH)

class ParseResponse:

    fuhao=['!=','>=','<=','>','<','=']

    def __init__(self,check_str,response):
        self.check_str=check_str
        self.response=response
        self.reason="都通过了"
        self.status='通过'
        self.check_response()

    def check_response(self):
        """
        预期结果格式是：yuqijieguo="status=1,score>60,age!=15"
        :return:
        """
        if self.check_str.strip():
            for s in self.check_str.split(","):
                for f in self.fuhao:
                    if f in s:
                        # 分割取出预期结果中的key
                        key, value = s.split(f)
                        # 取到实际结果
                        shijijieguo = get_value(self.response, key)
                        # 如果是实际结果类型是字符串的话，实际结果和预期结果都转换成字符串进行比较
                        if type(shijijieguo) == str:
                            shijijieguo = "'%s'" % (shijijieguo)
                            value = "'%s'" % (value)

                        # 转换成字符串进行eval运行
                        f = "==" if f == "=" else f
                        code = "%s %s %s" % (shijijieguo, f, value)
                        tag=eval(code)
                        # 判断tag不是true时表示有预期结果与实际结果对比是失败的
                        if tag!=True:
                            self.reason='key是%s，运算的代码是%s'%(key,code)
                            log.debug(self.reason)
                            self.status='失败'
                            return False
                        break
        return True