{"id":48,"date":"2016-10-02T01:53:14","date_gmt":"2016-10-01T16:53:14","guid":{"rendered":"http:\/\/testengine.co.jp\/engine\/?p=48"},"modified":"2016-10-02T20:15:08","modified_gmt":"2016-10-02T11:15:08","slug":"scriptbuilder-awk-%e5%a4%a7%e9%87%8f%e3%83%86%e3%82%b9%e3%83%88%e3%83%87%e3%83%bc%e3%82%bf%e7%94%9f%e6%88%90","status":"publish","type":"post","link":"https:\/\/testengine.co.jp\/engine\/2016\/10\/02\/scriptbuilder-awk-%e5%a4%a7%e9%87%8f%e3%83%86%e3%82%b9%e3%83%88%e3%83%87%e3%83%bc%e3%82%bf%e7%94%9f%e6%88%90\/","title":{"rendered":"scriptbuilder.awk \u5927\u91cf\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u751f\u6210"},"content":{"rendered":"<div id=\"dslc-theme-content\"><div id=\"dslc-theme-content-inner\"><p><strong>ScriptBuilder<\/strong><br \/>\n\u4f7f\u3044\u65b9\u3000redis\u3078\u306e\u66f8\u8fbc\u307f\u3092\u5927\u91cf\u306b\u751f\u6210\u3057\u305f\u3044\u3001SQL\u306einset\u6587\u3092\u5927\u91cf\u306b\u751f\u6210\u3057\u305f\u3044\u3068\u304d\u306a\u3069\u306b<br \/>\nScriptBuilder\u306b\u751f\u6210\u5143\u3068\u306a\u308b\u300c\u5143\u30cd\u30bf\u300d\u3092\u4e0e\u3048\u3001\u5927\u91cf\u306escript\u3092\u751f\u6210\u3057\u307e\u3059\u3002<br \/>\nredis\u3078\u306e\u66f8\u8fbc\u307f\u30b3\u30de\u30f3\u30c9\u5927\u91cf\u767a\u884c\u30b5\u30f3\u30d7\u30eb\u3001database\u3078\u306einset\u6587\u306e\u5927\u91cf\u767a\u884c\u306f\u3001\u5f8c\u65e5\u516c\u958b\u3057\u307e\u3059\u3002<\/p>\n<p><strong>\u4f8b\uff09loop.csv\u306e\u5143\u30cd\u30bf4\u884c\u304b\u3089\u300124\u884c\u751f\u6210\u3057\u3066\u6587\u5b57\u5217\u3092\u51fa\u529b\u3059\u308b<\/strong><br \/>\n<strong>awk -f scriptbuilder.awk loop.csv<\/strong><br \/>\n00001,1,111,222,333,444,555,666,777,888,999,000<br \/>\n00002,2,111,222,333,444,555,666,777,888,999,000<br \/>\n00003,1,111,222,333,444,555,666,777,888,999,000<br \/>\n00004,2,111,222,333,444,555,666,777,888,999,000<br \/>\n00005,1,111,222,333,444,555,666,777,888,999,000<br \/>\n00006,2,111,222,333,444,555,666,777,888,999,000<br \/>\n00007,1,111,222,333,444,555,666,777,888,999,000<br \/>\n00008,2,111,222,333,444,555,666,777,888,999,000<br \/>\n00009,1,111,222,333,444,555,666,777,888,999,000<br \/>\n00010,2,111,222,333,444,555,666,777,888,999,000<br \/>\n00011,1,111,222,333,444,555,666,777,888,999,000<br \/>\n00012,2,111,222,333,444,555,666,777,888,999,000<br \/>\n00013,1,111,222,333,444,555,666,777,888,999,000<br \/>\n00014,2,111,222,333,444,555,666,777,888,999,000<br \/>\n00015,1,111,222,333,444,555,666,777,888,999,000<br \/>\n00016,2,111,222,333,444,555,666,777,888,999,000<br \/>\n00017,1,111,222,333,444,555,666,777,888,999,000<br \/>\n00018,2,111,222,333,444,555,666,777,888,999,000<br \/>\n00019,1,111,222,333,444,555,666,777,888,999,000<br \/>\n00020,2,111,222,333,444,555,666,777,888,999,000<br \/>\n0021,3,111,222,333,444,555,666,777,888,999,000<br \/>\n0022,3,111,222,333,444,555,666,777,888,999,000<br \/>\n4,111,222,333,023444,555,666,777,888,999,000<br \/>\n24[#55555555555555555555555555555555555555555]<\/p>\n<p><strong>loop.csv\u306e\u4e2d\u8eab \u4e88\u7d04\u8a9e\u306f[]\u3067\u56f2\u3093\u3067\u6307\u5b9a\u3059\u308b<\/strong><br \/>\n[sleep 1]<br \/>\n[loop 10]<br \/>\n[lineNum05],1,111,222,333,444,555,666,777,888,999,000<br \/>\n[lineNum05],2,111,222,333,444,555,666,777,888,999,000<br \/>\n[sleep 0.0001]<br \/>\n[loopEnd]<br \/>\n[loop 2]<br \/>\n[lineNum04],3,111,222,333,444,555,666,777,888,999,000<br \/>\n[sleep 0.5]<br \/>\n[loopEnd]<br \/>\n[sleep 1.0]<br \/>\n4,111,222,333,[lineNum03]444,555,666,777,888,999,000<br \/>\n[lineNum][#55555555555555555555555555555555555555555]<\/p>\n<p>\u8aac\u660e<br \/>\n# 0.sleep\u30921\u79d2\u3059\u308b<br \/>\n<strong>[sleep 1]<\/strong><\/p>\n<p># 1.loop\u51e6\u7406\u3092\u958b\u59cb\u3059\u308b<br \/>\n# \u3053\u306e\u4f8b\u3067\u306f10\u56de\u7e70\u308a\u8fd4\u3057\u3059\u308b\u3053\u3068\u306e\u958b\u59cb\u306e\u5ba3\u8a00<br \/>\n<strong>[loop 10]<\/strong><br \/>\n# 2.script\u751f\u6210\u306e\u5143\u30cd\u30bf1\u884c\u76ee\u3092\u4e0e\u3048\u51fa\u529b\u3059\u308b<br \/>\n# [lineNum05]\u306f\u884c\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3059\u308b\u969b\u306b\u6307\u5b9a\u3059\u308b<br \/>\n# 05\u306e\u610f\u5473\u306fprintf()\u6587\u306e\u66f8\u5f0f\u6587\u5b57\u5217[%05d]\u306e05\u3068\u540c\u3058\u610f\u5473<br \/>\n<strong>[lineNum05],1,111,222,333,444,555,666,777,888,999,000<\/strong><br \/>\n# 3.script\u751f\u6210\u306e\u5143\u30cd\u30bf2\u884c\u76ee\u3092\u4e0e\u3048\u51fa\u529b\u3059\u308b<br \/>\n# [lineNum05]\u306f\u884c\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3059\u308b\u969b\u306b\u6307\u5b9a\u3059\u308b<br \/>\n# 05\u306e\u610f\u5473\u306fprintf()\u6587\u306e\u66f8\u5f0f\u6587\u5b57\u5217[%05d]\u306e05\u3068\u540c\u3058\u610f\u5473<br \/>\n<strong>[lineNum05],2,111,222,333,444,555,666,777,888,999,000<\/strong><br \/>\n# 4.sleep\u30920.0001\u79d2(0.1\u30df\u30ea\u79d2)\u3059\u308b<br \/>\n# loop\u51e6\u7406\u3092\u3059\u308b\u969b\u306bcpu\u3092\u5360\u6709\u3057\u306a\u3044\u3088\u3046\u306b\u3059\u308b<br \/>\n# \u3053\u306eScriptBuilder\u3092multi process\u3067\u52d5\u4f5c\u3059\u308b\u3068\u304d\u306e\u305f\u3081\u306e\u5bfe\u5fdc\u7b56<br \/>\n<strong>[sleep 0.0001]<\/strong><br \/>\n# 5.loop\u51e6\u7406\u306e\u7d42\u4e86 loop\u3092n\u56de\u3001loopEnd\u307e\u3067\u7e70\u308a\u8fd4\u3059<br \/>\n# \u3053\u306e\u4f8b\u3067\u306f\u30012.\u304b\u30894.\u307e\u3067\u309210\u56de\u7e70\u308a\u8fd4\u3059<br \/>\n<strong>[loopEnd]<\/strong><\/p>\n<p># 6.2\u56de\u76ee\u306eloop\u51e6\u7406\u958b\u59cb<br \/>\n# \u3053\u306e\u4f8b\u3067\u306f2\u56de\u7e70\u308a\u8fd4\u3057\u3059\u308b\u3053\u3068\u306e\u958b\u59cb\u306e\u5ba3\u8a00<br \/>\n<strong>[loop 2]<\/strong><br \/>\n# 7.script\u751f\u6210\u306e\u5143\u30cd\u30bf3\u884c\u76ee\u3092\u4e0e\u3048\u51fa\u529b\u3059\u308b<br \/>\n3,111,222,333,444,555,666,777,888,999,000<br \/>\n# 8.sleep\u30920.5\u79d2\u3059\u308b<br \/>\n<strong>[sleep 0.5]<\/strong><br \/>\n# 9.loop\u51e6\u7406\u306e\u7d42\u4e86 loop\u3092n\u56de\u3001loopEnd\u307e\u3067\u7e70\u308a\u8fd4\u3059<br \/>\n# \u3053\u306e\u4f8b\u3067\u306f\u30017.\u304b\u30898.\u307e\u3067\u309210\u56de\u7e70\u308a\u8fd4\u3059<br \/>\n<strong>[loopEnd]<\/strong><br \/>\n# 10.sleep\u30921\u79d2\u3059\u308b(\u5c0f\u6570\u70b9\u4ed8\u304d\u3067\u6307\u5b9a\u3057\u3066\u3082\u826f\u3044)<br \/>\n<strong>[sleep 1.0]<\/strong><\/p>\n<p># 11.script\u751f\u6210\u306e\u5143\u30cd\u30bf4\u884c\u76ee\u3092\u4e0e\u3048\u51fa\u529b\u3059\u308b<br \/>\n# [lineNum03]\u306f\u884c\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3059\u308b\u969b\u306b\u6307\u5b9a\u3059\u308b<br \/>\n# 03\u306e\u610f\u5473\u306fprintf()\u6587\u306e\u66f8\u5f0f\u6587\u5b57\u5217[%03d]\u306e03\u3068\u540c\u3058\u610f\u5473<br \/>\n# script\u6587\u4e2d\u3067\u884c\u6570\u3092\u4f7f\u7528\u3057\u305f\u3044\u5834\u5408\uff08\u30e6\u30cb\u30fc\u30af\u306a\u30b7\u30fc\u30b1\u30f3\u30b9\u756a\u53f7\u306a\u3069\uff09\u884c\u4e2d\u3067\u6307\u5b9a\u3057\u3001\u6587\u5b57\u5217\u9023\u7d50\u3059\u308b<br \/>\n<strong>4,111,222,333,[lineNum03]444,555,666,777,888,999,000<\/strong><\/p>\n<p># 12.script\u751f\u6210\u306e\u5143\u30cd\u30bf5\u884c\u76ee\u3092\u4e0e\u3048\u51fa\u529b\u3059\u308b<br \/>\n# [lineNum]\u306f\u6574\u5f62\u305b\u305a\u306b\u884c\u756a\u53f7\u3092\u305d\u306e\u307e\u307e\u51fa\u529b\u3059\u308b<br \/>\n# []\u5185\u306b\u4e88\u7d04\u8a9e\u304c\u306a\u3044\u5834\u5408\u306f\u3001\u305d\u306e\u307e\u307e\u51fa\u529b\u3059\u308b<br \/>\n<strong>[lineNum][#55555555555555555555555555555555555555555]<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><script src=\"https:\/\/gist.github.com\/TsutomuWakamatsu\/1e19bc4968377aa04a218e4bc890b736.js\"><\/script><\/p>\n<p><span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe loading=\"lazy\" class=\"youtube-player\" width=\"1170\" height=\"659\" src=\"https:\/\/www.youtube.com\/embed\/PzwguQWnd2Y?version=3&#038;rel=1&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=ja&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span><\/p>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>ScriptBuilder \u4f7f\u3044\u65b9\u3000redis\u3078\u306e\u66f8\u8fbc\u307f\u3092\u5927 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[3,12,15,13,11,14,16],"class_list":["post-48","post","type-post","status-publish","format-standard","hentry","category-4","tag-awk","tag-builder","tag-insert","tag-reds","tag-script","tag-sql","tag-16","clearfix"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7t6nl-M","jetpack-related-posts":[{"id":57,"url":"https:\/\/testengine.co.jp\/engine\/2016\/10\/11\/redis-%e5%a4%a7%e9%87%8f%e6%9b%b8%e8%be%bc%e3%81%bf%e3%83%87%e3%83%bc%e3%82%bf%e7%94%9f%e6%88%90\/","url_meta":{"origin":48,"position":0},"title":"redis \u5927\u91cf\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u30c7\u30fc\u30bf\u751f\u6210","author":"\u52aa\u82e5\u677e","date":"2016\u5e7410\u670811\u65e5","format":false,"excerpt":"redis \u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u30b5\u30f3\u30d7\u30eb \u4f7f\u3044\u65b9 awk\u3092\u4f7f\u7528\u3057\u3066\u3001redis\u3078\u306e\u5927\u91cfset\u3092\u5b9f\u884c\u3059\u308b\u30b5\u30f3\u30d7\u2026","rel":"","context":"\u6280\u8853\u306e\u5c0f\u90e8\u5c4b","block_context":{"text":"\u6280\u8853\u306e\u5c0f\u90e8\u5c4b","link":"https:\/\/testengine.co.jp\/engine\/category\/%e6%8a%80%e8%a1%93%e3%81%ae%e5%b0%8f%e9%83%a8%e5%b1%8b\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/posts\/48","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/comments?post=48"}],"version-history":[{"count":7,"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/posts\/48\/revisions"}],"predecessor-version":[{"id":55,"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/posts\/48\/revisions\/55"}],"wp:attachment":[{"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/media?parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/categories?post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/testengine.co.jp\/engine\/wp-json\/wp\/v2\/tags?post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}