Results .objects.aggregate(max(student))

So take avg instead of max

result = Results.objects.values('student').annotate(Avg('marks')) i tried to do this but i fail to get the name by using a foreign key

you would start your query from Student model (you can use Result also but you should do "group by") .. Student.objects.annotate(marks_avg=Avg('related_name__marks') ) add related name to your Results Model

you would start your query from Student model (you can use Result also but you should do "group by") .. Student.objects.annotate(marks_avg=Avg('related_name__marks') ) add related name to your Results Model

you would start your query from Student model (you can use Result also but you should do "group by") .. Student.objects.annotate(marks_avg=Avg('related_name__marks') ) add related name to your Results Model

i did it but fails to calculate average and it displays on the name: result = Student.objects.annotate(marks_avg=Avg('results__marks'))

can you paste the exception here ?

i did it but fails to calculate average and it displays on the name: result = Student.objects.annotate(marks_avg=Avg('results__marks'))

<QuerySet [<Student: Godfrey John>, <Student: Sard Damas>]> this is the output of the queryset

hop you add related name to student foreign key in your Result Model

ok . you should iterate.. each object of queryset has an attribute marks_avg

class Results(models.Model): student = models.ForeignKey(Student, related_name='results', on_delete=models.RESTRICT) entry = models.ForeignKey(Entry,on_delete=models.SET_NULL, null=True) subject_name = models.CharField(max_length=20) marks = models.FloatField() remarks = models.CharField(max_length=255, null=True)

if you want to see directly a list of average you can do result = Student.objects.annotate(marks_avg=Avg('results__marks')).values('marks_avg')

class Product(models.Model): category = models.ForeignKey(Category, on_delete=models.CASCADE, related_name='product') title = models.CharField(max_length=255) description = models.TextField(blank=True) price = models.DecimalField(default=0, max_digits=100000, decimal_places=1) price_before_offer = models.DecimalField(default=0, max_digits=100000, decimal_places=1) def offer_maker(self): amount = 2 jj = self.price * amount return Product(price_before_offer=jj).save() << Why my code is not save in the database >>

if you want to see directly a list of average you can do result = Student.objects.annotate(marks_avg=Avg('results__marks')).values('marks_avg')

def offer_maker(self , *args , **kwargs): #args and kwargs to preserve params as commit=True/False amount = 2 jj = self.price * amount self.price_before_offer=jj return super().save(*args, **kwargs)

I have followed all the tutorials but all of them ended in failure

Tutorials are means for you to understand the process..

Lemme send the code

Hello bro, I stuck in my project, where I am creating API for college management system. I have a Teacher table that is OnetoOne related with User table. I want that any teacher and view and update any teacher details. For that I created a group of "teacher" in Group table and give permission for "can update teacher ". I add teacher to that group. But when I go to update teacher detail It says you don't have permission. It work when I give "can change User" person to teacher. I used JWT for authentication and DjangoModelPermisson as permission class

can anyone tell me what is the name of the widget that numbericinput has in forms inputs

Default widget: NumberInput when Field.localize is False, else TextInput.

Guys I need one suggestion, I belong to Data Analyst background (BI). Want to learn web developement. Django or React, not able to decide. 😞

Hello I cannot access to my ubuntu server within xrdp, it said rdp is disabled or not working but here's the status: xrdp.service - xrdp daemon Loaded: loaded (/lib/systemd/system/xrdp.service; enabled; vendor preset: enabled) Active: active (running) since Mon 2021-08-23 15:00:09 UTC; 11min ago Docs: man:xrdp(8) man:xrdp.ini(5) Aug 23 15:00:08 django-server xrdp[1001]: (1001)(139752369825600)[INFO ] address [0.0.0.0] port [3389]> Aug 23 15:00:08 django-server xrdp[1001]: (1001)(139752369825600)[INFO ] listening to port 3389 on 0.0> Aug 23 15:00:08 django-server xrdp[1001]: (1001)(139752369825600)[INFO ] xrdp_listen_pp done Aug 23 15:00:08 django-server xrdp[1001]: (1001)(139752369825600)[DEBUG] Closed socket 7 (AF_INET6 :: > Aug 23 15:00:08 django-server systemd[1]: xrdp.service: Can't open PID file /run/xrdp/xrdp.pid (yet?) > Aug 23 15:00:09 django-server systemd[1]: Started xrdp daemon. Aug 23 15:00:10 django-server xrdp[1010]: (1010)(139752369825600)[INFO ] starting xrdp with pid 1010 Aug 23 15:00:10 django-server xrdp[1010]: (1010)(139752369825600)[INFO ] address [0.0.0.0] port [3389]> Aug 23 15:00:10 django-server xrdp[1010]: (1010)(139752369825600)[INFO ] listening to port 3389 on 0.0> Aug 23 15:00:10 django-server xrdp[1010]: (1010)(139752369825600)[INFO ] xrdp_listen_pp done

Hello anyone try using raw query with multiple table joined and returned as json?

I have a question, can somebody provide any feedback please?

https://docs.google.com/presentation/d/1fPqMcr6LW1JiTHrbb8UwZ53FvPxjWZX-dpAUBCqiIU8/edit?usp=sharing

here are the same rules as in @python

Please tell if I'm missing any detail in that post. I have specified what I have tried.

Can someone helps to solve my error here?https://pastebin.com/hjBVV4Bv

A model 'C' has its data given in the form of Fixtures. Many models are dependent on this model through both FK & M2M. Now, in Develop, it has some pk for particular object, while in Prod, for that pk, some different object is set, causing Fixture inconsistency in pk's. To resolve this, in (test db), 1. I tried to alter the schema of child table of C with "ON UPDATE CASCADE" in psql using this https://stackoverflow.com/questions/25973576/updating-primary-keys-in-postgresql., since Django doesn't have on_update=models.CASCADE. 3. I then updated the pk of 'C' objects with the one having in development, in order to avoid Unique constraint failed error, (at this moment, update reflected in Child model) & then reloaded the fixture, it was fine. Some Side effect of this change resulted in "some_model_id_seq" got its value replaced with new one ( because of my Fixture pk change ) My queries are : 1. Is this way the correct to do ?, If so, it won't cause any serious issues ( because of changing pk )? 2. I tried in only one child of C, but there are many more children models of C. So, for them also, I should do manually or any other quick way ? 3. For Child model having M2M, I tried to same Operation in the "Join Table", since that has FK to Parent, it works as expected. Is that ok to do, or any other special change required for it? 4. Is there any other way to solve this ? I'm thinking of having env specific Fixtures ( for Prod, 1 fixture , for Dev, different fixture ). But, it's too much of thing to do.. Changing primary keys is definitely a bad idea, but I don't have any other choice to maintain consistency of 'C' across all env's.. Sorry for the wall of text, since I need to clearly explain what my problem is.

Anyone please help on this..

Anyone please help on this..

may i write in PM?

Hi, ValueError: Django can only handle ASGI/HTTP connections, not websocket.

Can anyone help me? How can i join two tables using ORM? In two tables i don't have any foreign key

Can anyone help me? How can i join two tables using ORM? In two tables i don't have any foreign key

Use AJAX call