faker\u3092\u5229\u7528\u3057\u3066\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u306e\u30d0\u30eb\u30afINSERT\u6587\u3092\u751f\u6210\u3057\u3066\u307f\u305f\u306e\u3067\u3001\u30ed\u30b0\u3068\u3057\u3066\u6b8b\u3059\u3002
\u5b9f\u969b\u306bDB\u3078\u633f\u5165\u3067\u304d\u305f\u306e\u306f\u78ba\u8a8d\u3057\u305f\u3002
\u3053\u308c\u3092\u53c2\u8003\u306bfaker\u306e\u30e1\u30bd\u30c3\u30c9\u78ba\u8a8d\u3059\u308c\u3070\u8272\u3005\u306a\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u633f\u5165\u7528\u306eINSERT\u6587\u751f\u6210\u3067\u304d\u308b\u306f\u305a\u3002<\/p>\n\n\n\n
\n<?php\n\nrequire_once 'vendor\/autoload.php';\n\n\/**\n * \u6307\u5b9a\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u540d\u306b\u5bfe\u3059\u308b\u3001\n * \u6307\u5b9a\u3057\u305f\u5217\u540d\u3068\u5024\u306e\n * \u5b9f\u884c\u53ef\u80fd\u306a\u30d0\u30eb\u30afINSERT\u6587\u3092\u8fd4\u3059\u3002\n *\n * \u914d\u5217\u306f\u6b21\u306e\u5f62\u3092\u3068\u308b\u3002\n * \uff08flagString\u304ctrue\u306e\u5834\u5408\u3001INSERT\u6587\u3067\u306e\u5024\u306f\u30b7\u30f3\u30b0\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u3067\u56f2\u308f\u308c\u308b\u3002\n * false\u306a\u3089\u30b7\u30f3\u30b0\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u3067\u56f2\u308f\u308c\u306a\u3044\u3002\uff09\n * $values = [\n * '\u5217\u540d1' => [\n * 'flagString' => true,\n * 'values' => [\n * '\u50241', '\u50242',\n * ],\n * ],\n * '\u5217\u540d2' => [\n * 'flagString' => false,\n * 'values' => [\n * '\u50241', '\u50242',\n * ],\n * ],\n * ];\n *\n * @param string $tableName \u30c6\u30fc\u30d6\u30eb\u540d\n * @param array $values \u5217\u540d\u3068\u5024\u306e\u9023\u60f3\u914d\u5217\n * @return string|null \u5b9f\u884c\u53ef\u80fd\u306aINSERT\u6587 \u307e\u305f\u306f \u30a8\u30e9\u30fc\u6642\u306b\u306fnull\n *\/\nfunction getInsertQuery(string $tableName, array $values): string|null {\n \/**********************************************\n * \u5f15\u6570\u306e\u78ba\u8a8d\n **********************************************\/\n \/\/ \u30c6\u30fc\u30d6\u30eb\u540d\u304c\u7a7a\u3067\u306a\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3002\n if ($tableName === '') return null;\n\n \/\/ \u7a7a\u914d\u5217\u3067\u306a\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3002\n if (count($values) === 0) return null;\n\n \/\/ \u5024\u306e\u6570\u304c\u5168\u3066\u306e\u5217\u540d\u3067\u7b49\u3057\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3002\n $valueCount = count(array_values($values)[0]['values']);\n foreach($values as $key => $arrays) {\n if($valueCount !== count($arrays['values'])) return null;\n }\n\n \/**********************************************\n * INSERT\u6587\u306e\u5217\u540d\u307e\u3067\u751f\u6210\u3002\n **********************************************\/\n $strInsert = 'INSERT INTO ' . $tableName . ' ';\n\n # INSERT\u6587\u306e\u5217\u540d\u542b\u3080\u7b87\u6240\u307e\u3067\u4f5c\u6210\u3002\n $keys = array_keys($values);\n $strColumns = '(';\n foreach($keys as $key) {\n $strColumns .= ($key . ', ');\n }\n $strColumns = mb_substr($strColumns, 0, mb_strlen($strColumns) - 2);\n $strColumns .= ') ';\n $strInsert .= $strColumns;\n unset($strColumns);\n\n \/**********************************************\n * INSERT\u6587\u306e\u5024\u3092\u751f\u6210\u3002\n **********************************************\/\n $strValues = 'VALUES ';\n $strValuesElement = '';\n for ($i = 0; $i < $valueCount; $i++) {\n if ($i === 0) {\n $strValuesElement .= '(';\n } else {\n $strValuesElement .= ', (';\n }\n\n foreach ($values as $key => $arrays) {\n if ($arrays['flagString']) {\n $strValuesElement .= "'" . $arrays['values'][$i] . "'";\n $strValuesElement .= ', ';\n } else {\n $strValuesElement .= $arrays['values'][$i];\n $strValuesElement .= ', ';\n }\n }\n unset($key);\n unset($arrays);\n $strValuesElement = mb_substr($strValuesElement, 0, mb_strlen($strValuesElement) - 2);\n $strValuesElement .= ')';\n $strValues .= $strValuesElement;\n $strValuesElement = '';\n }\n $strValues .= ';';\n\n return $strInsert . $strValues;\n}\n\n$faker = Faker\\Factory::create('ja_JP');\n\n$temp = [\n 'family_name' => [\n 'flagString' => true,\n 'values' => [],\n ],\n 'personal_name' => [\n\/\/ 'flagString' => false,\n 'flagString' => true,\n 'values' => [],\n ],\n];\n\nfor ($i = 0; $i < 1000; $i++) {\n $temp['family_name']['values'][] = $faker->lastName();\n $temp['personal_name']['values'][] = $faker->firstName();\n}\n\n$result = getInsertQuery('test', $temp);\nprintf("%s", $result);\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"\u6982\u8981 faker\u3092\u5229\u7528\u3057\u3066\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u306e\u30d0\u30eb\u30afINSERT\u6587\u3092\u751f\u6210\u3057\u3066\u307f\u305f\u306e\u3067\u3001\u30ed\u30b0\u3068\u3057\u3066\u6b8b\u3059\u3002\u5b9f\u969b\u306bDB\u3078\u633f\u5165\u3067\u304d\u305f\u306e\u306f\u78ba\u8a8d\u3057\u305f\u3002\u3053\u308c\u3092\u53c2\u8003\u306bfaker\u306e\u30e1\u30bd\u30c3\u30c9\u78ba\u8a8d\u3059\u308c\u3070\u8272\u3005\u306a\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u633f\u5165\u7528\u306eINSERT\u6587\u751f\u6210\u3067 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[80],"tags":[81],"class_list":["post-1010","post","type-post","status-publish","format-standard","hentry","category-php","tag-php"],"_links":{"self":[{"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/posts\/1010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/shinke1987.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1010"}],"version-history":[{"count":5,"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/posts\/1010\/revisions"}],"predecessor-version":[{"id":1015,"href":"https:\/\/shinke1987.net\/index.php?rest_route=\/wp\/v2\/posts\/1010\/revisions\/1015"}],"wp:attachment":[{"href":"https:\/\/shinke1987.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shinke1987.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shinke1987.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}