import unittest

class f1(unittest.TestCase):

    def setUp(self):

        pass

    def tearDown(self):

        pass

    def test_001(self):

        pass

    def test_002(self):

        pass

'''按类来执行'''

if __name__ == '__main__':

    suite = unittest.TestSuite(unittest.makeSuite(f1))

    unittest.TextTestRunner(verbosity=).run(suite)

import unittest

from selenium import webdriver

class BaiduLink(unittest.TestCase):

    def setUp(self):

        self.driver=webdriver.Chrome()

        self.driver.maximize_window()

        self.driver.implicitly_wait()

        self.driver.get(url="htttp://www.baidu.com")

    def tearDown(self):

        self.driver.quit()

    def test_001(self):

        self.driver.find_element_by_link_text("新闻").click()

    def test_002(self):

        self.driver.find_element_by_link_text("地图").click()

'''加载测试模块来执行（TestLoader）'''

if __name__ == '__main__':

    suite=unittest.TestLoader().loadTestsFromModule(BaiduLink)

    # suite=unittest.TestLoader().loadTestsFromModule("f2.py")

    unittest.TextTestRunner(verbosity=).run(suite)

import unittest

from selenium import webdriver

class BaiduLink(unittest.TestCase):

    def setUp(self):

        self.driver=webdriver.Chrome()

        self.driver.maximize_window()

        self.driver.implicitly_wait()

        self.driver.get(url="htttp://www.baidu.com")

    def tearDown(self):

        self.driver.quit()

    def test_001(self):

        self.driver.find_element_by_link_text("新闻").click()

    def test_002(self):

        self.driver.find_element_by_link_text("地图").click()

    def suite(self):

        suite = unittest.TestLoader().loadTestsFromModule(BaiduLink)

        return suite

'''加载测试模块来执行（TestLoader）'''

if __name__ == '__main__':

    unittest.TextTestRunner(verbosity=).run(BaiduLink.suite())

import unittest

import os

from testCase1 import HTMLTestRunner_cn

import time

'''批量执行所有的测试用例'''

def allTests():

    suite = unittest.TestLoader().discover(

        start_dir=os.path.dirname(__file__),

        pattern="test_*.py",

        top_level_dir=None

    )

    return suite

def getNowTime():

    return time.strftime("%Y-%m-%d %H_%M_%S",time.localtime(time.time()))

def run():

    # unittest.TextTestRunner(verbosity=).run(allTests())

    fp = os.path.join(os.path.dirname(__file__),"report",getNowTime() + "testReport.html")

    HTMLTestRunner_cn.HTMLTestRunner(

        stream=open(fp,"wb"),

        title="自动化测试报告",

        description="自动化测试报告详细信息"

    ).run(allTests())

if __name__ == '__main__':

    run()

import xlrd

import os

from xlutils.copy import copy

def base_dir(filename):

    return os.path.join(os.path.dirname(__file__),filename)

# '''elcel文件的操作'''

# work = xlrd.open_workbook(base_dir("data.xls"))

# sheet = work.sheet_by_index()

# #查看文件有多少行

# print(sheet.nrows)

# #获取单元格的内容

# print(sheet.cell_value(,))

'''excel文件内容的修改'''

work = xlrd.open_workbook(base_dir("data.xls"))

old_content=copy(work)

ws = old_content.get_sheet()

ws.write(,,"")

old_content.save(base_dir("data1.xls"))