Пример #1
0
    def setUp(self):
        """

        :return:
        """
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
Пример #2
0
    def setUp(self):
        """

        :return:
        """
        print "测试接口:", self.case_describe
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
Пример #3
0
    def setUp(self):
        """

        :return:
        """
        time.sleep(3)
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
Пример #4
0
    def setUp(self):
        """

        :return:
        """
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
        self.login_token = businessCommon.login()
Пример #5
0
    def readsheet(self, sheet_name):
        """

        :param table_name: sheet表名,若table_name == None,则读取所有table中的数据
        :return: 返回list[
        {'id': 1.0, 'tags': '位置信息', 'name': '获取ip信息接口测试用例-1', 'method': 'get', 'url': 'http://ip.taobao.com/service/getIpInfo.php', 'headers': "{'Host':'ip.taobao.com'}", 'body': "{'ip':'63.223.108.4'}", 'type': 'json', 'return_status_code': '', 'return_text': ''},
        {'id': 2.0, 'tags': '位置信息', 'name': '获取ip信息接口测试用例-2', 'method': 'get', 'url': 'http://ip.taobao.com/service/getIpInfo.php', 'headers': "{'Host':'ip.taobao.com'}", 'body': "{'ip':'127.0.0.1'}", 'type': 'json', 'return_status_code': '', 'return_text': ''}
        ]
        """
        interfaces_list = []
        try:
            if sheet_name is not None:
                sheet = self.xl.sheet_by_name(sheet_name)
            # 获取总列数
            rows = sheet.nrows
            if rows >= 2:
                # 获取第一行数据,作为字典Key值
                keys_list = sheet.row_values(0)

                for i in range(rows):
                    if i >= 1:
                        parmDict = dict(zip(keys_list, sheet.row_values(i)))
                        interfaces_list.append(parmDict)
                        result = {
                            'code': '0000',
                            'message': '执行批量excel查询表%s操作成功' % sheet_name,
                            'data': interfaces_list
                        }
                return result
            else:
                print('表名为%s数据为空!' % sheet_name)
                result = {
                    'code': '0000',
                    'message': '执行批量excel查询操作失败,表名为%s数据为空' % sheet_name,
                    'data': []
                }
                return result
        except xlrd.biffh.XLRDError as e:
            print('没有名称为%s的sheet' % sheet_name)
            MyLog.error('没有名称为%s的sheet' % sheet_name)
            result = {
                'code': '9999',
                'message': '执行批量excel查询操作失败,没有名称为%s的sheet' % sheet_name,
                'data': []
            }
            return result
Пример #6
0
 def setUp(self):
     """
     :return:
     """
     self.log = MyLog.get_log()
     self.logger = self.log.get_logger()
     print("测试开始前准备====================>>>>")
     print("测试用例名为:" + self.case_name)
Пример #7
0
 def __init__(self):
     global log, logger, resultPath, on_off
     log = MyLog.get_log()
     logger =  log.get_logger()
     resultPath = log.get_report_path()
     self.caseListFile = os.path.join(readConfig.proDir,'caselist.txt')
     self.caseFile = os.path.join(readConfig.proDir,'test_case')
     self.caseList = []
    def setUp(self):
        """

        :return:
        """
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
        print("开始测试用例" + self.case_name)
Пример #9
0
 def insert_data(self, condition, params):
     """
     定义表中插入操作
     :param condition: insert 语句
     :param params:数据,列表形式[('3','Tom','1 year 1 class','6'),('3','Jack','2 year 1 class','7')]
     :return:字典形式的批量插入数据结果
     """
     try:
         results = self.cur.executemany(condition, params)  # 返回插入的数据条数
         self.conn.commit()
         result = {'code': '0000', 'message': '执行批量插入操作成功', 'data': results}
     except Exception as e:
         self.conn.rollback()  # 执行回滚操作
         result = {'code': '9999', 'message': '执行批量插入操作异常', 'data': []}
         # print("数据库错误| Mysql Error %d: %s" % (e.args[0], e.args[1]))
         MyLog.error(e)
     return result
Пример #10
0
    def setUp(self):
        """

        :return:
        """
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
        print(self.case_name + "测试开始前准备")
Пример #11
0
    def setUp(self):
        """

        :return:
        """
        self.log = Log.get_log()
        self.logger = self.log.get_logger()
        self.logger.info(self.case_name + "_ready")
Пример #12
0
 def setUp(self):
     """
     before test
     :return:
     """
     self.log = Log.get_log()
     self.logger = self.log.get_logger()
     self.log.build_start_line(self.case_name)
Пример #13
0
    def setUp(self):
        """

        :return:
        """
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
        print self.case_describe + u"测试开始前准备"
Пример #14
0
 def __init__(self):
     self.timeout = 8.0
     self.log = MyLog.get_log()
     self.url = None
     self.method = None
     self.params = {}
     self.header = {}
     self.data = {}
Пример #15
0
class orderProcess(unittest.TestCase):
    def setUp(self):
        #self.log = Log.Log("OrderList")
        self.log = MyLog("orderProcess").get_log()
        #self.driver = webdriver.Firefox()
        self.log.info("开始测试订单流程")
        #self.driver.implicitly_wait(30)  # 隐性等待时间为30秒
        #self.base_url = "https://www.baidu.com"

    def test_orderStatusChange(self):
        """测试获取订单状态变化"""
        self.log.info("开始测试获取订单列表信息")
        self.log.info("测试成功")

    def test_OrderFullProcess(self):
        """测试订单总流程"""
        self.log.info("开始测试订单总流程")
        self.log.info("测试成功")
Пример #16
0
    def setUp(self):
        """

        :return:
        """
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
        sql = "UPDATE ft_orders SET STATUS = '0' WHERE id = '8320';"
        configDB.MyDB().zhiyu_run_sql(sql)
Пример #17
0
    def setUp(self):
        """

        :return:
        """
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
        sql1 = "UPDATE fy_house SET STATUS = '2' WHERE id = '1636559';"
        configDB.MyDB().zhiyu_run_sql(sql1)
Пример #18
0
    def setUp(self):
        """

        :return:
        """
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
        sql = "UPDATE ft_rent_reside SET STATUS = '-1' WHERE user_id = '566';"
        configDB.MyDB().zhiyu_run_sql(sql)
Пример #19
0
class MemberLevelInfo(unittest.TestCase):
    def setUp(self):
        #self.log = Log.Log("MemberLevelInfo")
        self.log = MyLog("MemberLevelInfo").get_log()
        #self.driver = webdriver.Firefox()
        self.log.info("开始测试获取会员等级信息")
        #self.driver.implicitly_wait(30)  # 隐性等待时间为30秒
        #self.base_url = "https://www.baidu.com"


    def test_getMemberLevelInfo(self):
        time.sleep(3)
        self.log.info("开始测试获取会有等级信息")
        self.log.info("测试成功")

    def test_changeMemberLevelInfo(self):
        self.log.info("开始测试更改会有等级信息")
        self.log.info("测试成功")
Пример #20
0
 def setUp(self):
     """
     :return:
     """
     self.log = MyLog.get_log()
     self.logger = self.log.get_logger()
     print("测试开始前准备====================>>>>")
     testSendVerifyCode.send_verify_code(self.mobile)
     print("测试用例名为:" + self.case_name)
Пример #21
0
class supplierInfo(unittest.TestCase):
    def setUp(self):
        #self.log = Log.Log("supplierInfo")
        self.log = MyLog("supplierInfo").get_log()
        #self.driver = webdriver.Firefox()
        self.log.info("开始测试获取供应商信息")
        #self.driver.implicitly_wait(30)  # 隐性等待时间为30秒
        #elf.base_url = "https://www.baidu.com"

    def test_getSupplierInfo(self):
        """获取供应商信息"""
        self.log.info("开始测试获取供应商信息")
        self.log.info("测试成功")

    def test_DeleteSupplierInfo(self):
        """删除供应商信息"""
        self.log.info("开始测试删除供应商信息")
        self.log.info("测试成功")
Пример #22
0
class productCategory(unittest.TestCase):
    def setUp(self):
        #self.log = Log.Log("productCategory")
        self.log = MyLog("productCategory").get_log()
        #self.driver = webdriver.Firefox()
        self.log.info("开始测试获取商品类型信息")
        #self.driver.implicitly_wait(30)  # 隐性等待时间为30秒
        #self.base_url = "https://www.baidu.com"

    def test_getProductCategory(self):
        """获取商品种类"""
        self.log.info("开始测试获取商品种类信息")
        self.log.info("测试成功")

    def test_productCategoryUpdate(self):
        """更新商品种类"""
        self.log.info("开始测试更新商品种类信息")
        self.log.info("测试成功")
Пример #23
0
 def __init__(self):
     global log, logger, resultPath
     log = Log.get_log()
     logger = log.get_logger()
     resultPath = log.get_report_path()
     # on_off = localReadConfig.get_email("on_off")
     self.caseListFile = os.path.join(readCongfig.proDir, "caselist.txt")
     self.caseFile = os.path.join(readCongfig.proDir, "testcase")
     self.caselist = []
Пример #24
0
    def setUp(self):
        """

        :return:
        """
        print "测试接口:", self.case_describe
        time.sleep(60)  # 因为会报获取验证码太频繁的错误,所以等待10秒
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
Пример #25
0
    def setUp(self):
        """

        :return:
        """
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
        sql = "UPDATE ft_bill_list SET orders_id = 0 WHERE id = 23;"
        configDB.MyDB().zhiyu_run_sql(sql)
Пример #26
0
    def __http_post(self, interface_url, headerdata, interface_param):
        """

        :param interface_url: 接口地址
        :param headerdata: 请求头文件
        :param interface_param: 接口请求参数
        :return: 字典形式结果
        """
        try:
            if interface_url != '':
                temp_interface_param = self.__new__param(interface_param)
                if headerdata.get('Content-Type') == 'application/x-www-form-urlencoded':
                    response = requests.post(url=interface_url,
                                             headers=headerdata,
                                             data=temp_interface_param,
                                             verify=False,
                                             timeout=10)
                if headerdata.get('Content-Type') == 'application/json':
                    response = requests.post(url=interface_url,
                                             headers=headerdata,
                                             json=temp_interface_param,
                                             verify=False,
                                             timeout=10)
                if headerdata.get('Content-Type') == 'multipart/form-data':
                    # files = {'file': open('upload.txt', 'rb')}
                    response = requests.post(url=interface_url,
                                             headers=headerdata,
                                             files=temp_interface_param,
                                             verify=False,
                                             timeout=10)

                if response.status_code == 200:
                    response_time = response.elapsed.microseconds / 1000  # 发起请求和响应到达的时间,单位ms
                    result = {'code': '0000', 'message': '成功', 'data': response.text, 'response_time': response_time}
                else:
                    result = {'code': '2004', 'message': '接口返回状态错误', 'data': []}
            elif interface_url == '':
                result = {'code': '2002', 'message': '接口地址参数为空', 'data': []}
            else:
                result = {'code': '2003', 'message': '接口地址错误', 'data': []}
        except Exception as e:
            result = {'code': '9999', 'message': '系统异常', 'data': []}
            MyLog.error(e)
        return result
Пример #27
0
    def setUp(self):
        """

        :return:
        """
        print "测试接口:", self.case_describe
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
        sql = "UPDATE coupon_lists SET used_status = 0 WHERE id = 29;"
        configDB.MyDB().zhiyu_run_sql(sql)
Пример #28
0
class productInfo(unittest.TestCase):
    def setUp(self):
        #self.log = Log("productInfo")
        self.log = MyLog("productCategory").get_log()
        #self.driver = webdriver.Firefox()
        self.log.info("开始测试获取商品信息")
        #self.driver.implicitly_wait(30)  # 隐性等待时间为30秒
        #self.base_url = "https://www.baidu.com"


    def test_getProductInfo(self):
        """测试获取商品信息"""
        self.log.info("开始测试获取商品信息")
        self.log.info("测试成功")

    def test_getSubProductInfo(self):
        """测试获取商品子商品"""
        self.log.info("开始测试获取商品子商品信息")
        self.log.info("测试成功")
Пример #29
0
    def setUp(self):
        """

        :return:
        """
        print "测试接口:", self.case_describe
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
        sql = "UPDATE ft_signing SET STATUS = '5' WHERE house_id = '1636559';"
        configDB.MyDB().zhiyu_run_sql(sql)
Пример #30
0
    def setUp(self):
        """

        :return:
        """
        print "测试接口:", self.case_describe
        self.log = MyLog.get_log()
        self.logger = self.log.get_logger()
        sql = "UPDATE fy_decorate SET STATUS = 1 WHERE id =28;"
        configDB.MyDB().zhiyu_run_sql(sql)
Пример #31
0
 def __init__(self):
     self.log = Log.get_log()
     self.logger = self.log.get_logger()
     self.db = None
     self.cursor = None