def get_history_size(self):
""" Returns the total size of the history and
amounts downloaded in the last month and week
"""
# Total Size of the history
total = 0
if self.execute('''SELECT sum(bytes) FROM history'''):
try:
total = self.c.fetchone().get('sum(bytes)')
except AttributeError:
pass
# Amount downloaded this month
# r = time.gmtime(time.time())
# month_timest = int(time.mktime((r.tm_year, r.tm_mon, 0, 0, 0, 1, r.tm_wday, r.tm_yday, r.tm_isdst)))
month_timest = int(this_month(time.time()))
month = 0
if self.execute('''SELECT sum(bytes) FROM history WHERE "completed">?''', (month_timest,)):
try:
month = self.c.fetchone().get('sum(bytes)')
except AttributeError:
pass
# Amount downloaded this week
week_timest = int(this_week(time.time()))
week = 0
if self.execute('''SELECT sum(bytes) FROM history WHERE "completed">?''', (week_timest,)):
try:
week = self.c.fetchone().get('sum(bytes)')
except AttributeError:
pass
return (total, month, week)
def get_history_size(self):
""" Returns the total size of the history and
amounts downloaded in the last month and week
"""
# Total Size of the history
total = 0
if self.execute('''SELECT sum(bytes) FROM history'''):
try:
total = self.c.fetchone().get('sum(bytes)')
except AttributeError:
pass
# Amount downloaded this month
# r = time.gmtime(time.time())
# month_timest = int(time.mktime((r.tm_year, r.tm_mon, 0, 0, 0, 1, r.tm_wday, r.tm_yday, r.tm_isdst)))
month_timest = int(this_month(time.time()))
month = 0
if self.execute('''SELECT sum(bytes) FROM history WHERE "completed">?''', (month_timest,)):
try:
month = self.c.fetchone().get('sum(bytes)')
except AttributeError:
pass
# Amount downloaded this week
week_timest = int(this_week(time.time()))
week = 0
if self.execute('''SELECT sum(bytes) FROM history WHERE "completed">?''', (week_timest,)):
try:
week = self.c.fetchone().get('sum(bytes)')
except AttributeError:
pass
return (total, month, week)
def get_history_size(self):
"""Returns the total size of the history and
amounts downloaded in the last month and week
"""
# Total Size of the history
total = 0
if self.execute("""SELECT sum(bytes) FROM history"""):
total = self.c.fetchone()["sum(bytes)"]
# Amount downloaded this month
month_timest = int(this_month(time.time()))
month = 0
if self.execute(
"""SELECT sum(bytes) FROM history WHERE completed > ?""",
(month_timest, )):
month = self.c.fetchone()["sum(bytes)"]
# Amount downloaded this week
week_timest = int(this_week(time.time()))
week = 0
if self.execute(
"""SELECT sum(bytes) FROM history WHERE completed > ?""",
(week_timest, )):
week = self.c.fetchone()["sum(bytes)"]
return total, month, week