{"id":744,"date":"2019-02-03T17:42:50","date_gmt":"2019-02-03T08:42:50","guid":{"rendered":"https:\/\/www.nblog09.com\/w\/?p=744"},"modified":"2021-11-11T17:33:58","modified_gmt":"2021-11-11T08:33:58","slug":"django-order-by","status":"publish","type":"post","link":"https:\/\/www.nblog09.com\/w\/2019\/02\/03\/django-order-by\/","title":{"rendered":"Django\u306eorder_by\u306b\u3064\u3044\u3066\u3044\u308d\u3044\u308d\u306a\u4f7f\u3044\u65b9\u3092\u307e\u3068\u3081\u307e\u3057\u305f"},"content":{"rendered":"


\nDjango\u306e\u4e26\u3073\u66ff\u3048\u306e\u65b9\u6cd5<\/strong><\/h2>\n

Django\u3067\u5024\u3092\u4e26\u3073\u66ff\u3048\u3066\u53d6\u5f97\u3059\u308b\u306b\u306f\u3001\u30e2\u30c7\u30eb\u306eorder_by\u30e1\u30bd\u30c3\u30c9\u3092\u7528\u3044\u308b\u3002
\nModel.objects.order_by(\u2019column\u2019)<\/span>
\n\u3068\u3059\u308b\u3068column\u3092\u7528\u3044\u3066\u30ec\u30b3\u30fc\u30c9\u3092\u6607\u9806\u306b<\/span>\u4e26\u3073\u66ff\u3048\u5024\u3092\u4e00\u89a7\u3067\u53d6\u5f97\u3055\u308c\u308b\u3002<\/p>\n

\u307e\u305f\u3001
\norder_by().reverse()<\/span>\u3068\u3059\u308b\u3068\u964d\u9806\u306b<\/span>\u4e26\u3073\u66ff\u3048\u3066\u53d6\u5f97\u3055\u308c\u308b\u3002<\/p>\n

\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5229\u7528\u3059\u308b<\/p>\n

\n
    \n
  • order_by\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9<\/li>\n<\/ul>\n
    \nimport os
    \nos.environ.setdefault(\"DJANGO_SETTINGS_MODULE\", 'ProTwo.settings') # django\u306eDB\u63a5\u7d9a\u8a2d\u5b9a\u8aad\u307f\u8fbc\u307f<\/strong><\/p>\n

    import django
    \ndjango.setup() # django\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7<\/strong><\/p>\n

    from app.models import User<\/p>\n

    user_list = User.objects.order_by<\/span>('first_name') # User\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092first_name\u3067\u6607\u9806\u306b\u3057\u3066\u5024\u3092\u53d6\u5f97(order by first_name)<\/strong><\/p>\n

    for user in user_list:
    \n    print(user.first_name) # \u53d6\u5f97\u3057\u305f\u5024\u306e\u4e00\u89a7\u30921\u3064\u305a\u3064\u8868\u793a<\/strong><\/p>\n

    user_list = User.objects.order_by<\/span>('first_name').reverse()<\/span>
    \n# User\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092first_name\u3067\u964d\u9806\u306b\u3057\u3066\u5024\u3092\u53d6\u5f97(order by first_name desc)<\/strong>\n<\/div>\n

      \n
    • \u30e9\u30f3\u30c0\u30e0\u306b\u4e26\u3073\u66ff\u3048\u305f\u3044\u5834\u5408\u306f\u3001order_by(?)\u3068\u3059\u308b<\/strong><\/li>\n<\/ul>\n
      \nuser_list = User.objects.order_by('?')<\/span>\n<\/div>\n
        \n
      • 2\u3064\u306e\u30ad\u30fc\u3092\u7528\u3044\u3066order by\u3059\u308b\u5834\u5408\u306f\u3001\u30ab\u30f3\u30de(,)\u3067\u533a\u5207\u308b<\/li>\n<\/ul>\n
        \nuser_list = User.objects.order_by('first_name', 'last_name')<\/span> # order by first_name, last_name<\/strong>\n<\/div>\n
          \n
        • \u5927\u6587\u5b57\u3001\u5c0f\u6587\u5b57\u306b\u5909\u63db\u3057\u3066order_by<\/li>\n<\/ul>\n
          \nfrom django.db.models.functions import Lower, Upper<\/p>\n

          user_list = User.objects.order_by(Lower('last_name'))
          \nuser_list = User.objects.order_by(Upper('last_name'))\n<\/p><\/div>\n

            \n
          • \u30ab\u30e9\u30e0\u3092\u3064\u306a\u3052\u3066order_by<\/li>\n<\/ul>\n
            from django.db.models.functions import Concat
            \n<\/span>
            \nuser_list = User.objects.order_by(Concat('last_name', 'first_name'))\n<\/div>\n<\/div>\n
            <\/div>\n","protected":false},"excerpt":{"rendered":"

            Django\u306e\u4e26\u3073\u66ff\u3048\u306e\u65b9\u6cd5 Django\u3067\u5024\u3092\u4e26\u3073\u66ff\u3048\u3066\u53d6\u5f97\u3059\u308b\u306b\u306f\u3001\u30e2\u30c7\u30eb\u306eorder_by\u30e1\u30bd\u30c3\u30c9\u3092\u7528\u3044\u308b\u3002 Model.objects.order_by(\u2019column\u2019) \u3068\u3059\u308b\u3068column\u3092\u7528\u3044\u3066\u30ec\u30b3\u30fc\u30c9\u3092 […]<\/p>\n","protected":false},"author":1,"featured_media":109,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uag_custom_page_level_css":"","_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[121,219],"tags":[122,139,14],"class_list":{"0":"post-744","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-django","8":"category-it-programming","9":"tag-django","10":"tag-order_by","11":"tag-python","12":"entry"},"uagb_featured_image_src":{"full":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/Mac.jpg",720,480,false],"thumbnail":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/Mac-150x150.jpg",150,150,true],"medium":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/Mac-300x200.jpg",300,200,true],"medium_large":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/Mac.jpg",720,480,false],"large":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/Mac.jpg",720,480,false],"1536x1536":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/Mac.jpg",720,480,false],"2048x2048":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/Mac.jpg",720,480,false],"home-middle":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/Mac.jpg",525,350,false],"home-top":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/Mac.jpg",630,420,false],"sidebar-thumbnail":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/Mac.jpg",100,67,false]},"uagb_author_info":{"display_name":"9nmatsumoto","author_link":"https:\/\/www.nblog09.com\/w\/author\/9nmatsumoto\/"},"uagb_comment_info":40,"uagb_excerpt":"Django\u306e\u4e26\u3073\u66ff\u3048\u306e\u65b9\u6cd5 Django\u3067\u5024\u3092\u4e26\u3073\u66ff\u3048\u3066\u53d6\u5f97\u3059\u308b\u306b\u306f\u3001\u30e2\u30c7\u30eb\u306eorder_by\u30e1\u30bd\u30c3\u30c9\u3092\u7528\u3044…","_links":{"self":[{"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/posts\/744","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/comments?post=744"}],"version-history":[{"count":13,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/posts\/744\/revisions"}],"predecessor-version":[{"id":3786,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/posts\/744\/revisions\/3786"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/media\/109"}],"wp:attachment":[{"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/media?parent=744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/categories?post=744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/tags?post=744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}