def get_stats_files(session):
total_files = 0 # number of files
total_size_bytes = 0 # bytes
total_duration_seconds = 0 # seconds
try:
File = models.File
result = session.query(File.size, File.duration).all()
for size, duration in result:
try:
size = int(size)
except Exception as e: # ignore some ill-records
LOG.warning("%s" % e)
size = 0
try:
duration = float(duration)
except Exception as e: # ignore some ill-records
LOG.warning("%s" % e)
duration = 0
total_files += 1
total_size_bytes += size
total_duration_seconds += duration
except Exception as e:
LOG.error("handling request: %s" % e)
stats = {
'total_files': total_files,
'total_size_bytes': total_size_bytes,
'total_duration_seconds': total_duration_seconds,
}
return stats
评论列表
文章目录