Django ORM - Querying and Creating Records / Working with Foreign Keys

[@bugbytes3923]

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

[@anouarbagent2511]

this is literally the best Django Channel there is, keep up the good work Lyle it will definitely get much bigger.

[@bugbytes3923]

Wow, thanks Anouar! Glad you like the content!

[@Davidkiania]

I agree entirely ..

[@anthonykarungu1419]

Totally agree. I really follow your content now.

[@BhaiyaJee]

Why this man have only 31.6k Subs he deserves much more

[@bugbytes3923]

Haha thanks, nice to hear that!

[@annyd3406]

One of the best tut i have watched while learning DJANGO , Thanks Mate.

[@bugbytes3923]

Thanks a lot mate for the kind words! Glad you liked it.

[@552rajeshyadav2]

I don't get any channel regarding django orm since past few months but got an exciting series from heaven thank u❤❤❤❤

[@bugbytes3923]

Thank you so much, really appreciate the nice comment! 🙂

[@hiankitkr]

showing sql was great, it gives idea of what queries is being executed, keep doing it.

[@bugbytes3923]

Thanks Ankit, will do!

[@sidds09]

great. I don't think anybody explaining these things in django. most just touch the basic things. super helpful. just keep on doing.. . hope you also spend enough time on authentication and show custom user models in future.

[@bugbytes3923]

Thank you - glad it is helpful :) Will do!

[@alvarofigueroa4693]

Thanks man! This video of yours just help me run a script to create some fake data for an app I am working on. Being a beginner when it comes to Python and Django, your work is very inspiring and easy to understand and follow along. Cheers

[@bugbytes3923]

@@alvarofigueroa4693 glad to hear it helped man! Thanks for the nice words 🙏

[@AmoahDevLabs]

It's always good to have you here. Thanks very much for the insights you've been given.

[@bugbytes3923]

Thanks a lot!

[@seydinaoumarsamabaly1806]

So simple, so easy to learn with you master 🙌🏾. Thank you.

[@bugbytes3923]

Thank you for the support Seydina! 😀

[@Davidkiania]

Dj-Sensei 😁

[@bugbytes3923]

@@Davidkiania 😅

[@iiju8212]

I haven't seen the video yet. But I am grateful that you are putting such videos out.

[@bugbytes3923]

Thank you - hope you like this video.

[@Davidkiania]

Thank you so much for this tutorial and of course very interested in this content and please continue in this very format there's very little internet content on the same. Excellent stuff

[@bugbytes3923]

Thank you David - will do!

[@LegionLeague]

Please keep going with this series. Like from me on every single video here. This is amazing.

[@bugbytes3923]

Thanks a lot! Really happy the series has been useful - got around 15 more videos written up, so plenty more to come!

[@iwswordpress]

another excellent video! Channel is probably the best for Django and related subjects.

[@bugbytes3923]

Thanks a lot!

[@Ego_Maritm]

As always, great, high level, and detailed videos. Thank you so much.💪

[@bugbytes3923]

Thanks a lot! :)

[@carstenthies9597]

Excellent video series so far. A bit fast but that keeps you focused. Not exactly for people with a moder super short attention span. Thank You so much for putting this together, learning a lot.

[@bugbytes3923]

Thank you! I'll take the suggestions on board, too! Thanks for watching.

[@silkogelman]

This is a great tutorial about querying the database with Django! 🙏😀👍 I like that you show the under-the-hood SQL queries sometimes (and not too much). And as pprint alternative: the rich and django-rich libraries are great for pretty printing stuff to the terminal too.

[@bugbytes3923]

Thanks a lot Sil! I'll look into rich/django-rich - haven't used those tools yet.

[@silkogelman]

@@bugbytes3923 With rich I love that it requires zero code change as drop-in replacement 'from rich import print'. Done.

[@ffzz007]

Thanks Alot... You are my Django Mentor

[@bugbytes3923]

Thanks a lot! :)

[@ytouate]

Very Great content, Just keep doing the queries explanation and Thank you

[@bugbytes3923]

Thanks a lot!

[@gigi123-hp3]

Very well explained..❤

[@bugbytes3923]

Cheers! Glad you thought so!

[@zxmu5755]

¡Gracias!

[@bugbytes3923]

Thanks so much!

[@abdullahmosbah8410]

the most useful course

[@bugbytes3923]

@@abdullahmosbah8410 thanks a lot!

[@shamshad-live]

Perfect explanation !

[@bugbytes3923]

Thanks a lot!

[@امینجمالی-خ9ص]

awesome explanations thank you

[@bugbytes3923]

Thanks a lot!

[@Surajkumar-ok4ze]

Awesome explanation

[@bugbytes3923]

Thanks a lot!

[@MayasMess]

Awesome video 💪

[@bugbytes3923]

Thanks a lot!!

[@SOHAILKHAN-iu8fu]

Awesome video 💪 plz Also make video on django subquery

[@bugbytes3923]

Thank you! For sure, I'll do one on this later in this series.

[@zxmu5755]

Thank you so much!

[@bugbytes3923]

Thanks for watching!

[@nicenaija9952]

I see you’ve reviewed django-hijack. Have a look at Django-unfold too

[@bugbytes3923]

Thanks, will do!

[@TomislavMiletic]

Thank you, 3 lessons in and already better than paid udemy orm course, straight to the point without losing time on theory. Is there an option to pay something in order to suggest, and you maybe take into consideration to create a video on that subject?

[@bugbytes3923]

Hi Tomislav - thanks a lot for your support! You are free to suggest anything here, thank you! If you can support in any way (no obligation of course), there is also a ko-fi page: ko-fi.com/bugbytes Thanks again and glad you're enjoying the series! I have actually just this second finished recording the next video in this series - will be released this week.

[@ammaryasser4839]

Go on, if you make a complete course on Django for beginners it will be very useful and it will be a unique explanation

[@bugbytes3923]

I'm looking forward to doing this at some point - just need to find the time!

[@olable9]

I'm definitely interested

[@bugbytes3923]

Thank you!

[@raffritter6766]

Thank you very much! 👍 Where would you put that logic? Do you use fat models? Btw. I'm interested in sql queries though I'm glad the ORM does the heavy lifting.

[@bugbytes3923]

Thanks! I put a lot of the logic in models usually. Or use a custom manager or queryset implementation - more on that later in this series! Generally, in a real app, I try to keep the views thin, with different techniques for doing so.

[@raffritter6766]

@@bugbytes3923 Awesome, I can't wait to see that in action!

[@studioteque]

Would love it if you would do a video on creating a multi-tenant Django app. For example a SaaS that allows for organizations with multiple related users.

[@jedi2light]

Isn't it confusing that UPDATE statement on save() method call contains all the fields whereas we only changed `name` of the restaurant? 23:56 Just in case if someone is wondering how to avoid it, we can pass `update_fields` to `save()` methods which a list of strings where each string is the name of the field we want to include in `UPDATE...` statement produced by Django ORM

[@Just4Pro1]

i think we shouldn't use get_or_create for user rating beacuse if user previously gave 5 star to a restaurant and now it's dissatisfied and want to give 2 stars then get_or_create will not be able to find the 5star rating of the user and will create another record in Ratings table with 2 star rating and it will lead to duplicates in rating unless user field is defined as unique thank you so much for your effort, great series

[@frameff9073]

Good thank

[@ohbhaibadiya]

This made Django learning very simple.. I just had one doubt, in normal query even when you were doing all the sql query has limit 21, did you configure that somewhere or is it default or where is that coming from? Thanks again for videos.

[@batuhanunal9380]

Wonderful

[@bugbytes3923]

Thanks a lot!

[@amine63404]

Great tutorial. I have a question please. When you have three tables as following : Restaurant Sale - fk restaurant Invoice - fk sale How do you get all invoices related to the restaurant ? Can we use something like Restaurant.sale_set.all().invoice_set.all() ??? Thank you again for such a great tutorial.

[@Zzz-xt6ki]

I am not getting suggestions like rating.object.create and rating.object.filter(). How to get those?

[@pedarayududola1672]

I'm getting the error ModuleNotFoundError: No module named 'django_extensionscore'

[@bugbytes3923]

Make sure you have django-extensions installed (you can install with pip) It’s concatenating that with the “core” app - are you missing a comma between the two elements in INSTALLED_APPS?

[@立法院很忙]

First!

[@bugbytes3923]

Thanks 😄

[@abbasebadian6851]

Find ❌ Feyind✅