File size: 2,246 Bytes
020c337 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 | #!/usr/bin/python
# coding: utf-8
# -------------------------------------------------------------------
# 宝塔Linux面板
# -------------------------------------------------------------------
# Copyright (c) 2015-2099 宝塔软件(http://bt.cn) All rights reserved.
# -------------------------------------------------------------------
# Author: hwliang <hwl@bt.cn>
# -------------------------------------------------------------------
# -------------------------------------------------------------------
# 数据库定时备份检测
# -------------------------------------------------------------------
import os, sys, re, public
_title = '数据库定时备份检测'
_version = 1.0 # 版本
_ps = "检测所有数据库是否设置定期备份" # 描述
_level = 2 # 风险级别： 1.提示(低) 2.警告(中) 3.危险(高)
_date = '2020-08-04' # 最后更新时间
_ignore = os.path.exists("data/warning/ignore/sw_database_backup.pl")
_tips = [
"在【计划任务】页面将未设置备份的数据库设置定期备份，或设置备份所有数据库",
"提示：未设置数据库定期备份的情况下，一但发生意外导致数据丢失，无处恢复，损失巨大",
]
_help = ''
_remind = '此方案可以预防数据库丢失数据，保证数据的安全。'
def check_run():
'''
@name 开始检测
@author hwliang<2020-08-03>
@return tuple (status<bool>,msg<string>)
'''
if os.path.exists('/www/server/panel/plugin/enterprise_backup'):
return True, '无风险'
if public.M('crontab').where('sType=? AND (sName=? OR sName=?)', ('database', 'ALL', '全部')).count():
return True, '无风险'
# if public.M('crontab').where('sType=? AND sName=?', ('database', '全部')).count():
# return True, '无风险'
db_list = public.M('databases').field('name').select()
not_backups = []
sql = public.M('crontab')
for db in db_list:
if sql.where('sType=? AND sName=?', ('database', db['name'])).count():
continue
not_backups.append(db['name'])
if not_backups:
return False, '以下数据库未设置定期备份: <br />' + ('<br />'.join(not_backups))
return True, '无风险'
|