class FileBackup(object):
_file_backup_db = 'DbBak'
_db = None
def __init__(self):
dbconfig = {'host':backup_config.BACKUP_INFO_DB_IP,
'port':backup_config.BACKUP_INFO_DB_PORT,
'user':AppConfig.MYSQL_ADMIN_USR,
'passwd':AppConfig.MYSQL_ADMIN_PSWORD,
'db':self._file_backup_db,
'charset':'utf8'}
self._db = MySQL_lightweight(dbconfig)
def get_file_backup_info_from_db(self, st_date=time.strftime("%Y-%m-%d",time.localtime(time.time()-24*60*60)), en_date=time.strftime('%Y-%m-%d',time.localtime(time.time()))):
if not (is_valid_date(st_date) and is_valid_date(en_date)):
raise Exception('It is not a valid date.')
sql = "SELECT name,file_name,file_size,bak_keep_host FROM file_backup WHERE TIME >= '%s' AND TIME < '%s' order by name" % (st_date, en_date)
print sql
self._db.query(sql)
result = self._db.fetchAllArray()
return result
def get_file_backup_info(self, st_date=time.strftime("%Y-%m-%d",time.localtime(time.time()-24*60*60)),
en_date=time.strftime('%Y-%m-%d',time.localtime(time.time()))):
if not (is_valid_date(st_date) and is_valid_date(en_date)):
raise Exception('It is not a valid date.')
result = {
'total': 0,
'success': 0,
'failed': 0,
'noback': 0,
'data_size': 0,
'disk_use': 0,
'bak_server': '',
'info': {}
}
need_backup = AppConfig.FILE_BACKUP
need_backup = list(need_backup)
result['total'] = len(need_backup)
items = self.get_file_backup_info_from_db()
for item in items:
if item['name'] in need_backup:
result['success'] += 1
need_backup.remove(item['name'])
result['data_size'] += item['file_size']
result['failed'] = len(need_backup)
result['info'] = items
result['bak_server'] = AppConfig.FILE_BACKUP_server
return result
def get_latest_server_use(self, ip):
if not (ip):
raise Exception('It is not a valid ip.')
sql = "Select IP, Path, DiskUse, AddTime from Backup_ServerUseFraction where IP='%s' Order by AddTime Desc limit 1;" % ip
print sql
self._db.query(sql)
result = self._db.fetchOneRow()
return result
class FileBackup(object):
_file_backup_db = backup_config.FILE_BACKUP_DB
_file_backup_servers = backup_config.FILE_BACKUP_SERVERS
_file_backup_types = backup_config.FILE_BACKUP_TYPES
_db = None
def __init__(self):
dbconfig = {
'host': backup_config.BACKUP_INFO_DB_IP,
'port': backup_config.BACKUP_INFO_DB_PORT,
'user': AppConfig.MYSQL_ADMIN_USR,
'passwd': AppConfig.MYSQL_ADMIN_PSWORD,
'db': backup_config.FILE_BACKUP_DB,
'charset': 'utf8'
}
self._db = MySQL_lightweight(dbconfig)
def get_file_backup_info_from_db(
self,
st_date=time.strftime("%Y-%m-%d",
time.localtime(time.time() - 24 * 60 * 60)),
en_date=time.strftime('%Y-%m-%d', time.localtime(time.time()))):
if not (is_valid_date(st_date) and is_valid_date(en_date)):
raise Exception('It is not a valid date.')
sql = "SELECT name,file_name,file_size,bak_keep_host FROM file_backup WHERE TIME >= '%s' AND TIME < '%s' order by name" % (
st_date, en_date)
print sql
self._db.query(sql)
result = self._db.fetchAllArray()
return result
def get_file_backup_info(
self,
st_date=time.strftime("%Y-%m-%d",
time.localtime(time.time() - 24 * 60 * 60)),
en_date=time.strftime('%Y-%m-%d', time.localtime(time.time()))):
if not (is_valid_date(st_date) and is_valid_date(en_date)):
raise Exception('It is not a valid date.')
result = {
'total': 0,
'success': 0,
'failed': 0,
'noback': 0,
'data_size': 0,
'disk_use': 0,
'bak_server': '',
'info': {}
}
need_backup = backup_config.FILE_BACKUP_TYPES
need_backup = list(need_backup)
result['total'] = len(need_backup)
items = self.get_file_backup_info_from_db()
for item in items:
if item['name'] in need_backup and item['file_size'] != 0:
result['success'] += 1
need_backup.remove(item['name'])
result['data_size'] += item['file_size']
result['failed'] = len(need_backup)
result['info'] = items
result['bak_servers'] = backup_config.FILE_BACKUP_SERVERS
return result
def get_latest_server_use(self, ip):
if not (ip):
raise Exception('It is not a valid ip.')
sql = "Select IP, Path, DiskUse, AddTime from Backup_ServerUseFraction where IP='%s' Order by AddTime Desc limit 1;" % ip
print sql
self._db.query(sql)
result = self._db.fetchOneRow()
return result
