59 lines
2.1 KiB
Python
59 lines
2.1 KiB
Python
|
import os
|
|||
|
|
import time
|
|||
|
|
import sched
|
|||
|
|
import smtplib
|
|||
|
|
from email.mime.text import MIMEText
|
|||
|
|
from email.header import Header
|
|||
|
|
from email.mime.multipart import MIMEMultipart
|
|||
|
|
from email.mime.application import MIMEApplication
|
|||
|
|
# 第一个参数确定任务的时间，返回从某个特定的时间到现在经历的秒数
|
|||
|
|
# 第二个参数以某种人为的方式衡量时间
|
|||
|
|
schedule = sched.scheduler(time.time, time.sleep);
|
|||
|
|
def backupsDB():
|
|||
|
|
host = '210.77.68.250'
|
|||
|
|
db_user = 'drought'
|
|||
|
|
db_pwd = 'g214G214'
|
|||
|
|
db_port = '5432'
|
|||
|
|
db_name = 'drought'
|
|||
|
|
backup_path = '/home/xieshen/databackup/'
|
|||
|
|
today = time.strftime('%Y-%m-%d')
|
|||
|
|
s = "pg_dump -h " + host + " -p " + db_port + " -U " + db_user + " -W -F c --no-owner --no-privileges -d " + db_name + " > " + backup_path + today + ".dump"
|
|||
|
|
print(str(s))
|
|||
|
|
os.system(s)
|
|||
|
|
def sendMail():
|
|||
|
|
_user = "1397910458@qq.com"#发送者的邮箱
|
|||
|
|
_pwd = "XIESHEN95"#发送者的密码
|
|||
|
|
_to = "1679484695@qq.com"#接收者的邮箱
|
|||
|
|
msg = MIMEMultipart()
|
|||
|
|
msg["Subject"] = "数据库备份"
|
|||
|
|
msg["From"] = _user
|
|||
|
|
msg["To"] = _to
|
|||
|
|
# ---这是文字部分---
|
|||
|
|
part = MIMEText("数据库备份")
|
|||
|
|
msg.attach(part)
|
|||
|
|
# # ---这是附件部分---
|
|||
|
|
# # 类型附件
|
|||
|
|
# part = MIMEApplication(open('c:/abc_backup.sql', 'rb').read())
|
|||
|
|
# part.add_header('Content-Disposition', 'attachment', filename="abc_backup.sql")
|
|||
|
|
# msg.attach(part)
|
|||
|
|
s = smtplib.SMTP("smtp.exmail.qq.com", timeout=30) # 连接smtp邮件服务器,端口默认是25
|
|||
|
|
s.login(_user, _pwd) # 登陆服务器
|
|||
|
|
s.sendmail(_user, _to, msg.as_string()) # 发送邮件
|
|||
|
|
s.close();
|
|||
|
|
def perform_command(cmd, inc):
|
|||
|
|
# 安排inc秒后再次运行自己，即周期运行
|
|||
|
|
schedule.enter(inc, 0, perform_command, (cmd, inc));
|
|||
|
|
os.system(cmd);
|
|||
|
|
backupsDB();
|
|||
|
|
sendMail();
|
|||
|
|
def timming_exe(cmd, inc=10):
|
|||
|
|
# enter用来安排某事件的发生时间，从现在起第n秒开始启动
|
|||
|
|
schedule.enter(inc, 0, perform_command, (cmd, inc))
|
|||
|
|
# 持续运行，直到计划时间队列变成空为止
|
|||
|
|
schedule.run()
|
|||
|
|
if __name__ == '__main__':
|
|||
|
|
print("show time after 10 seconds:");
|
|||
|
|
timming_exe("echo %time%", 40);#每间隔56400秒备份发送邮件
|
|||
|
|
#46400 基本上是半天
|
|||
|
|
|