{"id":2786,"date":"2021-03-30T10:27:40","date_gmt":"2021-03-30T01:27:40","guid":{"rendered":"https:\/\/qol-kk.com\/wp2\/?p=2786"},"modified":"2021-03-30T10:27:40","modified_gmt":"2021-03-30T01:27:40","slug":"post-2786","status":"publish","type":"post","link":"https:\/\/qol-kk.com\/wp2\/blog\/2021\/03\/30\/post-2786\/","title":{"rendered":"Django\uff1aQuerySet\u306eJSON\u5909\u63db\u3067\u5927\u30cf\u30de\u30ea\u3057\u305f\u4ef6"},"content":{"rendered":"<h2>Django\uff1aQuerySet\u306eJSON\u5909\u63db\u3067\u5927\u30cf\u30de\u30ea\u3057\u305f\u4ef6<\/h2>\n<p>\u89e3\u6c7a\u3057\u305f\u5f62\u306f\u4e00\u756a\u30b7\u30f3\u30d7\u30eb\u3060\u3063\u305f\u3068\u3044\u3046\u30aa\u30c1\u304c\u4ed8\u3044\u305f\u4eca\u56de\u306e\u30c9\u306f\u307e\u308a\u4e8b\u4ef6\u3002<br \/>\n\u30ad\u30ab\u30c3\u30b1\u306fFront\u3068Back\u306b\u5206\u3051\u305fDjango\u69cb\u7bc9\u3067\u306eBack\u5074\u306eAPI\u51fa\u529b\u3067\u3059\u3002<\/p>\n<pre class=\"prettyprint\"><span class=\"str\">\"WorkList\"<\/span><span class=\"pun\">:<\/span> <span class=\"str\">\"[{\\\"model\\\": \\\"managedcontents.operation\\\", \\\"pk\\\": 9, \\\"fields\\\": {\\\"customer\\\": 1, \\\"title\\\": \\\"\u307b\u3052\u307b\u3052\\\", ...<\/span><\/pre>\n<p>QuerySet\u3068\u3057\u3066\u62bd\u51fa\u3055\u308c\u305f\u5024\u3092\u30d5\u30ed\u30f3\u30c8\u3067\u53d7\u3051\u53d6\u308c\u308b\u3088\u3046\u306bAPI\u3092\u8a2d\u7f6e\u3057\u305f\u306e\u3067\u3059\u304c\u3001\u4e0a\u306e\u3088\u3046\u306a\u30b3\u30fc\u30c9\u304c\u751f\u6210\u3055\u308c\u307e\u3057\u305f\u3002\u3067\u3001\u3053\u308c\u3092\u5c55\u958b\u3057\u3066\u4f55\u3068\u304b\u3057\u3066\u3084\u308d\u3046\u3068\u601d\u3063\u305f\u306e\u3067\u3059\u304c\u30d5\u30ed\u30f3\u30c8\u5074\u3067Key\u3054\u3068\u306e\u5024\u3092\u53d6\u5f97\u3057\u3088\u3046\u3068\u3057\u3066\u3082\u51fa\u6765\u306a\u3044...\u3002<\/p>\n<h3>\u539f\u56e0\u3068\u89e3\u6c7a\u65b9\u6cd5<\/h3>\n<p>\u4e0a\u306e\u69d8\u306b\u300e\\\u201dmodel\u00a5\"\u300f\u3068\u3044\u3063\u305f\u59ff\u306b\u306a\u308b\u5834\u5408\u306f1\u30ec\u30b3\u30fc\u30c9\u306e\u6587\u5b57\u5217\u3068\u3057\u3066API\u9001\u4fe1\u3055\u308c\u3066\u3044\u307e\u3059\u3002<br \/>\n\u3053\u306e\u539f\u56e0\u306fjson.dump\u306e\u52d5\u4f5c\u3067\u3059\u3002<br \/>\nFront\u5074\u3067\u5c55\u958b\u3067\u304d\u308b\u59ff\u306f\u4e0b\u306e\u5f62\u3067\u9001\u4fe1\u3055\u308c\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"lang:default decode:true\">{\r\n    \"WorkList\": [\r\n        {\r\n            \"id\": 9,\r\n            \"customer_id\": 1,\r\n            \"title\": \"\u307b\u3052\u307b\u3052\",<\/pre>\n<p>QuerySet\u306e\u5834\u5408\u3001\u3053\u306e\u5f62\u306b\u3059\u308b\u306e\u306f\u975e\u5e38\u306b\u7c21\u5358\u30671\u884c\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n<pre class=\"\">WorkLists = hoge.objects.filter(customer__exact=userid).order_by('-enddate')\r\n\r\njson_encode = list(WorkLists.values())<\/pre>\n<h3>\u9593\u9055\u3048\u306e\u5143\u51f6\u306f\u96e3\u3057\u304f\u8003\u3048\u3066\u3057\u307e\u3046\u304b\u3089<\/h3>\n<p>\u305d\u3046\u306a\u3093\u3067\u3059\u3088\u306d\u3002<br \/>\n\u30b0\u30fc\u30b0\u30eb\u5148\u751f\u306b\u3053\u3093\u306a\u30ad\u30fc\u30ef\u30fc\u30c9\u3092\u5165\u308c\u3066\u307f\u307e\u3059\u3002<\/p>\n<div class=\"borderBox\">\n<p>\u300cDjango QuerySet JSON \u5909\u63db\u300d<\/p>\n<\/div>\n<p>\u3053\u308c\u3067\u51fa\u3066\u304f\u308b\u5148\u4eba\u306e\u8a18\u4e8b\u306f\u591a\u304f\u306e\u5834\u5408\u3067\u3053\u3093\u306a\u30b3\u30fc\u30c9\u304c\u66f8\u3044\u3066\u3042\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"lang:default decode:true\">json_encode = serializers.serialize('json', WorkList, ensure_ascii=False)<\/pre>\n<pre class=\"lang:default decode:true\">json_encode  = json.dumps(list(WorkList), cls=DjangoJSONEncoder)<\/pre>\n<p>\u3067\u3001\u3053\u308c\u3092\u884c\u3046\u3068\u4e00\u756a\u6700\u521d\u306b\u8a18\u8f09\u3057\u305f\u72b6\u614b\u306b\u306a\u308b\u3068\u3002<\/p>\n<h3>\u30ea\u30b9\u30c8(\u914d\u5217)\u3084DataFrame\u3092Front\u3067\u4f7f\u3044\u305f\u3044\u6642\u3069\u3046\u3059\u308c\u3070\u3044\u3044\uff1f<\/h3>\n<p>\u914d\u5217(\u30ea\u30b9\u30c8)\u306b\u3057\u3066\u9001\u4fe1\u3059\u308c\u3070OK\u3067\u3059\u3002\u4e0b\u306e\u3088\u3046\u306a\u59ff\u306b\u306a\u308b\u306e\u3067 Vue\u3067\u3042\u308c\u3070 v-for\u306a\u3069\u304c\u5229\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/qol-kk.com\/wp2\/wp-content\/uploads\/2021\/03\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"2790\" data-permalink=\"https:\/\/qol-kk.com\/wp2\/blog\/2021\/03\/30\/post-2786\/image-29\/\" data-orig-file=\"https:\/\/qol-kk.com\/wp2\/wp-content\/uploads\/2021\/03\/image-1.png\" data-orig-size=\"1142,348\" data-comments-opened=\"1\" data-image-title=\"list_api\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/qol-kk.com\/wp2\/wp-content\/uploads\/2021\/03\/image-1-1024x312.png\" class=\"alignnone size-medium wp-image-2790\" src=\"https:\/\/qol-kk.com\/wp2\/wp-content\/uploads\/2021\/03\/image-1-300x91.png\" alt=\"\" width=\"300\" height=\"91\" srcset=\"https:\/\/qol-kk.com\/wp2\/wp-content\/uploads\/2021\/03\/image-1-300x91.png 300w, https:\/\/qol-kk.com\/wp2\/wp-content\/uploads\/2021\/03\/image-1-1024x312.png 1024w, https:\/\/qol-kk.com\/wp2\/wp-content\/uploads\/2021\/03\/image-1-768x234.png 768w, https:\/\/qol-kk.com\/wp2\/wp-content\/uploads\/2021\/03\/image-1.png 1142w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u4eca\u56de\u306e\u4ef6\u3067\u8272\u3005\u3068\u30c6\u30b9\u30c8\u3057\u3066\u307f\u307e\u3057\u305f\u304c\u3001json.dumps\u3092\u884c\u3046\u3068\u30ea\u30b9\u30c8\u3084DataFrame\u306e\u5148\u982d\/\u672b\u5c3e\u306b\u3010\u201d\u3011\u304c\u5165\u308a\u5927\u304d\u306a\u6587\u5b57\u5217\u3068\u5316\u3057\u3066\u3057\u307e\u3046\u3088\u3046\u3067\u3059\u3002\u3046\uff5e\u3093\u3001\u3053\u308c\u306f\u74b0\u5883\u5dee\u306a\u306e\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n<p>FrontEnd\u3067\u5c55\u958b\u3059\u308b\u5024\u3092BackEnd\u304b\u3089API\u3067\u9001\u4fe1\u3059\u308b\u69cb\u9020\u3092\u4f5c\u308a\u305f\u3044\u8a33\u306a\u306e\u3067\u3001API\u3067Key\u53d6\u5f97\u3067\u304d\u308b\u74b0\u5883\u3067\u30c7\u30fc\u30bf\u3092\u6e21\u305b\u308c\u3070\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002\u305d\u3093\u306a\u6642\u306f\u914d\u5217\u3092\u683c\u7d0d\u3057\u3066return Response \u3067\u6e21\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n<pre>works = []\r\nd1 = [1,'test_title01','test_image01']\r\nd2 = [12,'test_title02','test_image02']\r\n\r\nworks.append(d1)\r\nworks.append(d2)\r\n\r\nparams = {\r\n    'WorkList': works\r\n}\r\nreturn Response(params)<\/pre>\n<h3>\u307e\u3068\u3081<\/h3>\n<p>\u306a\u3093\u304b\u3053\u306e\u8fba\u306e\u60c5\u5831\u3063\u3066Google\u5148\u751f\u306e\u62bd\u51fa\u3059\u308b\u56de\u7b54\u3082\u8ff7\u8d70\u3057\u3066\u3044\u308b\u3088\u3046\u3067\u3059\u3002<br \/>\n\u4f8b\u3048\u3070\u3001JSON\u5316\u306e\u76ee\u7684\u304c\u30b0\u30e9\u30d5\u306a\u306e\u3067\u3042\u308c\u3070Json.dumps\u3057\u305f\u4e0b\u306e\u59ff\u3067\u3082\u5c55\u958b\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"prettyprint\"><span class=\"pun\">{<\/span>\r\n    <span class=\"str\">\"WorkList\"<\/span><span class=\"pun\">:<\/span> <span class=\"str\">\"[[1, \\\"test_title01\\\", \\\"test_image01\\\"], [12, \\\"test_title02\\\", \\\"test_image02\\\"]]\"<\/span>\r\n<span class=\"pun\">}<\/span><\/pre>\n<p>\u3064\u307e\u308a\u3001\u3053\u306e\u59ff\u3067\u56f0\u308b\u306e\u306f\u591a\u304f\u306e\u5834\u5408\u3067WEB\u5074\u3067\u306e\u8868\u793a\u306b\u306a\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u3002<br \/>\n\u3067\u3082\u306d\u3001Google\u5148\u751f\u305d\u3053\u3089\u8fba\u306e\u60c5\u5831\u3092\u3042\u307e\u308a\u51fa\u3057\u3066\u304f\u308c\u306a\u3044\u3093\u3067\u3059\u3088\u306d\u3002<\/p>\n<p>\u60c5\u5831\u3068\u3057\u3066\u306f\u3001Replace\u3067\u5f37\u5f15\u306b\u3010<span class=\"str\"> \\\"test_title01\\\"<\/span>\u3011\u3092\u3010<span class=\"str\"> \"test_title01\"<\/span>\u3011\u306b\u5909\u63db\u3057\u3066\u5148\u982d\u3068\u672b\u5c3e\u306e\u3010\u201d\u3011\u3092\u524a\u9664\u3057\u3088\u3046\u3068\u3044\u3046\u3082\u306e\u307e\u3067\u3042\u308a\u307e\u3057\u305f\u304c\u3001\u305d\u308c\u306f\u591a\u5206\u3067\u304d\u305f\u3068\u3057\u3066\u3082\u6b63\u3057\u3044\u56de\u7b54\u3067\u306f\u306a\u3044\u3088\u3046\u306a\u6c17\u304c\u3057\u307e\u3059\u3002<br \/>\n\u79c1\u306e\u69d8\u306b\u51fa\u4f1a\u3063\u305f\u60c5\u5831\u3092\u5148\u982d\u304b\u3089\u9806\u306b\u5b9f\u9a13\u3057\u3066\u3044\u304f\u3068\u591a\u304f\u306e\u6642\u9593\u3092\u6d88\u8cbb\u3057\u3066\u3057\u307e\u3044\u307e\u3059\u3002<br \/>\n\u76ee\u7684\u304cWEB\u5074\u3067\u306e\u8868\u793a\u3067\u3042\u308c\u3070\u30ea\u30b9\u30c8\u5316\u3057\u3066\u6e21\u3059\u306e\u304c\u4e00\u756a\u7c21\u5358\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Django\uff1aQuerySet\u306eJSON\u5909\u63db\u3067\u5927\u30cf\u30de\u30ea\u3057\u305f\u4ef6 \u89e3\u6c7a\u3057\u305f\u5f62\u306f\u4e00\u756a\u30b7\u30f3\u30d7\u30eb\u3060\u3063\u305f\u3068\u3044\u3046\u30aa\u30c1\u304c\u4ed8\u3044\u305f\u4eca\u56de\u306e\u30c9\u306f\u307e\u308a\u4e8b\u4ef6\u3002 \u30ad\u30ab\u30c3\u30b1\u306fFront\u3068Back\u306b\u5206\u3051\u305fDjango\u69cb\u7bc9\u3067\u306eBack\u5074\u306eAPI\u51fa\u529b\u3067\u3059\u3002  [&hellip;]<\/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":"","_lightning_design_setting":[],"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_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":[64,979,814,980,365,147,967,966,97,53],"class_list":["post-2786","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-python-memorandum","tag-api","tag-backend","tag-django","tag-frontend","tag-javascript","tag-python","tag-spa","tag-vue-js","tag-97","tag-53"],"veu_head_title_object":{"title":"","add_site_title":""},"jetpack_publicize_connections":[],"jetpack-related-posts":[],"jetpack_sharing_enabled":false,"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\/2786","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=2786"}],"version-history":[{"count":0,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/posts\/2786\/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=2786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/categories?post=2786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/tags?post=2786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}