։ൃମݧΛര্͛͢ΔLaravel Dacapo ϚΠάϨʔγϣϯαϙʔτπʔϧͷεεϝ 2022.08.27 @ucan_lab

ࣗݾ঺հ • Ώ͏͖ΌΜ • ௕࡚ग़਎ • גࣜձࣾROLOॴଐ • ͓࢓ࣄ͸αʔόʔαΠυΤϯδχΞ • झຯ͸HADOɺݪਆɺࡾᅳࢤਅઓɺΞχϝɺອը 
 ΧϑΣ८ΓɺεϚϒϥSPɺϧʔϏοΫΩϡʔϒ 
 ...ͨ͘͞Μɻ

એ఻

એ఻1: ϩϩɺҊ݅େେେืूதʂ • גࣜձࣾROLO (https://rolo.jp) • ΤϯδχΞ͸7ਓ΄Ͳ(Laravel, React) • ௕ظతͳ͓࢓ࣄ୳ͯ͠·͢ʂ • Laravelʹ1೥ۙ͘৮Εͯͳ͍ʂ

એ఻2: ຖ݄HADOͯ͠·͢ʂ • HADO (https://meleap.com) • ಄ͱ࿹ʹηϯλʔΛ૷ணͯ͠ٿΛ์ͭ࠷৽ͷARεϙʔπ • ੈք39ΧࠃɺԆ΂350ສਓ͕ϓϨΠ • 1ࢼ߹80ඵؒɺ3ର3Ͱ఺਺ΛऔΓ߹͏ήʔϜ • HADOެೝνʔϜʮShim Shamʯʹॴଐ • ৔ॴ͸͓୆৔(ԭೄʹ͸ແ͍Έ͍ͨ...😢) • ڵຯ͋Δํ͸ @ucan_lab ·Ͱ

※ը૾͸ΠϝʔδͰ͢ɻ

໨࣍ • Laravel Migrationػೳͷ͓͞Β͍ • Laravel Dacapoͷ঺հ • Laravel Dacapoͷ࢖͍ํ • ࠓޙͷΞοϓσʔτʹ͍ͭͯ • ※Laravel࢖ͬͯͳ͍ਓʹ͸ؔ܎ͳ͍࿩ʹͳΓ·͢🙏 • ※ίʔυ͕Ͱͯ͘ΔͷͰ͓खݩͰࢿྉΛݟ͍ͯͩ͘͞🙏

Laravel Migrationͷ͓͞Β͍

Laravel Migrationͱ͸ • σʔλϕʔεςʔϒϧఆٛͷมߋཤྺΛ؅ཧ • SQLͰ͸ͳ͘PHPϑΝΠϧͰ؅ཧ • ಛఆͷσʔλϕʔεʹґଘ͠ͳ͍ 
 MySQL, PostgreSQL, SQLite, SQL ServerͰಈ͘ • php artisan migrate ίϚϯυҰൃͰ൓өʂ

MigrationϑΝΠϧͷத਎ id(); $table->string('name'); $table->string('email')->unique(); $table->timestamp('email_verified_at')->nullable(); $table->string('password'); $table->rememberToken(); $table->timestamps(); }); } public function down() { Schema::dropIfExists('users'); } };

MigrationͷྲྀΕ php artisan migrate .JHSBUJPO༻ͷ1)1ϑΝΠϧΛ࡞੒ ίϚϯυΛ࣮ߦͯ͠42-͕ൃߦ

🤔 ΊͬͪΌγϯϓϧ ͡ΌͶʁ Կ͕ࠔΔͷʁ

ςʔϒϧఆٛ͸มΘΓ΍͍͢ • ࢓༷͕มΘΕ͹ςʔϒϧ΋มΘΔ • ෆཁͳςʔϒϧɺΧϥϜ͕ͲΜͲΜग़ͯ͘Δ

ͭ·Γɺ͜͏ɻ php artisan migrate 🤔 ΊͬͪΌ૿͑Δ ͡ΌΜʁ

Migrationͷෆຬ఺ • ΰϛϑΝΠϧ͕࢒Δ🙄 
 ʢෆཁʹͳͬͨςʔϒϧ΍ΧϥϜ౳ʣ • ࠷ऴతͳςʔϒϧߏ੒͕ϑΝΠϧΛݟͯ΋෼͔ΒΜ🤔 
 ʢҰཡੑ͕௿͍ʣ • PHPϑΝΠϧͰup, downΛॻ͘ͷ͕ΊΜͲ͍🙃 • ࣗಈੜ੒͞Εͨ೔෇͕όϥόϥͰؾ࣋ͪѱ͍😣

͜ΕΛղܾ͢Δͷ͕μΧʔϙʂ • https://github.com/ucan-lab/laravel-dacapo

Laravel Dacapoͷ঺հ

Laravel Dacapoͱ͸ ɾLaravel MigrationͷαϙʔτϥΠϒϥϦ ɾYAMLܗࣜͰMigrationΛॻ͘ ɾMigration͸ৗʹ࠷৽ͷঢ়ଶΛอͭ 
 ɹʢ୅ΘΓʹςʔϒϧ͸ຖճΫϦΞ͞ΕΔʣ ɾ։ൃ͕ऴΘͬͨΒ௨ৗͷMigrationͷӡ༻ʹ໭͢

ϥΠϒϥϦΛ࡞੒͖͔͚ͨͬ͠ • 4೥લʹmpyw͞ΜͷLTʹӨڹΛड͚ͨ

YAMLϑΝΠϧͷத਎ # database/schemas/sample.yml users: columns: id: bigIncrements name: string email: type: string unique: true email_verified_at: type: timestamp nullable: true password: string rememberToken: true timestamps: true • 1֊૚ʹςʔϒϧ໊ • 2֊૚͸columnsݻఆ • 3֊૚ʹΧϥϜఆٛ • 4֊૚͸ඞཁʹԠͯ͡Φϓγϣϯఆٛ

ੜ੒͞ΕͨMigrationϑΝΠϧͷத਎ id(); $table->string('name'); $table->string('email')->unique(); $table->timestamp('email_verified_at')->nullable(); $table->string('password'); $table->rememberToken(); $table->timestamps(); }); } public function down() { Schema::dropIfExists('users'); } };

DacapoͷྲྀΕ php artisan dacapo .JHSBUJPO༻ͷ:".-ϑΝΠϧΛ࡞੒ ࠷৽ͷ.JHSBUJPOϑΝΠϧΛੜ੒ .JHSBUJPOΛσʔλϕʔεʹద༻ 
 ςʔϒϧॳظԽɺγʔμʔ࣮ߦ΋ؚΉ

Laravel DacapoͷϝϦοτ • YAMLͳͷͰPHPΑΓѹ౗తʹ୹͍ • ࠷৽͔ͭෳ਺ͷఆٛΛॻ͚ͯҰཡੑ͕ߴ͍ • MigrationϑΝΠϧͷ೔෇͕੔ཧ੔಴͞ΕΔ • ςʔϒϧ࡞੒ɺΠϯσοΫεɺ֎෦Ωʔʹ ϑΝΠϧ͕෼͔ΕΔ

Laravel Dacapo ͷ࢖͍ํ

Πϯετʔϧํ๏ $ composer require --dev ucan-lab/laravel-dacapo ※ݱ࣌఺ͷόʔδϣϯ͸5.1.2

ॳظઃఆ(dacapo:init ίϚϯυ)

database/schemas/default.yml

database/migrations/ 1970_01_01_000001_create_users_table.php

php artisan dacapo ίϚϯυ • εΩʔϚYAMLΛߋ৽ͨ͠Βdacapo͢Δͩ ͚ʂ • ৗʹ࠷৽ͷϚΠάϨʔγϣϯϑΝΠϧ͕ੜ੒

php artisan dacapo ίϚϯυ

εΩʔϚYAMLϑΥʔϚοτ

εΩʔϚYAMLϑΥʔϚοτ テーブル名: comment: テーブルコメント columns: カラム名: カラムタイプ カラム名: type: カラムタイプ args: カラムタイプの引数(任意) カラム修飾⼦: カラム修飾⼦の引数 カラムエイリアス(timestamps等): indexes: - columns: [カラム名] type: インデックス修飾⼦ name: インデックス名(任意) foreign_keys: - columns: [カラム名] references: [カラム名] table: テーブル名

εΩʔϚYAMLઃఆྫ lessons: columns: id: instructor_id: unsignedBigInteger studio_id: unsignedBigInteger name: unsignedInteger capacity: unsignedInteger started_at: dateTime minutes: unsignedInteger timestamps: indexes: - columns: started_at type: index foreign_keys: - columns: instructor_id references: id table: instructors - columns: studio_id references: id table: studios instructors: columns: id: name: string stores: columns: id: name: string address: string phone_number: string timestamps: studios: columns: id: store_id: unsignedBigInteger name: string timestamps: foreign_keys: - columns: store_id references: id table: stores

ͦͷଞ

MigrationϑΝΠϧ໊ͷϧʔϧ • 1970_01_01_000001 → ςʔϒϧ࡞੒ • 1970_01_01_000002 → ΠϯσοΫε੍໿ • 1970_01_01_000003 → ֎෦Ωʔ੍໿

YAMLͰදݱͰ͖ͳ͍΋ͷ $ php artisan make:migration create_flights_table id(); $table->json('movies')->default(new Expression('(JSON_ARRAY())')); $table->timestamps(); }); } public function down() { Schema::drop('flights'); } }; $ php artisan dacapo ௨ৗͷMigrationϑΝΠϧͱڞଘՄ

εΩʔϚϑΝΠϧ͸͍ͭ͘Ͱ΋

ΞϯΠϯετʔϧํ๏ $ php artisan dacapo:uninstall $ composer remove ucan-lab/laravel-dacapo • ӡ༻͕࢝·ͬͨΒμΧʔϙ͸࡟আ͢Δ

ࠓޙͷΞοϓσʔτ • ϞσϧɺϑΝΫτϦʔɺγʔμʔͷࣗಈੜ੒ • σʔλϕʔε͔ΒεΩʔϚYAMLͷੜ੒ • σʔλϕʔεͱεΩʔϚYAMLͷࠩ෼ͷϚΠά ϨʔγϣϯΛੜ੒

͓͠·͍

࣭໰ͳͲ͋Ε͹ ͓ؾܰʹͲ͏ͧ