python应用集合

最新推荐文章于 2024-07-17 09:15:39 发布

早起晚睡

最新推荐文章于 2024-07-17 09:15:39 发布

阅读量126

点赞数 6

文章标签： python 开发语言

本文链接：https://blog.csdn.net/bjgzxx/article/details/134645803

版权

一、Oracle数据库监控

import cx_Oracle
import smtplib
import pyttsx3
from email.mime.text import MIMEText


# 语音播报
def engine(voice):
    engine = pyttsx3.init()
    engine.say(voice)
    engine.runAndWait()

def send_mail(username, passwd, recv, title, content, mail_host='smtp.hbxdis.com', port=25):
    '''
    发送邮件函数，默认使用企业邮箱
    :param username: 邮箱账号 
    :param passwd: 邮箱密码
    :param recv: 邮箱接收人地址，多个账号以逗号隔开
    :param title: 邮件标题
    :param content: 邮件内容
    :param mail_host: 邮箱服务器
    :param port: 端口号
    :return:
    '''
    msg = MIMEText(content)  # 邮件内容
    msg['Subject'] = title  # 邮件主题
    msg['From'] = username  # 发送者账号
    msg['To'] = recv  # 接收者账号列表
    smtp = smtplib.SMTP(mail_host, port=port)  # 连接邮箱，传入邮箱地址，和端口号，smtp的端口号是25
    smtp.login(username, passwd)  # 发送者的邮箱账号，密码
    smtp.sendmail(username, recv, msg.as_string())
    # 参数分别是发送者，接收者，第三个是把上面的发送邮件的内容变成字符串
    smtp.quit()  # 发送完毕后退出smtp
    print('email send success.')
def oracle(user,passwd,ipstring,sqlstr,systemname):
    '''
    :param user: 数据库用户名 
    :param passwd: 数据库密码
    :param ipstring: 数据库连接串
    :param sqlstr: sql语句
    :return:
    '''

    content = ''
    # 1.建立连接
    conn = cx_Oracle.connect(user, passwd, ipstring)

    # 2.创建游标
    cursor = conn.cursor()

    # 3.执行SQL
    res = cursor.execute(sqlstr)
    

    # 4.获取数据
    data = res.fetchall()
    for tablespace_name, file_name,total_space in data:
        if total_space>0.8:
            content =content+systemname+ tablespace_name+'\r\n'
            
        # print('=' * 70)
        # print("表空间名：" + tablespace_name, "文件名和路径: " + file_name,"空间大小："+str(total_space))
    #send_mail(email_user, email_pwd, maillist, title, content)
    # 5.关闭游标
    cursor.close()

    # 6.关闭连接
    conn.close()
    return content
def main():
    email_user = '邮箱地址'  # 发送者账号
    email_pwd = '*******'  # 发送者密码
    maillist = '******@ceshi.com'
    title = 'oacle数据库表空间使用情况'
   
    sqlstr='''select tablespace_name,file_name,round(bytes / (1024 * 1024), 0)/32768 total_space from sys.dba_data_files'''
    
    #''' 连接10.2.1.100erp数据库测试库 '''
    str1_100=oracle('system', '******', '127.0.0.1:1521/racdb',sqlstr,'ERP测试系统10.2.1.100:')
    print(str1_100)

    
    #连接10.2.101.104MES数据库测试库 

    str101_104=oracle('system', '******', '127.0.0.1:1521/racdb',sqlstr,'MES测试系统:')
    
    #''' 连接10.2.101.84ERP数据库管理账 '''
    str101_84=oracle('system', '******', '127.0.0.1:1521/racdb',sqlstr,'ERP管理账系统:')
    
    #''' 连接10.2.1.55ERP数据库税务账 '''
    str1_55=oracle('system', '******', '127.0.0.1:1521/orcl',sqlstr,'ERP管理账系统:')

    #''' 连接10.2.1.55ERP数据库税务账 '''
    str101_83=oracle('system', '******', '127.0.0.1:1521/les',sqlstr,'MES和无人计量系统:')
        
    #连接10.2.101.104MES数据库测试库 

    str1_60=oracle('system', '******', '127.0.0.1:1521/sridbp',sqlstr,'首安云和电商系统:')
   
    
    send_mail(email_user, email_pwd, maillist, title, str1_100+str101_104+str101_84+str1_55+str101_83+str1_60)
    #engine(str1_100)

if __name__ == '__main__':
    main()

二、红包算法

# -*- coding: utf-8 -*-
import random
import sys
 
def randBonus(min, max, total,num):
    print (min, max, total, num )
    #print "{:.2f}".format(3.1415029)
    total = float(total)
    num = int(num)
    #设置最小红包钱数
    min = 0.01
     
    if num < 1:
        return
    if num == 1:
        print ("第%d个人拿到红包数:%.2f" %(num,total))
        return
    i = 1
    totalMoney = total
    while(i < num):
        max = totalMoney - min*(num- i)
        k = int((num-i)/2)
        if num -i <= 2:
            k = num -i
        max = max/k
        monney = random.randint(int(min*100), int(max*100))
        #monney = random.randint(int(min*100), int(max))
        monney = float(monney)/100
        #限制每人钱数
        #if monney>2:
        #    continue
        totalMoney = totalMoney - monney
        print ("第%d个人拿到红包为:%.2f, 余额:%.2f" %(i,monney,totalMoney))
        i += 1
 
    print ("第%d个人拿到红包为:%.2f, 余额:%.2f" %(i,totalMoney,0.00))
 
if __name__ == '__main__':
    #min = sys.argv[1]
    #max = sys.argv[2]
    #total = sys.argv[3]
    #num = sys.argv[4]
    
    min = 1
    max = 2
    total = 100
    num = 60
    randBonus(min, max, total, num)

三、邮箱发送

import smtplib
import pyttsx3
from email.mime.text import MIMEText


def send_mail(username, passwd, recv, title, content, mail_host='smtp.hbxdis.com', port=25):
    '''
    发送邮件函数，默认使用163smtp
    :param username: 邮箱账号 xx@163.com
    :param passwd: 邮箱密码
    :param recv: 邮箱接收人地址，多个账号以逗号隔开
    :param title: 邮件标题
    :param content: 邮件内容
    :param mail_host: 邮箱服务器
    :param port: 端口号
    :return:
    '''
    msg = MIMEText(content)  # 邮件内容
    msg['Subject'] = title  # 邮件主题
    msg['From'] = username  # 发送者账号
    msg['To'] = recv  # 接收者账号列表
    smtp = smtplib.SMTP(mail_host, port=port)  # 连接邮箱，传入邮箱地址，和端口号，smtp的端口号是25
    smtp.login(username, passwd)  # 发送者的邮箱账号，密码
    smtp.sendmail(username, recv, msg.as_string())
    # 参数分别是发送者，接收者，第三个是把上面的发送邮件的内容变成字符串
    smtp.quit()  # 发送完毕后退出smtp
    print('email send success.')
email_user = '邮箱地址'  # 发送者账号
email_pwd = '密码'  # 发送者密码
maillist = '邮箱'
title = '测试邮件标题'
content = '这里是邮件内容'
send_mail(email_user, email_pwd, maillist, title, content)
engine = pyttsx3.init()
engine.say('Sally sells seashells by the seashore.')
engine.say('The quick brown fox jumped over the lazy dog.')
engine.runAndWait()

三、MD5加密

#!/usr/bin/env python
# -*- coding: utf-8 -*-

from tkinter import *
import hashlib
import time

LOG_LINE_NUM = 0

class MY_GUI():
    def __init__(self,init_window_name):
        self.init_window_name = init_window_name


    #设置窗口
    def set_init_window(self):
        self.init_window_name.title("文本处理工具_v1.2")           #窗口名
        #self.init_window_name.geometry('320x160+10+10')                         #290 160为窗口大小，+10 +10 定义窗口弹出时的默认展示位置
        self.init_window_name.geometry('1068x681+10+10')
        #self.init_window_name["bg"] = "pink"                                    #窗口背景色，其他背景色见：blog.csdn.net/chl0000/article/details/7657887
        #self.init_window_name.attributes("-alpha",0.9)                          #虚化，值越小虚化程度越高
        #标签
        self.init_data_label = Label(self.init_window_name, text="待处理数据")
        self.init_data_label.grid(row=0, column=0)
        self.result_data_label = Label(self.init_window_name, text="输出结果")
        self.result_data_label.grid(row=0, column=12)
        self.log_label = Label(self.init_window_name, text="日志")
        self.log_label.grid(row=12, column=0)
        #文本框
        self.init_data_Text = Text(self.init_window_name, width=67, height=35)  #原始数据录入框
        self.init_data_Text.grid(row=1, column=0, rowspan=10, columnspan=10)
        self.result_data_Text = Text(self.init_window_name, width=70, height=49)  #处理结果展示
        self.result_data_Text.grid(row=1, column=12, rowspan=15, columnspan=10)
        self.log_data_Text = Text(self.init_window_name, width=66, height=9)  # 日志框
        self.log_data_Text.grid(row=13, column=0, columnspan=10)
        #按钮
        self.str_trans_to_md5_button = Button(self.init_window_name, text="字符串转MD5", bg="lightblue", width=10,command=self.str_trans_to_md5)  # 调用内部方法  加()为直接调用
        self.str_trans_to_md5_button.grid(row=1, column=11)


    #功能函数
    def str_trans_to_md5(self):
        src = self.init_data_Text.get(1.0,END).strip().replace("\n","").encode()
        #print("src =",src)
        if src:
            try:
                myMd5 = hashlib.md5()
                myMd5.update(src)
                myMd5_Digest = myMd5.hexdigest()
                #print(myMd5_Digest)
                #输出到界面
                self.result_data_Text.delete(1.0,END)
                self.result_data_Text.insert(1.0,myMd5_Digest)
                self.write_log_to_Text("INFO:str_trans_to_md5 success")
            except:
                self.result_data_Text.delete(1.0,END)
                self.result_data_Text.insert(1.0,"字符串转MD5失败")
        else:
            self.write_log_to_Text("ERROR:str_trans_to_md5 failed")


    #获取当前时间
    def get_current_time(self):
        current_time = time.strftime('%Y-%m-%d %H:%M:%S',time.localtime(time.time()))
        return current_time


    #日志动态打印
    def write_log_to_Text(self,logmsg):
        global LOG_LINE_NUM
        current_time = self.get_current_time()
        logmsg_in = str(current_time) +" " + str(logmsg) + "\n"      #换行
        if LOG_LINE_NUM <= 7:
            self.log_data_Text.insert(END, logmsg_in)
            LOG_LINE_NUM = LOG_LINE_NUM + 1
        else:
            self.log_data_Text.delete(1.0,2.0)
            self.log_data_Text.insert(END, logmsg_in)


def gui_start():
    init_window = Tk()              #实例化出一个父窗口
    ZMJ_PORTAL = MY_GUI(init_window)
    # 设置根窗口默认属性
    ZMJ_PORTAL.set_init_window()

    init_window.mainloop()          #父窗口进入事件循环，可以理解为保持窗口运行，否则界面不展示


gui_start()