{"id":2698,"date":"2021-03-03T13:48:26","date_gmt":"2021-03-03T04:48:26","guid":{"rendered":"https:\/\/qol-kk.com\/wp2\/?p=2698"},"modified":"2021-03-03T13:48:26","modified_gmt":"2021-03-03T04:48:26","slug":"post-2698","status":"publish","type":"post","link":"https:\/\/qol-kk.com\/wp2\/blog\/2021\/03\/03\/post-2698\/","title":{"rendered":"Django\uff1aQuerySet\u3092\u4f7f\u3063\u3066\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30ab\u30e9\u30e0\u306bfilter\u3057\u62bd\u51fa\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"

Django\uff1aQuerySet\u3092\u4f7f\u3063\u3066\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30ab\u30e9\u30e0\u306bfilter\u3057\u62bd\u51fa\u3059\u308b\u65b9\u6cd5<\/h2>\n

Laravel \u306eEloquent\u3067\u306f\u30b3\u30ec\u304c\u306a\u304b\u306a\u304b\u9762\u5012\u3060\u3063\u305f\u308a\u3059\u308b\u3051\u3069\u3001Django\u306eQuerySet\u3053\u306e\u51e6\u7406\u304c\u3068\u3066\u3082\u7c21\u5358\u3067\u3059\u3002<\/p>\n

\n

__\u3067\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u3064\u306a\u3050\u3060\u3051\u3067\u30ab\u30e9\u30e0\u307e\u3067\u305f\u3069\u308a\u7740\u3051\u308b<\/p>\n<\/div>\n

\u5177\u4f53\u7684\u306b\u306f\u3053\u3093\u306a\u30b3\u30fc\u30c9\u3067\u51e6\u7406\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u30d9\u30fc\u30b9\u306e\u30e2\u30c7\u30eb.objects.filter(\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30e2\u30c7\u30eb1__\u3055\u3089\u306b\u305d\u306e\u5148\u306e\u30e2\u30c7\u30eb2__\u30e2\u30c7\u30eb2\u306e\u30ab\u30e9\u30e0\u540d__exact=\u62bd\u51fa\u3059\u308b\u5024)<\/pre>\n
\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u5024\u3067\u62bd\u51fa\u3059\u308b\u5177\u4f53\u4f8b<\/h3>\n
\u5177\u4f53\u7684\u306b\u4eca\u4f5c\u3063\u3066\u3044\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f8b\u306b\u3057\u307e\u3059\u3002<\/p>\n
# Models.py\r\nfrom django.db import models\r\nfrom accounts.models import CustomUser\r\n\r\nclass Skill(models.Model):\r\n    CATEGORY_CHOICES = (\r\n        (1, '\u30b9\u30af\u30ea\u30d7\u30c8'),\r\n        (2, '\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9'),\r\n        (3, '\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\/\u30e9\u30a4\u30d6\u30e9\u30ea'),\r\n        (4, '\u74b0\u5883\/OS'),\r\n        (5, '\u305d\u306e\u4ed6'),\r\n    )\r\n    category = models.IntegerField(verbose_name='\u5206\u985e\u533a\u5206', choices=CATEGORY_CHOICES)\r\n    skillname = models.CharField(verbose_name=\"\u30b9\u30ad\u30eb\u540d\", max_length=100, blank=False)\r\n    created_at = models.DateTimeField(verbose_name='\u4f5c\u6210\u65e5\u6642', auto_now_add=True)\r\n    updated_at = models.DateTimeField(verbose_name='\u66f4\u65b0\u65e5\u6642', auto_now=True)\r\n\r\n    class Meta:\r\n        verbose_name_plural = 'Skill'\r\n\r\n        def __str__(self):\r\n            name = self.skillname\r\n            #return self.category + ' ' + self.skillname\r\n            return name\r\n\r\nclass Operation(models.Model):\r\n    EMPLOY_CHOICES = (\r\n        (1, '\u6b63\u793e\u54e1'),\r\n        (2, '\u30d5\u30ea\u30fc\u30e9\u30f3\u30b9'),\r\n        (3, '\u6d3e\u9063'),\r\n        (4, '\u305d\u306e\u4ed6'),\r\n    )\r\n    WORKING_CHOICES = (\r\n        (1, '\u5e38\u99d0'),\r\n        (2, '\u4e00\u90e8\u30ea\u30e2\u30fc\u30c8'),\r\n        (3, '\u30d5\u30eb\u30ea\u30e2\u30fc\u30c8'),\r\n    )\r\n    user = models.ForeignKey(CustomUser, on_delete=models.CASCADE, verbose_name='\u30e6\u30fc\u30b6\u30fcID')\r\n    title = models.CharField(verbose_name='\u6848\u4ef6\u540d', max_length=100, blank=False)\r\n    employmentstatus = models.IntegerField(verbose_name='\u96c7\u7528\u5f62\u614b', choices=EMPLOY_CHOICES)\r\n    wayofworking = models.IntegerField(verbose_name='\u6d3b\u52d5\u5f62\u614b', choices=WORKING_CHOICES)\r\n    ordering = models.CharField(verbose_name='\u4f9d\u983c\u4e3b', max_length=100, blank=True, null=True)\r\n    start_date = models.DateField(verbose_name='\u958b\u59cb\u65e5', blank=True, null=True)\r\n    end_date = models.DateField(verbose_name='\u4fee\u4e86\u65e5', blank=True, null=True)\r\n    casecontent = models.TextField(verbose_name='\u4f9d\u983c\u5185\u5bb9', blank=True, null=True, default=None)\r\n    handled = models.TextField(verbose_name='\u62c5\u5f53\u30d1\u30fc\u30c8', blank=True, null=True)\r\n    numberofteams = models.IntegerField(verbose_name='\u30c1\u30fc\u30e0\u4eba\u6570', default=None)\r\n    image = models.ImageField('\u753b\u50cf1', upload_to='images\/', blank=True, null=True, default=None)\r\n    creations = models.URLField(verbose_name='\u53c2\u8003URL', blank=True, null=True, default=None)\r\n    created_at = models.DateTimeField(verbose_name='\u4f5c\u6210\u65e5\u6642', auto_now_add=True)\r\n    updated_at = models.DateTimeField(verbose_name='\u66f4\u65b0\u65e5\u6642', auto_now=True)\r\n\r\n    class Meta:\r\n        verbose_name_plural = 'Operation'\r\n\r\n        def __str__(self):\r\n            return self.title\r\nclass UseSkill(models.Model):\r\n    operation = models.ForeignKey(Operation, on_delete=models.CASCADE, verbose_name='\u6848\u4ef6ID')\r\n    skill = models.ForeignKey(Skill, on_delete=models.CASCADE, verbose_name='\u30b9\u30ad\u30ebID')\r\n    created_at = models.DateTimeField(verbose_name='\u4f5c\u6210\u65e5\u6642', auto_now_add=True)\r\n    updated_at = models.DateTimeField(verbose_name='\u66f4\u65b0\u65e5\u6642', auto_now=True)\r\n\r\n    class Meta:\r\n        verbose_name_plural = 'Useskill'\r\n\r\n        def __str__(self):\r\n            return self.Skill.skillname + ' '+ self.Operation.title<\/pre>\n
\u3053\u308c\u306f\u4eca\u79c1\u304c\u4f5c\u6210\u3057\u3066\u3044\u308b\u30dd\u30fc\u30c8\u30d5\u30a9\u30ea\u30aaPDF\u306e\u751f\u6210\u30b7\u30b9\u30c6\u30e0\u306e\u30c6\u30fc\u30d6\u30eb\u3067\u3059\u3002
\n\u6848\u4ef6\uff1doperation\u306b\u5bfe\u3057\u3066\u3001\u3069\u3093\u306a\u30b9\u30ad\u30eb\u3092\u4f7f\u3063\u305f\u304b\u3092UseSkill\u3068\u3044\u3046\u30c6\u30fc\u30d6\u30eb\u306b\u8a18\u8f09\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n
\u30b9\u30ad\u30eb\u306e\u6d3b\u7528\u671f\u9593\u3092\u7b97\u51fa\u3057\u305f\u3044\u5834\u5408\u3069\u3046\u3059\u308c\u3070\u3044\u3044\u304b<\/h3>\n
UseSkill\u3092\u30b9\u30ad\u30eb\u3054\u3068\u306b\u62bd\u51fa\u3057\u30b9\u30ad\u30eb\u3092\u5229\u7528\u3057\u305f\u671f\u9593\u3092operation\u304b\u3089\u8a08\u7b97\u3057\u3088\u3046\u3068\u3057\u305f\u5834\u5408\u3001\u6b21\u306e\u3088\u3046\u306a\u30eb\u30fc\u30c8\u304c\u8003\u3048\u3089\u308c\u307e\u3059\u3002<\/p>\n
\n
    \n
  1. Skill\u3092all()\u3067\u5168\u4ef6\u53d6\u5f97\u3001\u3053\u308c\u3092For\u30eb\u30fc\u30d7\u3057UseSkill\u304b\u3089Operation(\u6848\u4ef6)\u3092\u62bd\u51fa\u3002\u3055\u3089\u306b\u6848\u4ef6\u3092\u56de\u3057\u3066\u81ea\u5206\u306e\u4fc2\u308f\u3063\u305f\u6848\u4ef6\u306e\u671f\u9593\u3092\u8a08\u7b97\u3057\u5408\u8a08<\/li>\n
  2. Operation\u304b\u3089\u81ea\u5206\u306e\u4fc2\u308f\u3063\u305f\u6848\u4ef6\u3092\u62bd\u51fa\u3002\u3053\u308c\u3092For\u30eb\u30fc\u30d7\u3057UseSkill\u3092\u62bd\u51fa\u3002[\u30b9\u30ad\u30eb\u540d,\u671f\u9593]\u306e\u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3057Group_by\u3067\u7d50\u5408\u3068Sum<\/li>\n
  3. UseSkill\u304b\u3089\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306eOperation\u306euser\u306b\u62bd\u51fa\u6761\u4ef6\u3092\u304b\u3051Group_by\u3057\u4f7f\u7528\u30b9\u30ad\u30eb\u540dList\u3092\u4f5c\u6210\u3002\u3053\u308c\u3092For\u30eb\u30fc\u30d7\u3057Operation\u3092\u62bd\u51fa(enddate-startdate)\u306e\u8a08\u7b97\u7d50\u679c\u3092SUM\u3067\u96c6\u8a08<\/li>\n
  4. UseSkill\u304b\u3089\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306eOperation\u306euser\u306b\u62bd\u51fa\u6761\u4ef6\u3092\u304b\u3051Group_by\u3057\u4f7f\u7528\u30b9\u30ad\u30eb\u540dList\u3092\u4f5c\u6210\u3002\u3053\u308c\u3092where in \u3067Operation\u3092\u62bd\u51fa\u3002pandas\u306b\u5165\u308c\u3066\u30b4\u30cb\u30e7\u30b4\u30cb\u30e7<\/li>\n
  5. UseSkill\u304b\u3089\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306eOperation\u306euser\u306b\u62bd\u51fa\u6761\u4ef6\u3092\u304b\u3051\u62bd\u51fa\u3002\u7d50\u679c\u3092pandas\u306b\u5165\u308c\u3066\u30b4\u30cb\u30e7\u30b4\u30cb\u30e7<\/li>\n<\/ol>\n<\/div>\n
    \u6ce5\u81ed\u304f\u4f55\u56de\u3082\u300e\u62bd\u51fa=>For\u30eb\u30fc\u30d7\u300f\u3092\u304b\u3051\u308c\u3070\u6b32\u3057\u3044\u60c5\u5831\u307e\u3067\u306f\u6301\u3063\u3066\u3044\u3051\u307e\u3059\u3002
    \n\u3067\u3082\u52c9\u5f37\u7528\u306a\u306e\u30673\uff5e5\u306e\u3069\u308c\u304b\u3067\u884c\u304d\u305f\u3044\u3067\u3059\u3002
    \n\u3067\u3053\u306e\u6642\u5171\u901a\u306e\u8ab2\u984c\u3068\u306a\u308b\u306e\u304c\u3010 \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30e9\u30e0\u306b\u62bd\u51fa\u6761\u4ef6\u3092\u304b\u3051\u308b \u3011\u3068\u3044\u3046\u64cd\u4f5c\u3067\u3059\u3002<\/p>\n
    \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u5024\u3067\u62bd\u51fa\u3059\u308bDjango\u306e\u30b9\u30af\u30ea\u30d7\u30c8<\/h3>\n
    us = Useskill.objects.filter(operation__customer__id__exact=\u30e6\u30fc\u30b6\u30fcID)<\/pre>\n
    1\u884c\u3067\u5b8c\u4e86\u3001\u3057\u304b\u3082\u308f\u304b\u308a\u3084\u3059\u3044\uff01Django\u30b9\u30b2\u30fc\u3002<\/p>\n
    \u3053\u308c\u3092Laravel\u306eEloquent\u3067\u66f8\u304f\u3068\u3053\u3093\u306a\u611f\u3058<\/p>\n
    us = UseSkill::whereHas('operation',function($seach)use('\u30e6\u30fc\u30b6\u30fcID'){\r\n    $search->where('user',\u30e6\u30fc\u30b6\u30fcID)\r\n}->get();<\/pre>\n
    function\u304c\u51fa\u3066\u304d\u305f\u308a\u306a\u3069\u306a\u3069\u6163\u308c\u308c\u3070\u554f\u984c\u306a\u3044\u3093\u3067\u3059\u3051\u3069\u3001\u6577\u5c45\u306f\u9ad8\u304f\u898b\u3048\u307e\u3059\u3088\u306d\u3002<\/p>\n
    \u307e\u3068\u3081<\/h3>\n
    QuerySet\u306e\u4e00\u767a\u3067\u4e00\u6c17\u306b\u65e5\u4ed8\u8a08\u7b97\u307e\u3067\u3067\u304d\u306a\u3044\u304b\u306a\u3068\u8a66\u884c\u932f\u8aa4\u3057\u307e\u3057\u305f\u304c\u3001\u79c1\u306b\u306f\u307e\u3060\u96e3\u6613\u5ea6\u9ad8\u3044\u3088\u3046\u3067\u632b\u6298\u3057\u307e\u3057\u305f\u3002<\/p>\n
    us = Useskill.objects.filter(operation__customer__id__exact=u_id)\\\r\n    .extra(\r\n        select={'val':\"select startdate - enddate from managedcontents_operation where id=%s\"},\r\n        select_params=(['operation'])\r\n    )<\/pre>\n
    \u3053\u3093\u306a\u3067\u884c\u3051\u308b\u304b\u3068\u601d\u3063\u305f\u306e\u3067\u3059\u304c\u3001\u30d1\u30e9\u30e1\u30fc\u30bf\u30fc\u306b'operation'\u3068\u3044\u3046\u6587\u5b57\u5217\u304c\u5165\u3063\u3066\u3057\u307e\u3044\u5931\u6557\u3002
    \n\u7d20\u76f4\u306bPandas\u306b\u683c\u7d0d\u3057\u3088\u3046\u3068\u601d\u3044\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
    Django\uff1aQuerySet\u3092\u4f7f\u3063\u3066\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5148\u306e\u30ab\u30e9\u30e0\u306bfilter\u3057\u62bd\u51fa\u3059\u308b\u65b9\u6cd5 Laravel \u306eEloquent\u3067\u306f\u30b3\u30ec\u304c\u306a\u304b\u306a\u304b\u9762\u5012\u3060\u3063\u305f\u308a\u3059\u308b\u3051\u3069\u3001Django\u306eQuerySet\u3053\u306e\u51e6\u7406\u304c\u3068\u3066\u3082\u7c21\u5358\u3067\u3059\u3002 […]<\/p>\n","protected":false},"author":1,"featured_media":2174,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"sns_share_botton_hide":"","vkExUnit_sns_title":"","_vk_print_noindex":"","sitemap_hide":"","_veu_custom_css":"","veu_display_promotion_alert":"","vkexunit_cta_each_option":"","_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[38],"tags":[814,952,99,147,954,53,308,953],"class_list":["post-2698","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-python-memorandum","tag-django","tag-filter","tag-mysql","tag-python","tag-queryset","tag-53","tag-308","tag-953"],"veu_head_title_object":{"title":"","add_site_title":""},"jetpack_publicize_connections":[],"jetpack-related-posts":[],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/qol-kk.com\/wp2\/wp-content\/uploads\/2020\/11\/django.png","_links":{"self":[{"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/posts\/2698","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/comments?post=2698"}],"version-history":[{"count":0,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/posts\/2698\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/media\/2174"}],"wp:attachment":[{"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/media?parent=2698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/categories?post=2698"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/tags?post=2698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}