-
- Supercontest.
- Followup appointment with PCP. Got the referrals approved for both ortho and for PT.
- The x-ray results:
- Soft tissues: Unremarkable.
- Bones: No acute fracture or subluxation. No lytic or blastic lesion.
- Joints: The joint spaces are preserved. Articular surfaces are unremarkable.
- So x-ray is fine. I’ll probably need to do an MRI, since this would imply that the muscle is the source of injury.
- Called the ortho place, made an appointment in Van Nuys for next wednesday.
- I’m going to hold off on scheduling the PT until after the ortho evaluation is done. Stim, stretching, strengthening, etc – I can do that all on my own. The referral won’t expired for 3 months, so I can schedule PT after ortho if need be.
- Got adjusted at chiro (bought the 3/$90), then went to the new Chick-Fil-A.
- For the last time: snake_case and camelCase and PascalCase.
- Reminder for ISO8601: https://www.cl.cam.ac.uk/~mgk25/iso-time.html. All dates should be in the format YYYY-MM-DD.
- A pipe | in a makefile is for order-only prerequisites. If you change any of those files, the parent recipe does not deem them necessary to rerun.
- Postgres.
- To get datatypes:
- select column_name, data_type from information_schema.columns where table_name = ‘<mytable>’;
- select pg_typeof(<mycol>) from <mytable> limit 1;
- I was very pleasantly surprised with postgresql’s ability to internally parse timestamps. It correctly converted the type ‘text’ to ‘timestamp with time zone’ for every single datetime string from westgate. I thought I would have to use the python logic I had written to do this, but it was dead easy using sql in the migration instead.
- lag() is a window function that allows you to update a row based on a previous row.
- You can use direct sqlalchemy inside of an alembic migration if you want. This might be easier to (add, modify, etc) your data in python rather than doing it in sql. https://stackoverflow.com/questions/13676744/using-the-sqlalchemy-orm-inside-an-alembic-migration-how-do-i/
- KFC is rolling out a chicken sandwich that uses glazed donuts instead of buns: https://www.cnn.com/2019/09/17/us/kfc-donut-chicken-sandwich-trnd/index.html.
- Remember https://www.pngtosvg.com/ is the right place for free online vector conversion with color.
- Just print(locals()) to show all args/kwargs passed to a function.
- Changed my default text editor for git to vim: git config –global core.editor “vim”
