Method ToBackup

class/databaseModel/sqlserverModel.py:195–227

@备份数据库 id 数据库id

(self, args)

        return public.returnMsg(True, 'DEL_SUCCESS')

    def ToBackup(self, args):
        """
        @备份数据库 id 数据库id
        """
        id = args['id']
        find = public.M('databases').where("id=? AND LOWER(type)=LOWER('SQLServer')", (id,)).find()
        if not find: return public.returnMsg(False, '数据库不存在!')

        self.CheckBackupPath(args)

        fileName = f"{find['name']}_sqlserver_data_{time.strftime('%Y%m%d_%H%M%S', time.localtime())}.bak"
        backupName = session['config']['backup_path'] + '/database/sqlserver/' + fileName

        mssql_obj = self.get_mssql_obj_by_sid(find['sid'])

        if not int(find['sid']):
            ret = mssql_obj.execute("backup database %s To disk='%s'" % (find['name'], backupName))
            isError = self.IsSqlError(ret)
            if isError != None: return isError
        else:
            # 远程数据库
            return public.returnMsg(False, '操作失败，远程数据库无法备份.')

        if not os.path.exists(backupName):
            return public.returnMsg(False, 'BACKUP_ERROR')

        public.M('backup').add('type,name,pid,filename,size,addtime', (1, fileName, id, backupName, 0, time.strftime('%Y-%m-%d %X', time.localtime())))
        public.WriteLog("TYPE_DATABASE", "DATABASE_BACKUP_SUCCESS", (find['name'],))

        if os.path.getsize(backupName) < 2048:
            return public.returnMsg(True, '备份执行成功，备份文件小于2Kb，请检查备份完整性.')
        else:
            return public.returnMsg(True, 'BACKUP_SUCCESS')

    def DelBackup(self, args):
        """