Hi all,
i am having trouble to get this query on db table right.
I am always getting error.
Please check shell erorr attached.
I appreciate your help!
--
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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/ca5a10a1-b8ea-4950-89b7-6806a4682ef8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
#models
from __future__ import unicode_literals
from django.db import models, connection
from django.utils import timezone
from datetime import date
class Material(models.Model):
id = models.IntegerField(db_column='ID', primary_key=True, blank=False,
unique=True)
bukrs = models.CharField(db_column='Bukrs', max_length=4)
materialid = models.CharField(db_column='MaterialID', max_length=10)
material_name = models.CharField(db_column='Material_name', max_length=7)
class Meta:
managed = False
db_table = 'Material'
def __str__(self):
return '%s %s %s' % (self.bukrs, self.materialid, self.material_name)
class MaterialGroup(models.Model):
id = models.CharField(db_column='ID', max_length=255, blank=False,
primary_key=True)
material_group = models.CharField(db_column='Material Group',
max_length=255, blank=True, null=True)
class Meta:
managed = False
db_table = 'Material Group'
def __str__(self):
return '%s' % (self.material_group)
class Productgroupinput(models.Model):
id = models.IntegerField(db_column='ID', primary_key=True, blank=False,
unique=True)
bukrs = models.CharField(db_column='Bukrs', max_length=4)
materialid = models.ForeignKey(Material, on_delete=models.CASCADE,
db_column='Materialid', max_length=10)
material_group = models.ForeignKey(MaterialGroup, on_delete=models.CASCADE,
db_column='Material_group', max_length=2)
class Meta:
managed = False
db_table = 'ProductGroupInput'
def __str__(self):
return '%s %s %s' % (self.bukrs, self.materialid, self.material_group)>>> from productsgrouping.models import Material, MaterialGroup,
>>> Productgroupinput
>>> test = Productgroupinput.objects.all()
>>> test
Traceback (most recent call last):
File
"C:\Users\martici\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\models\fields\related_des
criptors.py", line 163, in __get__
rel_obj = self.field.get_cached_value(instance)
File
"C:\Users\martici\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\models\fields\mixins.py",
line 13, in get_cached_value
return instance._state.fields_cache[cache_name]
KeyError: 'materialid'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "<console>", line 1, in <module>
File
"C:\Users\martici\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\models\query.py",
line 24
7, in __repr__
return '<%s %r>' % (self.__class__.__name__, data)
File
"C:\Users\martici\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\models\base.py",
line 503
, in __repr__
return '<%s: %s>' % (self.__class__.__name__, self)
File "C:\Users\martici\QIF\qif\productsgrouping\models.py", line 45, in
__str__
return '%s %s %s' % (self.bukrs, self.materialid, self.material_group)
File
"C:\Users\martici\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\models\fields\related_des
criptors.py", line 177, in __get__
rel_obj = self.get_object(instance)
File
"C:\Users\martici\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\models\fields\related_des
criptors.py", line 144, in get_object
return qs.get(self.field.get_reverse_related_filter(instance))
File
"C:\Users\martici\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\db\models\query.py",
line 39
9, in get
self.model._meta.object_name
productsgrouping.models.Material.DoesNotExist: Material matching query does not
exist.>>> query = Material.objects.all()
>>> query
<QuerySet [<Material: 2050 0000100731 Beton>, <Material: 2051 0000100732
Pijesak>, <Material: 2052 0000100332 Mort>, <Ma
terial: 2052 0000100232 Cement>, <Material: 2054 0000100454 Stirop>]>
>>>
