Django update all Users field Decimal












1















from decimal import Decimal
from apps.main.models import User
from django.db.models import F

User.objects.all().update(freeze_balance=F('freeze_balance') + Decimal(F('balance') / 8300))



ERROR -> TypeError: conversion from CombinedExpression to Decimal is
not supported




How do I write an ORM request for this?










share|improve this question





























    1















    from decimal import Decimal
    from apps.main.models import User
    from django.db.models import F

    User.objects.all().update(freeze_balance=F('freeze_balance') + Decimal(F('balance') / 8300))



    ERROR -> TypeError: conversion from CombinedExpression to Decimal is
    not supported




    How do I write an ORM request for this?










    share|improve this question



























      1












      1








      1








      from decimal import Decimal
      from apps.main.models import User
      from django.db.models import F

      User.objects.all().update(freeze_balance=F('freeze_balance') + Decimal(F('balance') / 8300))



      ERROR -> TypeError: conversion from CombinedExpression to Decimal is
      not supported




      How do I write an ORM request for this?










      share|improve this question
















      from decimal import Decimal
      from apps.main.models import User
      from django.db.models import F

      User.objects.all().update(freeze_balance=F('freeze_balance') + Decimal(F('balance') / 8300))



      ERROR -> TypeError: conversion from CombinedExpression to Decimal is
      not supported




      How do I write an ORM request for this?







      django orm django-orm






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 26 '18 at 11:27









      Dave

      2,84481830




      2,84481830










      asked Nov 26 '18 at 11:11









      Dilkhush VakhabovDilkhush Vakhabov

      83




      83
























          1 Answer
          1






          active

          oldest

          votes


















          0














          Combining Decimal and F expression is not supported in django. Try below code



          User.objects.all().update(freeze_balance=F('freeze_balance')  + F('balance') / 8300)





          share|improve this answer
























          • Thank you its work F('balance') / 8300.00

            – Dilkhush Vakhabov
            Nov 26 '18 at 13:04














          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53479865%2fdjango-update-all-users-field-decimal%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          Combining Decimal and F expression is not supported in django. Try below code



          User.objects.all().update(freeze_balance=F('freeze_balance')  + F('balance') / 8300)





          share|improve this answer
























          • Thank you its work F('balance') / 8300.00

            – Dilkhush Vakhabov
            Nov 26 '18 at 13:04


















          0














          Combining Decimal and F expression is not supported in django. Try below code



          User.objects.all().update(freeze_balance=F('freeze_balance')  + F('balance') / 8300)





          share|improve this answer
























          • Thank you its work F('balance') / 8300.00

            – Dilkhush Vakhabov
            Nov 26 '18 at 13:04
















          0












          0








          0







          Combining Decimal and F expression is not supported in django. Try below code



          User.objects.all().update(freeze_balance=F('freeze_balance')  + F('balance') / 8300)





          share|improve this answer













          Combining Decimal and F expression is not supported in django. Try below code



          User.objects.all().update(freeze_balance=F('freeze_balance')  + F('balance') / 8300)






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 26 '18 at 11:18









          Anjaneyulu BattaAnjaneyulu Batta

          4,03911639




          4,03911639













          • Thank you its work F('balance') / 8300.00

            – Dilkhush Vakhabov
            Nov 26 '18 at 13:04





















          • Thank you its work F('balance') / 8300.00

            – Dilkhush Vakhabov
            Nov 26 '18 at 13:04



















          Thank you its work F('balance') / 8300.00

          – Dilkhush Vakhabov
          Nov 26 '18 at 13:04







          Thank you its work F('balance') / 8300.00

          – Dilkhush Vakhabov
          Nov 26 '18 at 13:04






















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53479865%2fdjango-update-all-users-field-decimal%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Wiesbaden

          Marschland

          Dieringhausen