Model & Seeding 整合

於 2014/12/6, 7, 13, 14 受邀於 彰化師範大學 資訊工程學系系學會 進行 Laravel 工作坊，內容共分 12 個主題：

0. 工作坊簡介 - https://speakerdeck.com/shengyou/gong-zuo-fang-jian-jie
1. 開發環境建置 - https://speakerdeck.com/shengyou/kai-fa-huan-jing-jian-zhi
2. 開發流程與工具介紹 - https://speakerdeck.com/shengyou/kai-fa-liu-cheng-yu-gong-ju-jie-shao
3. 專案啟動與設定 - https://speakerdeck.com/shengyou/zhuan-an-qi-dong-yu-she-ding
4. Schema & Migration 操作 - https://speakerdeck.com/shengyou/schema-and-migrationcao-zuo
5. Model & Seeding 整合 - https://speakerdeck.com/shengyou/model-and-seeding-zheng-he
6. 使用 Eloquent ORM - https://speakerdeck.com/shengyou/shi-yong-eloquent-orm
7. Route 機制 - https://speakerdeck.com/shengyou/route-ji-zhi
8. View 與 Blade 樣板引擎 - https://speakerdeck.com/shengyou/view-yu-blade-yang-ban-yin-qing
9. 連結 Controller - https://speakerdeck.com/shengyou/lian-jie-controller
10. CRUD 綜合應用 - https://speakerdeck.com/shengyou/crud-zong-he-ying-yong
11. 使用者認證 - https://speakerdeck.com/shengyou/shi-yong-zhe-ren-zheng
12. 應用程式佈署 - https://speakerdeck.com/shengyou/ying-yong-cheng-shi-bu-shu

完整課程訊息請見：http://www.laravel-dojo.com/courses/laravel4-first-class
程式碼範例請見：https://github.com/laravel-dojo/laravel4-first-class-example

Transcript

1. Laravel ޻࡞๥ Model/Seeding ੔߹ shengyou @ জࢣେࢿ޻ܥላ။ (2014.12.07)
2. ֊ஈ೚຿ • ྃղ Laravel త Model ઃఆٴ໋໊׳ྫ • ላश೗Կ࢖༻ Laravel త Seeding ޭೳ
3. ݐཱ Model
4. Model • ౷Ұ์ஔࡏ app/models/{model}.php • ҰݸࢿྉදबੋҰ܈ࢿྉతू߹ɼ㑌Ұච ࢿྉ (row) बሣጯҰݸ Model መᱪ • ࡏ Laravel త׳ྫཫɼࢿྉදత໊᜝༻ӳ จෳᏐʀࣕ Model త໊᜝ब༻ӳจᄸᏐ ˒ ჩߟɿhttp://laravel.tw/docs/4.2/eloquent#basic-usage
5. Model 䈕Ҋ݁ߏ • Ұݸ࠷ਫ਼؆త Model 䈕Ҋ୞धࡾߦ • एཁڧ੍ࢦఆሣጯతࢿྉද໊᜝ɼଇ࠶Ճ Ұߦ class  Post  extends  \Eloquent { } class  Post  extends  \Eloquent {        protected  $table  =  ‘posts’; }
6. खಈݐཱ Model • ࡏ app/models/ ఈԼ৽⃧ {‘M’odel (ᄸ Ꮠ)}.php • ༌ೖ Model ఔࣜᛰ (ਫ਼؆ࡾߦ) • ࣥߦ php artisan dump-autoload ᩋ৽ݐ޷ త Model ሜೖ class map 㚎
7. Model ޠ๏ Ұݸجຊత Model ޠ๏
8. artisan generate:model • 㗞ੜ Model 䈕Ҋ - artisan 㚎ݐᔒ༗㗞ੜ Model 䈕తࢦྩɼ ୠՄ༻ generator 㗞ੜ • ൣྫɿ $  php  artisan  generate:model  post
9. 㗞ੜ model 䈕 ಁա generator 㗞ੜ model
10. ڧ੍ઃఆࢿྉද໊᜝ एࢿྉදቮៃଘࡏ (Ex. ҡޢᢜሢҊ)ɼՄڧ੍ࢦఆࢿྉද໊᜝
11. generator తઃఆ generator ။ଟ㗞ੜ fillable ሱੑɼޙ᠃ CRUD ষઅ࠶㘸໌
12. ଘ䈕ᴍ • ࢼஶ೺ݱࡏቮៃՄҎӡ࡞తఔࣜᛰՃೖ൛ ຊ߇੍㚎 • ྲྀఔఏ੧ɿ - working directory > staging area > commit
13. ࢖༻ Seeding
14. ॄኄੋ Seedingʁ • ࡏ։ᚙաఔதɼԟԟ။धཁଌࢼࢿྉိ၏ ྻදᰖࣔɺ႟আɺमվိ֬ೝఔࣜޭೳɼ ࣕࢿྉత㚎༰ෆඞੋਅత • ಁա Laravel త table seederɼՄҎշ଎త 㗞ੜଌࢼฒ౗ਐࢿྉݿɼํศ։ᚙ CRUD ṜछҎࢿྉૢ࡞ҝओతޭೳ
15. ҝॄኄཁ༻ Seedingʁ • ༗ଌࢼࢿྉ኷ํศɼୠࣗݾ㗞ੜ/ݐཱ኷Ֆ ࣌ؒʀएṜݸಈ࡞ཁॏෳ၏኷ଟวੋඇৗ ྦྷਓ໵࿘අ࣌ؒతࣄ • ༻ Seeding ޙɼՄҎշ଎తᩋ DB 㚎༗ଌ ࢼࢿྉՄҎ࢖༻ɼሜ DB ࢿྉૢ࡞త૬᮫ ޭೳ࣌ɼ։ᚙᏈ཰େ⃧
16. Seeds • ౷Ұ์ஔࡏ app/database/seeds/{seed}.php • 䈕Ҋ໋໊׳ྫҝ {‘M’odel ໊᜝}TableSeeder • 㑌Ұݸ Seeder 䈕Ҋཫ୞༗Ұݸ run വࣜ • വࣜ㚎ՄҎሜ૝ཁ㗞ੜଌࢼࢿྉతنଇ • هಘཁࡏ DatabaseSeeder ཫݺڣ ˒ ჩߟɿhttp://laravel.tw/docs/migrations#database-seeding
17. Seeder 䈕Ҋ݁ߏ • Ұݸجૅత Seeder ݁ߏɼ୞༗ run വࣜ class  PostTableSeeder  extends  Seeder {        public  function  run()        {                //  ࣗߦḤሜ㗞ੜଌࢼࢿྉతنଇ        } }
18. खಈݐཱ Seeder • ࡏ app/models/ ఈԼ৽⃧ {‘M’odel (ᄸᏐ)} TableSeeder.php • ༌ೖ Seeder ఔࣜᛰ (run വࣜ㚎༰) • ࣥߦ php artisan dump-autoload ᩋ৽ݐ޷ త Model ሜೖ class map 㚎
19. artisan generate:seed • 㗞ੜ Seeder 䈕Ҋ - artisan 㚎ݐᔒ༗㗞ੜ Seeder 䈕తࢦྩɼ ୠՄ༻ generator 㗞ੜ • ൣྫɿ $  php  artisan  generate:seed  post
20. 㗞ੜ seeder 䈕 ࢖༻ generator 㗞ੜ seeder 䈕
21. Ḥሜࢿྉ㗞ੜنଇ
22. ઃఆ DatabaseSeeder ࡏ DatabaseSeeder 㚎ݺڣཁࣥߦత Seed Class
23. ࣥߦ Seeding ࢖༻ artisan ࣥߦ db:seed
24. artisan db:seed • ࣥߦ Seeding - ݺڣ DatabaseSeederɼ೺ଖதॴ༗త Seeder 䋯Ұว - ՃჩᏐ --class={Model}TableSeeder ՄҎ ୞ࣥߦ๭Ұݸ Seeder • ൣྫɿ $  php  artisan  db:seed $  php  artisan  db:seed  -­‐-­‐class=PostTableSeeder
25. ࢿྉݿ㚎ᱛᨽ
26. ৽⃧ࢿྉલਗ਼ۭࢿྉ • artisan db:seed ࢦྩ୞။ᄸ७తࣥߦ run త 㚎༰ɼҼࠑएࢦྩҰ௚Լɼ၊ࢿྉब။Ұ ௚⃧Ճ • ࢖༻ DB ෺݅ࡏ Seeding ೭લઌਗ਼ۭࢿྉ දɼ၊ࢿྉ࠽ෆ။Ұ௚௕ɺҰ௚௕… • ൣྫɿ DB::table(‘{ࢿྉද໊᜝}’)-­‐>truncate();
27. ᩋࢿྉଟᴍᬋػײ • ઃఆ rand വࣜ㗞ੜ category_id ٴ post_idɼᩋሣጯՄҎߋᬋػҰࠣ • ༻ Carbon ߇੍೔ظ࣌ؒత㗞ੜɼᩋࢿྉ ෆ။౎ࡏಉҰఱሜೖ • ൣྫɿ ‘category_id’  =>  rand(1,  4); ‘created_at’  =>  \Carbon\Carbon::now()-­‐>addDays($index); ˒ ჩߟɿhttps://github.com/briannesbitt/Carbon
28. ᩋ၊ࢿྉߋਅʂ • ഑߹ Faker ౟݅ɼᩋ㗞ੜग़ိతଌࢼࢿྉ ߋ૾ਅతҰᒬ (༗ Fuʂ) • composer.json 㚎৽⃧ faker ౟݅ɼ࠶ࣥߦ composer update • ሜ Seeder 䈕࣌ɼҾೖ Faker ྨผ • ए࢖༻ generator త࿩ɼ။ࣗಈ㢨㟬ሜ޷ ˒ ჩߟɿhttps://github.com/fzaninotto/Faker
29. ߋଟ Faker ጯ༻ڭላ • Simplifying Test Data Generation with Faker - http://www.sitepoint.com/simplifying-test-data- generation-with-faker/ • Build a Database with Eloquent, Faker and Flysystem - http://www.sitepoint.com/build-database-eloquent- faker-flysystem/
30. ଘ䈕ᴍ • ࢼஶ೺ݱࡏቮៃՄҎӡ࡞తఔࣜᛰՃೖ൛ ຊ߇੍㚎 • ྲྀఔఏ੧ɿ - working directory > staging area > commit
31. ֊ஈᒾ查ද • ֬ೝ༗㗞ੜ 3 ݸ Model 䈕 • ֬ೝ༗㗞ੜ 3 ݸ Seeder 䈕ɼฒઃఆ޷ DatabaseSeeder • ֬ೝ DB 㚎ቮៃ༗㗞ੜग़ိతଌࢼࢿྉ
32. ໰ᢛ౴ ላһՄ։࢝࿅शɺመ࡞
33. ᄸݩখ݁ • ࡏṜݸᄸݩཫɼզ၇㘸໌೗Կઃఆ Laravel త Model ٴ໋໊׳ྫɼฒ༻ Seeding ٕ޼ 㗞ੜࢿྉݿ㚎త၊ࢿྉ • ԼҰݸᄸݩɼզ၇ሡላश೗Կ࢖༻ Laravel త ORM ိૢ࡞ࢿྉݿ㚎తࢿྉ