{"id":2078,"date":"2022-04-26T11:47:49","date_gmt":"2022-04-26T02:47:49","guid":{"rendered":"https:\/\/blog.wsd.sh\/?p=2078"},"modified":"2022-04-26T12:21:52","modified_gmt":"2022-04-26T03:21:52","slug":"nodejs-select%e3%81%97%e3%81%9f%e3%83%87%e3%83%bc%e3%82%bf%e3%81%8cnull%e3%81%ae%e9%85%8d%e5%88%97%e3%81%ae%e8%a6%81%e7%b4%a0%e3%82%92%e9%99%a4%e3%81%84%e3%81%a6%e3%80%81list%e3%82%92%e4%bd%9c","status":"publish","type":"post","link":"https:\/\/blog.wsd.sh\/?p=2078","title":{"rendered":"<small>nodejs: select\u3057\u305f\u30c7\u30fc\u30bf\u304cnull\u306e\u914d\u5217\u306e\u8981\u7d20\u3092\u9664\u3044\u3066\u3001\u914d\u5217\u3092\u4f5c\u6210<\/small>"},"content":{"rendered":"<p>\uff11\uff0e\u914d\u5217\u306e\u5404\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067copy<br \/>\nrows[i]\u3000-> rt[j]<\/p>\n<pre>\r\nrt[j] = { ...rows[i] };\r\n<\/pre>\n<p>\uff12\uff0e\u524d\u63d0<br \/>\n\u30fblet rows = [{&#8220;uuid&#8221;:&#8221;1111&#8243;},{&#8220;uuid&#8221;:&#8221;2222&#8243;},{&#8220;uuid&#8221;:&#8221;3333&#8243;}];<\/p>\n<p>\u30fbdb.selectOne\u306f\u6700\u521d\u306erow\u3092\uff11\u3064\u306e\u307f\u8fd4\u3059<\/p>\n<p>\uff13\uff0e\u4f8b<br \/>\nselect\u3057\u305f\u30c7\u30fc\u30bf\u304cnull\u306e\u914d\u5217\u3092\u524a\u9664\u3057\u3066\u3001list\u3092\u4f5c\u6210<\/p>\n<pre>\r\n    let rt = [];\r\n\r\n    for(let i = 0, j = 0; i < rows.length; i++) {\r\n        args = [rows[i].uuid];\r\n\r\n        try {\r\n            rows[i] = await db.selectOne(sql, args);\r\n        } catch(err) {\r\n            continue;\r\n        }\r\n        if(rows[i] ==  null) {\r\n            continue;\r\n        }\r\n        rt[j] = { ...rows[i] };\r\n        j++;\r\n    }\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uff11\uff0e\u914d\u5217\u306e\u5404\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067copy rows[i]\u3000-> rt[j] rt[j] = { &#8230;rows[i] }; \uff12\uff0e\u524d\u63d0 \u30fblet rows = [{&#8220;uuid&#8221;:&#8221;1111&#038;#&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/2078"}],"collection":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2078"}],"version-history":[{"count":5,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/2078\/revisions"}],"predecessor-version":[{"id":2094,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/2078\/revisions\/2094"}],"wp:attachment":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}