Web UI自动化测试框架(3)

最新推荐文章于 2025-12-17 20:00:56 发布

原创最新推荐文章于 2025-12-17 20:00:56 发布 · 210 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#UI自动化 #selenium

测试_UI自动化专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一个基于Python和unittest的自动化测试框架实现，该框架利用YQSel库进行UI自动化测试，通过DBManage模块从SQLite数据库读取用户信息，实现登录功能的自动化验证。

测试脚本描述如下


from YQSel.YQSel import *
import unittest, time, re
from DBManage.Userinfo import *
from DBManage.Newsdata import *
from time import sleep
import os

killfirefox = "taskkill /f /t /im firefox.exe 1>nul"

class JxxxTest1(unittest.TestCase):
    
    def setUp(self):
        self.driver = YQSel("firefox")

        self.url = 'http://192.168.21xxxx:6089/'
        
    def login(self):
        driver = self.driver
        url = self.url

        #get the user name and password from sqllite
        name = userinfo.name
        password = userinfo.password

        title = newsData.title
        content = newsData.content

        driver.open(url)
        driver.max_window()

        driver.clear("xpath=>//li[@class='login_user']/input[@class='ant-input f-text']")
        driver.type("xpath=>//li[@class='login_user']/input[@class='ant-input f-text']", name)

        driver.clear("xpath=>//li[@class='login_pass']/input[@class='ant-input f-text']")
        driver.typeEnter("xpath=>//li[@class='login_pass']/input[@class='ant-input f-text']", password)

        time.sleep(3)

这里我们引用了dbmanager类。这里面存放了数据操作的方法。

import sqlite3
import os

path = os.path.abspath(os.path.join(os.path.dirname(__file__),".."))+ '\\'+"db\\TestData.db"

command = "select * from userinfo"

class Userinfo(object):
    
    name = ""
    password = ""
    verifyCode = ""
    
    def __init__(self):  
       pass   
    
    conn = sqlite3.connect(path)
    
    cursor = conn.execute(command)
    
    for row in cursor:        
        name = row[1]
        password = row[2]
        verifyCode = row[3]
    conn.close()
    
userinfo = Userinfo()