【2019.09.08】python 基于Excel设计实现的关键字驱动的自动化测试框架

超、凢脫俗 2024-04-18 14:28 47阅读 0赞

之前写过PO模式、数据驱动的测试框架，最近要做一个测试平台，先写一个关键字驱动的测试框架练练手

# Excel 样式展示 #

> 如图  
> ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTM0MTA3_size_16_color_FFFFFF_t_70]

# 结果展示 #

![在这里插入图片描述][20190908032134202.gif]

# 代码 #

结构  
![在这里插入图片描述][20190908032322775.png]

1.  读取excel

#!/usr/bin/env python
    # -*- coding: utf-8 -*-
    # @Time : 2019/9/8 2:11
    # @Author : Paulson
    # @File : opera_excel.py
    # @Software: PyCharm
    # @define : function
    
    
    import xlrd
    
    
    class OperaExcel:
        def __init__(self, file_path=None):
            if file_path is None:
                self.file_path = '../dataconfig/selenium.xlsx'
            else:
                self.file_path = file_path
            self.excel = self.get_excel()
        
        def get_excel(self):
            tables = xlrd.open_workbook(self.file_path)
            return tables
        
        def get_sheet(self, i=None):
            if i is None:
                i = 0
            sheet_data = self.excel.sheets()[i]
            return sheet_data
        
        def get_lines(self):
            """获取行数"""
            lines = self.get_sheet().nrows
            return lines
        
        def get_cell(self, row, cell):
            """获取单元格内容"""
            data = self.get_sheet().cell(row, cell).value
            return data
    
    
    if __name__ == '__main__':
        opera = OperaExcel()
        print(opera.get_lines())
        print(opera.get_cell(0, 1))

1.  使用Excel中关键字对selenium 常用操作方法的封装

> 这里这有基本方法，可以自己丰富其他的的基本操作

#!/usr/bin/env python
    # -*- coding: utf-8 -*-
    # @Time : 2019/9/8 1:35
    # @Author : Paulson
    # @File : base.py
    # @Software: PyCharm
    # @define : function
    import time
    
    from selenium import webdriver
    from util.get_by_local import GetByLocal
    
    
    class ActionMethod:
        def open_browser(self, *args):
            """打开浏览器"""
            # self.driver = None
            browser = args[0]
            print(browser)
            if browser == "chrome":
                self.driver = webdriver.Chrome()
            else:
                self.driver = webdriver.Firefox()
                
        def get_url(self, *args):
            """打开 url"""
            url = args[0]
            self.driver.get(url)
            
        def get_element(self, *args):
            """定位方式"""
            key = args[0]
            get_by_element = GetByLocal(self.driver)
            element = get_by_element.get_local_element(key)
            return element
        
        def element_send_keys(self, *args):
            """对元素进行输入"""
            
            key, value = args[0], args[1]
            element = self.get_element(key)
            element.send_keys(value)
            
        def click_element(self, *args):
            """点击元素"""
            key = args[0]
            element = self.get_element(key)
            element.click()
            
        def sleep_time(self):
            """等待"""
            time.sleep(3)
            
        def close_browser(self):
            """关闭浏览器"""
            self.driver.quit()

1.  对selenium定位方法的通用方法提供的util方法

#!/usr/bin/env python
    # -*- coding: utf-8 -*-
    # @Time : 2019/9/8 1:56
    # @Author : Paulson
    # @File : get_by_local.py
    # @Software: PyCharm
    # @define : function
    
    class GetByLocal:
        def __init__(self, driver):
            self.driver = driver
        
        def get_local_element(self, key):
            """ name=email :return: """
            by = key.split('=')[0]
            by_value = key.split('=')[1]
            if by == 'id':
                return self.driver.find_element_by_id(by_value)
            elif by == 'name':
                return self.driver.find_element_by_name(by_value)
            elif by == 'className':
                return self.driver.find_element_by_class_name(by_value)
            else:
                return self.driver.find_element_by_xpath(by_value)

1.  执行case

> 这里使用了反射机制，需要注意传参的类型与数目

#!/usr/bin/env python
    # -*- coding: utf-8 -*-
    # @Time : 2019/9/8 2:13
    # @Author : Paulson
    # @File : test_case.py
    # @Software: PyCharm
    # @define : function
    # import sys
    # sys.path.append(r"C:\Users\ybsde\PycharmProjects\Life_Process_Study\StudyPacticePython\selenium_pageObject\selenium_excel")
    
    from util.opera_excel import OperaExcel
    from base.base import ActionMethod
    
    
    class TestCase:
        def __init__(self):
            self.handle_excel = OperaExcel()
            self.action_method = ActionMethod()
            
        def run_main(self):
            
            case_lines = self.handle_excel.get_lines()
            for i in range(1, case_lines):
                is_run = self.handle_excel.get_cell(i, 2)
                if is_run == "yes":
                    case_num = self.handle_excel.get_cell(i, 0)
                    print(f"开始测试: {case_num}")
                    method = self.handle_excel.get_cell(i, 3)
                    handle_value = self.handle_excel.get_cell(i, 4)
                    send_value = self.handle_excel.get_cell(i, 5)
                    # print(method, handle_value, send_value)
                    if send_value == '':
                        if handle_value == '':
                            self.run_method(method)
                        else:
                            self.run_method(method, handle_value)
                    else:
                        self.run_method(method, handle_value, send_value)
    
        def run_method(self, method, handle_value=None, send_value=None):
            """反射机制"""
            # print(method, handle_value, send_value)
            action_function = getattr(self.action_method, method)
            if send_value is None:
                if handle_value is None:
                    action_function()
                else:
                    action_function(handle_value)
            else:
                action_function(handle_value, send_value)
            
                
    if __name__ == '__main__':
        test = TestCase()
        test.run_main()

# github #

[点击前往GitHub][GitHub]

以上，希望可以帮到大家  
关注、点赞、评论  
star

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTM0MTA3_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/91de7ec7408c43be98fde46592abba19.png
[20190908032134202.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/c07044cde8ee4734b50b8f5a534cef0b.gif
[20190908032322775.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/c6a43e8cfb954e7089326ae7827c494d.png
[GitHub]: https://github.com/ybsdegit/selenium_keys