+def Q(q, b="", t=["now", "-7 days"]):
+ """Return db query identified by `q`.
+
+ :param q: Identifier of query.
+ :param b: Optionally, specify the beverage(s).
+ :param t: Optionally, specify the time range.
+ """
+ assert isinstance(t, tuple) or isinstance(t, list)
+ assert len(t) == 2
+ if t[0] == "now":
+ dtf = f"datetime('now', 'localtime', '{t[1]}')"
+ dtt = "datetime('now', 'localtime')"
+ elif t[1] == "now":
+ dtf = f"datetime('now', 'localtime', '{t[0]}')"
+ dtt = "datetime('now', 'localtime')"
+ else:
+ dtf = f"datetime('{t[0]}', 'localtime')"
+ dtt = f"datetime('{t[1]}', 'localtime')"
+ if q == "get_drinks":
+ return f"""