{"id":1657,"date":"2023-04-03T12:10:00","date_gmt":"2023-04-03T03:10:00","guid":{"rendered":"https:\/\/comcent.co.jp\/blog\/?p=1657"},"modified":"2023-03-27T12:26:08","modified_gmt":"2023-03-27T03:26:08","slug":"%e3%80%90codeigniter4%e3%80%91db%e3%83%9e%e3%82%a4%e3%82%b0%e3%83%ac%e3%83%bc%e3%82%b7%e3%83%a7%e3%83%b3%e3%81%ae%e5%b0%8e%e5%85%a5","status":"publish","type":"post","link":"https:\/\/comcent.co.jp\/blog\/archives\/1657\/","title":{"rendered":"\u3010CodeIgniter4\u3011DB\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u5c0e\u5165"},"content":{"rendered":"\n

CodeIgniter4\uff08\u4ee5\u964dCI4\uff09\u3067\u306e\u958b\u767a\u304c\u4e3b\u306b\u306a\u308a\u3001\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3044\u59cb\u3081\u307e\u3057\u305f\u3002
\u77e5\u3063\u3066\u3044\u308b\u3068\u3088\u3044\u77e5\u8b58\u3084\u958b\u767a\u3067\u306f\u3053\u3046\u3059\u308c\u3070\u3044\u3044\u306e\u3067\u306f\u3068\u3044\u3046\u7d4c\u9a13\u3092\u7d39\u4ecb\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3068\u306f\uff1f<\/h4>\n\n\n\n

\u4e00\u9023\u756a\u53f7or\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u306e\u3064\u3044\u305f\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u306b\u30c6\u30fc\u30d6\u30eb\u3084\u305d\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u306b\u4e0e\u3048\u308b\u5909\u66f4\u3084\u69cb\u9020\u3092\u8a18\u8ff0\u3057\u3066\u7ba1\u7406\u3057\u3066\u3044\u304f\u6a5f\u80fd\u3067\u3059\u3002
ex.\u30d5\u30a1\u30a4\u30eb\u540d\u306e\u4f8b
2022-11-30-042007_CreateUsersMigration
2022-11-30-023519_UpdateUsersMigration
2022-12-01-030606_UpdateUsersMigration
\u30e1\u30ea\u30c3\u30c8\u3068\u3057\u3066\u306f\u3001\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u5909\u66f4\u304c\u898b\u3048\u308b\u306e\u3067\u4ed6\u306e\u958b\u767a\u8005\u304c\u52a0\u3048\u305f\u5909\u66f4\u304c\u5206\u304b\u308a\u3084\u3059\u3044<\/strong>\u3053\u3068\u3084\u5225DB\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u306b\u30b3\u30de\u30f3\u30c9\u3067\u3059\u3050\u306b\u6700\u65b0\u306e\u72b6\u614b\u306b\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b<\/strong>\u306a\u3069\u304c\u3042\u308a\u307e\u3059\u3002
\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u306b\u306f\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u306e\u3088\u3046\u306aup\u30e1\u30bd\u30c3\u30c9\u3068down\u30e1\u30bd\u30c3\u30c9\u304c\u5b58\u5728\u3057\u3001\u305d\u308c\u305e\u308c\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u51e6\u7406\u3068\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u51e6\u7406\u3092\u66f8\u3044\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\/\/\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u51e6\u7406\npublic function up(){\n}\n\/\/\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u51e6\u7406\npublic function down(){\n}<\/span><\/code><\/pre>\n\n\n\n
\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u3066\u307f\u308b<\/h4>\n\n\n\n
spark\u30b3\u30de\u30f3\u30c9<\/h4>\n\n\n\n
CI4\u304b\u3089\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u3067\u5229\u7528\u3067\u304d\u308bspark\u30b3\u30de\u30f3\u30c9\u304c\u5c0e\u5165\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n
> php spark \u30b3\u30de\u30f3\u30c9\u540d<\/span><\/code><\/pre>\n\n\n\n
php spark list\u3067\u4f7f\u7528\u53ef\u80fd\u306a\u30b3\u30de\u30f3\u30c9\u4e00\u89a7\u3092\u8868\u793a\u3067\u304d\u307e\u3059\u3002
spark\u306fapp\u306a\u3069\u304c\u3042\u308b\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u30eb\u30fc\u30c8\u306b\u3042\u308a\u307e\u3059\u306e\u3067\u3001\u305d\u3053\u3067\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u5185\u306b\u3082\u3042\u308a\u307e\u3059\u304c\u3001\u308f\u3056\u308f\u3056\u6df1\u3044\u968e\u5c64\u307e\u3067\u884c\u304f\u5fc5\u8981\u306f\u306a\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n\n\n\n
\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u4f5c\u6210<\/h4>\n\n\n\n
\/\/\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\n> php spark make:migration \u30d5\u30a1\u30a4\u30eb\u540d<\/span><\/code><\/pre>\n\n\n\n
ex.\u30d5\u30a1\u30a4\u30eb\u306e\u547d\u540d\u4f8b
CreateUsersMigration(\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\u6642)
UpdateUsersMigration(\u30c6\u30fc\u30d6\u30eb\u5909\u66f4\u6642)
app\/Database\/Migrations\u5185\u306b\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u304c\u4f5c\u6210\u3055\u308c\u305f\u3068\u601d\u3046\u306e\u3067\u78ba\u8a8d\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n
\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u5b9f\u884c<\/h4>\n\n\n\n
\/\/\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\uff08\u6700\u65b0\uff09\n> php spark migrate<\/span><\/code><\/pre>\n\n\n\n
\u6210\u529f\u3059\u308b\u3068migration\u7528\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u6210\u3055\u308c\u5909\u66f4\u60c5\u5831\u306e\u5165\u3063\u305f\u30ec\u30b3\u30fc\u30c9\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n
migrate\u30b3\u30de\u30f3\u30c9\u7d39\u4ecb<\/h4>\n\n\n\n
\/\/\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u30ed\u30fc\u30eb\u30d0\u30c3\u30af(\u4e00\u3064\u524d)\n> php spark migrate:rollback\n\/\/\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u30ed\u30fc\u30eb\u30d0\u30c3\u30af(\u30d0\u30c3\u30c13\u3078\u30ed\u30fc\u30eb\u30d0\u30c3\u30af)\n> php spark migrate:rollback -b 3\n\/\/\u3059\u3079\u3066\u46fe\u79fb\u884c\u3092\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u3057\u3066\u304b\u3089\u6700\u65b0\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u79fb\u884c\n> php spark migrate:refresh\n<\/span><\/code><\/pre>\n\n\n\n
\u30c1\u30fc\u30e0\u3067\u884c\u3046\u3068\u304d\u306e\u6ce8\u610f\u70b9<\/h4>\n\n\n\n
\u30fb\u7279\u306b\u672c\u756a\u74b0\u5883\u306a\u3069\u3001\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u306b\u9650\u308a\u307e\u305b\u3093\u304c\u3001DB\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/strong>\u3092\u3068\u308b\u3002
\u30fb\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u306e\u8ffd\u52a0\u3068\u5909\u66f4\u306f\u3053\u307e\u3081\u306b\u9023\u7d61\u3057\u3042\u3046\u3068\u3044\u3044\u3067\u3059\u3002
\u5b9f\u969b\u306b\u5171\u6709\u3057\u305f\u65b9\u304c\u3088\u3044\u70b9\u3092\u6319\u3052\u308b\u3068\u3001
\u30fb\u3069\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u8ffd\u52a0\u3057\u305f\u304b<\/strong>
\u30fb\u540c\u3058DB\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u306fDB\u3078\u306e\u53cd\u6620\u3092\u3057\u305f\u306e\u304b<\/strong>
\u30fbGit\u306b\u306f\u4e0a\u304c\u3063\u3066\u3044\u308b\u306e\u304b<\/strong>
\u306a\u3069\u306f\u9023\u7d61\u3092\u3059\u308b\u3068\u826f\u3044\u3067\u3059\u3002<\/p>\n\n\n\n
\u30b7\u30fc\u30c7\u30a3\u30f3\u30b0\u306b\u3064\u3044\u3066<\/h4>\n\n\n\n
\u30b7\u30fc\u30c7\u30a3\u30f3\u30b0\u3068\u306f\uff1f<\/h4>\n\n\n\n
Seeding\uff08\u30b7\u30fc\u30c7\u30a3\u30f3\u30b0\uff09\u3068\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb\u306bSeeder\u30d5\u30a1\u30a4\u30eb\u3092\u4f7f\u7528\u3057\u3066\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3059\u308b<\/strong>\u3053\u3068\u3067\u3059\u3002
\u4f7f\u3044\u3069\u3053\u308d\u3068\u3057\u3066\u306f\u3001
\u30fb\u78ba\u5b9f\u306b\u767b\u9332\u304c\u3055\u308c\u308b\u3067\u3042\u308d\u3046\u30ec\u30b3\u30fc\u30c9
\u30fb\u30c6\u30b9\u30c8\u3057\u305f\u3044\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf
\u306a\u3069\u3092\u6295\u5165\u3059\u308b\u3068\u304d\u306b\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
\u4f5c\u6210\u3068\u5b9f\u884c<\/h4>\n\n\n\n
\/\/Seeder\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\n> php spark make:seeder \u30d5\u30a1\u30a4\u30eb\u540d<\/span><\/code><\/pre>\n\n\n\n
\u6210\u529f\u3059\u308b\u3068app\/Database\/Seeds\u5185\u306bSeeder\u30d5\u30a1\u30a4\u30eb\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002
Seeder\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u306b\u306f\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u306e\u3088\u3046\u306arun\u30e1\u30bd\u30c3\u30c9\u304c\u5b58\u5728\u3057\u3001\u767b\u9332\u3057\u305f\u30ec\u30b3\u30fc\u30c9\u3092\u66f8\u3044\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n
public function run()\n  {\n    $data = [\n      ['id' => 1, 'title' => '\u30bf\u30a4\u30c8\u30ebA', 'content' => '\u5185\u5bb9A'],\n      ['id' => 2, 'title' => '\u30bf\u30a4\u30c8\u30ebB', 'content' => '\u5185\u5bb9B'],\n      ['id' => 3, 'title' => '\u30bf\u30a4\u30c8\u30ebC', 'content' => '\u5185\u5bb9C']\n    ];\n    $this->db->table('table')->insertBatch($data);\n\n  }<\/span><\/code><\/pre>\n\n\n\n
\u8a18\u8ff0\u51fa\u6765\u305f\u3089\u3001\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\/\/Seeder\u3092\u5b9f\u884c\n> php spark db:seed \u30d5\u30a1\u30a4\u30eb\u540d<\/span><\/code><\/pre>\n\n\n\n
\u307e\u3068\u3081<\/h4>\n\n\n\n
\u4eca\u56de\u306fCI4\u3067\u884c\u3046DB\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u306b\u3064\u3044\u3066\u66f8\u304b\u305b\u3066\u3044\u305f\u3060\u304d\u307e\u3057\u305f\u3002
\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u306e\u6a5f\u80fd\u3092\u7406\u89e3\u3057\u3066\u4f7f\u3044\u3053\u306a\u305b\u308b\u3068\u4f5c\u696d\u304c\u52b9\u7387\u7684\u306b\u9032\u3080\u3068\u601d\u3044\u307e\u3059\u3002
\u4ee5\u4e0a\u306b\u306a\u308a\u307e\u3059\u3002
\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
CodeIgniter4\uff08\u4ee5\u964dCI4\uff09\u3067\u306e\u958b\u767a\u304c\u4e3b\u306b\u306a\u308a\u3001\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3044\u59cb\u3081\u307e\u3057\u305f\u3002\u77e5\u3063\u3066\u3044\u308b\u3068\u3088\u3044\u77e5\u8b58\u3084\u958b\u767a\u3067\u306f\u3053\u3046\u3059\u308c\u3070\u3044\u3044\u306e\u3067\u306f\u3068\u3044\u3046\u7d4c\u9a13\u3092\u7d39\u4ecb\u3057\u3066\u3044\u304d\u307e\u3059\u3002 \u4e00\u9023\u756a\u53f7or\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u306e\u3064\u3044\u305f\u30de\u30a4\u30b0\u30ec\u30fc\u30b7 […]<\/p>\n","protected":false},"author":11,"featured_media":1685,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[88,35,97,98,96],"coauthors":[49],"class_list":["post-1657","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-backend","tag-codeigniter4","tag-php","tag-97","tag-98","tag-96"],"author_meta":{"nickname":"K.D","position":"\u30d7\u30ed\u30b0\u30e9\u30de\u30fc","icon_url":"https:\/\/comcent.co.jp\/blog\/images\/authorKd-150x150.png","author_url":"https:\/\/comcent.co.jp\/blog\/archives\/author\/kimura\/"},"tag_names":["CodeIgniter4","php","\u30b7\u30fc\u30c7\u30a3\u30f3\u30b0","\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9","\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3"],"thumbnail_url":"https:\/\/comcent.co.jp\/blog\/wp-content\/uploads\/2022\/11\/cimigration_eye-300x200.jpg","_links":{"self":[{"href":"https:\/\/comcent.co.jp\/blog\/wp-json\/wp\/v2\/posts\/1657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/comcent.co.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/comcent.co.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/comcent.co.jp\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/comcent.co.jp\/blog\/wp-json\/wp\/v2\/comments?post=1657"}],"version-history":[{"count":21,"href":"https:\/\/comcent.co.jp\/blog\/wp-json\/wp\/v2\/posts\/1657\/revisions"}],"predecessor-version":[{"id":1792,"href":"https:\/\/comcent.co.jp\/blog\/wp-json\/wp\/v2\/posts\/1657\/revisions\/1792"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/comcent.co.jp\/blog\/wp-json\/wp\/v2\/media\/1685"}],"wp:attachment":[{"href":"https:\/\/comcent.co.jp\/blog\/wp-json\/wp\/v2\/media?parent=1657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/comcent.co.jp\/blog\/wp-json\/wp\/v2\/categories?post=1657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/comcent.co.jp\/blog\/wp-json\/wp\/v2\/tags?post=1657"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/comcent.co.jp\/blog\/wp-json\/wp\/v2\/coauthors?post=1657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}