Curso de FastAPI - Rest API com Python - Aula 09: Adicionar Item em Pedido e Relationship em Models

Want to learn more about our Complete Python Course? Click the link below to secure your spot in the next class: https://lp.hashtagtreinamentos.com/es... ----------------------------------------------------------------------- 📁 Files Used in Video: https://dlp.hashtagtreinamentos.com/p... 💻 Recommended video: FastAPI Course Playlist - Rest API with Python (Complete Backend)    • Curso de FastAPI - Rest API com Python (Ba...   ----------------------------------------------------------------------- If you prefer the video Text format: https://www.hashtagtreinamentos.com/c... ----------------------------------------------------------------------- TO HIRE HASHTAG FOR YOUR COMPANY: https://www.hashtagtreinamentos.com/t... ----------------------------------------------------------------------- 🚀 We've reached the ninth lesson of our FastAPI Course with Python, and now we'll take another important step in building a complete, efficient API with real business logic. You'll learn how to add items to existing orders, create schemas with Pydantic to validate item data, and connect database tables using SQLAlchemy relationships in a practical and organized way. In this lesson, we'll also apply advanced access control: only the administrator or order owner can add new items, ensuring security and consistency in API operations. All of this with permission checks within the function and clear error handling with HTTPException. Furthermore, we'll automate the order price calculation based on the added items, updating this value whenever there's a change, and using good modeling practices to keep your code clean and functional. Finally, we'll test everything in the interactive FastAPI documentation, simulating different usage scenarios. 🔔 If you're enjoying the complete FastAPI with Python course, subscribe to the channel, like it, and activate the bell to continue following all the lessons on backend development with Python and professional APIs! ----------------------------------------------------------------------- Hashtag Programming ► Subscribe to our channel: http://bit.ly/3c0LJQi ► Turn on notifications (click the bell)! ► Like our video! ----------------------------------------------------------------------- Social Media ► Blog: https://bit.ly/2MRUZs0 ► YouTube: http://bit.ly/3c0LJQi ► Instagram: https://bit.ly/3o6dw42 ► Facebook: http://bit.ly/3qGtaF2 Here in the videos on the Hashtag Programming channel, we teach several Python tips so you can develop in this programming language and create your own projects and automations! ----------------------------------------------------------------------- Class Content 00:00 Introduction to creating relationships between tables in FastAPI 01:10 How to list all orders in the system with a new route 02:28 Restrict access to the orders route with authentication and authorization 04:53 Test the new route with the admin user 06:43 Add an item to an order via an endpoint 08:46 Create the Pydantic schema for order items 11:10 Configure a POST route to add an item to an order 16:30 When should I update the order price? 19:48 Automatically update the order total when adding an item 21:35 Test the add item endpoint and check the result in the database 23:36 Create a function to calculate the total order price 24:40 Define a relationship between tables with SQLAlchemy relationship 26:07 How to use a relationship in a FastAPI model 28:45 Apply list comprehension to the price calculation function 30:00 Migrate the database with Alembic 32:00 Test the total price calculation function with items in the order 33:38 Fix a sum error in the total order price 34:43 Conclusion and next steps #python #hashtagprogramming