c.execute("insert into coffees (id, flavor, time) values (?,?,?)", (uid, flavor, time))
close_db(conn)
-
-def list_coffees(uid=None):
- c = conn.cursor()
- if uid is None:
- for row in c.execute("select id, date(time, 'localtime'), flavor from coffees"):
- print(row)
- else:
- for row in c.execute("select date(time, 'localtime'), flavor from coffees where id = ?", (uid,)):
- print(row)
-
def flavors():
conn, c = open_db()
res = [row for row, in c.execute("select distinct name from flavors")]