Django Conditional Expressions / Case() and When() objects

In this video, we'll show examples of how to perform Conditional Expressions in Django.
These allow developers to perform IF/ELSE logic within database queries, and get back values based on conditions that are defined using Case and When objects.
☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲:
To support the channel and encourage new videos, please consider buying me a coffee here:
ko-fi.com/bugb...
▶️ Full Playlist:
• Django ORM Deep Dive
𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:
📖 Blog: bugbytes.io/po...
👾 Github: github.com/bug...
🐦 Twitter: / bugbytesio
📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:
Django Conditional Expressions: docs.djangopro...
#python #django #webdevelopment #database #sql

[@bugbytes3923]

ORM Playlist link: kzbin.info/www/bejne/e6SlonyQordli8U

[@trosgate]

I will be deceiving myself if I don't drop a comment on this. These are advanced topics littered in few books. You have simplified everything.❤

[@bugbytes3923]

Awesome - thanks a lot for the nice comment!

[@alexisrichard1812]

Perfect. Simple, clear and well explained. Continue this way. I do not raise very often comment but as previously said by others, it is really great videos on ORM. Many thanks for your time and dedication. You should think about posting training on udemy or others sites, I will definitively support you.

[@bugbytes3923]

Thanks a lot! Appreciate the nice comment, I'll maybe try releasing some full courses after new year I think. Thanks again!

[@juanbetancourt5106]

I use to use Pandas for that type of data analysis but the orm seems like a robust way to handle the same logic, thank your good Sr.

[@bugbytes3923]

Thanks - Pandas is always good too, but definitely a heavier dependency in a web app!

[@seydinaoumarsamabaly1806]

I knew these concepts from SQL, now in Django Orm 😀. Thank you very much Master 🙌🏾.

[@bugbytes3923]

Thanks a lot!

[@DecodingTruth101]

amazing content ,great tutor

[@bugbytes3923]

Thanks so much!

[@DjangoNator]

man u actually a hero

[@bugbytes3923]

Thanks a lot, glad to hear that!

[@anatoliyloboda4601]

Thanks for good explanation! Even though it looks a little complicated, for me it is amazing. I will be poud if I could to write such a comprehensive code!

[@bugbytes3923]

Thanks a lot! Appreciate it! And yes, it's a little complex, and not something you'd use every day as a Django dev. Useful to know, though!

[@Developer_python_]

Very useful lesson

[@bugbytes3923]

@@Developer_python_ thank you 🙏

[@uttamsharma3242]

Well explanation, Thank you so much

[@bugbytes3923]

Thanks a lot!

[@oizik]

Brilliant content, thank you so much!

[@bugbytes3923]

Thanks a lot!

[@repotranstech]

Great video as always.

[@bugbytes3923]

Thanks a lot!

[@jonathacarneiro]

amazing content, congratulations!

[@bugbytes3923]

Thanks a lot for watching and commenting, cheers!

[@khalilbenmeziane8836]

great teacher 🌹

[@bugbytes3923]

Thanks a lot!

[@miguelvasquez9849]

it helps me a lot, thanks

[@bugbytes3923]

Thanks, great to hear that!

[@alexdubkov6998]

Super!

[@bugbytes3923]

Thank you!

[@hack727]

Great content, plz make a video on django signals.

[@bugbytes3923]

Will do! Coming up soon...

[@imanirban]

hello?... I'm working with a HTMX file upload form, I want to have a cancel button, on click, the post request will be cancelled, how do I cancel it?...

[@khunjohn1054]

THIS ... WAS ... AWESOME. I've yet to use the case and when structures so was. More advanced topics are welcome. Here's an idea/challenge I was mulling over the other day in regards to Django vs FastApi. Everyone wants fast, modern and async, but I won't give up on the orm or the migrations. Yes I can use SQLAlchemy and Alembic, but it doesn't have the same sleekness. Can you get the same speed and lightness in Django by using Daphne/Uvicorn ASGI, the async ORM functions, and async functions using Django-Nina as the serializer? I'm not sure if ninja has implemented pydantic 2.0 yet, but their first full release is in beta 1.

[@bugbytes3923]

Thanks! And interesting idea there - I'll need to revisit django-ninja. Some of my earliest videos where I actually put more thought into the planning were on Ninja, but I'm not sure if it supports Pydantic 2.0 yet.

[@frameff9073]

thank you

[@bugbytes3923]

Thanks a lot!

[@shahabgohar3350]

Majestic

[@myoji5580]

I watched your videos many times. Very thanks. I just talked program bug. Not offensive. I don’t understand why delete my comment.

[@bugbytes3923]

Please post the bug here! KZbin must have deleted that comment (this happens a lot!). Thanks for watching!

[@myoji5580]

This code have a bug If last_sale: 2023-08-03 dates last date range: 2023-07-30 ~ 2023-08-09 But last sale: 2023-08-03 Right dates last date range: 2023-07-30 ~ 2023-08-03(03? 04?) Additionally, Filtering a DateTimeField with dates won’t include items on the last day, because the bounds are interpreted as “0am on the given date”. If pub_date was a DateTimeField, the above expression would be turned into this SQL: SELECT ... WHERE pub_date BETWEEN '2005-01-01 00:00:00' and '2005-03-31 00:00:00'; Thanks lecture!😊 Delete Django link. I think link problem

[@dmitrymikhailovnicepianomu8688]

Not easy to grasp!