Intro to Django's Annotate

This video explains how the annotate feature works in Django with examples.

WORK WITH ME👇🏼

✅ Implement features and fix bugs in your app: Live, one-on-one screenshare

[mohammadsamir]

your style in videos which is the same as a live video without any cuts is really helpful because it's an educational material as you know
some of us may see it boring
i found it great

[omarhafez]

Great tutorial, keep it up bro
Greetings from Alexandria, Egypt ❤

[PRASHANTKUMAR-twhd]

Please also make a video on select_related and pefetch_related

[abhishekk]

Thank you, Anthony, This playlist is amazing, Love From India

[ashurkanwal]

Hey Anthony I am big fan of you,

I watch a lot of your videos, I am about to submit my project and I am struck in deadlock

sizes = Variants.objects.raw('SELECT * FROM products_variants WHERE product_id=%s GROUP BY size_id', [product_id])

I used this query in django and then and when I hosted my project on heroku and use postgress as my database this query didn't worked

I just simply want to find its django equivalent any suggestions mate thanks

[andrewnjaya]

How about if I want to get results for one country and it's all cities and do this for all countries that are available and their cities grouped for a particular city

[irfanwani]

How to use geodesic function with annotate if the latitude and longitude are from the models field.
I tried this;
origin = (lat, lng)
models.objects.annotate(distance=geodesic(origin, (F("latitude"),
This shows a Type Error ;
float() argument must be a string or a number, not 'F'

Please help

[Sai_keshireddy]

Can you explain how to make join 2 tables without foreignkey using orm

[darkanoid]

can i group the cities by contries? an get as result [las vegas, NY], etc?

[MatheusLegenda]

Hey man, in the Bash shell, you might want to try out the key combinations Ctrl-A and Ctrl-E to get around. Was it helpful?

[zaganmichal]

Hi! How would You ask for the total number of countries that have at least one city in them?

[robertsivanovs]

Small problem I am having, I will paraphrase it to the tutorial objects:
I have Country objects and City objects.
City objects have calculations that that are not written on database field (simple subtraction between 2 fields on CIties object ).
Can I use annotate to sum together the subtraction values?
I am getting "FieldError: Unsupported lookup 'worked_in_day' for AutoField or join on the field not permitted.", as I am new to Django and databases in general I am unsure if that is because I am trying to sum together datatypes that do not allow it or Django does not support the calculation I want.

[hirenpatel]

Keep up the good work man! Your flask course was awesome!

[ulgens]

You should use shell_plus from django-extensions.

[udhayprakashpethakamsetty]

you are using vars() to convert the ORM object to a dictionary. is this function builtin, or your custom function. if a custom function, how you implemented it?

[TusharVasudev]

The course on your site understanding django is using version 1.0 or 2.0?

[altair]

what 's up man can u do a video on middlewares (how to create a simple login restriction middleware and restriction for pages u cant c when u r logged in )

[maqboolthoufeeqt]

Nicely Explained> Thanks Brother <3

[Skaxarrat]

This is going to be a stand-alone video or it's the first of a series?

[mohangoud]

Can u pls tell me how to do arthimetic operations between the model fields . I have
= x:y:z
in database and I have to do these operations:

x/(x+y+z) : y/(x+y+z) : z/(x+y+z)
Thank u