Notes from Django Apps workshop 4/12/2023 - Githubissues

pamelafox / my-py-talks

My Python talks

https://pamelafox.github.io/my-py-talks/

6 stars 2 forks source link

Notes from Django Apps workshop 4/12/2023 #5

Open pamelafox opened 1 year ago

pamelafox commented 1 year ago

We went over on time, so it should either be 2 workshops or a 3-hour workshop with a 5-10 min break in the middle.

Timing: 1:04PM: Start exercise 1:25PM: Done 1:50PM: Exercise #2 1:58PM: Hosting

[x] Add a slide specifically about migrations
[x] Upgrade code to SQLAlchemy 2.0
[x] Add a slide about SQLAlchemy queries
[x] Add to Prereqs: Local PostgreSQL
[x] Make sure SQLTools start off as enabled
[x] Update deployment diagrams/slides to be accurate

[x] Better injection example:

user_input = "Bobby"
user_input = "Bobby); DROP TABLE students;"

"SELECT name, title FROM organizers where name = " + user_input

[ ] For each exercise, show solution after or put in a branch and link it

pamelafox commented 1 year ago

Timing:

9:30: Start 10:40: Exercise #1 11:07: Exercise #1 Done 11:35: Exercise #2 12:05: Exercise #2 Done

Codespace issues:

Student confused by Key Bindings message and whether it mattered.

TODO:

[ ] https://github.com/kjaymiller/cookiecutter-relecloud/issues/215
[ ] https://github.com/kjaymiller/cookiecutter-relecloud/issues/213
[ ] https://github.com/kjaymiller/cookiecutter-relecloud/issues/212
[ ] Add Key Vault to architecture slide
[ ] Slide about database hosting considerations (slides/replicas/etc)