<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[comesuh的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/comesuh</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; comesuh]]></copyright><item><title><![CDATA[mysql 报错1055  GROUP BY 需要包含所有 在 SELECT 中出现的字段]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/106688257</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/106688257</guid><author>comesuh</author><pubDate>Thu, 11 Jun 2020 14:30:16 +0800</pubDate><description><![CDATA[[Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dps_test.qm_audit_plan_order.scheduled_end_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=on]]></description><category></category></item><item><title><![CDATA[mysql统计某个字段不同值某个时间段数量之sum(case...when)]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/106688219</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/106688219</guid><author>comesuh</author><pubDate>Thu, 11 Jun 2020 14:27:38 +0800</pubDate><description><![CDATA[sum(case 属性名 when 属性值1 then 1 else 0 end)，意思就是某个属性下为属性值1就加1个数量，否则就作0统计。


]]></description><category></category></item><item><title><![CDATA[jmeter接口测试-关联]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/106247733</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/106247733</guid><author>comesuh</author><pubDate>Thu, 21 May 2020 00:22:49 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[postman接口测试遇到的问题--http404]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/106247644</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/106247644</guid><author>comesuh</author><pubDate>Thu, 21 May 2020 00:18:09 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[linux]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/106247592</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/106247592</guid><author>comesuh</author><pubDate>Thu, 21 May 2020 00:12:15 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[app功能测试]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/106247400</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/106247400</guid><author>comesuh</author><pubDate>Thu, 21 May 2020 00:04:22 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[前端]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/106247278</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/106247278</guid><author>comesuh</author><pubDate>Wed, 20 May 2020 23:54:19 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[单元测试]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/106247242</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/106247242</guid><author>comesuh</author><pubDate>Wed, 20 May 2020 23:50:34 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[数据处理踩过的坑1]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/106020001</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/106020001</guid><author>comesuh</author><pubDate>Sat, 09 May 2020 15:25:25 +0800</pubDate><description><![CDATA[list_position_name=['网络工程师', '网络工程师',
                    '884-软件测试工程师', '测试工程师', '软硬件测试工程师', '测试工程师','网络工程师',
                    '软件测试', '软件测试（常州）']
list_price_positoin_address = []
for i in list_position_name:
    address_index = [x for x in range(len(.]]></description><category></category></item><item><title><![CDATA[异常处理]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/103772562</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/103772562</guid><author>comesuh</author><pubDate>Mon, 30 Dec 2019 20:04:46 +0800</pubDate><description><![CDATA[#一、捕捉异常，程序继续向下运行
a=[1,2,3,4]
try:
    a[5]
#except IndexError as e:#已知异常类型
    #print('下标越界')
except Exception as e:#所有异常类型
    print('出异常了')#发生异常执行的语句
else:
    print('存在下标5')#未发生异常执行语句
finally:
   ...]]></description><category></category></item><item><title><![CDATA[django]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/103749418</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/103749418</guid><author>comesuh</author><pubDate>Sun, 29 Dec 2019 00:30:12 +0800</pubDate><description><![CDATA[安装django，创建项目

查看django版本：python -m django --version
	卸载django：pip uninstall django==3.0.1
	安装django：pip install django==2.1.5
	命令行新建一个项目：django-admin startproject test
	创建一个子项目（user模块）python manage....]]></description><category></category></item><item><title><![CDATA[mock接口开发-flask模块]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/103691707</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/103691707</guid><author>comesuh</author><pubDate>Wed, 25 Dec 2019 00:20:41 +0800</pubDate><description><![CDATA[mock接口开发 1、模拟第三方接口2、给别人提供数据，避免对方直接连接数据库3、flask是一个web开发框架
1、安装flask模块pip install flask 2、导入模块 3、开发接口 4、启动服务 5、接口测试工具验证接口
import flask
import json
import tools
server=flask.Flask(__name__)#开发一个服务，把当前py...]]></description><category></category></item><item><title><![CDATA[线程]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/103214799</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/103214799</guid><author>comesuh</author><pubDate>Sat, 23 Nov 2019 15:35:08 +0800</pubDate><description><![CDATA[import threading,time,threadpool
# #线程具体干活的，进程是线程和其他资源（图片等）的集合
# def download():
#     time.sleep(3)
#     t1=threading.Thread(target=download)
#     t1.start()
#     print('执行完了')
# for i in range(5...]]></description><category></category></item><item><title><![CDATA[迁移redis]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/102866300</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/102866300</guid><author>comesuh</author><pubDate>Fri, 01 Nov 2019 23:26:13 +0800</pubDate><description><![CDATA[import time

import redis
r = redis.Redis(host='192.168.1.1',password='11311331',port=6379,db=0,decode_responses=True)

#r2 = redis.Redis(host='192.168.1.1',password='45534343',port=6378,db=0,decode_...]]></description><category></category></item><item><title><![CDATA[匿名函数]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/102866288</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/102866288</guid><author>comesuh</author><pubDate>Fri, 01 Nov 2019 23:23:33 +0800</pubDate><description><![CDATA[#递归，就是函数自己调用自己

def func():
    num = int(input('num:'))
    if num % 2 ==0:
        print('是偶数')
        return
    else:
        func()

f = lambda x,b:str(x+b)

# result = f(1,2)
# print(result)

...]]></description><category></category></item><item><title><![CDATA[加密]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/102866275</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/102866275</guid><author>comesuh</author><pubDate>Fri, 01 Nov 2019 23:22:25 +0800</pubDate><description><![CDATA[import hashlib
# import md5 python2
# s='1'
# # m = hashlib.md5( s )#只是加密未返回加密后的结果
# m = hashlib.sha224( s.encode() )
# result = m.hexdigest() #获取加密后的结果
# print(result)
# #撞库 #加盐
# salt='24dfw32R@#@#...]]></description><category></category></item><item><title><![CDATA[读excel]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/102866262</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/102866262</guid><author>comesuh</author><pubDate>Fri, 01 Nov 2019 23:20:33 +0800</pubDate><description><![CDATA[import xlrd

book = xlrd.open_workbook(r'C:\\Users\\sh188\\PycharmProjects\\untitled\\day5\\aa.xlsx')
sheet = book.sheet_by_index(0)
# sheet = book.sheet_by_name('sheet1')
result = sheet.cell(0,0).va...]]></description><category></category></item><item><title><![CDATA[xlwt]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/102769983</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/102769983</guid><author>comesuh</author><pubDate>Sun, 27 Oct 2019 19:00:36 +0800</pubDate><description><![CDATA[import xlwt
book = xlwt.Workbook()
sheet = book.add_sheet('sheet1')
# sheet.write(0,0,'名字')
# sheet.write(0,1,'手机号')
# sheet.write(1,1,'119')
# sheet.write(2,1,'110')


stus = [
    ['id', 'name', 's...]]></description><category></category></item><item><title><![CDATA[redis]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/102758160</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/102758160</guid><author>comesuh</author><pubDate>Sat, 26 Oct 2019 16:25:33 +0800</pubDate><description><![CDATA[#关系型数据库，表与表之间有关系：MySQL sqlserver、Oracle 要检查语法 查看是否有索引等等 比较慢
#非关系数据库 NOsql 比关系型数据库快  mongodb 存在磁盘  redis 每秒10w次的读写，存在内存,做缓存 比方说session
#Redis只有ip 端口号 密码 没有账号
#0-15个数据库
import redis
r=redis.Redis(host=...]]></description><category></category></item><item><title><![CDATA[pymysql]]></title><link>https://blog.youkuaiyun.com/comesuh/article/details/102756780</link><guid>https://blog.youkuaiyun.com/comesuh/article/details/102756780</guid><author>comesuh</author><pubDate>Sat, 26 Oct 2019 15:01:07 +0800</pubDate><description><![CDATA[import pymysql
ip ="192.168.1.32"
user = 'username'
password="123456"#字符串
db='shujukuname'
port=3306
conn=pymysql.connect(host=ip,user=user,password=password,db=db,port=port,charset='utf8',autocommit...]]></description><category></category></item></channel></rss>