Method insert_db

class/process_task.py:634–680

@name 插入数据库 @param process_info_list list @return bool

(self, process_info_list, _time)

        return time.time() - _day * 86400

    def insert_db(self, process_info_list, _time):
        '''
            @name 插入数据库
            @param process_info_list list
            @return bool
        '''
        if not process_info_list: return
        all_top, cpu_top, disk_top, net_top, memory_top = self.get_top_list(
            process_info_list)

        with db.Sql().dbfile('system') as _sql:
            if not _time:
                _time = int(time.time())
            _sql.table('process_top_list').insert({
                'all_top':
                dumps(all_top),
                'cpu_top':
                dumps(cpu_top),
                'disk_top':
                dumps(disk_top),
                'net_top':
                dumps(net_top),
                'memory_top':
                dumps(memory_top),
                'addtime':
                _time
            })

            # 删除过期数据
            if not self.__insert_time: self.__insert_time = _time
            if _time - self.__insert_time > 3600:
                self.__insert_time = _time
                _sql.table('process_top_list').where('addtime<?', self.get_expire_time()).delete()
                
                # 释放一次磁盘空间
                system_vacuum_file = "{}/data/system_vacuum.pl".format(public.get_panel_path())
                do_vacuum = False
                if not os.path.exists(system_vacuum_file):
                    public.writeFile(system_vacuum_file, str(int(time.time())))
                    do_vacuum = True
                elif os.path.getmtime(system_vacuum_file) < time.time() - 86400 * 7:
                    public.writeFile(system_vacuum_file, str(int(time.time())))
                    do_vacuum = True
                if do_vacuum:
                    _sql.execute('VACUUM', ())

            _sql.close()

    def get_top_list(sekf, process_info_list):
        ''&#x27;