import unittest import requests from utils.tools import Db from config import host, dbinfo dbhost = dbinfo["host"] user = dbinfo["user"] password = dbinfo["password"] dbname = dbinfo["dbname"] db = Db(dbhost, user, password, dbname) class TestInspirer(unittest.TestCase): @classmethod def setUpClass(cls): cls.requests = requests.Session() url = host + "/login" headers = {"Content-Type": "application/json"} data = {"username": "******", "password": "******"} res = cls.requests.post(url, headers=headers, json=data) cls.token = res.json()["data"]["token"] @classmethod def tearDownClass(cls): db.commit("delete from t_inspirer where uid = 251;") def test_01_inspirernew(self): """测试发表灵感接口""" url = host + "/inspirer/new" headers = {"Content-Type": "application/json"} headers.update(token=self.token)
import unittest import requests from utils.tools import readexcle, createreport, Db host = "http://118.24.255.132:2333" datalist = readexcle("./data/接口测试用例.xlsx", "Cases") db = Db("118.24.255.132", "testgoup", "1qaz!QAZ", "ljtestdb") class TestInspirer(unittest.TestCase): def setUp(self): self.requests = requests.Session() url = host + "/login" headers = {"Content-Type": "application/json"} data = {"username": "******", "password": "******"} res = self.requests.post(url, headers=headers, json=data) self.token = res.json()["data"]["token"] def tearDown(self): print("测试结束!") def test_01_inspirernew(self): """测试发表灵感接口""" url = host + datalist[1][2] headers = eval(datalist[1][4]) headers.update(token=self.token) data = eval(datalist[1][5]) global iid res = self.requests.post(url, headers=headers, json=data) iid = db.query( "SELECT id FROM t_inspirer WHERE uid=1333365113 ORDER BY createtime DESC LIMIT 1;"
import unittest import requests from utils.tools import readexcle, createreport, Db db = Db("192.168.50.11", 3312, "root", "szgr123", "gre_study") datalist = readexcle("./data/个人中心接口测试用例.xlsx", "Cases") host = "http://192.168.50.11" class TestExam(unittest.TestCase): @classmethod def setUpClass(cls): cls.requests = requests.Session() url = "http://test.geron-e.com:8095/api/app/login" headers = eval(datalist[0][4]) values = eval(datalist[0][5]) res = cls.requests.post(url, headers=headers, data=values) resl = res.json() cls.token = resl.get("data") print(resl.get("data")) @classmethod def tearDownClass(cls): print("测试结束!") def test_01_getBaseInfo(self): """个人中心接口测试""" url = host + datalist[1][2] headers = eval(datalist[1][4]) headers.update(sessionId=self.token) res = requests.get(url, headers=headers)
import tkinter from tkinter import Label, Button, END, Entry, Tk, PhotoImage, Menu, Text from PIL import Image, ImageTk import os import random from utils.tools import Db import tkinter as tk from fun.menu import UserMenu menu1 = UserMenu() db = Db("192.168.30.248", 3306, "root", "123456", "test") class myWindow(): def __init__(self, parent): """Constructor""" self.root = parent self.root.title('登录') self.loginui() self.frame = tk.Frame(parent) # self.frame.pack() def loginui(self): """主窗体页面""" global entry_name global entry_pwd label = tk.Label(self.root) label['text'] = '用户名' label['font'] = 14 label.grid(row=0, column=0, padx=60, pady=50) entry_name = tk.Entry(self.root)