{"id":3549,"date":"2020-07-10T10:16:51","date_gmt":"2020-07-10T01:16:51","guid":{"rendered":"https:\/\/taki-lab.site\/bocci\/?p=3549"},"modified":"2020-07-10T10:16:54","modified_gmt":"2020-07-10T01:16:54","slug":"%e3%80%90laravel%e3%80%91%e3%80%90%e3%83%80%e3%82%a4%e3%82%a8%e3%83%83%e3%83%88%e6%94%af%e6%8f%b4%e3%80%91%e9%a3%9f%e4%ba%8b%e7%ae%a1%e7%90%86%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9","status":"publish","type":"post","link":"https:\/\/taki-lab.site\/bocci\/?p=3549","title":{"rendered":"\u3010Laravel\u3011\u3010\u30c0\u30a4\u30a8\u30c3\u30c8\u652f\u63f4\u3011\u98df\u4e8b\u7ba1\u7406\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b"},"content":{"rendered":"\n

\u98df\u4e8b\u7ba1\u7406\u6a5f\u80fd\u306e\u4f5c\u6210\u306b\u7740\u624b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u307e\u305a\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u3002<\/p>\n\n\n\n

\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

$ php artisan make:migration create_eating_management<\/code><\/pre>\n\n\n\n
class CreateEatingManagement extends Migration\n{\n    \/**\n     * Run the migrations.\n     *\n     * @return void\n     *\/\n    public function up()\n    {\n        Schema::create('eating_managements', function (Blueprint $table) {\n            $table->increments('id');\n            $table->date('date');\n            $table->text('item');\n            $table->integer('protein');\n            $table->integer('ripid');\n            $table->integer('carbo');\n            $table->integer('calorie');\n            $table->timestamps();\n            $table->engine = 'InnoDB';\n            $table->charset = 'utf8mb4';\n            $table->collation = 'utf8mb4_unicode_ci';\n        });\n\n        Schema::create('eating_management_user', function (Blueprint $table) {\n            $table->integer('user_id')\n                  ->foreign('user_id')\n                  ->references('id')->on('users')\n                  ->onDelete('cascade');\n            $table->integer('eating_management_id')\n                  ->foreign('eating_management_id')\n                  ->references('id')->on('eating_managements')\n                  ->onDelete('cascade');\n            $table->engine = 'InnoDB';\n            $table->charset = 'utf8mb4';\n            $table->collation = 'utf8mb4_unicode_ci';\n        });\n\n        Schema::create('timezones', function (Blueprint $table) {\n            $table->increments('id');\n            $table->text('zone');\n            $table->timestamps();\n            $table->engine = 'InnoDB';\n            $table->charset = 'utf8mb4';\n            $table->collation = 'utf8mb4_unicode_ci';\n        });\n\n        Schema::create('eating_management_timezone', function (Blueprint $table) {\n            $table->integer('eating_management_id')\n                  ->foreign('eating_management_id')\n                  ->references('id')->on('eating_managements')\n                  ->onDelete('cascade');\n            $table->integer('timezone_id')\n                  ->foreign('timezone_id')\n                  ->references('id')->on('timezones')\n                  ->onDelete('cascade');\n            $table->engine = 'InnoDB';\n            $table->charset = 'utf8mb4';\n            $table->collation = 'utf8mb4_unicode_ci';\n        });\n    }\n\n    \/**\n     * Reverse the migrations.\n     *\n     * @return void\n     *\/\n    public function down()\n    {\n        Schema::dropIfExists('eating_management_timezone');\n        Schema::dropIfExists('timezones');\n        Schema::dropIfExists('eating_management_user');\n        Schema::dropIfExists('eating_managements');\n    }\n}\n<\/code><\/pre>\n\n\n\n
\u5fc5\u8981\u306a\u9805\u76ee\u306f\u3001\u65e5\u4ed8\u3001\u6642\u9593\u5e2f\u3001\u54c1\u76ee\u3001\u30bf\u30f3\u30d1\u30af\u8cea\u3001\u8102\u8cea\u3001\u70ad\u6c34\u5316\u7269\u3001\u30ab\u30ed\u30ea\u30fc\u3002<\/p>\n\n\n\n
\u6642\u9593\u5e2f\u306f\u5225\u30c6\u30fc\u30d6\u30eb\u3067\u5b9a\u7fa9\u3057\u3066\u3001\u671d\u3001\u663c\u3001\u591c\u3001\u9593\u98df\u304b\u3089\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\u6642\u9593\u5e2f\u306f\u56fa\u5b9a\u5024\u306a\u306e\u3067\u3001Seeder\u3067\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
$ php artisan make:seeder TimezoneSeeder<\/code><\/pre>\n\n\n\n
class TimezoneSeeder extends Seeder\n{\n    \/**\n     * Run the database seeds.\n     *\n     * @return void\n     *\/\n    public function run()\n    {\n        DB::table('timezones')->insert(['zone' => '\u671d',]);\n        DB::table('timezones')->insert(['zone' => '\u663c',]);\n        DB::table('timezones')->insert(['zone' => '\u591c',]);\n        DB::table('timezones')->insert(['zone' => '\u9593\u98df',]);\n    }\n}<\/code><\/pre>\n\n\n\n
\u3053\u308c\u3089\u3092\u5b9f\u884c\u3057\u3066\u9069\u7528\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n\n
$ composer dump-autoload\nGenerating optimized autoload files\n> Illuminate\\Foundation\\ComposerScripts::postAutoloadDump\n> @php artisan package:discover\nDiscovered Package: fideloper\/proxy\nDiscovered Package: laravel\/tinker\nDiscovered Package: nesbot\/carbon\nPackage manifest generated successfully.\n$ php artisan migrate\nMigrating: 2020_07_10_092328_create_eating_management\nMigrated:  2020_07_10_092328_create_eating_management (0.07 seconds)\n$ php artisan db:seed --class=TimezoneSeeder\nDatabase seeding completed successfully.\n<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u4f5c\u6210\u6642\u9593\u306bNULL\u3063\u3066\u5165\u3063\u3066\u3044\u308b\u3051\u3069\u3001\u307e\u3042\u3044\u3044\u304b\u3002<\/p>\n\n\n\n<\/a>\n\n","protected":false},"excerpt":{"rendered":"
\u98df\u4e8b\u7ba1\u7406\u6a5f\u80fd\u306e\u4f5c\u6210\u306b\u7740\u624b\u3057\u307e\u3059\u3002 \u307e\u305a\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u3002 \u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002 \u5fc5\u8981\u306a\u9805\u76ee\u306f\u3001\u65e5\u4ed8\u3001\u6642\u9593\u5e2f\u3001\u54c1\u76ee\u3001\u30bf\u30f3\u30d1\u30af\u8cea\u3001\u8102\u8cea\u3001\u70ad\u6c34\u5316\u7269\u3001\u30ab\u30ed\u30ea\u30fc\u3002 \u6642\u9593\u5e2f\u306f\u5225\u30c6\u30fc\u30d6\u30eb\u3067\u5b9a\u7fa9\u3057\u3066\u3001\u671d\u3001\u663c\u3001\u591c\u3001\u9593\u98df\u304b\u3089\u9078 … \u7d9a\u304d\u3092\u8aad\u3080 \u3010Laravel\u3011\u3010\u30c0\u30a4\u30a8\u30c3\u30c8\u652f\u63f4\u3011\u98df\u4e8b\u7ba1\u7406\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"\u3010Laravel\u3011\u3010\u30c0\u30a4\u30a8\u30c3\u30c8\u652f\u63f4\u3011\u98df\u4e8b\u7ba1\u7406\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b\n#TechCommit\n","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[167,3],"tags":[138,193],"class_list":["post-3549","post","type-post","status-publish","format-standard","hentry","category-laravel","category-3","tag-laravel","tag-193"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t