SQLAlchemy 2 In Practice - Solutions to the Exercises
a day ago
- The article provides solutions to all exercises from the SQLAlchemy 2 in Practice series, covering chapters 2 to 6.
- Chapter 2 solutions focus on basic queries on a Product table, including filtering by year, CPU type, country, and aggregate functions.
- Chapter 3 solutions involve joins between Product and Manufacturer tables, with conditions on manufacturer name and product CPU.
- Chapter 4 solutions use many-to-many relationships with Country table, including queries on products by country, countries with most products, and joint production.
- Chapter 5 solutions cover orders, order items, and product reviews, including aggregation, filtering, and joins across multiple tables.
- Chapter 6 solutions involve page analytics with BlogArticle and BlogView tables, including views by language, time periods, and article translations.
- Each solution includes the SQLAlchemy ORM query code and the resulting output, with notes on alternatives and important considerations like using distinct() or left outer joins.