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

测试脚本描述如下

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()