Candy.Zhao-CSDN博客

原创 python发送HTML表格邮件

import tracebackimport requestsimport loggingimport osfrom mysql_factory.connection import Conn_Dbfrom mysql_factory.dau import Data_utilsfrom Git_factory.dau import Data_Handlefrom Git_factory.connection import Conn_Gitfrom pprint import pprintfr

2021-02-02 17:08:15 1038 2

原创 SQL语句---子查询、行列互换、if语句

select A.date_range,`USER`,A.USER_ID,A.PROJECT,`GROUP`,sum(IF(A.staus='pushed to',A.ct, 0)) as `pushed to`,sum(IF(A.staus='pushed new',A.ct,0)) as `pushed new`,sum(IF(A.staus='created',A.ct,0)) as `created`,sum(IF(A.staus='deleted',A.ct,0)) as `delete.

2021-01-29 16:33:14 307

原创行列互换

这里是引用https://stackoverflow.com/questions/12598120/mysql-pivot-table-query-with-dynamic-columns

2020-12-28 17:17:21 209

原创 Python-flask-render_template（）函数

#run.py文件from flask import Flask, render_templateapp = Flask(__name__)@app.route("/")def template_test(): return render_template('template.html', my_string="Wheeeee!", my_list=[0,1,2,3,4,5])result=app.template_test()print(result)# if __name__

2020-12-23 21:08:50 1934 1

原创 flask-python-html表格

#!/usr/bin/env python3# -*- coding:utf-8 -*-#test.py文件 import jsonfrom flask import Flask, render_template app = Flask(__name__) # @app.route("/")# @app.route("/index.html")def index(): # flask_data = 'Hello Flask!' flask_data='name'

2020-12-23 21:02:47 1421

原创 python调用webservice接口发邮件

from suds.client import Clientfrom suds.transport.https import HttpAuthenticated t = HttpAuthenticated(username = '你的账号' ,password = '你的密码' ) url = 'http://msgcenter.xxxxx.vvvvv.com/Messaging.asmx?wsdl'test = Client(url,transport = t)res

2020-12-18 10:11:24 398 1

原创 python发邮件的第一种方法

from suds.client import Clienturl = 'http://msgcccffffsdd.com/Messaging.asmx?wsdl'client=Client(url)header={'UserId':'mmmmm','Password':'swwwwww4'}client.set_options(soapheaders=[header,])res=test.service.SendGroupMails(TO,CC,Subject,Body,Smtpld.

2020-12-18 10:08:29 169

原创文字检测（白底黑字）

在这里插入代码片`@TOCimport cv2import numpy as npimg = cv2.imread(‘截图.jpg’)cv2.imshow(‘原图片’,img)cv2.waitKey()dst=cv2.cvtColor(img,cv2.COLOR_BGR2GRAY)cv2.imshow(‘灰度图’,dst)cv2.waitKey()sobel_dst=cv2.Sobel(dst,cv2.CV_8U, 1, 0, ksize=3)cv2.imshow(‘梯度检测’,sobe

2020-12-03 14:31:17 810

原创图像金字塔相关练习

在这里插入代码片```#11.1使用函数cv2.pyrDown()对一幅图像进行向下采样，观察采样的结果'''import cv2 img=cv2.imread('XZ.jpg')r1=cv2.pyrDown(img)r2=cv2.pyrDown(r1)r3=cv2.pyrDown(r2)print('img.shape=',img.shape)print('r1.shape=',r1.shape)print('r2.shape=',r2.shape)print('r3.shape=',

2020-10-09 15:17:33 185 1

原创 shape[:2]相关问题

img.shape[:2]取彩色图片的长、宽img.shape[:3]取彩色图片的长、宽、通道img.shape[0]图像的垂直尺寸（高度）img.shape[1]图像的水平尺寸（宽度）img.shape[2]图像的通道数注：矩阵中，[0]表示行数，[1]表示列数...

2020-10-07 17:47:19 5246

原创 python基础练习之实战

#确定列表长度cars=[‘bow’,‘audi’,‘toyota’,‘subaru’]long=len(cars) #使用len()快速获悉列表长度print(long)for car in cars: #利用for循环遍历整个列表print(car)#遍历列表magicians=[‘alice’,‘david’,‘carolina’]for magician in magicians:#print(magician)print(magician.title() + ‘,that

2020-09-22 19:38:09 414

原创 OpenCV-python中循环读取图片

OpenCV-python中循环读取图片

2020-09-17 10:05:42 4599

原创 OpenCV-python显示图片时图片比窗口大的解决办法

显示图片过大与窗口不符最先开始的写法imageB = cv2.imread(r"NG.bmp")cv2.imshow(‘demo1’,imageA)cv2.waitKey()cv2.destroyAllWindows()导致显示的图片与窗口不符合解决办法cv2.namedWindow(‘demo’, 0)cv2.imshow(“demo”,imageA)cv2.waitKey(0)cv2.destroyAllWindows()若想直接规定打开图片的大小cv2.namedWindow

2020-09-15 08:50:10 3744

原创 OpenCV-python利用鼠标绘制ROI区域

一、利用鼠标移动截取感兴趣区域ROI：OpenCV-python自带 API 可直接选择矩形区域作为ROI，该API位于目标追踪模块，主要是cv2.selectROI()函数import cv2img = cv2.imread(“D:\OpenCV-python ROI\sliceROI_image.jpg”)#windowName：选择的区域被croi = cv2.selectROI(windowName=“roi”, img=img, showCrosshair=True, fromCenter

2020-09-07 16:51:45 2664 3

zhaoqian199529的博客