The dinrplan from godsmith

Got 502 from server

Using the web CLI, I could run a few commands. The dinrplan-db was listed as suspended, and the machine had not started:

/app/bin $ fly apps list
NAME                                    OWNER           STATUS          PLATFORM        LATEST DEPLOY 
dinrplan                                personal        deployed        machines        8m28s ago    
dinrplan-db                             personal        suspended       machines                     
fly-builder-billowing-cloud-7534        personal        deployed        machines  

/app/bin $ fly checks list -a dinrplan-db
Health Checks for dinrplan-db
  NAME | STATUS  | MACHINE        | LAST UPDATED         | OUTPUT                      
-------*---------*----------------*----------------------*-----------------------------
  pg   | warning | 5683074f00d08e | 2023-06-26T20:33:15Z | the machine hasn't started  
-------*---------*----------------*----------------------*-----------------------------
  role | warning | 5683074f00d08e | 2023-06-26T20:33:15Z | the machine hasn't started  
-------*---------*----------------*----------------------*-----------------------------
  vm   | warning | 5683074f00d08e | 2023-06-26T20:33:15Z | the machine hasn't started  
-------*---------*----------------*----------------------*-----------------------------

However, I could not restart it:

/app/bin $ fly pg restart -a dinrplan-db
Error: no active leader found

But I could restart the machine dinrplan-db was running on, and that fixed it:

/app/bin $ fly machine list -a dinrplan-db
1 machines have been retrieved from app dinrplan-db.
View them in the UI here (https://fly.io/apps/dinrplan-db/machines/)

dinrplan-db
ID              NAME                    STATE   REGION  IMAGE                           IP ADDRESS                              VOLUME                 CREATED                 LAST UPDATED            APP PLATFORM    PROCESS GROUP   SIZE                
5683074f00d08e  winter-forest-5654      stopped ams     flyio/postgres:14.6 (v0.0.34)   fdaa:0:a08f:a7b:23c5:dd86:e028:2        vol_5podq4qzxed4g8w1   2023-03-09T18:25:11Z    2023-06-26T20:33:15Z                    app             shared-cpu-1x:256MB

/app/bin $ fly machine restart 5683074f00d08e -a dinrplan-db
Restarting machine 5683074f00d08e
  Waiting for 5683074f00d08e to become healthy (started, 3/3)
Machine 5683074f00d08e restarted successfully!
/app/bin $ fly pg list
NAME            OWNER           STATUS          LATEST DEPLOY 
dinrplan-db     personal        deployed                     

/app/bin $ fly checks list -a dinrplan-db
Health Checks for dinrplan-db
  NAME | STATUS  | MACHINE        | LAST UPDATED | OUTPUT                                                                   
-------*---------*----------------*--------------*--------------------------------------------------------------------------
  pg   | passing | 5683074f00d08e | 25s ago      | [✓] transactions: read/write (192.07µs)                                  
       |         |                |              | [✓] connections: 11 used, 3 reserved, 300 max (3.89ms)                   
-------*---------*----------------*--------------*--------------------------------------------------------------------------
  role | passing | 5683074f00d08e | 26s ago      | leader                                                                   
-------*---------*----------------*--------------*--------------------------------------------------------------------------
  vm   | passing | 5683074f00d08e | 49s ago      | [✓] checkDisk: 805.58 MB (82.5%) free space on /data/ (32.12µs)          
       |         |                |              | [✓] checkLoad: load averages: 0.00 0.00 0.00 (57.18µs)                   
       |         |                |              | [✓] memory: system spent 0s of the last 60s waiting on memory (34.64µs)  
       |         |                |              | [✓] cpu: system spent 168ms of the last 60s waiting on cpu (15.91µs)     
       |         |                |              | [✓] io: system spent 246ms of the last 60s waiting on io (14.65µs)       
-------*---------*----------------*--------------*--------------------------------------------------------------------------
/app/bin $

Dark mode: current day not showing

No cancel button/escape does nothing when editing a day

Improve interface for setting rating

Number of stars?

Investigate if we can avoid logging in using the login page for each playwright test

https://playwright.dev/python/docs/auth/

Running poetry update or poetry lock adds psycopg2 to poetry.lock, which makes subsequent installations from scratch fail

Recipes page: Show visual confirmation when a meal is assigned to a day

Crash after logging in

To reproduce, log out and then in again. The redirect seems to be broken.

Change from daphne to gunicorn

Reportedly faster. Can't run under Windows, but there we can run the development server instead.

Pressing ok or cancel when editing a day closes all days being edited

From recipe list, assign recipe to next empty day

Instead of just delete button add expanding "..." with the two options delete and assign to next empty day?

Make is_created a BooleanField instead

Currently you just check if the ingredientsfield is filled in, which is a bit crude. A better way would be to set it when you update the recipe for the first time. That is also the way it works in old dinnerplan.

Clicking edit day button shall focus input field

Drag and drop days

Dinnerplan code: https://github.com/Godsmith/dinnerplan/blob/5ea4d3f97891ad41e4d141a4ceffea893f509b78/client/views/plan/day.js

Tutorial: https://www.javascripttutorial.net/web-apis/javascript-drag-and-drop/

Filter by category on recipes page

Recipe list

Must be able to click the recipes. Preferably to open them in a modal or something.

Remove brief flash after creating edit day button

The vanilla select element is briefly visible before it is replaced by selectize.

Edit meal page is ugly

Switch from as_p to as_table and see if that is better. Use a bootstrap table.

Delete recipe

playwright tests

Selectize dialog is still open after choosing a meal

It hides the ok button.

Put OK on the left of all dialogs instead to follow Windows conventions

Also requires less tabs to get there. Although the case is not clear-cut, see discussion here: https://ux.stackexchange.com/questions/1072/ok-cancel-on-left-right

Deploy on pythonanywhere

Enable migrating old database

Comments

Editing meal on recipes page redirects to main page

Archive feature

Perhaps needed because we want to import all the recipes at once, but we don't want all of them visible in the list. Perhaps this feature can be removed later.