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.

[@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!

[@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! 🙂

[@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 😅

[@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!

[@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.

[@Ego_Maritm]

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

[@bugbytes3923]

Thanks a lot! :)

[@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.

[@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.

[@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!

[@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!

[@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!

[@Surajkumar-ok4ze]

Awesome explanation

[@bugbytes3923]

Thanks a lot!

[@nicenaija9952]

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

[@bugbytes3923]

Thanks, will do!

[@zxmu5755]

¡Gracias!

[@bugbytes3923]

Thanks so much!

[@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.

[@shamshad-live]

Perfect explanation !

[@bugbytes3923]

Thanks a lot!

[@frameff9073]

Good thank

[@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

[@zxmu5755]

Thank you so much!

[@bugbytes3923]

Thanks for watching!

[@olable9]

I'm definitely interested

[@bugbytes3923]

Thank you!

[@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.

[@batuhanunal9380]

Wonderful

[@bugbytes3923]

Thanks a lot!

[@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.

[@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.

[@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.

[@MayasMess]

Awesome video 💪

[@bugbytes3923]

Thanks a lot!!

[@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!

[@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

[@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?

[@user-xu7jz4li7e]

First!

[@bugbytes3923]

Thanks 😄