Oct 06: Introduction to SQLModel

Learning Objectives

After today's class, you should be able to:

• Define SQLModel classes that correspond to database tables.
• Create tables and insert objects using a Session.

Lesson Outline

SQLModel [25 min]

• SQL databases in Python
• models.py – hotel demo, rewritten

Mini Lab [25 min]

• SQLModel Mini Lab
  • Rewrite Thursday's create_load.py with two model classes
  • Steps 1–5 in class; Steps 6–7 if you have time

Exam 1 [25 min]

• Exam 1 Study Guide – outline and practice questions

Your To-Do List

• GP2 code review ← due Monday, Oct 12
• Study for Exam 1 ← Tuesday, Oct 13