[Django] #31887: from django.db.models import Avg, Max, Min, Sum In [369]: from StoreWeb.models import Product, Price In [370]: Price.objects.all().aggregate(Min('value'))
Django
In [369]: from StoreWeb.models import Product, Price In [370]:
Price.objects.all().aggregate(Min('value'))
-------------------------------------+-------------------------------------
Reporter: Mirirous | Owner: nobody
Type: | Status: new
Uncategorized |
Component: | Version: 3.1
Uncategorized |
Severity: Normal | Keywords: uso de Max y Min
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
OperationalError Traceback (most recent call
last)
~/env38/StoreVirtual/lib/python3.8/site-
packages/django/db/backends/utils.py in _execute(self, sql, params,
*ignored_wrapper_args)
85 else:
---> 86 return self.cursor.execute(sql, params)
87
~/env38/StoreVirtual/lib/python3.8/site-
packages/django/db/backends/mysql/base.py in execute(self, query, args)
73 # args is None means no string interpolation
---> 74 return self.cursor.execute(query, args)
75 except Database.OperationalError as e:
~/env38/StoreVirtual/lib/python3.8/site-packages/MySQLdb/cursors.py in
execute(self, query, args)
205 assert isinstance(query, (bytes, bytearray))
--> 206 res = self._query(query)
207 return res
~/env38/StoreVirtual/lib/python3.8/site-packages/MySQLdb/cursors.py in
_query(self, q)
318 self._result = None
--> 319 db.query(q)
320 self._do_get_result(db)
~/env38/StoreVirtual/lib/python3.8/site-packages/MySQLdb/connections.py in
query(self, query)
258 query = bytes(query)
--> 259 _mysql.connection.query(self, query)
260
OperationalError: (2006, 'MySQL server has gone away')
The above exception was the direct cause of the following exception:
OperationalError Traceback (most recent call
last)
<ipython-input-367-52af1526b6a5> in <module>
----> 1 Price.objects.all().aggregate(Min('value'))
~/env38/StoreVirtual/lib/python3.8/site-packages/django/db/models/query.py
in aggregate(self, *args, **kwargs)
382 if not query.annotations[alias].contains_aggregate:
383 raise TypeError("%s is not an aggregate
expression" % alias)
--> 384 return query.get_aggregation(self.db, kwargs)
385
386 def count(self):
~/env38/StoreVirtual/lib/python3.8/site-
packages/django/db/models/sql/query.py in get_aggregation(self, using,
added_aggregate_names)
501 outer_query.select_related = False
502 compiler = outer_query.get_compiler(using)
--> 503 result = compiler.execute_sql(SINGLE)
504 if result is None:
505 result = [None] * len(outer_query.annotation_select)
~/env38/StoreVirtual/lib/python3.8/site-
packages/django/db/models/sql/compiler.py in execute_sql(self,
result_type, chunked_fetch, chunk_size)
1150 cursor = self.connection.cursor()
1151 try:
-> 1152 cursor.execute(sql, params)
1153 except Exception:
1154 # Might fail for server-side cursors (e.g. connection
closed)
~/env38/StoreVirtual/lib/python3.8/site-
packages/django/db/backends/utils.py in execute(self, sql, params)
98 def execute(self, sql, params=None):
99 with self.debug_sql(sql, params,
use_last_executed_query=True):
--> 100 return super().execute(sql, params)
101
102 def executemany(self, sql, param_list):
~/env38/StoreVirtual/lib/python3.8/site-
packages/django/db/backends/utils.py in execute(self, sql, params)
66
67 def execute(self, sql, params=None):
---> 68 return self._execute_with_wrappers(sql, params,
many=False, executor=self._execute)
69
70 def executemany(self, sql, param_list):
~/env38/StoreVirtual/lib/python3.8/site-
packages/django/db/backends/utils.py in _execute_with_wrappers(self, sql,
params, many, executor)
75 for wrapper in reversed(self.db.execute_wrappers):
76 executor = functools.partial(wrapper, executor)
---> 77 return executor(sql, params, many, context)
78
79 def _execute(self, sql, params, *ignored_wrapper_args):
~/env38/StoreVirtual/lib/python3.8/site-
packages/django/db/backends/utils.py in _execute(self, sql, params,
*ignored_wrapper_args)
84 return self.cursor.execute(sql)
85 else:
---> 86 return self.cursor.execute(sql, params)
87
88 def _executemany(self, sql, param_list,
*ignored_wrapper_args):
~/env38/StoreVirtual/lib/python3.8/site-packages/django/db/utils.py in
__exit__(self, exc_type, exc_value, traceback)
88 if dj_exc_type not in (DataError, IntegrityError):
89 self.wrapper.errors_occurred = True
---> 90 raise dj_exc_value.with_traceback(traceback) from
exc_value
91
92 def __call__(self, func):
~/env38/StoreVirtual/lib/python3.8/site-
packages/django/db/backends/utils.py in _execute(self, sql, params,
*ignored_wrapper_args)
84 return self.cursor.execute(sql)
85 else:
---> 86 return self.cursor.execute(sql, params)
87
88 def _executemany(self, sql, param_list,
*ignored_wrapper_args):
~/env38/StoreVirtual/lib/python3.8/site-
packages/django/db/backends/mysql/base.py in execute(self, query, args)
72 try:
73 # args is None means no string interpolation
---> 74 return self.cursor.execute(query, args)
75 except Database.OperationalError as e:
76 # Map some error codes to IntegrityError, since they
seem to be
~/env38/StoreVirtual/lib/python3.8/site-packages/MySQLdb/cursors.py in
execute(self, query, args)
204
205 assert isinstance(query, (bytes, bytearray))
--> 206 res = self._query(query)
207 return res
208
~/env38/StoreVirtual/lib/python3.8/site-packages/MySQLdb/cursors.py in
_query(self, q)
317 db = self._get_db()
318 self._result = None
--> 319 db.query(q)
320 self._do_get_result(db)
321 self._post_get_result()
~/env38/StoreVirtual/lib/python3.8/site-packages/MySQLdb/connections.py in
query(self, query)
257 if isinstance(query, bytearray):
258 query = bytes(query)
--> 259 _mysql.connection.query(self, query)
260
261 def _bytes_literal(self, bs):
OperationalError: (2006, 'MySQL server has gone away')
--
Ticket URL: <https://code.djangoproject.com/ticket/31887>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
Django
In [369]: from StoreWeb.models import Product, Price In [370]:
Price.objects.all().aggregate(Min('value'))
Reporter: Mirirous | Owner: Mirirous
Type: Uncategorized | Status: assigned
Component: Error reporting | Version: 3.1
Severity: Normal | Resolution:
Keywords: uso de Max y Min | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
Changes (by Mirirous):
* status: new => assigned
* cc: Mirirous (added)
* component: Uncategorized => Error reporting
* owner: nobody => Mirirous
* stage: Unreviewed => Accepted
Old description:
> packages/django/db/models/query.py in aggregate(self, *args, **kwargs)
New description:
--
Comment:
Hola, compañeros tengo este error al ejecutar las siguientes lines en el
shell de django
from django.db.models import Avg, Max, Min, Sum
In [369]: from StoreWeb.models import Product, Price
In [370]: Price.objects.all().aggregate(Min('value'))
EROOR
--
Ticket URL: <https://code.djangoproject.com/ticket/31887#comment:1>
Django
In [369]: from StoreWeb.models import Product, Price In [370]:
Price.objects.all().aggregate(Min('value'))
Reporter: Mirian Pardo | Owner: Mirian Pardo
Type: Uncategorized | Status: closed
Component: Error reporting | Version: 3.1
Keywords: uso de Max y Min | Triage Stage: Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
Changes (by felixxm):
* status: assigned => closed
* resolution: => invalid
* stage: Accepted => Unreviewed
Comment:
Please don't use Trac as a support channel. Closing per
TicketClosingReasons/UseSupportChannels.
Also please don't accept your own tickets.
--
Ticket URL: <https://code.djangoproject.com/ticket/31887#comment:2>
Django
----------------------------------+----------------------------------------
Reporter: Mirian Pardo | Owner: Mirian Pardo
Type: Uncategorized | Status: closed
Component: Error reporting | Version: 3.1
Severity: Normal | Resolution: invalid
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
--
Ticket URL: <https://code.djangoproject.com/ticket/31887#comment:3>