開発体験を爆上げするLaravel Dacapo マイグレーションサポートツールのススメ

PHPカンファレンス沖縄2022の発表資料です。

Transcript

1. ։ൃମݧΛര্͛͢ΔLaravel Dacapo ϚΠάϨʔγϣϯαϙʔτπʔϧͷεεϝ 2022.08.27 @ucan_lab
2. ࣗݾ঺հ • Ώ͏͖ΌΜ • ௕࡚ग़਎ • גࣜձࣾROLOॴଐ • ͓࢓ࣄ͸αʔόʔαΠυΤϯδχΞ • झຯ͸HADOɺݪਆɺࡾᅳࢤਅઓɺΞχϝɺອը 
 ΧϑΣ८ΓɺεϚϒϥSPɺϧʔϏοΫΩϡʔϒ 
 ...ͨ͘͞Μɻ
3. એ఻
4. એ఻1: ϩϩɺҊ݅େେେืूதʂ • גࣜձࣾROLO (https://rolo.jp) • ΤϯδχΞ͸7ਓ΄Ͳ(Laravel, React) • ௕ظతͳ͓࢓ࣄ୳ͯ͠·͢ʂ • Laravelʹ1೥ۙ͘৮Εͯͳ͍ʂ
5. એ఻2: ຖ݄HADOͯ͠·͢ʂ • HADO (https://meleap.com) • ಄ͱ࿹ʹηϯλʔΛ૷ணͯ͠ٿΛ์ͭ࠷৽ͷARεϙʔπ • ੈք39ΧࠃɺԆ΂350ສਓ͕ϓϨΠ • 1ࢼ߹80ඵؒɺ3ର3Ͱ఺਺ΛऔΓ߹͏ήʔϜ • HADOެೝνʔϜʮShim Shamʯʹॴଐ • ৔ॴ͸͓୆৔(ԭೄʹ͸ແ͍Έ͍ͨ...😢) • ڵຯ͋Δํ͸ @ucan_lab ·Ͱ
6. ※ը૾͸ΠϝʔδͰ͢ɻ
7. ໨࣍ • Laravel Migrationػೳͷ͓͞Β͍ • Laravel Dacapoͷ঺հ • Laravel Dacapoͷ࢖͍ํ • ࠓޙͷΞοϓσʔτʹ͍ͭͯ • ※Laravel࢖ͬͯͳ͍ਓʹ͸ؔ܎ͳ͍࿩ʹͳΓ·͢🙏 • ※ίʔυ͕Ͱͯ͘ΔͷͰ͓खݩͰࢿྉΛݟ͍ͯͩ͘͞🙏
8. Laravel Migrationͷ͓͞Β͍
9. Laravel Migrationͱ͸ • σʔλϕʔεςʔϒϧఆٛͷมߋཤྺΛ؅ཧ • SQLͰ͸ͳ͘PHPϑΝΠϧͰ؅ཧ • ಛఆͷσʔλϕʔεʹґଘ͠ͳ͍ 
 MySQL, PostgreSQL, SQLite, SQL ServerͰಈ͘ • php artisan migrate ίϚϯυҰൃͰ൓өʂ
10. MigrationϑΝΠϧͷத਎ <?php // ... return new class extends Migration { public function up() { Schema::create('users', function (Blueprint $table) { $table->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'); } };
11. MigrationͷྲྀΕ php artisan migrate 
    .JHSBUJPO༻ͷ1)1ϑΝΠϧΛ࡞੒ 
    ίϚϯυΛ࣮ߦͯ͠42-͕ൃߦ
12. 🤔 ΊͬͪΌγϯϓϧ ͡ΌͶʁ Կ͕ࠔΔͷʁ
13. ςʔϒϧఆٛ͸มΘΓ΍͍͢ • ࢓༷͕มΘΕ͹ςʔϒϧ΋มΘΔ • ෆཁͳςʔϒϧɺΧϥϜ͕ͲΜͲΜग़ͯ͘Δ
14. ͭ·Γɺ͜͏ɻ php artisan migrate 🤔 ΊͬͪΌ૿͑Δ ͡ΌΜʁ
15. Migrationͷෆຬ఺ • ΰϛϑΝΠϧ͕࢒Δ🙄 
 ʢෆཁʹͳͬͨςʔϒϧ΍ΧϥϜ౳ʣ • ࠷ऴతͳςʔϒϧߏ੒͕ϑΝΠϧΛݟͯ΋෼͔ΒΜ🤔 
 ʢҰཡੑ͕௿͍ʣ • PHPϑΝΠϧͰup, downΛॻ͘ͷ͕ΊΜͲ͍🙃 • ࣗಈੜ੒͞Εͨ೔෇͕όϥόϥͰؾ࣋ͪѱ͍😣
16. ͜ΕΛղܾ͢Δͷ͕μΧʔϙʂ • https://github.com/ucan-lab/laravel-dacapo
17. Laravel Dacapoͷ঺հ
18. Laravel Dacapoͱ͸ ɾLaravel MigrationͷαϙʔτϥΠϒϥϦ ɾYAMLܗࣜͰMigrationΛॻ͘ ɾMigration͸ৗʹ࠷৽ͷঢ়ଶΛอͭ 
 ɹʢ୅ΘΓʹςʔϒϧ͸ຖճΫϦΞ͞ΕΔʣ ɾ։ൃ͕ऴΘͬͨΒ௨ৗͷMigrationͷӡ༻ʹ໭͢
19. ϥΠϒϥϦΛ࡞੒͖͔͚ͨͬ͠ • 4೥લʹmpyw͞ΜͷLTʹӨڹΛड͚ͨ
20. 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֊૚͸ඞཁʹԠͯ͡Φϓγϣϯఆٛ
21. ੜ੒͞ΕͨMigrationϑΝΠϧͷத਎ <?php // ... return new class extends Migration { public function up() { Schema::create('users', function (Blueprint $table) { $table->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'); } };
22. DacapoͷྲྀΕ php artisan dacapo 
    .JHSBUJPO༻ͷ:".-ϑΝΠϧΛ࡞੒ 
    ࠷৽ͷ.JHSBUJPOϑΝΠϧΛੜ੒ 
    .JHSBUJPOΛσʔλϕʔεʹద༻ 
 ςʔϒϧॳظԽɺγʔμʔ࣮ߦ΋ؚΉ
23. Laravel DacapoͷϝϦοτ • YAMLͳͷͰPHPΑΓѹ౗తʹ୹͍ • ࠷৽͔ͭෳ਺ͷఆٛΛॻ͚ͯҰཡੑ͕ߴ͍ • MigrationϑΝΠϧͷ೔෇͕੔ཧ੔಴͞ΕΔ • ςʔϒϧ࡞੒ɺΠϯσοΫεɺ֎෦Ωʔʹ ϑΝΠϧ͕෼͔ΕΔ
24. Laravel Dacapo ͷ࢖͍ํ
25. Πϯετʔϧํ๏ $ composer require --dev ucan-lab/laravel-dacapo ※ݱ࣌఺ͷόʔδϣϯ͸5.1.2
26. ॳظઃఆ(dacapo:init ίϚϯυ)
27. database/schemas/default.yml
28. database/migrations/ 1970_01_01_000001_create_users_table.php
29. php artisan dacapo ίϚϯυ • εΩʔϚYAMLΛߋ৽ͨ͠Βdacapo͢Δͩ ͚ʂ • ৗʹ࠷৽ͷϚΠάϨʔγϣϯϑΝΠϧ͕ੜ੒
30. php artisan dacapo ίϚϯυ
31. εΩʔϚYAMLϑΥʔϚοτ
32. εΩʔϚYAMLϑΥʔϚοτ テーブル名: comment: テーブルコメント columns: カラム名: カラムタイプ カラム名: type: カラムタイプ args: カラムタイプの引数(任意) カラム修飾⼦: カラム修飾⼦の引数 カラムエイリアス(timestamps等): indexes: - columns: [カラム名] type: インデックス修飾⼦ name: インデックス名(任意) foreign_keys: - columns: [カラム名] references: [カラム名] table: テーブル名
33. εΩʔϚ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
34. ͦͷଞ
35. MigrationϑΝΠϧ໊ͷϧʔϧ • 1970_01_01_000001 → ςʔϒϧ࡞੒ • 1970_01_01_000002 → ΠϯσοΫε੍໿ • 1970_01_01_000003 → ֎෦Ωʔ੍໿
36. YAMLͰදݱͰ͖ͳ͍΋ͷ $ php artisan make:migration create_flights_table <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Query\Expression; use Illuminate\Database\Migrations\Migration; return new class extends Migration { public function up() { Schema::create('flights', function (Blueprint $table) { $table->id(); $table->json('movies')->default(new Expression('(JSON_ARRAY())')); $table->timestamps(); }); } public function down() { Schema::drop('flights'); } }; $ php artisan dacapo ௨ৗͷMigrationϑΝΠϧͱڞଘՄ
37. εΩʔϚϑΝΠϧ͸͍ͭ͘Ͱ΋
38. ΞϯΠϯετʔϧํ๏ $ php artisan dacapo:uninstall $ composer remove ucan-lab/laravel-dacapo • ӡ༻͕࢝·ͬͨΒμΧʔϙ͸࡟আ͢Δ
39. ࠓޙͷΞοϓσʔτ • ϞσϧɺϑΝΫτϦʔɺγʔμʔͷࣗಈੜ੒ • σʔλϕʔε͔ΒεΩʔϚYAMLͷੜ੒ • σʔλϕʔεͱεΩʔϚYAMLͷࠩ෼ͷϚΠά ϨʔγϣϯΛੜ੒
40. ͓͠·͍
41. ࣭໰ͳͲ͋Ε͹ ͓ؾܰʹͲ͏ͧ