🐝 Queries & Using the Shell 🐝

Today’s Topics

• Interacting with models in the shell
• Queries and more queries

🎯 Project: Still Working on Habit Tracker

Habit Tracker is due on Monday. You can do this! 💪 What do you need to know in order to finish it?

📖 Read | 📺 Watch | 🎧 Listen

This section is material to prep for the topic we will begin next week: building APIs.

• RESTful APIs – read up through the “Standard Methods” subsection of the section on “Methods”. You can read more if you want to but it gets pretty deep.
• Safia Abdullah, You and Me Learn All About HTTP

🔖 Resources

• Pretty Printed Video: How Model Queries Work in Django
• Pretty Printed Video: Querying One-to-Many Relationships in Django
• Django QuerySets
• Django Model Managers
• Django Queries: Retrieving Objects
• Field lookups
• Lookups that span relationships
• Lookups with Related objects
• Django Related Objects Reference
• Complex lookups with Q
• F objects

Aggregate & Annotate

• PrettyPrinted Video: Basics of Django Aggregations
• Pretty Printed Video: How to Use Annotate in Django
• Django docs:Aggregate & Annotate
• Django docs: Combining Aggregations with other QuerySets
• Aggregation Functions (e.g., Avg, Count, Min, Max)

🦉 Code & Notes

• Django Model Queries CheatSheet