These are genuinely some of the most helpful tutorials on the Internet. No fluff, just constant gold.
@bugbytes3923 Жыл бұрын
Wow, thanks a lot! Delighted to hear that!
@khunjohn1054 Жыл бұрын
As usual, great tutorial. I hope that in the next video you include OuterRef and Subquery. This is a more advanced topic, but it packs a ton of functionality. ie. Let's say you have a company with many offices and one of those offices is market as the HQ. With OuterRef and Subquery, you can annotate the company address from the specific office in the many to one related table marked as the HQ and also aggregate the total amount of employees as a Sum of each office.
@bugbytes3923 Жыл бұрын
Thank you! I'll cover these topics very soon - not the next video but the one after, I think. But yeah, will definitely cover it!
@codedjango Жыл бұрын
Very nice explanation on aggregate and annotate.....thank you so much
@bugbytes3923 Жыл бұрын
Thanks very much!
@diegofunes1802Ай бұрын
Excellent video! Many thanks!
@bugbytes3923Ай бұрын
Thanks a lot!
@seydinaoumarsamabaly1806 Жыл бұрын
I just want to thank you Master 🙌🏾before I finish watching the tutorial !
@bugbytes3923 Жыл бұрын
Thanks as always! 😄
@robhafemeister3100 Жыл бұрын
Great video! you explained in less than an hour what probably took me a week to learn on my own awhile back. Love it!
@bugbytes3923 Жыл бұрын
Thanks a lot Rob, much appreciated as always!
@priyanshvatsal97913 ай бұрын
So much useful information in just one video. Thanks
@bugbytes39233 ай бұрын
Glad to hear it, thanks a lot for watching and commenting!
@firstandlast44353 ай бұрын
A little recap: Annotate by itself (without values()) doesn't do grouping even with use of aggregate functions (which just duplicate argumented field in such case); We use annotate() with values() and we don't use it with only() (at least my tests proved last as useless); We can start from both child and parent Model and get the same result So this: Books.objects.values_list("author__firstname", "author__lastname").annotate( total=Count("id") ) And that: q = Author.objects.values_list("firstname", "lastname").annotate( total=Count("books") ) will do the same (p.s. "books" in the last statement refers to "related_query_name" specified in ForeignKey field of the "Books" model );
@repotranstech9614 Жыл бұрын
Thanks 👍 for this tutorial.I have a microfinance project that will require this.
@bugbytes3923 Жыл бұрын
Hope the video will help! 👍
@user-gi7ei7rm4x Жыл бұрын
Nice plants as well as the video
@bugbytes3923 Жыл бұрын
Thanks a lot! 🪴😄
@Peterstavrou Жыл бұрын
This series has been incredible!
@bugbytes3923 Жыл бұрын
Thanks a lot Peter!
@farzadmf Жыл бұрын
SUPER high quality video as always; great job!
@bugbytes3923 Жыл бұрын
Thanks a lot 🙏
@DhavalAhir1011 ай бұрын
Amazing every concept clear. Love from India bro. ✌️
@bugbytes392311 ай бұрын
Thanks a lot bro! Glad it was clear and greetings from Scotland!
@vaibhavbijapur60378 ай бұрын
bro you deserve more followers
@bugbytes39238 ай бұрын
Thanks man!
@user-xc2me6zh2k11 ай бұрын
awesome content Mate!! I learned many new concepts in this video and will try to apply in my projects too 😁
@bugbytes392311 ай бұрын
Awesome, thanks a lot, glad you liked the video!
@Septumsempra8818 Жыл бұрын
Great tutorial. Any caching vids coming?
@bugbytes3923 Жыл бұрын
Thanks! Yes, I'll be doing stuff with Django + Redis in the near future.
@user-ib9dv3pr9b Жыл бұрын
Thanks for great videos
@bugbytes3923 Жыл бұрын
You’re welcome, thanks a lot for watching!
@thokozanindlovu19397 ай бұрын
Another brilliant video. thank you
@bugbytes39237 ай бұрын
Thanks a lot!
@Niki-ue6fk5 ай бұрын
Thanks !!
@bugbytes39235 ай бұрын
Thanks for watching!
@anatoliyloboda46017 ай бұрын
It's a very interesting and important part of working with DB. Thank you for sharing!!!
@frameff9073 Жыл бұрын
thank
@bugbytes3923 Жыл бұрын
Thanks for watching!
@paulwanjohi25375 ай бұрын
Incredible. That was so helpful. Thank you man👊
@bugbytes39234 ай бұрын
Thanks a lot man! Glad it helped.
@techwithabid28 күн бұрын
Do a video on channel and web socket
@bugbytes392328 күн бұрын
In the future for sure!
@Yarkanlaki4 ай бұрын
I wonder why aggregation results always is too big.? Comapre to use for loop
@user-jd9fc7to4c10 ай бұрын
hi, do you have solution for Like: Multiple table field Sum calculation from parent model ---------- to get stock qty each product (stock qty= purchase_qty - purchase_return_qty - sales_qty + sales_qty )
@wihlarkop Жыл бұрын
can you make tutorial how to use async queryset on django 4?
@bugbytes3923 Жыл бұрын
Yes, definitely!
@azhariqbal36586 ай бұрын
Is there any package you use for runscript this is very useful for testing queries
@bugbytes39236 ай бұрын
It’s part of django-extensions which I always add to django projects
@firstandlast44353 ай бұрын
What I dislike about youtube is that there's a need in comments in order to promote a channel, it might be ok in some cases but when it's about education I actually wanna see some related to subject discussions on top instead of "thanks author you are so great"... Anyway what I failed to understand is when annotate is used to add extra field to query set and when to group by fields and the similar about values. As it does return dictionaries like? Then why can we do things like ModelName.objects.values('smth').annotate(Agregate func) and then use functions like order by to it. Don't we need Django specific query sets to use those functions, or we can use it to any dictionary?
@bugbytes39233 ай бұрын
The annotate() function will add the annotated field to each object in the queryset. Importantly, annotate returns a queryset, so you can chain other methods like values() and order_by(), etc. The aggregate() function, on the other hand, returns a dictionary containing all the aggregations passed to the function. Queryset methods don’t work on dictionaries, so chaining additional methods like order_by() won’t work.
@pakeffendi50619 ай бұрын
# fungction to get one cctv location and past it to leaflet map def Cctvlist(request, id): # get cctv category cctvs = get_object_or_404(Daftarcctv, id = id) # show all cctv location in cctv category cctv = cctvs.cctvdetail_set.all() # lopping all cctv location for i in cctv: # get one cctv location from i looping showloc = Cctvlocation.objects.get(pk=i) # i want to get cctv location row to past in json format # and get values lat, long from varible "showloc" # BUT ALWAYS FAIL, PLEASE SHOW ME A SOLUTION cctvsloc = list(Cctvlocation.objects.values('latitude', 'longitude')[:100]) print(cctvsloc) return render(request, 'cctvkorem/daftarcctv.html', {'cctvs':cctvs, 'cctv':cctv, 'showloc':showloc })