UUID binary field make error while loading referenced table [PYFB75] #90
Comments
Modified by: Emmanuel Belair (ebelair)description: Hi, I have a related entity that uses UUID binary as primary key, when I try to get this entity, I get the following error: Schema: from django.db import models class AgdeEtab(models.Model): class AgdeActiviteCommerce(models.Model): >>> from agde.models import AgdeEtab During handling of the above exception, another exception occurred: Traceback (most recent call last): => Hi, I have a related entity that uses UUID binary as primary key, when I try to get this entity, I get the following error: Schema: from django.db import models class AgdeEtab(models.Model): class AgdeActiviteCommerce(models.Model): >>> from agde.models import AgdeEtab During handling of the above exception, another exception occurred: Traceback (most recent call last): When I debug http://fbcore.py line 3091, the value type is bytes with 32 alnum chars |
Modified by: Emmanuel Belair (ebelair)description: Hi, I have a related entity that uses UUID binary as primary key, when I try to get this entity, I get the following error: Schema: from django.db import models class AgdeEtab(models.Model): class AgdeActiviteCommerce(models.Model): >>> from agde.models import AgdeEtab During handling of the above exception, another exception occurred: Traceback (most recent call last): When I debug http://fbcore.py line 3091, the value type is bytes with 32 alnum chars => Hi, I have a related entity that uses UUID binary as primary key, when I try to get this entity, I get the following error: Schema: from django.db import models class AgdeEtab(models.Model): class AgdeActiviteCommerce(models.Model): In console : >>> from agde.models import AgdeEtab Traceback (most recent call last): During handling of the above exception, another exception occurred: Traceback (most recent call last): When I debug http://fbcore.py line 3091, the value type is bytes with 32 alnum chars |
Submitted by: Emmanuel Belair (ebelair)
Hi, I have a related entity that uses UUID binary as primary key, when I try to get this entity, I get the following error:
Schema:
import uuid
from django.db import models
class AgdeEtab(models.Model):
etab_id = models.UUIDField(primary_key=True, default=uuid.uuid4, blank=False, null=False)
activite_commerce = models.ForeignKey('AgdeActiviteCommerce', models.DO_NOTHING, blank=True, null=True)
class AgdeActiviteCommerce(models.Model):
activite_commerce_id = models.UUIDField(primary_key=True, default=uuid.uuid4)
activite_commerce_lib = models.CharField(unique=True, max_length=60)
In console :
>>> from agde.models import AgdeEtab
>>> etab = AgdeEtab.objects.get(enseigne__startswith='MIDAS')
>>> etab.activite_commerce
Traceback (most recent call last):
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/fields/related_descriptors.py", line 158, in __get__
rel_obj = self.field.get_cached_value(instance)
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/fields/mixins.py", line 13, in get_cached_value
return instance._state.fields_cache[cache_name]
KeyError: 'activite_commerce'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "<input>", line 1, in <module>
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/fields/related_descriptors.py", line 164, in __get__
rel_obj = self.get_object(instance)
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/fields/related_descriptors.py", line 139, in get_object
return qs.get(self.field.get_reverse_related_filter(instance))
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/query.py", line 397, in get
num = len(clone)
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/query.py", line 254, in __len__
self._fetch_all()
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/query.py", line 1182, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1068, in execute_sql
cursor.execute(sql, params)
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 100, in execute
return super().execute(sql, params)
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 68, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute
return self.cursor.execute(sql, params)
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/django/db/backends/firebird/base.py", line 262, in execute
return self.cursor.execute(q, params)
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/fdb/fbcore.py", line 3627, in execute
self._ps._execute(parameters)
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/fdb/fbcore.py", line 3308, in _execute
self.__tuple2xsqlda(self._in_sqlda, parameters)
File "/home/manu/env01/fbtest/venv/lib/python3.6/site-packages/fdb/fbcore.py", line 3091, in __tuple2xsqlda
len(value)))
ValueError: Value of parameter (0) is too long, expected 16, found 32
When I debug http://fbcore.py line 3091, the value type is bytes with 32 alnum chars
Feel free to ask if you need more details
The text was updated successfully, but these errors were encountered: