[Thu Sep 17 23:07:26.870983 2020] [wsgi:error] [pid 39120] [remote 142.136.2.27:45290] Internal Server Error: /functions/ClassMonthlyCost/ [Thu Sep 17 23:07:26.871052 2020] [wsgi:error] [pid 39120] [remote 142.136.2.27:45290] Traceback (most recent call last): [Thu Sep 17 23:07:26.871057 2020] [wsgi:error] [pid 39120] [remote 142.136.2.27:45290] File "/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner [Thu Sep 17 23:07:26.871060 2020] [wsgi:error] [pid 39120] [remote 142.136.2.27:45290] response = get_response(request) [Thu Sep 17 23:07:26.871064 2020] [wsgi:error] [pid 39120] [remote 142.136.2.27:45290] File "/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/django/core/handlers/base.py", line 115, in _get_response [Thu Sep 17 23:07:26.871067 2020] [wsgi:error] [pid 39120] [remote 142.136.2.27:45290] response = self.process_exception_by_middleware(e, request) [Thu Sep 17 23:07:26.871070 2020] [wsgi:error] [pid 39120] [remote 142.136.2.27:45290] File "/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/django/core/handlers/base.py", line 113, in _get_response [Thu Sep 17 23:07:26.871073 2020] [wsgi:error] [pid 39120] [remote 142.136.2.27:45290] response = wrapped_callback(request, *callback_args, **callback_kwargs) [Thu Sep 17 23:07:26.871079 2020] [wsgi:error] [pid 39120] [remote 142.136.2.27:45290] TypeError: object() takes no parameters
On Thursday, September 17, 2020 at 3:00:08 PM UTC-5 Patrick Carra wrote: > The actual trace coolguy is > > TypeError at /functions/ClassMonthlyCost/object() takes no > parametersRequest > Method: GETRequest > URL: http://98.8.61.133:8080/functions/ClassMonthlyCost/Django > Version: 2.2.4Exception > Type: TypeErrorException > Value: object() takes no parametersException > Location: > /home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/django/core/handlers/base.py > > in _get_response, line 113Python > Executable: /home/db_user/ciopsdb/venv/bin/pythonPython > Version:3.6.8 > Python Path: > ['/home/db_user/ciopsdb', '/usr/lib64/python36.zip', > '/usr/lib64/python3.6', '/usr/lib64/python3.6/lib-dynload', > '/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages', > '/home/db_user/ciopsdb/venv/lib/python3.6/site-packages', > '/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/odf', > '/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/odf', > '/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/odf', > '/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/odf', > '/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/odf', > '/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/odf', > '/home/db_user/ciopsdb/venv/lib64/python3.6/site-packages/odf'] > Server time: Thu, 17 Sep 2020 18:29:52 +0000 > > On Thursday, September 17, 2020 at 2:26:32 PM UTC-5 coolguy wrote: > >> is there any specific line number that message is pointing too. Can you >> share the actual error message and its trace... >> >> On Thursday, September 17, 2020 at 2:35:53 PM UTC-4 [email protected] >> wrote: >> >>> Hello everyone, I am trying to utilize the SIngleTableMixin of >>> django_tables2 using a custom function that queries my database and >>> aggregates the data into a list of dictionaries. I read to use the >>> SingleTableMixin that all I needed was an iterable containing a data >>> structure that has a key(a list of dicts) and then to instantiate a table >>> in tables.py and pass to a my views Class. I am getting an error when I do >>> this TypeError: Object() takes no parameters. I have included a link to >>> the django tables 2 doc and my code below: >>> >>> #views.py >>> from django_tables2.views import SingleTableMixin >>> from django_tables2.export.views import ExportMixin >>> from django_filters.views import FilterView >>> from django.views.generic.list import ListView >>> from django.shortcuts import render >>> >>> from finance.models import Circuitinfotable, Budget >>> from .forms import monthlyCostForm >>> from .tables import CircuitTable, monthlyCostTable >>> from .filters import CircuitinfotableFilter >>> >>> from datetime import datetime >>> from decimal import Decimal >>> from re import sub >>> import calendar >>> >>> #convert a distinct queryset into a singular list of values >>> def getList(qs, key): >>> resultsList = [] >>> for each in qs: >>> resultsList.append(each[key]) >>> return resultsList >>> >>> >>> def getDistinct(key): >>> return Circuitinfotable.objects.all().values(key).distinct() >>> >>> >>> def convertCurrency(val): >>> return Decimal(sub(r'[^\d.]', '', val)) >>> >>> >>> def getMonthlyCostQuery(year, field): >>> circuits = Circuitinfotable.objects.all() >>> field_list = getList(getDistinct(field), field) >>> >>> results_list = [] >>> resultsDict={'field': 'None', 'Jan': 0, 'Feb': 0, 'Mar': 0, 'Apr': >>> 0, 'May': 0, 'Jun': 0, 'Jul': 0, 'Aug': 0, 'Sep': 0, 'Oct': 0, 'Nov': 0, >>> 'Dec': 0, >>> 'Janbw': 0, 'Febbw': 0, 'Marbw': 0, 'Aprbw': 0, >>> 'Maybw': 0, 'Junbw': 0, 'Julbw': 0, 'Augbw': 0, 'Sepbw': 0, 'Octbw': 0, >>> 'Novbw': 0, 'Decbw': 0} >>> results_list.append(resultsDict) >>> for each in field_list: >>> if each!=None and each!='None': >>> resultsDict={'field': '', 'Jan': 0, 'Feb': 0, 'Mar': 0, >>> 'Apr': 0, 'May': 0, 'Jun': 0, 'Jul': 0, 'Aug': 0, 'Sep': 0, 'Oct': 0, >>> 'Nov': 0, 'Dec': 0, >>> 'Janbw': 0, 'Febbw': 0, 'Marbw': 0, 'Aprbw': 0, >>> 'Maybw': 0, 'Junbw': 0, 'Julbw': 0, 'Augbw': 0, 'Sepbw': 0, 'Octbw': 0, >>> 'Novbw': 0, 'Decbw': 0} >>> resultsDict['field'] = each >>> results_list.append(resultsDict) >>> >>> for circuit in circuits: >>> #If you add a field to forms.py to aggregate by then add here >>> if field=='region': >>> matchField = circuit.region >>> elif field=='carrier': >>> matchField = circuit.carrier >>> elif field=='bandwidth': >>> matchField = circuit.bandwidth >>> elif field=='status': >>> matchField = circuit.status >>> #get the budget for each circuit >>> for budgetItem in circuit.budget_set.filter(yearnum=year): >>> #if an item is budgeted for given month >>> if(budgetItem.actualmrc!=0): >>> #Cycle through results_list to find the correct >>> dictionary >>> for each in results_list: >>> if each['field']==matchField: >>> #update budgetItem and bw >>> if budgetItem != None: >>> >>> each[calendar.month_abbr[budgetItem.monthnum]]+=convertCurrency(budgetItem.actualmrc) >>> if circuit.bw!= None: >>> >>> each[calendar.month_abbr[budgetItem.monthnum] + 'bw']+=int(circuit.bw) >>> elif matchField==None: >>> if budgetItem != None: >>> >>> results_list[0][calendar.month_abbr[budgetItem.monthnum]]+=convertCurrency(budgetItem.actualmrc) >>> if circuit.bw!= None: >>> >>> results_list[0][calendar.month_abbr[budgetItem.monthnum]+'bw']+=int( >>> circuit.bw) >>> >>> results_list = sorted(results_list, key=lambda i:i['field']) >>> return results_list >>> >>> >>> class MonthlyCost(SingleTableMixin): >>> template_name = 'functions/ClassMonthlyCost.html' >>> context_object_name = 'qs' >>> queryset = monthlyCostTable(getMonthlyCostQuery(2020, 'region')) >>> >>> >>> #tables.py >>> import django_tables2 as tables >>> from django_tables2.utils import A >>> from .models import Circuitinfotable >>> >>> class CircuitTable(tables.Table): >>> class Meta: >>> model = Circuitinfotable >>> export_formats = ['csv', 'xlsx'] >>> template_name = "django_tables2/bootstrap.html" >>> Id1 = tables.Column(linkify={"viewname": "viewLit", "args": >>> [tables.A('id1__pk')]}) >>> fields = ("id1", "circuitid", "bandwidth", "region", "carrier", >>> "segmentname", "status", "mrcnew", "diversity", ) >>> >>> class monthlyCostTable(tables.Table): >>> field = tables.Column() >>> Jan = tables.Column() >>> Janbw = tables.Column() >>> Feb = tables.Column() >>> Febbw = tables.Column() >>> Mar = tables.Column() >>> Marbw = tables.Column() >>> Apr = tables.Column() >>> Aprbw = tables.Column() >>> May = tables.Column() >>> Maybw = tables.Column() >>> Jun = tables.Column() >>> Junbw = tables.Column() >>> Aug = tables.Column() >>> Augbw = tables.Column() >>> Sep = tables.Column() >>> Sepbw = tables.Column() >>> Oct = tables.Column() >>> Octbw = tables.Column() >>> Nov = tables.Column() >>> Novbw = tables.Column() >>> Dec = tables.Column() >>> Decbw = tables.Column() >>> >>> Documentation Link that I am using: >>> https://django-tables2.readthedocs.io/en/latest/pages/table-data.html >>> >>> Anybody know where I went wrong??? If I can figure this out I really >>> feel like I can utilize django and django_tables2 to really improve! >>> >>> -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/2f0345f6-51a7-4c24-9c6c-49219f6e2a71n%40googlegroups.com.
