Fix data acquisition for flavor graph.

Function 'coffee_flavors' wasn't doing what it was supposed to do.
Upper bound was shifted by a day (so for a week graph it was count-
ing 8 days) and also it didn't take into account 'start' variable.

diff --git a/coffee_db.py b/coffee_db.py
index 8653f98fbb274377c1b7b17b5c5f33fba7dd922b..7e28f923d851e25c37e2e8eb22cbf49766441dba 100644 (file)
--- a/coffee_db.py
+++ b/coffee_db.py
@@ -77,7 +77,7 @@ def coffee_flavors(uid=None, days=0, start=0):
     variables = list()
 
     if days is not None and days != 0:
-        query += " where date(time) between date('now', 'localtime', '-"+ str(days) +" days') and date('now', 'localtime', '-"+ str(start) +" days')"
+        query += " where date(time) between date('now', 'localtime', '-"+ str(days+start-1) +" days') and date('now', 'localtime', '-"+ str(start) +" days')"
 
         if uid is not None:
             query += " and id = ?"