Listing meal history here to help decide the next meal:
| place | last_time | count |
|---|---|---|
| french cafe | 2021-08-13 | 2 |
| burger | 2021-08-12 | 3 |
| sweden zizhu | 2021-08-11 | 1 |
| coop | 2021-08-09 | 2 |
| spicy hot | 2021-08-07 | 1 |
| test | 2021-08-07 | 2 |
| home cook | 2021-08-07 | 1 |
Updated at 2024年12月14日 星期六 15时15分22秒 PST
This page is generated by meal_choices.md.
Schema:
create table meals2 (
place text unique,
--- last time of the meal
last_time text,
--- how many times this place has been visited since 2021-08-07
count INTEGER
);Run this command to update your meal:
sqlite3 meals.sqlite3 "insert into meals2 values ('burger', date(), 1) on conflict(place) do update set count=count+1, last_time=date()"Back to Home