caiyong_-CSDN博客

import openpyxlimport randomimport jsondef writeExcel(): # 创建一个xlsx文件 wb = openpyxl.Workbook() # 创建sheet wb.create_sheet("20220225") wb.create_sheet("20220226") sheet_list = wb.sheetnames print(sheet_list) # 删除sheet .

2022-02-25 22:46:16 326

原创测试流程总结

测试流程1.测试计划阶段1.1 编写测试计划，测试方案，提起功能测试点，经过讨论，形成最终稿输出1.2 在项目开发初始阶段2.测试准备阶段2.1 编写测试用例，经过评审后并最终输出2.2 准备测试数据，测试环境3.测试执行阶段3.1 功能测试中测试执行记录，校验测试结果和预期结果是否一致，验证系统各模块功能是否按需求文档实现3.2 提bug单，确保所有的缺陷都被及时有效的进行处理3.3 集成测试，执行测试案例，校验测试结果和预期结果是否一致，验证系统及系统间各功能是否按需求实现3.4

2020-07-03 11:52:37 389

原创带basic auth验证的接口测试

#加密参数生成def encryption():#加密报文接口地址urlA = “https://127.0.0.1:8080/Debug/signature”platform = “c85a0615052986f212386fa9e”#加密参数subdata=“platformno=TEST\nrequesttime= 1577172\norderno=243546\ntype=1\nusername=00102\ncurrency=9999\nrequestip=127.0.0.1”par

2020-06-03 17:05:18 1193

原创小小抽奖实现

package luckDraw;import java.util.ArrayList;import java.util.Collections;import java.util.HashMap;import java.util.LinkedHashMap;import java.util.Random;/** 设计一个抽奖功能* 1.中奖的概率* 2.中奖项目...

2020-04-30 16:38:29 313

原创 mysql常用语句随笔

mysql中常用sql语句分表后跨表查询select DATE_FORMAT(tmp.creatTime, ‘%Y-%m-%d’) as time,count(1),sum(tmp.coin) from(select * from table_201910 UNION ALL select * from table_201911 UNION ALL select * from table_...

2019-12-05 19:37:29 162

原创 mysql数据库中按天统计数据

mysql数据库中按天统计数据SELECTDATE_FORMAT(orderTime, ‘%Y-%m-%d’) as time, sum(payout),count(1) FROMorder_detail WHEREorderTime BETWEEN ‘2019-09-01 00:00:00’AND ‘2019-10-31 23:59:59’ group by time order by...

2019-11-05 00:17:56 1709

原创 mysql中简单存储过程创建和调用

1.创建新增1百万条数据存储过程DROP PROCEDURE IF EXISTS cunchu; CREATE PROCEDURE cunchu() BEGIN declare i int; set i = 1; while i<1000000 do INSERT INT...

2019-01-18 12:59:43 700 1

原创自动化用例执行和测试报告展示

from tkinter import *from selenium import webdriverimport tkinter as tkfrom tkinter import scrolledtext,messageboxfrom time import sleepfrom tkinter import ttkimport xlrdimport requestsimport...

2019-01-09 12:24:33 1866 2

原创 base64加解密和md5加密工具

from tkinter import *import qrcodefrom tkinter.filedialog import askopenfilename,asksaveasfilenamefrom tkinter import scrolledtextimport hashlibimport base64def jiemian_info(): ws = jiemia...

2019-01-03 16:23:42 355

原创封装好批量执行测试用例

from tkinter import *from selenium import webdriverimport tkinter as tkfrom tkinter import scrolledtext,messageboxfrom time import sleepfrom tkinter import ttkimport xlrdimport requestsimport...

2018-12-30 18:45:08 477

原创编写的文本展示工具和md5加密

from tkinter import *import qrcodefrom tkinter.filedialog import askopenfilename,asksaveasfilenamefrom tkinter import scrolledtextimport hashlibdef jiemian_info(): ws = jiemian.winfo_screenwi...

2018-12-18 09:11:13 221

原创 python自动化中调用键盘输入数字和,字母，字符封装方法

from appium import webdriverimport timefrom PIL import Image, ImageEnhance# import baseinfofrom pytesseract import *from pymouse import PyMousefrom pykeyboard import PyKeyboarddesired_caps ...

2018-12-17 20:14:11 3241

原创 python中将不同界面以frame框架结合成一个集合体

from tkinter import *from selenium import webdriverimport tkinter as tkfrom tkinter import scrolledtext,messageboxfrom time import sleepfrom tkinter import ttkimport xlrdimport requestsimport ...

2018-12-17 20:01:03 1619

原创 python中简单破译纯数字输入

import datatime，random"""破译输入数字"""m = [1,2,3,4,5,6,7,8,9,0]c = 2n = []print(len(n))while c > 1: starttime = datetime.datetime.now() print("程序开始时间：", starttime) a = 153 num = ...

2018-12-17 19:56:00 302

原创 python中实现组合数和排列数

"""组合数"""def zuhe(m,n): c = 1 b = 1 d = 1 num2 = 1 num1 = 1 num3 = 1 while c <= m: if c <= m: num1 = num1 * c c = c +1 while b &...

2018-12-17 19:53:00 3130

原创移动端自动化中tap点击输入框传值（这里用send_keys输入不行）

from appium import webdriverimport timedesired_caps = {#设备系统‘platformName’: ‘Android’,#设备名称‘deviceName’: ‘127.0.0.1:7555’,#安卓版本‘platformVersion’: ‘6.0.1’,# apk包名‘appPackage’: ‘org.cocos2d.hu...

2018-12-16 10:10:17 2071 1

原创验证码识别

from selenium import webdriverfrom time import sleepfrom PIL import Image, ImageEnhancefrom pytesseract import *driver= webdriver.Chrome()driver.get(url) #url为验证码出现的地址sleep(1)driver.save_screen...

2018-12-15 14:17:46 256

原创 python开发接口

import json,flaskfrom flask import request,jsonifyimport cx_Oracle as oracleimport hashlibdef jiaoyan(user):db = oracle.connect(‘pj_core’, ‘pj_core’, ‘192.168.55.5:1521/ljcprd’)cur = db.cursor()...

2018-10-22 18:24:27 431

原创 python-生成二维码图片

from tkinter import *import qrcodedef jiemian_info():ws = jiemian.winfo_screenwidth()hs = jiemian.winfo_screenheight()x = (ws / 2) - 200y = (hs / 2) - 200print("%d,%d" % (ws, hs))return x, yj...

2018-10-17 10:06:11 1164

原创 python-tkinter的登录界面

from tkinter import *import tkinter as tkimport jsonimport requestsfrom tkinter import messageboxdef jiemian_info():ws = jiemian.winfo_screenwidth()hs = jiemian.winfo_screenheight()x = (ws / 2...

2018-10-17 10:02:18 1524 3

caiyong_的博客

原创验证码生成

原创读写xlsx和json操作