<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[qq_34237321的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/qq_34237321</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qq_34237321]]></copyright><item><title><![CDATA[python 操作mysql]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/116057029</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/116057029</guid><author>qq_34237321</author><pubDate>Fri, 23 Apr 2021 15:06:16 +0800</pubDate><description><![CDATA[import pymysql

class py_mysql():
    def __init__(self,host,user,pwd,db):
        self.user=user
        self.pwd = pwd
        self.db = db
        self.host = host
        self.connet=pymysql.connect(host=self.host,user =self.user,password=self.pwd,data]]></description><category></category></item><item><title><![CDATA[k8s可视化安装]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/115916167</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/115916167</guid><author>qq_34237321</author><pubDate>Tue, 20 Apr 2021 19:50:06 +0800</pubDate><description><![CDATA[要求2台服务器
一台master       2CPU
一台工作节点   2CPU
以下操作所有机器都要执行
1) 检查操作系统的版本Centos版本要在7.5或之上

2） 时间同步
kubernetes要求集群中的节点时间必须精确一致，这里直接使用chronyd服务从网络同步时间。
企业中建议配置内部的时间同步服务器
systemctl start chronyd   # 启动chronyd服务
systemctl enable chronyd   # 设置chronyd服务开机自启
date     ]]></description><category></category></item><item><title><![CDATA[flask+uwsgi+nginx部署Python项目]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/114987445</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/114987445</guid><author>qq_34237321</author><pubDate>Thu, 18 Mar 2021 18:31:09 +0800</pubDate><description><![CDATA[前提，项目运行没有问题
执行文件的绝对路径为
/root/wan/anomaly-detection-master/detection.py

调试命令
python3 detection.py

uwsgi.ini
[uwsgi]
socket = 127.0.0.1:5000
module = detection
chdir = /root/wan/anomaly-detection-master
wsgi-file = detection.py
processes = 4
threads = 2
ca]]></description><category></category></item><item><title><![CDATA[centos nginx 的安装]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/114987336</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/114987336</guid><author>qq_34237321</author><pubDate>Thu, 18 Mar 2021 18:23:07 +0800</pubDate><description><![CDATA[yum -y install gcc
yum install -y pcre pcre-devel
yum install -y zlib zlib-devel
yum install -y openssl openssl-devel
wget http://nginx.org/download/nginx-1.9.9.tar.gz  #自行选择版本
tar -zxvf  nginx-1.9.9.tar.gz
./configure
make
make install


]]></description><category></category></item><item><title><![CDATA[centos python3安装]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/114964740</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/114964740</guid><author>qq_34237321</author><pubDate>Thu, 18 Mar 2021 09:54:58 +0800</pubDate><description><![CDATA[https://www.python.org/ftp/python/3.7.0/Python-3.7.0.tgz
# 1、yum更新yum源
yum update
# 2、安装Python 3.7所需的依赖否则安装后没有pip3包
yum install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel libffi-devel gcc make
# 3、在官网下载所需版本，这里用的]]></description><category></category></item><item><title><![CDATA[linux命令行颜色设置]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/114963441</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/114963441</guid><author>qq_34237321</author><pubDate>Thu, 18 Mar 2021 09:25:29 +0800</pubDate><description><![CDATA[在终端输入命令：
echo $PS1

PS1='[\[\e[32;40m\]\u@\h \w \t]$ \[\e[0m\]'

vim .bashrc
加入这一行的值
PS1='[\[\e[32;40m\]\u@\h \w \t]$ \[\e[0m\]'
source .bashrc#重新加载文件 使其永久生效


]]></description><category></category></item><item><title><![CDATA[Python datetime 模块 时间增量的用法]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/114110211</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/114110211</guid><author>qq_34237321</author><pubDate>Fri, 26 Feb 2021 08:16:13 +0800</pubDate><description><![CDATA[#计算时间差
import datetime
from datetime import timedelta
now = datetime.datetime.now()
now_tm = (now + timedelta(hours=10)).strftime('%Y-%m-%d')
now_tm_day = (now + timedelta(days=2)).strftime('%Y-%m-%d')
now_tm_days = (now + timedelta(days=350)).strftime('%Y]]></description><category></category></item><item><title><![CDATA[centos  Jenkins的安装]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/112509103</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/112509103</guid><author>qq_34237321</author><pubDate>Tue, 12 Jan 2021 10:41:19 +0800</pubDate><description><![CDATA[1：安装jdk
yum install -y java

2:安装Jenkins
首先要先添加Jenkins源:
sudo wget -O /etc/yum.repos.d/jenkins.repo http://jenkins-ci.org/redhat/jenkins.repo
sudo rpm --import http://pkg.jenkins-ci.org/redhat/jenkins-ci.org.key
yum install jenkins

3:启动并查看状态
systemctl  st]]></description><category></category></item><item><title><![CDATA[使用git将代码上传到gitlab服务器]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/112213303</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/112213303</guid><author>qq_34237321</author><pubDate>Tue, 05 Jan 2021 09:52:08 +0800</pubDate><description><![CDATA[1.初始化本地环境，把该项目变成可被git管理的仓库
　　$ git init
2.添加该项目下的所有文件
　　$git add .
3.使用如下命令将文件添加到仓库中去
　　$ git commit -m ‘本次提交的说明’（说明信息为必填项）
4.将本地代码库与远程代码库相关联
　　$ git remote add origin https://xxxxxx/xxxx.git
5.强制把远程仓库的代码跟新到当前分支上面。ps:如果仓库为空这一步可以跳过
　　$ git pull --rebase ori]]></description><category></category></item><item><title><![CDATA[Python插入mysql数据时（多条件），存在则更新不存在则插入。]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/111934761</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/111934761</guid><author>qq_34237321</author><pubDate>Tue, 29 Dec 2020 18:36:57 +0800</pubDate><description><![CDATA[1：表结构，ID为主键

2：需求。
当插入的数值与count_date和measure_name两者的值都相同时。存在则更新不存在则插入


此时数据库的值为
count_date=“2020-12-27”
measure_name=“ods_jd_commodity_list-accuracy-shop_id”
注意：一定要给id值，否则啥事不会发生
INSERT INTO accuracy(count_date, total, measure_name, matched_fraction, match]]></description><category></category></item><item><title><![CDATA[Python递归删除目录下的空文件或空目录]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/111916457</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/111916457</guid><author>qq_34237321</author><pubDate>Tue, 29 Dec 2020 15:12:58 +0800</pubDate><description><![CDATA[思路：
递归获取文件名，判断文件大小，当大小等于0时，删除。
1：删除空文件
import os
def del_dir(path):
    for (root, dirs, files) in os.walk(path):
        for item in files:
            # print(root,item)
            a=os.path.join(root,item)
            print(a)
            r = os.path.g]]></description><category></category></item><item><title><![CDATA[Python matplotlib 折线图]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/111691626</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/111691626</guid><author>qq_34237321</author><pubDate>Fri, 25 Dec 2020 16:58:59 +0800</pubDate><description><![CDATA[import matplotlib.pyplot as plt
import matplotlib as mpl
def getdate(beforeOfDay):#获取最近7天的数据
    today = datetime.datetime.now()
    # 计算偏移量
    dates=[]
    for i in range(beforeOfDay,0,-1):
        offset = datetime.timedelta(days=-i+1)
        # 获取想要的日期]]></description><category></category></item><item><title><![CDATA[pycharm 控制台json格式化输出]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/111351929</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/111351929</guid><author>qq_34237321</author><pubDate>Fri, 18 Dec 2020 08:26:57 +0800</pubDate><description><![CDATA[import json
import requests

header = {"content-type": "application/x-www-form-urlencoded"}
param = {"key": "手机","page":'1.3','limit':1 }
timeout = 0.5
url = "http://58.49.122.210:10010/bijia_V1_0_0/discount?"
response = requests.get(url, headers=header, p]]></description><category></category></item><item><title><![CDATA[k8s系统，异常通知对接钉钉系统]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/110849458</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/110849458</guid><author>qq_34237321</author><pubDate>Tue, 08 Dec 2020 08:42:48 +0800</pubDate><description><![CDATA[1：首先在钉钉系统中自定义机器人记住webhoodk地址和自定义关键字，点击完成

2：创建ymal 文件，内容如下，修改webhook 地址，以及带上后面的参数
—sink=dingtalk:https:************&amp;label=cluster1&amp;level=Warning#钉钉对接的调用接口
label为对应的关键字，levle为对应的消息级别。如果需要监控具体的某个命名空间可以带上&amp;namespaces=“要监控的资源空间”

apiVersion: apps/v1]]></description><category></category></item><item><title><![CDATA[jira对接钉钉系统。实时发送消息]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/110482068</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/110482068</guid><author>qq_34237321</author><pubDate>Wed, 02 Dec 2020 15:11:06 +0800</pubDate><description><![CDATA[1：先添加机器人

2：记住webhook地址

3：登录jira管理系统（管理员权限）
点击设置-系统-网络钩子(webhook)

4:测试一下，在JD（我设置了筛选条件按）下面创建一个缺陷。


]]></description><category></category></item><item><title><![CDATA[python对MongoDB的操作]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/110135733</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/110135733</guid><author>qq_34237321</author><pubDate>Thu, 26 Nov 2020 19:36:56 +0800</pubDate><description><![CDATA[try:
        conn = MongoClient(ip, port)
        database = conn[db] #db为数据库名称
        my_set = database[tb]#tb为表名称
        # logger.info("需要检测的字段：{0}".format(field))
        nm_all = my_set.estimated_document_count()#数据库总条数
        all_dates=my_set.find.]]></description><category></category></item><item><title><![CDATA[Python判断字符串是否符合时间格式]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/110090677</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/110090677</guid><author>qq_34237321</author><pubDate>Tue, 24 Nov 2020 18:43:26 +0800</pubDate><description><![CDATA[strdate = “2020-1-2 12:1:1”
b = re.findall(":", strdate)
try:
    if len(b) &gt;= 2:
        time.strptime(strdate, "%Y-%m-%d %H:%M:%S")
        # time.strptime(check_date[ck_field], "Y年%m-%d %H:%M:%S")
    elif 0 &lt; len(b) &lt; 2:
        time.strptime(]]></description><category></category></item><item><title><![CDATA[Python计算2个时间的差值]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/110085852</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/110085852</guid><author>qq_34237321</author><pubDate>Tue, 24 Nov 2020 16:29:36 +0800</pubDate><description><![CDATA[计算程序执行了多长时间
starttime = datetime.datetime.now()
#程序代码。。。。。。。。。
endtime = datetime.datetime.now()
logger.info("开始时间：{0}".format(starttime))
logger.info("结束时间：{0}".format(endtime))
times = (endtime - starttime).seconds
logger.info("运行时间：{0}".format(datetime.]]></description><category></category></item><item><title><![CDATA[Python统计当前目录下的文件个数]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/110085081</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/110085081</guid><author>qq_34237321</author><pubDate>Tue, 24 Nov 2020 16:11:01 +0800</pubDate><description><![CDATA[import glob
path_file_number=glob.glob(pathname='./bug_back/*.txt') #获取当前文件夹下个数
print(path_file_number)
print(len(path_file_number))


]]></description><category></category></item><item><title><![CDATA[python对表格的操作]]></title><link>https://blog.youkuaiyun.com/qq_34237321/article/details/109989877</link><guid>https://blog.youkuaiyun.com/qq_34237321/article/details/109989877</guid><author>qq_34237321</author><pubDate>Mon, 23 Nov 2020 11:34:56 +0800</pubDate><description><![CDATA[只考虑对表格的读操作。
1：使用xlrd模块，了解基本属性
# 1、打开excel
import xlrd
readbook = xlrd.open_workbook(r'../template/JD数据检测模板.xls')#文档路径地址
# 2、获取读入的文件的sheet
sheet = readbook.sheet_by_name('ods_jd_brand')#文件的sheet名称
# 3、获取sheet的最大行数和列数
nrows = sheet.nrows#行
ncols = sheet.ncol]]></description><category></category></item></channel></rss>