AttributeError 'QuerySet' object has no attribute 'expenses'

[Kean]

Hi, 

New to Django. when navigating to the reqired view, I get the error above.

urls.py

path('businesslogin/businessadmin/busproject', views.projectdetail, name='projectdetail'),

views.py

def projectdetail(request):

    project = Project.objects.all()

    return render(request, 'busprojectdetail.html', {'project': project, 'expense_list': project.expenses.all()})

models.py

# Project model

class Project(models.Model):

    name = models.CharField(max_length=100)

    budget = IntegerField()

    def save(self, *args, **kwargs):

        self.name

        super(Project, self).save(*args, **kwargs)

# Category manager model

class Category(models.Model):

    project = models.ForeignKey(

        Project, on_delete=models.CASCADE)

    name = models.CharField(max_length=150)

# Expenses manager model

class Expense(models.Model):

    project = models.ForeignKey(

        Project, on_delete=models.CASCADE, related_name='expenses')

    title = models.CharField(max_length=100)

    amount = models.DecimalField(max_digits=8, decimal_places=2)

    category = models.ForeignKey(Category, on_delete=models.CASCADE)

the error is as follows:

Exception Type:	AttributeError
Exception Value:	'QuerySet' object has no attribute 'expenses'
Exception Location:	/Users/ProductionEnv/Desktop/test/test1/dev/core/views.py in projectdetail, line 238 Please can anyone help? Best  K

[Bhoopesh sisoudiya]

Hi kean,

    Please check Expenses Class is not Manager

    Please make Manager Class.

Thanks

Bhoopesh sisoudiya

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/024bc998-b683-41ae-90e2-d33f4527913a%40googlegroups.com.

[Kean]

Hi, 

Thanks for the help.

The header for each model is # out, so is not read when the code parsed, it is just to help me identify the models.

I only have 3 models Project, Category and Expense.

Best wishes,

Kean

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAAk3c1PoGuLeAsnJoEUuB1LdZw8SwpJDFy51%3Di89%2BAv_Zd1sOA%40mail.gmail.com.

[Bhoopesh sisoudiya]

Hi Kean,

 Write manager like this ,I give you reference

from django.db import models

 # First, define the Manager subclass. 

class BhoopeshBookManager(models.Manager):

   def get_queryset(self): 

        return super(BhoopeshBookManager, self).get_queryset().filter(author='Bhoopesh') 

# Then hook it into the Book model explicitly. class Book(models.Model): 

title = models.CharField(max_length=100) 

author = models.CharField(max_length=50)

 # ... 

objects = models.Manager()

 # The default manager. 

bhoopesh_objects = BhoopeshBookManager()

 # The Bhoopesh-specific manager.

Book.bhoopesh_objects.all() # use manager

Thanks 

Bhoopesh Kumar

[Kean]

Hi Bhoopesh

Thanks for this, please can you put it into the context of my specific model setup, so I get it right and understand.

This will be easier for me as this approach is causing me some other errors, when i try to apply it.

Best wishes, 

Kean 

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAAk3c1NmgbP7cQtyX8uOAFX%3DXbyC6f2ug1FURabwxRgD44Mwpg%40mail.gmail.com.

[Bhoopesh sisoudiya]

Ok No problem but 

why you want Manager?

Please send me answer

Thanks

Bhoopesh sisoudiya

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/52D49AAA-5E17-4F6C-92DE-E1576F305927%40gmail.com.

[Bhoopesh sisoudiya]

Hi kean,

Category and Expense is not Manager model this is only model class.

Thanks

Bhoopesh Kumar

[Kean]

Hi,

please ignore the manager it is just a naming convention ignore, it if for me to identify tables, if i have 50 table, I want to be able to know which model is holding which object information and for what I need it.

Please use below, I have removed the # information to reduce confusion.

models.py

class Project(models.Model):

    name = models.CharField(max_length=100)

    budget = IntegerField()

    def save(self, *args, **kwargs):

        self.name

        super(Project, self).save(*args, **kwargs)

class Category(models.Model):

    project = models.ForeignKey(

        Project, on_delete=models.CASCADE)

    name = models.CharField(max_length=150)

class Expense(models.Model):

    project = models.ForeignKey(

        Project, on_delete=models.CASCADE, related_name='expenses')

    title = models.CharField(max_length=100)

    amount = models.DecimalField(max_digits=8, decimal_places=2)

    category = models.ForeignKey(Category, on_delete=models.CASCADE)

On 6 Sep 2019, at 20:45, Bhoopesh sisoudiya <bhoop...@gmail.com> wrote:

Best wishes,

Kean

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAAk3c1PtFX7oNie8qZKF%3Dm7jFrCEMwTZfn%2BcvWBFSqc9FT0h4A%40mail.gmail.com.

[Bhoopesh sisoudiya]

def projectdetail(request):

    project = Project.objects.all()

    return render(request, 'busprojectdetail.html', {'project': project, 'expense_list': project.expenses.all()})

According to me by this archive you want expense details of each project

Then you write

projectDetails = Project.objects.select_related(your foreign key).values (select column).all()

Thanks

Bhoopesh sisoudiya

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/06BE184B-33E5-4B84-A723-5C7075048349%40gmail.com.

[Kean]

Thanks,

I updated the view, and now I am getting syntax error.

Please see below.

views.py

def projectdetail(request):

    project = Project.objects.all()

    return render(request, 'busprojectdetail.html', {'project': project, 'expense_list': project.expenses.all()})

    projectDetails = Project.objects.select_related(Project).values(select column).all()

please advise how to correct?

Best,

Kean

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAAk3c1OiCB0YW_5%2B2CcjFGJzBytRpOmKCw%3D3f_C2w-0JuESnvA%40mail.gmail.com.

[Bhoopesh sisoudiya]

Write this

Expense.objects.select_related('project').all()

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/79DB1D00-AF66-4584-B635-7C22F9673733%40gmail.com.

[Kean]

This is still not working,

please can you provide full code, this way it is complete and accurate, and not me guessing?

Best,

Kean

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAAk3c1OmNHiqVgvQMHj16wiMPr23hy%3DfU%2BE4WFH8sDixpiVx5w%40mail.gmail.com.

[Bhoopesh sisoudiya]

def projectdetail(request):

    projectExpnseDetails = Expense.objects.select_related('project').all()

    return render(request, 'busprojectdetail.html', {'project': project, 'expense_list':projectExpnseDetails })

[Kean]

Hi Ok,

I updated as advised.

views.py

def projectdetail(request):

    projectExpenseDetails = Expense.objects.select_related('project').all()

    return render(request, 'busprojectdetail.html', {'project': project, 'expense_list': projectExpenseDetails})

I get new error

Exception Type:	NameError
Exception Value:	name 'project' is not defined

Exception Location:	/Users/ProductionEnv/Desktop/test/test1/dev/core/views.py in projectdetail, line 238

Please advise?

Best,

Kean

On 6 Sep 2019, at 21:19, Bhoopesh sisoudiya <bhoop...@gmail.com> wrote:

projectExpnseDetails

[Kean]

Ok,

Updated to below, and am still getting the same error:

def projectdetail(request):

    projectList = Project.objects.all()

    projectExpenseDetails = Expense.objects.select_related('project').all()

    return render(request, 'busprojectdetail.html', {'project': project, 'expense_list': projectExpenseDetails})

Exception Type:	NameError
Exception Value:	name 'project' is not defined

Exception Location:	/Users/ProductionEnv/Desktop/test/test1/dev/core/views.py in projectdetail, line 239

Best,

Kean

On 6 Sep 2019, at 21:32, Bhoopesh sisoudiya <bhoop...@gmail.com> wrote:

Sorry my mistake

def projectdetail(request):

    projectList = Project.objects.all()

    projectExpenseDetails = Expense.objects.select_related('project').all()

    return render(request, 'busprojectdetail.html', {'project': projectList, 'expense_list': projectExpenseDetails})

[Kean]

Hi,

removing did, not work, still getting same error.

Welcome any other help from the wider community in reference to this issue.

best,

Kean

On 6 Sep 2019, at 22:26, Bhoopesh sisoudiya <bhoop...@gmail.com> wrote:

Try after removing related_name='expenses' from Expenses model.

On Sat, Sep 7, 2019, 2:28 AM Kean <kea...@gmail.com> wrote:

Hi Bhoopesh,

If this is a simple issue to resolve, please provide code which works.

Reading an abstract reference, is welcome, but is not really helping to solve as one can always reference a source. 

Please advise solution that works, and then reference a learning resource, so user knows where to go for learning, but with solution in hand.

Best,

Kean

On 6 Sep 2019, at 21:54, Bhoopesh sisoudiya <bhoop...@gmail.com> wrote:

https://stackoverflow.com/questions/31237042/whats-the-difference-between-select-related-and-prefetch-related-in-django-orm

On Sat, Sep 7, 2019, 2:20 AM Kean <kea...@gmail.com> wrote:

Don’t understand?

On 6 Sep 2019, at 21:41, Bhoopesh sisoudiya <bhoop...@gmail.com> wrote:

'project' inside select_related() is foreign key in Expenses modal of Project modal.