Django Queryset

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Django Queryset

Emmanuel Oppong Ntiamoah
Hello, Django Users please I need your help and it is urgent,

          I have this code:
permit_cy = Permit.objects.values(
        'info__date_of_transaction__year', 'info__country_destination__continent'
    ).annotate(volume=Sum('volume')
    ).order_by('info__country_destination__continent'
    ).filter(info__date_of_transaction__range=["2019-01-01", "2020-12-31"])

and this Queryset:

<QuerySet [{'info__date_of_transaction__year': 2019, 'info__country_destination__continent': 'Africa', 'volume': Decimal('214.330')}, {'info__date_of_transaction__year': 2020, 'info__country_destination__continent': 'Africa', 'volume': Decimal('1546.482')}, {'info__date_of_transaction__year': 2020, 'info__country_destination__continent': 'Asia/Far East', 'volume': Decimal('5678.234')}, {'info__date_of_transaction__year': 2020, 'info__country_destination__continent': 'EU', 'volume': Decimal('100.282')}]> 2019 2020 2020 2020

Please how do use it in the template to get something like this, 
Capture.PNG

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/2a7e56f3-e4d1-4cbe-87c6-1e9675aa0ab3n%40googlegroups.com.
Reply | Threaded
Open this post in threaded view
|

Re: Django Queryset

Walter Randazzo
Hi there. 

Did you try datatable

Regards,

El mié., 4 nov. 2020 8:30 a. m., [hidden email] <[hidden email]> escribió:
Hello, Django Users please I need your help and it is urgent,

          I have this code:
permit_cy = Permit.objects.values(
        'info__date_of_transaction__year', 'info__country_destination__continent'
    ).annotate(volume=Sum('volume')
    ).order_by('info__country_destination__continent'
    ).filter(info__date_of_transaction__range=["2019-01-01", "2020-12-31"])

and this Queryset:

<QuerySet [{'info__date_of_transaction__year': 2019, 'info__country_destination__continent': 'Africa', 'volume': Decimal('214.330')}, {'info__date_of_transaction__year': 2020, 'info__country_destination__continent': 'Africa', 'volume': Decimal('1546.482')}, {'info__date_of_transaction__year': 2020, 'info__country_destination__continent': 'Asia/Far East', 'volume': Decimal('5678.234')}, {'info__date_of_transaction__year': 2020, 'info__country_destination__continent': 'EU', 'volume': Decimal('100.282')}]> 2019 2020 2020 2020

Please how do use it in the template to get something like this, 
Capture.PNG

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/2a7e56f3-e4d1-4cbe-87c6-1e9675aa0ab3n%40googlegroups.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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAL7Dry6kBcLwnfw7naeYr_ROCsGRwzdbHv5mcQWxgEv7G7%2B-8Q%40mail.gmail.com.
Reply | Threaded
Open this post in threaded view
|

Re: Django Queryset

MAMADOU KANTE
Hi to everybody;
I have been trying to deploy an app through heroku for the past 7 days but whenever I reach the final stage  I receive a rejection message.
The message tells me the module "skbuild" was not imported or I should upgrade my pip version. But when I check through the terminal
I find that I can import skbuild and the latest version of pip is installed on the machine.
I tried to deploy by linking my Github repository to heroku but I still receive the same error message as described below:
Python app detected
 !     Python has released a security update! Please consider upgrading to python-3.9.1
       Learn More: https://devcenter.heroku.com/articles/python-runtimes
-----> Installing python-3.9.0
-----> Installing pip 9.0.2, setuptools 47.1.1 and wheel 0.34.2
-----> Installing dependencies with Pipenv 2018.5.18…
       Installing dependencies from Pipfile.lock (db603f)…
       An error occurred while installing opencv-python==4.4.0.46! Will try again.
       Installing initially–failed dependencies…
           Traceback (most recent call last):
             File "<string>", line 1, in <module>
             File "/tmp/pip-build-m9tvr4w5/opencv-python/setup.py", line 9, in <module>
               import skbuild
           ModuleNotFoundError: No module named 'skbuild'
       Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-m9tvr4w5/opencv-python/
       You are using pip version 9.0.2, however version 20.3.1 is available.
       You should consider upgrading via the 'pip install --upgrade pip' command.
       
 !     Push rejected, failed to compile Python app.
 !     Push failed
CAN ANYONE HELP?


On Wed, Nov 4, 2020 at 7:31 PM Walter Randazzo <[hidden email]> wrote:
Hi there. 

Did you try datatable

Regards,

El mié., 4 nov. 2020 8:30 a. m., [hidden email] <[hidden email]> escribió:
Hello, Django Users please I need your help and it is urgent,

          I have this code:
permit_cy = Permit.objects.values(
        'info__date_of_transaction__year', 'info__country_destination__continent'
    ).annotate(volume=Sum('volume')
    ).order_by('info__country_destination__continent'
    ).filter(info__date_of_transaction__range=["2019-01-01", "2020-12-31"])

and this Queryset:

<QuerySet [{'info__date_of_transaction__year': 2019, 'info__country_destination__continent': 'Africa', 'volume': Decimal('214.330')}, {'info__date_of_transaction__year': 2020, 'info__country_destination__continent': 'Africa', 'volume': Decimal('1546.482')}, {'info__date_of_transaction__year': 2020, 'info__country_destination__continent': 'Asia/Far East', 'volume': Decimal('5678.234')}, {'info__date_of_transaction__year': 2020, 'info__country_destination__continent': 'EU', 'volume': Decimal('100.282')}]> 2019 2020 2020 2020

Please how do use it in the template to get something like this, 
Capture.PNG

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/2a7e56f3-e4d1-4cbe-87c6-1e9675aa0ab3n%40googlegroups.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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAL7Dry6kBcLwnfw7naeYr_ROCsGRwzdbHv5mcQWxgEv7G7%2B-8Q%40mail.gmail.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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAOUY%2BRr81Xh0VBXzwoUxUppht_BKuwY-ec%3Dy23Q6pcHN7E0tYg%40mail.gmail.com.
Reply | Threaded
Open this post in threaded view
|

Re: Django Queryset

Jorge Gimeno


On Sun, Dec 13, 2020 at 7:21 PM MAMADOU KANTE <[hidden email]> wrote:
Hi to everybody;
I have been trying to deploy an app through heroku for the past 7 days but whenever I reach the final stage  I receive a rejection message.
The message tells me the module "skbuild" was not imported or I should upgrade my pip version. But when I check through the terminal
I find that I can import skbuild and the latest version of pip is installed on the machine.
I tried to deploy by linking my Github repository to heroku but I still receive the same error message as described below:
Python app detected
 !     Python has released a security update! Please consider upgrading to python-3.9.1
       Learn More: https://devcenter.heroku.com/articles/python-runtimes
-----> Installing python-3.9.0
-----> Installing pip 9.0.2, setuptools 47.1.1 and wheel 0.34.2
-----> Installing dependencies with Pipenv 2018.5.18…
       Installing dependencies from Pipfile.lock (db603f)…
       An error occurred while installing opencv-python==4.4.0.46! Will try again.
       Installing initially–failed dependencies…
           Traceback (most recent call last):
             File "<string>", line 1, in <module>
             File "/tmp/pip-build-m9tvr4w5/opencv-python/setup.py", line 9, in <module>
               import skbuild
           ModuleNotFoundError: No module named 'skbuild'
       Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-m9tvr4w5/opencv-python/
       You are using pip version 9.0.2, however version 20.3.1 is available.
       You should consider upgrading via the 'pip install --upgrade pip' command.
       
 !     Push rejected, failed to compile Python app.
 !     Push failed
CAN ANYONE HELP?

 
I would start by upgrading pip (https://pypi.org/project/pip/).  Version 9.x was quite some time ago.  Also, pipenv's current version is 2020.11.15 (https://pypi.org/project/pipenv/).

-Jorge
 

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CANfN%3DK86JFm2RiEw0wu3T6%2B-bzPtZ5Yh-2ZosA928pgjOMifyA%40mail.gmail.com.