try to pass -1.0 On Tue, May 19, 2020 at 1:08 PM Aldian Fazrihady <mob...@aldian.net> wrote:
> replace > ``` > Report.objects.create(param=test_name,comp=compon,value=test_value) > ``` > with > ``` > Report.objects.create(param=test_name,comp_id=compon,value=test_value) > ``` > > On Tue, May 19, 2020 at 2:39 PM ratnadeep ray <ratnade...@gmail.com> > wrote: > >> Can you please say in which line we should make that change because in so >> many places I am using comp. So in all the places should I change that ? >> >> On Tuesday, 19 May 2020 12:36:19 UTC+5:30, Aldian Fazrihady wrote: >>> >>> Use comp_id= instead of comp= >>> >>> Regards, >>> >>> Aldian Fazrihady >>> http://aldianfazrihady.com >>> >>> Pada tanggal Sel, 19 Mei 2020 13.49, ratnadeep ray <ratna...@gmail.com> >>> menulis: >>> >>>> Hi all, >>>> >>>> I am trying to add a row in the DB using the following views.py: >>>> >>>> # Create your views here. >>>>> from django.shortcuts import render >>>>> from fusioncharts.models import Component,Report >>>>> import xlrd >>>>> def pie_chart(request): >>>>> labels = [] >>>>> data = [] >>>>> loc = ("C:\Django_apps\QRC_Report.xlsx") >>>>> workbook = xlrd.open_workbook(loc) >>>>> worksheet = workbook.sheet_by_name('Sheet1') >>>>> num_rows = worksheet.nrows - 1 >>>>> num_cols = worksheet.ncols - 1 >>>>> curr_row = -1 >>>>> component = [] >>>>> comp = None >>>>> while curr_row < num_rows: >>>>> curr_row += 1 >>>>> row = worksheet.row(curr_row) >>>>> curr_col = -1 >>>>> if "Header" in worksheet.cell_value(curr_row, 0): >>>>> compon = worksheet.cell_value(curr_row, 0).strip("*") >>>>> print("The component is %s" %compon) >>>>> component.append(compon) >>>>> print("===========The results of the component %s is as >>>>> follows============" %compon) >>>>> Component.objects.create(comp=compon) >>>>> continue >>>>> while curr_col < num_cols: >>>>> curr_col += 1 >>>>> cell_value = worksheet.cell_value(curr_row, curr_col) >>>>> #print("Cell value = %s" %cell_value) >>>>> test_name = worksheet.cell_value(curr_row,0) >>>>> print("Test name = %s" %test_name) >>>>> test_value = worksheet.cell_value(curr_row,1) >>>>> print("Test result = %s" %test_value) >>>>> print("The component is = %s" %comp) >>>>> >>>>> *Report.objects.create(param=test_name,comp=compon,value=test_value)* >>>>> return render(request, 'pie_chart.html', { >>>>> 'labels': labels, >>>>> 'data': data, >>>>> }) >>>> >>>> >>>> However the above highlighted line is throwing the following error: >>>> >>>>> Cannot assign "'Header SQL Detailed'": "Report.comp" must be a >>>>> "Component" instance. >>>> >>>> >>>> My model is as follows: >>>> >>>> from django.db import models >>>>> from django.urls import reverse >>>>> from decimal import Decimal >>>>> # Create your models here. >>>>> class Component(models.Model): >>>>> comp = models.CharField(max_length=30) >>>>> class Report(models.Model): >>>>> comp = models.ForeignKey(Component,on_delete=models.CASCADE) >>>>> param = models.CharField(max_length=30) >>>>> value = >>>>> models.DecimalField(max_digits=25,decimal_places=18,default=Decimal('0.0000')) >>>> >>>> >>>> >>>> Can anyone please point out what is going wrong here? What should be >>>> the correction? >>>> >>>> Thanks. >>>> >>>> -- >>>> 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...@googlegroups.com. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/django-users/afb5a06a-0d7d-4038-a0fc-3c2aadbbe4fc%40googlegroups.com >>>> <https://groups.google.com/d/msgid/django-users/afb5a06a-0d7d-4038-a0fc-3c2aadbbe4fc%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >> 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+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/1425af8b-7dae-4cdb-ba8a-82d0a9fa0a74%40googlegroups.com >> <https://groups.google.com/d/msgid/django-users/1425af8b-7dae-4cdb-ba8a-82d0a9fa0a74%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > > > -- > Regards, > > Aldian Fazrihady > http://aldianfazrihady.com > > -- > 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+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CAN7EoAZ%2BnrQSbpcwx8-PbYyvTNLE1X%3DpfLH0ifVb2KrR3zRsEw%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAN7EoAZ%2BnrQSbpcwx8-PbYyvTNLE1X%3DpfLH0ifVb2KrR3zRsEw%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAP6Ddn3FwaNeUrTUZKPMwsysYU40OdqzYv8YvR3o-Xig%3D3b8Cw%40mail.gmail.com.
