Share
Embed
2021 Web アプリフレームワーク入門_REST API 入門
GTB2020 Web App Framework and REST API Introduction
kumaki
June 14, 2021
Transcript
230 slides
-
ڮޱɹ ॴଐɿ GMOΠϯλʔωοτגࣜձࣾ γεςϜຊ෦ɹ ໊͓લ.com ։ൃ෦ ໊͓લϑϩϯτΤϯυ νʔϜ ೖࣾɿ 2019
झຯɿ ےτϨɺαφɺΞχϝ ߨࢣհ 7 -
1ʢ2021/05/12 16:15ʙ18:40ʣ ࠲ֶ 1࣌ؒ15 (16:15ʙ17:30) kumak1 - Webʹ͍ͭͯ - ϖʔδ͕දࣔ͞ΕΔ·Ͱ
- WebΞϓϦέʔγϣϯʹ͍ͭͯ - WebΞϓϦέʔγϣϯΛ࡞͢Δʹ͋ͨͬͯ ։ൃڥߏங 1࣌ؒ (17:40ʙ18:40) endu - ConoHa VPSʹαʔόʔΛՃ͢Δ - VSCodeͷ֦ுػೳRemote-SSHͰαʔόʔʹΞΫηε͢Δ ߨٛͷਐΊํʹ͍ͭͯ 9 εέδϡʔϧͱ୲ʹ͍ͭͯ -
εέδϡʔϧͱ୲ʹ͍ͭͯ 2ʢ2021/05/13 10:30ʙ18:45ʣ Laravelʹ͍ͭͯ 1࣌ؒʢ10:30ʙ11:30ʣ kumak1 - Laravelͱʁ - Laravelͷศརػೳ
- LaravelͷσΟϨΫτϦߏ - LaravelͰͷॲཧͷྲྀΕΛ֬ೝ͢Δ ߨٛͷਐΊํʹ͍ͭͯ 10 -
εέδϡʔϧͱ୲ʹ͍ͭͯ 2ʢ2021/05/13 10:30ʙ18:45ʣ LaravelΛͬͯAPIΛ࡞͢Δ 6࣌ؒʢ11:40ʙ18:45ʣ endu - ΞϓϦέʔγϣϯΛηοτΞοϓ͠Α͏ - ΞϓϦέʔγϣϯΛϒϥβ͔ΒݟͯΈΑ͏
- APIͷCRUDΛ࣮͠Α͏ - ORMͷΑ· - ValidationΛ࣮͠Α͏ ߨٛͷਐΊํʹ͍ͭͯ 11 -
Webʹ͍ͭͯ Web ͷؔ࿈ٕज़ͱͯѻ͍͘͢ɺ༷ʑͳͱ͜ΖͰར༻͞Ε͍ͯ·͢ɻ - Chrome Edge ͳͲͷϒϥβͰاۀαʔϏεͷWebϖʔδΛݟΔ - ΦʔιυοΫεͳΘΕํ
- PCɾεϚϗɾςϨϏͱ͍༷ͬͨʑͳσόΠε͔ΒݟΔ͜ͱ͕Ͱ͖Δ - εϚϗͷήʔϜΞϓϦͰ௨৴Λߦ͍ͳ͕ΒڠྗϓϨΠΛ͢Δ - ϒϥβҎ֎ͷ༷ʑͳΞϓϦσʔλͷΓऔΓʹར༻͍ͯ͠Δ Webʹ͍ͭͯ 20 -
ΫϥΠΞϯτͱαʔόʔ αʔϏεΛఏڙ͢ΔଆΛαʔόʔɺαʔϏεΛड͚ΔଆΛΫϥΠΞϯτͱ ݺͼ·͢ʢҰൠతͳݴ༿ʹͳΓͭͭ͋Γ·͢Ͷʣɻ ΫϥΠΞϯτͷදྫ͕ϒϥβ - Google Chrome - Microsoft EdgeɺInternet
Explorer - Apple Safari - Mozilla Firefox αʔόʔͱͯ͠ར༻͞Ε͍ͯΔදతͳͷ - Apache HTTP Server - Nginx (ΤϯδϯΤοΫε) - Microsoft IIS (Internet Information Services) - LiteSpeed Web Server Webʹ͍ͭͯ 21 -
URL ͱ HTTP Web Ͱ࣍ͷ2͕ͭͱͯॏཁͳཁૉͱͳΓ·͢ɻ URL (Uniform Resource Locator) ʮཉ͍͠ใ͕Ͳ͜ʹ͋Δͷ͔ʯͱ͍͏ॴΛ໌֬ʹࣔ͢
HTTP (HyperText Transfer Protocol) URL Ͱࣔͨ͠ॴʹରͯ͠ʮใΛͲ͏͍͔ͨ͠ʯΛ௨৴Ͱࢦࣔ͢Δ ্هͷ2ͭΛ͜ΕҎ߱͏গ͚ͩ͠ਂ۷Γ͠·͢ɻ Webʹ͍ͭͯ 22 -
URLͱ URLΛ͏͜ͱͰʮͲ͜ʹͳʹ͕͋Δ͔ʯΛ؆୯ʹࣔ͢͜ͱ͕Ͱ͖·͢ɻ URL͕ͳ͔ͬͨΒ… - ͋ͷاۀαʔόʔͷ˓˓ͱ͍͏ΧςΰϦԼͷ˚˚ͱ͍͏αϒΧςΰϦΛΈͯʂ - ͱͯେม URL͕͋ͬͨΒ… - https://example.com/◦◦/△△/
ΛΈͯʂ - ॴΛࢦࣔ͢͠ͷʹγϯϓϧͳϧʔϧΛఏڙͰ͖ͨͷͰɺར༻͢Δͷ͕ͱͯ؆୯ʹͳͬͨ Webʹ͍ͭͯ 23 -
ϓϩτίϧͱ ϓϩτίϧͱ௨৴͢Δࡍͷखॱن֨ΛఆΊͨنͷ͜ͱͰ͢ɻ ϓϩτίϧʹै͏͜ͱͰɺαʔόʔͱΫϥΠΞϯτ͕ωοτϫʔΫΛ ௨ͯ͡ΓऔΓͰ͖·͢ɻ - ΫϥΠΞϯτ͕αʔόʔʹܾΊΒΕ໋ͨྩ (1ͭ͘͠ෳ) Λૹ৴͢Δͱ݁Ռ ͕ฦΔ -
Web Ͱ URL Ͱࣔ͞Εͨॴʹରͯ͠ HTTP ͱ͍͏ϓϩτίϧͰΓ औΓΛߦ͏ Webʹ͍ͭͯ 24 -
HTTP ͷྑ͞ HTTP ͦΕ·Ͱ͋ͬͨϓϩτίϧΑΓ͔ͳΓ୯७ͳͷͱͳ͍ͬͯ·͢ɻ Ҏલͷϓϩτίϧ - SMTP POP3/IMAP4 (ϝʔϧͰ༻)
- FTP (ϑΝΠϧసૹͰ༻) - ෳͷ໋ྩΛΈ߹Θͤͯతͷಈ࡞Λߦ͏ HTTP - (جຊతʹ) 1ͭͷ໋ྩͰతΛՌͨͤΔ - ϓϩτίϧ͕୯७ͳͨΊɺαʔόʔΫϥΠΞϯτΛ࣮͍͢͠ HTTP Λར༻ͨ͠ϓϩμΫτࣄྫ͕രൃతʹ૿͑·ͨ͠ɻ Webʹ͍ͭͯ 25 -
HTTP ͷΓऔΓ ྫ͑ɺYahoo! JAPAN ͷϖʔδΛදࣔ͢Δ·ͰΛߟ͑ͯΈ·͠ΐ͏ɻ 1. ϒϥβ͔Β Yahoo! JAPAN ͷWebαʔόʔʹτοϓϖʔδͷใΛΒ͏ͨΊʹ
τοϓϖʔδͷURL ʹରͯ͠ϦΫΤετΛ͛Δ 1. WebαʔόʔτοϓϖʔδͷσʔλΛ४උͯ͠ɺϒϥβʹϨεϙϯεͱͯ͠ HTML ϑΝΠϧΛฦ͢ 2. ϒϥβ͕ HTML ϑΝΠϧΛղੳ͢ΔͱɺCSS JavaScriptɺը૾ͱ͍ͬͨϑΝΠϧΛ ՃͰऔಘ͢Δඞཁ͕͋Δ͜ͱ͕໌͢Δ 1. ϒϥβ͔ΒWebαʔόʔʹ ඞཁͳͷΛΒ͏ͨΊʹ͛Δ 2. αʔόʔ͔ΒϒϥβʹϦΫΤετ͞ΕͨͷΛฦ͢ ...ҎԼ͜Εͷ܁Γฦ͠ Webϖʔδ͕දࣔ͞ΕΔ·Ͱ 28 -
ϒϥβ͔Β Yahoo! JAPAN ͷWebαʔόʔʹτοϓϖʔδͷใΛ Β͏ͨΊʹτοϓϖʔδͷURL ʹରͯ͠ϦΫΤετΛ͛·͢ɻ Yahoo! JAPAN ͷϖʔδ͕ݟ͑Δ·Ͱʢͦͷ1ʣ ϦΫΤετ
GET https://www.yahoo.co.jp/ HTTP/1.1 Host: www.yahoo.co.jp Connection: keep-alive accept:text/html,application/xhtml+xml,application/xml;q=0.9,image/ webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 accept-encoding: gzip, deflate, br accept-language: ja,en-US;q=0.9,en;q=0.8 cookie: ... sec-fetch-dest: document sec-fetch-mode: navigate sec-fetch-site: none sec-fetch-user: ?1 upgrade-insecure-requests: 1 user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/ 537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36 30 -
ϒϥβ͔Β Yahoo! JAPAN ͷWebαʔόʔʹτοϓϖʔδͷใΛ Β͏ͨΊʹτοϓϖʔδͷURL ʹରͯ͠ϦΫΤετΛ͛·͢ɻ Yahoo! JAPAN ͷϖʔδ͕ݟ͑Δ·Ͱʢͦͷ1ʣ ϦΫΤετ
GET https://www.yahoo.co.jp/ HTTP/1.1 Host: www.yahoo.co.jp Connection: keep-alive accept:text/html,application/xhtml+xml,application/xml;q=0.9,image/ webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 accept-encoding: gzip, deflate, br accept-language: ja,en-US;q=0.9,en;q=0.8 cookie: ... sec-fetch-dest: document sec-fetch-mode: navigate sec-fetch-site: none sec-fetch-user: ?1 upgrade-insecure-requests: 1 user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/ 537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36 GET https://www.yahoo.co.jp/ HTTP/1.1 31 -
ϒϥβ͔Β Yahoo! JAPAN ͷWebαʔόʔʹτοϓϖʔδͷใΛ Β͏ͨΊʹτοϓϖʔδͷURL ʹରͯ͠ϦΫΤετΛ͛·͢ɻ Yahoo! JAPAN ͷϖʔδ͕ݟ͑Δ·Ͱʢͦͷ1ʣ ϦΫΤετ
GET https://www.yahoo.co.jp/ HTTP/1.1 Host: www.yahoo.co.jp Connection: keep-alive accept:text/html,application/xhtml+xml,application/xml;q=0.9,image/ webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 accept-encoding: gzip, deflate, br accept-language: ja,en-US;q=0.9,en;q=0.8 cookie: ... sec-fetch-dest: document sec-fetch-mode: navigate sec-fetch-site: none sec-fetch-user: ?1 upgrade-insecure-requests: 1 user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/ 537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36 GET https://www.yahoo.co.jp/ HTTP/1.1 ϦΫΤετ ϝιου URL HTTPͷ όʔδϣϯ 32 -
ϦΫΤετϝιου ϦΫΤετϝιουɺURLʹରͯ͠ͲͷΑ͏ͳॲཧΛ͍ͨ͠ͷ͔Λ ࣔͨ͠ͷͰ͢ɻ GET - ใΛऔಘ - ෭࡞༻ͳ͍Α͏ʹ POST -
ใΛมߋ PUT - ใΛஔ PATCH - ใΛҰ෦ஔ DELETE - ใΛআ Yahoo! JAPAN ͷϖʔδ͕ݟ͑Δ·Ͱʢͦͷ1ʣ 33 -
WebαʔόʔτοϓϖʔδͷσʔλΛ४උͯ͠ɺϒϥβʹ Ϩεϙϯεͱͯ͠ html ϑΝΠϧΛฦ͠·͢ɻ Yahoo! JAPAN ͷϖʔδ͕ݟ͑Δ·Ͱʢͦͷ2ʣ Ϩεϙϯε HTTP/1.1 200
OK Cache-Control: private, no-cache, no-store, must-revalidate Content-Type: text/html; charset=UTF-8 Date: Mon, 20 Apr 2020 06:59:26 GMT Expires: -1 Pragma: no-cache Set-Cookie: B=18kikclf9qi2e&b=3&s=2m; expires=Thu, 21-Apr-2022 06:59:26 GMT; pat h=/; domain=.yahoo.co.jp Vary: Accept-Encoding X-Content-Type-Options: nosniff X-Frame-Options: SAMEORIGIN X-Vcap-Request-Id: 075691ed-bab6-4077-58f0-34523d132299 X-Xss-Protection: 1; mode=block Age: 0 Transfer-Encoding: chunked Connection: keep-alive Via: http/1.1 edge1675.img.bbt.yahoo.co.jp (ApacheTrafficServer [c sSf ]) Server: ATS Set-Cookie: XB=18kikclf9qi2e&b=3&s=2m; expires=Thu, 21-Apr-2022 06:59:26 GMT; pa th=/; domain=.yahoo.co.jp; secure; samesite=none <!DOCTYPE html><html lang="ja">... 35 -
WebαʔόʔτοϓϖʔδͷσʔλΛ४උͯ͠ɺϒϥβʹ Ϩεϙϯεͱͯ͠ html ϑΝΠϧΛฦ͠·͢ɻ Yahoo! JAPAN ͷϖʔδ͕ݟ͑Δ·Ͱʢͦͷ2ʣ Ϩεϙϯε HTTP/1.1 200
OK Cache-Control: private, no-cache, no-store, must-revalidate Content-Type: text/html; charset=UTF-8 Date: Mon, 20 Apr 2020 06:59:26 GMT Expires: -1 Pragma: no-cache Set-Cookie: B=18kikclf9qi2e&b=3&s=2m; expires=Thu, 21-Apr-2022 06:59:26 GMT; pat h=/; domain=.yahoo.co.jp Vary: Accept-Encoding X-Content-Type-Options: nosniff X-Frame-Options: SAMEORIGIN X-Vcap-Request-Id: 075691ed-bab6-4077-58f0-34523d132299 X-Xss-Protection: 1; mode=block Age: 0 Transfer-Encoding: chunked Connection: keep-alive Via: http/1.1 edge1675.img.bbt.yahoo.co.jp (ApacheTrafficServer [c sSf ]) Server: ATS Set-Cookie: XB=18kikclf9qi2e&b=3&s=2m; expires=Thu, 21-Apr-2022 06:59:26 GMT; pa th=/; domain=.yahoo.co.jp; secure; samesite=none <!DOCTYPE html><html lang="ja">... HTTP/1.1 200 OK 36 -
WebαʔόʔτοϓϖʔδͷσʔλΛ४උͯ͠ɺϒϥβʹ Ϩεϙϯεͱͯ͠ html ϑΝΠϧΛฦ͠·͢ɻ Yahoo! JAPAN ͷϖʔδ͕ݟ͑Δ·Ͱʢͦͷ2ʣ Ϩεϙϯε HTTP/1.1 200
OK Cache-Control: private, no-cache, no-store, must-revalidate Content-Type: text/html; charset=UTF-8 Date: Mon, 20 Apr 2020 06:59:26 GMT Expires: -1 Pragma: no-cache Set-Cookie: B=18kikclf9qi2e&b=3&s=2m; expires=Thu, 21-Apr-2022 06:59:26 GMT; pat h=/; domain=.yahoo.co.jp Vary: Accept-Encoding X-Content-Type-Options: nosniff X-Frame-Options: SAMEORIGIN X-Vcap-Request-Id: 075691ed-bab6-4077-58f0-34523d132299 X-Xss-Protection: 1; mode=block Age: 0 Transfer-Encoding: chunked Connection: keep-alive Via: http/1.1 edge1675.img.bbt.yahoo.co.jp (ApacheTrafficServer [c sSf ]) Server: ATS Set-Cookie: XB=18kikclf9qi2e&b=3&s=2m; expires=Thu, 21-Apr-2022 06:59:26 GMT; pa th=/; domain=.yahoo.co.jp; secure; samesite=none <!DOCTYPE html><html lang="ja">... HTTP/1.1 200 OK HTTPͷ όʔδϣϯ εςʔλε ίʔυ εςʔλε ςΩετ 37 -
εςʔλείʔυ εςʔλείʔυɺαʔόʔͷॲཧ݁ՌΛࣔͨ͠ͷͰ͢ɻ 3ܻͷͰͲͷΑ͏ͳঢ়ଶʹͳ͔ͬͨΛද͠·͢ɻ - 200൪ॲཧ͕ޭͨ͜͠ͱΛද͢ - 200 OK - 201
Created - 300൪Ճͷॲཧ͕ඞཁͰ͋Δ͜ͱΛද͢ - 301 Moved Permanently - 302 Found - 307 Temporary Redirect - 308 Permanent Redirect εςʔλείʔυ 38 -
εςʔλείʔυ - 400൪ϦΫΤετʹ͕͋ͬͨ͜ͱΛද͢ - 400 Bad Request - 401 Unauthorized
- ೝূ͕ඞཁ - 403 Forbidden - 404 Not Found - 500൪αʔόʔଆʹ͕͋ͬͨ͜ͱΛද͢ - 500 Internal Server Error - 503 Service Unavailable εςʔλείʔυ 39 -
ϦΫΤετϨεϙϯε୯ͳΔςΩετͳͷͰɺͦͷ··Ͱ؆୯ʹ தΛݟΒΕͯ͠·͍·͢ɻ TLS (Transport Layer Security) - ௨৴૬खͷೝূɺ௨৴ͷ҉߸ԽΛߦ͏ϓϩτίϧ - Ҏલ
SSL (Secure Sockets Layer) ͱݺΕ͍ͯͨ - SSL ͷݹ͍όʔδϣϯͰΘΕ͍ͯͨ҉߸ํ͕ࣜഁΒΕͯ͠·ͬͨͨΊɺSSL ͷ্Ґنͱͯ͠ TLS ͕࡞ΒΕͨ - SSL ͱ TLS Λ·ͱΊͯ SSL ͱݺΕΔ͜ͱଟ͍ HTTPS - SSL/TLS ϓϩτίϧͰଓͷ্Ͱ HTTP ௨৴Λߦ͏͜ͱ - SSL/TLS ͕ΘΕ͍ͯͳ͍ঢ়ଶͩͱURL http://ʙ - SSL/TLS ͕ΘΕ͍ͯΔঢ়ଶͰ https://ʙ ʹͳΔ ҆શͳ௨৴Λ͢ΔͨΊʹ 41 -
ಛఆͷ୭͔͚ͩར༻͍ͤͨ͞ ఏڙ͢ΔίϯςϯπʹΑͬͯɺձһ͚͕ͩ͑Δͱ͔ɺಛఆͷਓ͚͕ͩ͑Δ ͱ੍͍ͬͨݶΛ͍ͨ͜͠ͱ͕Α͋͘Γ·͢ɻ ೝূ (Authentication) - ୭Ͱ͋Δ͔Λ֬ೝͯ͠ɺڐՄ͞ΕͨਓҎ֎ڐ͞ͳ͍ - ྫɿiPhone ͷ
Face ID Λ༻͍ͨೝূͳͲ ೝՄ (Authorization) - ୭Ͱ͋Δ͔ʹԠͯ͡ɺͲͷΑ͏ͳݖར͕͋Δ͔Λίϯτϩʔϧ͢Δ - ྫɿөըؗͰόΠΦϨϯεͳөըΛΈΔͳͲ ຊޠͰࣅͨΑ͏ͳ༻ޠͩ͠ɺӳޠͰ྆ํͱུ͢ͱ Auth ͱͳΓɺࠞಉ͞ΕΔࣄ͕ଟ͍ͷͰҙ͠·͠ΐ͏ɻ 42 -
υΩϡϝϯτϧʔτ - URL (https://<server_name>/) ͷτοϓ෦ͱରԠ͢Δαʔόʔ্ͷσΟϨΫτϦͷ͜ͱ - ≒υΩϡϝϯτϧʔτʹϑΝΠϧΛஔ͘ͱWebʹެ։͞ΕΔ - Linux ΛWebαʔόʔʹηοτΞοϓ͢Δͱ
/var/www/html ͕υΩϡϝϯτϧʔτʹͳΔ - ઃఆϑΝΠϧͰมߋՄೳ - ϨϯλϧαʔόʔͰ1ͭͷαʔόʔΛෳͷ͓٬༷͕ར༻͢ΔͷͰɺ͓٬༷ͷυϝΠϯຖʹ υΩϡϝϯτϧʔτΛઃఆ͍ͯ͠Δ υΩϡϝϯτϧʔτʹϑΝΠϧΛແ࡞ʹஔ͘ͱɺWebϒϥβ͔Β؆୯ʹΞΫηε͞Εͯ͠·͏ɻ ͜ͷͨΊɺݟΒΕ͍͚ͯͳ͍σʔλ /var/www/data ͳͲͷυΩϡϝϯτϧʔτ֎ͷσΟϨΫτϦʹ ஔ͘Α͏ʹ͠·͠ΐ͏ʢใ࿙͍͑ͷҰ෦υΩϡϝϯτϧʔτʹޡͬͯϑΝΠϧΛஔ͍ͨ͜ͱͰൃੜ͍ͯ͠·͢ʣɻ ิ 43 -
Web ΞϓϦέʔγϣϯΛྨͯ͠ΈΔ WebϖʔδΛදࣔ͢ΔͨΊͷΞϓϦέʔγϣϯ - αʔόʔ͔Β HTML, JavaScript, CSS, ը૾ͳͲΛฦ͢ -
ݹ͔͘Βఏڙ͞Ε͖ͯͨͷ εϚϗ͔Βར༻͞ΕΔΞϓϦέʔγϣϯ - εϚϗΞϓϦ͔ΒΞΫηε͞Εɺσʔλͷऔಘߋ৽Λߦ͏ - ʮσʔλΛͲ͏ΓऔΓΛ͢Δ͔ʯͱ͍͏ܾ·ΓΛΞϓϦέʔγϣϯຖʹܾΊͯɺ ΫϥΠΞϯτͱαʔόʔͰΓऔΓΛߦ͏ - ͜ͷܾ·Γͷ͜ͱΛ API (Application Programming Interface) ͱ͍͏ ࠓճͷߨٛͰ͜ͷ API ͷ࣮ํ๏Λֶͼ·͢ɻ WebΞϓϦέʔγϣϯʹ͍ͭͯ 46 -
RESTful API API ͷઃܭํ๏ʹ͍͔ͭ͘ͷྲّྀ͕͋Γ·͢ʢRPC SOAPͳͲʣɻ Web API SOAP
(Simple Object Access Protocol) ͳͲͰఏڙ͞Ε͍ͯͨ - γεςϜຖʹෳࡶͳ༷ॻ (XMLͷߏͳͲ) ͷΓऔΓ͕ඞཁ - ࡞͢ΔγεςϜ͕৭ʑͰ͖Δ͕ෳࡶʹͳΓ͕ͪ RESTful API - URL ͕ࣔ͢ͷʹରͯ͠ HTTP ͷϝιουΛͬͯ୯७ʹΞΫηε͢Δ - ༷͕γϯϓϧʹͳΔͷͰɺෳͷγεςϜ࿈ܞ͕ൺֱత༰қʹͳΔ ࡢࠓ RESTful API Ͱఏڙ͢Δͷ͕ଟ͍Ͱ͢ɻ WebΞϓϦέʔγϣϯʹ͍ͭͯ 47 -
REST ͱ͍͏ߟ͑ํ Web ͰγεςϜΛߏங͢Δʹ͋ͨͬͯɺͲͷΑ͏ʹ͢Δͱޮ͕͍͍ͷ͔ͱ ͍͏ߟ͑ํ͕ HTTP ͷنΛࡦఆͨ͠ϝϯόʔͷҰਓͰ͋Δ Roy Fielding ʹΑͬͯఏএ͞Ε·ͨ͠ɻ
REST (REpresentational State Transfer) - ֦ுੑͷ͋Δ Web γεςϜΛߏங͢ΔͨΊͷ ΞʔΩςΫνϟελΠϧ(ઃܭͷྲّྀ༷ࣜɺ࡞๏) - ΫϥΠΞϯτͱαʔόʔͷؒΛURLͱ౷ҰΠϯλϑΣʔε (ϦΫΤετϝιου) Λͬͯ εςʔτϨεʹΓऔΓ͢Δ͜ͱʹΑΓ֦ுੑΛߴΊΔΑ͏ʹͰ͖Δͱͨ͠ߟ͑ - Web ͓Αͼ HTTP ͦͷͷͷݪଇͱݴ͑Δ WebΞϓϦέʔγϣϯʹ͍ͭͯ 48 -
CRUD ͱ͍͏ߟ͑ํ CRUD ͱɺσʔλૢ࡞Ͱ͏4ͭͷجຊػೳͷͦΕͧΕͷ಄จࣈΛͱͬͨͷͰ ͢ɻ͜ΕΛ RESTful API ʹϚοϐϯά͢ΔͱҎԼͷ௨ΓͰ͢ɻ Create -
σʔλΛੜ͢Δ - POST <URL> Read - σʔλΛಡΈऔΔ - GET <URL> Update - σʔλΛߋ৽͢Δ - PUT <URL> or PATCH <URL> Delete - σʔλΛআ͢Δ - DELETE <URL> WebΞϓϦέʔγϣϯʹ͍ͭͯ 49 -
ฦ٫͞ΕΔσʔλͷܗࣜ ௨ৗͷWebΞϓϦέʔγϣϯͰ HTML JavaScriptɾCSS ͳͲ͕ฦ٫ ͞Ε·͕͢ɺAPI ͰͦΕͱҧͬͨܗࣜͰσʔλΛฦ٫͠·͢ɻ ύʔε -
ϓϩάϥϜͰσʔλ (จࣈྻ) ղੳ͢Δ͜ͱ - API Ͱѻ͏σʔλϓϩάϥϜͰॲཧ͍͢͠ܗࣜΛ બͿʢHTML ୯ͳΔෳߦςΩετύʔεͮ͠Β͍ʣ ύʔε͍͢͠σʔλܗࣜ - XML (Extensible Markup Language) - σʔλʹରͯ͠ݫີʹλάΛ༩ͨ͠σʔλܗࣜ - JSON (JavaScript Object Notation) - JavaScript Ͱͦͷ··ར༻ՄೳͰɺͦͷଞݴޠͰѻ͍͍͢ - ࠓճͷߨٛͰ JSON ΛऔΓѻ͏ WebΞϓϦέʔγϣϯʹ͍ͭͯ 50 -
JSON αϯϓϧίʔυͰൺֱ WebΞϓϦέʔγϣϯʹ͍ͭͯ XML HTML <!doctype html> <html> <head> <meta
charset="utf-8"> </head> <body> <form> <input type="text" name="key" value="value"> </form> </body> </html> { "key": "value" } <?xml version="1.0" encoding="utf-8" ?> <key>value</key> 51 -
ϑϨʔϜϫʔΫͱ ໌ͷϋϯζΦϯͰ࡞͢ΔWebΞϓϦέʔγϣϯͰϑϨʔϜϫʔΫΛ ར༻͠·͢ɻ ϑϨʔϜϫʔΫʢWeb ΞϓϦέʔγϣϯϑϨʔϜϫʔΫʣ - ϞϊΛ࡞͢Δࡍɺ0͔Βશͯ࡞Δͷͱͯେม - ͱͯ͠Կׂ͔Ͱ͖͕͋ͬͨϞϊͷ্ʹॲཧΛՃ͢Δ͜ͱͰɺΞϓϦέʔγϣϯ·Ͱͷ खؒΛগͳ͘͢ΔιϑτΣΞ
- ϑϨʔϜϫʔΫຖʹϧʔϧ࡞๏͕͋Γɺ͜Εʹै͑ൺֱత؆୯ʹΞϓϦέʔγϣϯΛ ࡞Ͱ͖Δʢٯʹݴ͑ϑϨʔϜϫʔΫຖʹบ͕͋Γɺ߹Θͤͯ࡞Δඞཁ͕͋Δʣ ϥΠϒϥϦͱͷҧ͍ - ϥΠϒϥϦ͕ࣗ࡞͢ΔϓϩάϥϜ͔Βར༻͢Δ෦ - ಛผͳॲཧΛ؆୯ʹ࣮ݱͰ͖ΔΑ͏࡞͞Ε͓ͯΓɺ࠶࣮͢Δख͕ؒল͚Δ - ϑϨʔϜϫʔΫ͕ࣗ࡞͢ΔϓϩάϥϜ͕ར༻͞ΕΔ෦ WebΞϓϦέʔγϣϯΛ࡞͢Δʹ͋ͨͬͯ 53 -
ύλʔϯ ϓϩάϥϜΛઃܭɾ࣮ʹ͓͍ͯʮ୭͕ࣅ࣮ͨΛ͍ͯ͠Δͳʯͱ ͍͏͜ͱ͕͠͠ى͜Γ·͢ɻ ύλʔϯ - ࣅͨΞϓϦέʔγϣϯΛ࡞͢Δ߹ɺޙʑ֦ுɾमਖ਼͍͢͠ڞ௨ͷΓํ͕ग़ͯ͘Δ - ख๏खॱʹ໊લΛ͚ͭɺΤϯδχΞؒͰڞ௨ͷޠኮͱͯ͠ձ͕Ͱ͖ΔΑ͏ʹͨ͠Ϟϊ Ξϯνύλʔϯ -
ύλʔϯྑ͍Ϟϊ͔ΓͰͳ͍ - ʮ͜͏͍͏෩ʹ͢Δͱྑ͘ͳ͍Αʯͱҙשى͢Δͷ ϑϨʔϜϫʔΫ͜ͷύλʔϯΛଟ͘ར༻͓ͯ͠Γɺͦͷදྫ͕ MVCύλʔϯͰ͢ɻ WebΞϓϦέʔγϣϯΛ࡞͢Δʹ͋ͨͬͯ 54 -
MVCύλʔϯ MVCύλʔϯ (Model-View-Controller ύλʔϯ) - ModelɺViewɺController ͷ3ͭͷύʔπͰΞϓϦέʔγϣϯΛ࡞Δߟ͑ํ Controller - ֎෦͔ΒͷϦΫΤετΛड͚Δ
- ॲཧΛ Model ʹґཔͯ͠ɺ݁ՌΛड͚औΔ - ॲཧ݁ՌΛ View ʹͯ͠ɺग़ྗ݁ՌΛड͚औΔ - ग़ྗ݁ՌΛϨεϙϯεͱͯ͠ฦ٫͢Δ Model - ΞϓϦέʔγϣϯͱͯ͠ͷॲཧΛ୲͢Δ - DBΞΫηε֎෦αʔϏεͱͷΓऔΓ͜͜Ͱߦ͏ View - ॲཧ݁ՌΛͲͷΑ͏ʹΞτϓοτ͢Δ͔Λ୲͢Δ - HTMLͷੜɺJSONͷੜΛߦͬͨΓ͢Δ WebΞϓϦέʔγϣϯΛ࡞͢Δʹ͋ͨͬͯ 55 -
MVCύλʔϯͷಛ MVCύλʔϯଟ͘ͷϑϨʔϜϫʔΫʹ࠾༻͞Ε͍ͯΔͨΊԠ༻͍͢͠ - ࣮͢Δࡍʮ MVC ͷͲΕ͕୲͢Δ͔ʯͱ͍͏͜ͱͰཧ͍͢͠ - σΟϨΫτϦߏʢͲ͜ʹԿΛஔ͔͘ʣΈͷλωʹͳΓ͍͢ - ΄ͱΜͲͷϑϨʔϜϫʔΫσΟϨΫτϦߏ͕ܾ·͓ͬͯΓ
͜Εʹै࣮ͬͯ͢ΔͷͰ ʢൺֱతʣ ·ͳ͍ͰࡁΉ ҙ - MVCͷ୲ΛׂΓৼΔࡍɺͲ͏ͯ͠ᐆດͳ෦͕Ͱ͖ͯ͠·͏ - Controller, Model ͷͲͪΒ͔ͷ୲ൣғ͘ͳΓ͗͢Δ͕͋Δ WebΞϓϦέʔγϣϯΛ࡞͢Δʹ͋ͨͬͯ 56 -
ͳͥVSCodeΛ༻͢Δͷ͔ VSCodeΛ༻͠ͳ͍߹ɺҎԼͷΑ͏ͳ࡞ۀ͕ൃੜ͠·͢ɻ - ίϯιʔϧը໘ʹೖΓίϚϯυϥΠϯͰૢ࡞͢Δඞཁ͕͋Δ - ख͕ؒൃੜ͢Δ - ίϚϯυͷೖྗؒҧ͍Ͱ࡞ۀ͕ࢥ͏Α͏ʹਐ·ͳ͍ - viͳͲͷ͕ࣝඞཁ
- मਖ਼ՕॴΛ୳͢ͷ͕େม Remote-SSHͰαʔόʔʹΞΫηε͢Δ 63 -
Πϝʔδਤ - VSCodeΛ༻ͨ͠߹ Remote-SSHͰαʔόʔʹΞΫηε͢Δ खݩͷPCڥ ConoHa VPS ্ͷڥ SSH ଓ
Remote-SSH VSCodeͰฤू ؆୯ʂ 68 -
͜Ε͔Βߦ͏۩ମతͳखॱ 1. VSCodeʹ֦ுػೳ Remote-SSH ΛΠϯετʔϧ͢Δ 2. VSCode Remote-SSH ͷଓઃఆ a.
SSH Key ͷݖݶมߋ͢Δ b. VSCode Remote-SSH ʹଓઃఆΛՃ͢Δ Remote-SSHͰαʔόʔʹΞΫηε͢Δ 69 -
αʔόʔͷઃఆ͕ਖ਼͘͠Ͱ͖͍ͯΔ͔֬ೝ͠Α͏ Remote-SSHͰConoHa VPSʹΞΫηε͢Δ ࡞ۀ root@αʔόʔ໊ ͱදࣔ͞Ε͍ͯΔλʔϛφϧͰ࡞ۀ͠·͢ cd /var/www/html pwd #
͜ͷΑ͏ʹදࣔ͞Ε͍ͯΔ͜ͱΛ֬ೝ͍ͯͩ͘͠͞ /var/www/html ͠Τϥʔ͕ग़ͨΓɺ্هͷΑ͏ͳ݁Ռ͕දࣔ͞Εͳ͔ͬͨΒɺ VPSͷॳظઃఆ͕ؒҧ͍ͬͯΔՄೳੑ͕͋Γ·͢ɻ ݱࡏͷΠϯελϯεΛআͯ͠ɺ࠶VPSͷઃఆ͔ΒΓ͠·͠ΐ͏ɻ खΛڍ͛ͯڭ͍͍͑ͯͨͩͨΒϑΥϩʔ͠·͢ʂ -
18:40 ·Ͱ֤ࣗͰ࡞ۀΛ͠·͠ΐ͏ɻ Θ͔Βͳ͍͜ͱ͕͋ͬͨΒɺԕྀͳ͘zoomͷνϟοτʹʲ࣭ʳΛ͚ͭͯίϝϯτ͍ͯͩ͘͠͞ɻ ͦΕҎ֎ͷίϝϯτେৎͰ͢! Δ͜ͱ ɾVSCodeʹRemote-SSHΛΠϯετʔϧ ɾRemote-SSHʹConoHaαʔόʔͷઃఆΛొ ɾConoHaͷαʔόʔʹϩάΠϯ ֬ೝ ɾRemote-SSHͨ͋͠ͱͷλʔϛφϧͰ
ɹpwdͷ݁Ռ͕ਖ਼͘͠දࣔ͞Ε͍ͯΔ͜ͱ ࡞ۀλΠϜ Remote-SSHͰαʔόʔʹΞΫηε͢Δ ࡞ۀ 75 -
εέδϡʔϧͱ୲ʹ͍ͭͯ 2ʢ2021/05/13 10:30ʙ18:45ʣ Laravelʹ͍ͭͯ 1࣌ؒʢ10:30ʙ11:30ʣ kumak1 - Laravelͱʁ - Laravelͷศརػೳ
- LaravelͷσΟϨΫτϦߏ - LaravelͰͷॲཧͷྲྀΕΛ֬ೝ͢Δ ߨٛͷਐΊํʹ͍ͭͯ 78 -
εέδϡʔϧͱ୲ʹ͍ͭͯ 2ʢ2021/05/13 10:30ʙ18:45ʣ LaravelΛͬͯAPIΛ࡞͢Δ 6࣌ؒʢ11:40ʙ18:45ʣ endu - ΞϓϦέʔγϣϯΛηοτΞοϓ͠Α͏ - ΞϓϦέʔγϣϯΛϒϥβ͔ΒݟͯΈΑ͏
- APIͷCRUDΛ࣮͠Α͏ - ORMͷΑ· - ValidationΛ࣮͠Α͏ ߨٛͷਐΊํʹ͍ͭͯ 79 -
Laravelͷհ PHPͰॻ͔ΕͨϑϨʔϜϫʔΫ - ެࣜυΩϡϝϯτɹ https://laravel.com/ - ຊޠ༁·ͱΊαΠτ https://readouble.com/laravel/ όʔδϣϯʹ͍ͭͯ -
v1 20116݄ఏڙ։࢝ - ࠷৽όʔδϣϯ 8.Xʢ2021/4 ݱࡏʣ - ຖʹϝδϟʔόʔδϣϯΞοϓ - LTSʢLong Term SupportʣͷϦϦʔε2ຖ - όάϑΟοΫε2ؒܧଓ - ηΩϡϦςΟϑΟοΫε3ؒܧଓ ࠓճͷߨٛͰ Laravel 6.Xʢ࠷৽ͷLTSʣΛ༻͠·͢ɻ Laravelͱʁ 81 -
ϑϨʔϜϫʔΫͱ ໌ͷϋϯζΦϯͰ࡞͢ΔWebΞϓϦέʔγϣϯͰϑϨʔϜϫʔΫΛ ར༻͠·͢ɻ ϑϨʔϜϫʔΫʢWeb ΞϓϦέʔγϣϯϑϨʔϜϫʔΫʣ - ϞϊΛ࡞͢Δࡍɺ0 ͔Βશͯ࡞Δͷͱͯେม - ͱͯ͠Կׂ͔Ͱ͖͕͋ͬͨϞϊͷ্ʹॲཧΛՃ͢Δ͜ͱͰɺΞϓϦέʔγϣϯ·Ͱͷ
खؒΛগͳ͘͢ΔιϑτΣΞ - ϑϨʔϜϫʔΫຖʹϧʔϧ࡞๏͕͋Γɺ͜Εʹै͑ൺֱత؆୯ʹΞϓϦέʔγϣϯΛ ࡞Ͱ͖Δʢٯʹݴ͑ϑϨʔϜϫʔΫຖʹบ͕͋Γɺ߹Θͤͯ࡞Δඞཁ͕͋Δʣ ϥΠϒϥϦͱͷҧ͍ - ϥΠϒϥϦ͕ࣗ࡞͢ΔϓϩάϥϜ ͔Β ར༻͢Δ෦ - ಛผͳॲཧΛ؆୯ʹ࣮ݱͰ͖ΔΑ͏࡞͞Ε͓ͯΓɺ࠶࣮͢Δख͕ؒল͚Δ - ϑϨʔϜϫʔΫ͕ࣗ࡞͢ΔϓϩάϥϜ ͕ ར༻͞ΕΔ෦ ෮शʢϑϨʔϜϫʔΫͱʣ 82 -
ϑϨʔϜϫʔΫΛ͏ϝϦοτ ؆୯ʹɺ҆શʹɺ͘ॻ͘͜ͱ͕ՄೳʹͳΓ·͢ɻ - ن͕༻ҙ͞Ε͍ͯΔ - نʹఴ͏͜ͱͰ։ൃऀ͝ͱͷίʔσΟϯάͷόϥ͖͕͑ΒΕΔ - ίʔυ͕ߏԽ͞Ε͍ͯΔ - MVCύλʔϯɺϦϙδτϦύλʔϯͳͲ
- อकੑ্ - ศརͳϞϊ͕༻ҙ͞Ε͍ͯΔ - ίϚϯυϥΠϯΠϯλʔϑΣΠεɺORMͳͲ - ։ൃεϐʔυΞοϓ Laravelͱʁ 84 -
ϑϨʔϜϫʔΫΛ͏σϝϦοτ - ֶशίετ͕૿͑Δ - ϑϨʔϜϫʔΫͷ͓࡞๏ͷशಘ͕ඞཁʢݴޠͷ͓࡞๏ͱผʹʣ - ྫɿίϚϯυϥΠϯΠϯλʔϑΣΠεɺORMͷه๏ɺϧʔςΟϯάͳͲ - ϑϨʔϜϫʔΫͷࣝʹภͬͯ͠·͏ -
ࡉ͔͍ΈΛཧղͤͣʹΞϓϦέʔγϣϯ͕࡞Εͯ͠·͏ͷͰ ϒϥοΫϘοΫεԽ͍͢͠ - ΧελϚΠζͮ͠Β͍ʢεΫϥονͱൺʣ - ΞϓϦέʔγϣϯͷنʹରͯ͠ʹͳΔ߹͕͋Δ Laravelͱʁ 85 -
Artisan ʹ͍ͭͯ LaravelͷίϚϯυϥΠϯΠϯλʔϑΣΠε - https://readouble.com/laravel/6.x/ja/artisan.html - Artisan = ৬ਓͱ͍͏ҙຯ ʮphp
artisan xxxʯͱ͍͏ه๏Ͱ༷ʑͳίϚϯυΛ࣮ߦͰ͖Δ LaravelͷศརػೳͷҰྫ 87 -
LaravelͷศརػೳͷҰྫ 88 ArtisanίϚϯυ ॲཧ༰ php artisan -v Laravelͷόʔδϣϯͷ֬ೝ php artisan
list ίϚϯυҰཡΛ֬ೝͰ͖Δ php artisan <࣮ߦίϚϯυ> -h ίϚϯυͷ͍ํΛ֬ೝͰ͖Δ php artisan make:controller FooController FooίϯτϩʔϥʔΛ࡞͢Δ php artisan make:model Foo FooϞσϧΛ࡞͢Δ php artisan make:migration create_tests_table --create=tests create_tests_table=ϑΝΠϧ໊ɺtests=ςʔϒϧ໊ͰϚΠά ϨʔγϣϯϑΝΠϧΛ࡞͢Δ php artisan migrate ϚΠάϨʔγϣϯͷ࣮ߦ php artisan migrate:rollback ϚΠάϨʔγϣϯͷϩʔϧόοΫ php artisan route:list ϧʔςΟϯάͷҰཡΛදࣔ php artisan tinker REPLͷىಈʢͪΐͬͱͨ͠σόοάͱ͔ʹศརʣ -
ϚΠάϨʔγϣϯʹ͍ͭͯ ҠಈɾҠߦͱ͍͏ҙຯʢwikipediaΑΓҾ༻ʣ - ͜͜ͰσʔλϕʔεϚΠάϨʔγϣϯͷ͜ͱ - DBʹอଘ͞Ε͍ͯΔσʔλΛอ࣋ͨ͠··ɺςʔϒϧͷ࡞ΧϥϜͷมߋͳͲΛߦ͏ͨΊͷػೳ ϚΠάϨʔγϣϯͷϝϦοτ - SQLจΛ࡞࣮ͯ͠ߦ͠ͳͯ͘ɺ؆୯ʹςʔϒϧΛఆٛͰ͖Δ -
ςʔϒϧͷઃܭΛίʔυͰཧͰ͖ΔʢϚΠάϨʔγϣϯϑΝΠϧʣ - σʔλϕʔεઃఆ͕όʔδϣϯϑΝΠϧʹΑΓཧ͞ΕΔ - ෳਓͰͷ։ൃ࡞ۀΓ͘͢ͳΔ LaravelͷศརػೳͷҰྫ 89 -
.envϑΝΠϧʹ͍ͭͯ - ΞϓϦέʔγϣϯͰ͏֤छઃఆؚ͕·ΕΔ - σʔλϕʔεͷଓઃఆ - ΞϓϦέʔγϣϯݻ༗ͷڥมʢAPP_KEYͳͲʣ - ։ൃڥຊ൪ڥͷΓସ͑ -
Ϧετͨ͠PHPͷεʔύʔάϩʔόϧมϩʔυ͞ΕΔ - ൿಗใͳͲΛ֎෦͔ΒΞΫηεͰ͖ͳ͍ܗͰอ࣋Ͱ͖Δ .envϑΝΠϧGitHubͳͲʹΞοϓϩʔυ͍͚ͯ͠·ͤΜ LaravelͷศརػೳͷҰྫ 90 -
σΟϨΫτϦͷߏͷҰ෦ MVCͷσΟϨΫτϦ - app/Http/ ModelͷϑΝΠϧؚ͕·ΕΔ - app/Http/Controller/ ControllerͷϑΝΠϧؚ͕·ΕΔ - app/resources/views/
ViewͷϑΝΠϧؚ͕·ΕΔ ͦͷଞͷσΟϨΫτϦ - app/Console/Commands/ ArtisanͷಠࣗΧελϜίϚϯυ - routes/ɹ ϧʔτఆٛϑΝΠϧ - database/ DBͷϚΠάϨʔγϣϯɾॳظઃఆϑΝΠϧͳͲ - tests/ɹ ςετ - vendor/ɹ ϥΠϒϥϦͳͲʢcomposer ʹΑΔґଘύοέʔδղܾʣ ※ϑϨʔϜϫʔΫͷछྨʹΑͬͯߏҟͳΓ·͢ɻ ɹ·ͨɺόʔδϣϯʹΑͬͯҟͳΔ߹͕͋Γ·͢ɻ LaravelͷσΟϨΫτϦߏ 93 -
MVCύλʔϯ MVCύλʔϯ (Model-View-Controller ύλʔϯ) - ModelɺViewɺController ͷ3ͭͷύʔπͰΞϓϦέʔγϣϯΛ࡞Δߟ͑ํ Controller - ֎෦͔ΒͷϦΫΤετΛड͚Δ
- ॲཧΛ Model ʹґཔͯ͠ɺ݁ՌΛड͚औΔ - ॲཧ݁ՌΛ View ʹͯ͠ɺग़ྗ݁ՌΛड͚औΔ - ग़ྗ݁ՌΛϨεϙϯεͱͯ͠ฦ٫͢Δ Model - ΞϓϦέʔγϣϯͱͯ͠ͷॲཧΛ୲͢Δ - DBΞΫηε֎෦αʔϏεͱͷΓऔΓ͜͜Ͱߦ͏ View - ॲཧ݁ՌΛͲͷΑ͏ʹΞτϓοτ͢Δ͔Λ୲͢Δ - HTMLͷੜɺJSONͷੜΛߦͬͨΓ͢Δ MVCύλʔϯͷ෮श 95 -
MVCύλʔϯͷಛ MVCύλʔϯ ଟ͘ͷϑϨʔϜϫʔΫʹ࠾༻͞Ε͍ͯΔͨΊԠ༻͍͢͠ - ࣮͢Δࡍʮ MVC ͷͲΕ͕୲͢Δ͔ʯͱ͍͏͜ͱͰཧ͍͢͠ - σΟϨΫτϦߏʢͲ͜ʹԿΛஔ͔͘ʣΈͷλωʹͳΓ͍͢ -
΄ͱΜͲͷϑϨʔϜϫʔΫσΟϨΫτϦߏ͕ܾ·͓ͬͯΓ ͜Εʹै࣮ͬͯ͢ΔͷͰʢൺֱతʣ·ͳ͍ͰࡁΉ ҙ - MVCͷ୲ΛׂΓৼΔࡍɺͲ͏ͯ͠ᐆດͳ෦͕Ͱ͖ͯ͠·͏ - Controller, Model ͷͲͪΒ͔ͷ୲ൣғ͘ͳΓ͗͢Δ͕͋Δ →͔࣍ΒɺLaravelͰMVCΛݟ͍͖ͯ·͢ 96 MVCύλʔϯͷ෮श -
Model ECγϣοϓ͔ΒͷҰཡσʔλΛऔಘ͍ͨ͠߹ͷྫ 100 ॲཧͷྲྀΕΛMVCʹԊͬͯݟͯΈΑ͏ Route DB View ᶃ ᶄ ᶅ
ᶆ ᶇ ᶈ ᶉ Controller -
Model ECγϣοϓ͔ΒͷҰཡσʔλΛऔಘ͍ͨ͠߹ͷྫ 102 ॲཧͷྲྀΕΛMVCʹԊͬͯݟͯΈΑ͏ Route DB View ᶄ ᶅ ᶆ
ᶇ ᶈ ᶉ Controller ControllerଆͰʮͷҰཡΛ औಘ͢ΔʯॲཧΛݺͼग़͠·͢ ᶃ -
Model ECγϣοϓ͔ΒͷҰཡσʔλΛऔಘ͍ͨ͠߹ͷྫ 103 ॲཧͷྲྀΕΛMVCʹԊͬͯݟͯΈΑ͏ Route DB View ᶃ ᶄ ᶅ
ᶆ ᶇ ᶈ ᶉ Controller DB͔ΒσʔλΛऔಘ͍ͨ͠ͷͰ Ϟσϧʹॲཧ͕ҠΓ·͢ -
Model ECγϣοϓ͔ΒͷҰཡσʔλΛऔಘ͍ͨ͠߹ͷྫ 104 ॲཧͷྲྀΕΛMVCʹԊͬͯݟͯΈΑ͏ Route DB View ᶃ ᶄ ᶅ
ᶆ ᶇ ᶈ ᶉ Controller Modelܦ༝ͰDB͔Βඞཁͳ σʔλΛऔಘ͠·͢ -
Model ECγϣοϓ͔ΒͷҰཡσʔλΛऔಘ͍ͨ͠߹ͷྫ 105 ॲཧͷྲྀΕΛMVCʹԊͬͯݟͯΈΑ͏ Route DB View ᶃ ᶄ ᶅ
ᶆ ᶇ ᶈ ᶉ Controller ड͚औͬͨσʔλΛ Controllerʹฦ͠·͢ -
Model ECγϣοϓ͔ΒͷҰཡσʔλΛऔಘ͍ͨ͠߹ͷྫ 106 ॲཧͷྲྀΕΛMVCʹԊͬͯݟͯΈΑ͏ Route DB View ᶃ ᶄ ᶅ
ᶆ ᶇ ᶈ ᶉ Controller σʔλΛViewʹͯ͠ ϨεϙϯεͰฦ͢ܗʹՃ͠·͢ -
Model ECγϣοϓ͔ΒͷҰཡσʔλΛऔಘ͍ͨ͠߹ͷྫ 107 ॲཧͷྲྀΕΛMVCʹԊͬͯݟͯΈΑ͏ Route DB View ᶃ ᶄ ᶅ
ᶆ ᶇ ᶈ ᶉ Controller Controller͔ΒϨεϙϯεΛ ΫϥΠΞϯτʹฦ͠·͢ -
Model ECγϣοϓ͔ΒͷҰཡσʔλΛऔಘ͍ͨ͠߹ͷྫ 108 ॲཧͷྲྀΕΛMVCʹԊͬͯݟͯΈΑ͏ Route DB View ᶃ ᶄ ᶅ
ᶆ ᶇ ᶈ ᶉ Controller MVCύλʔϯͷྲྀΕ -
LaravelͷσΟϨΫτϦͷߏͷҰ෦ MVCͷσΟϨΫτϦ - app/Http/ ModelͷϑΝΠϧؚ͕·ΕΔʢॾઆ͋Δʣ - app/Http/Controller/ ControllerͷϑΝΠϧؚ͕·ΕΔ - app/resources/views/
ViewͷϑΝΠϧؚ͕·ΕΔ ͦͷଞͷσΟϨΫτϦ - app/Console/Commands/ ArtisanͷಠࣗΧελϜίϚϯυ - routes/ɹ ϧʔτఆٛϑΝΠϧ - database/ DBͷϚΠάϨʔγϣϯɾॳظઃఆϑΝΠϧͳͲ - tests/ɹ ςετ - vendor/ɹ ϥΠϒϥϦͳͲʢcomposer ʹΑΔґଘύοέʔδղܾʣ →ઌఔͷॲཧͷྲྀΕʹɺσΟϨΫτϦΛରԠͤͯ͞Έ·͠ΐ͏ LaravelͷσΟϨΫτϦߏͷ͓͞Β͍ 109 -
λʔϛφϧͰΑ͘͏ίϚϯυ λʔϛφϧ্ͰσΟϨΫτϦΛҠಈͨ͠Γ͠·͢ɻ ͦͷͨΊʹ͓͖ͬͯ͘ίϚϯυΛࡌ͓͖ͤͯ·͢ɻ ଞʹΦϓγϣϯͳͲ͋Γ·͕͢ɺຊߨٛͰ͜ͷ4ͭͷίϚϯυΛ͏ͱ ͓͍͍֮͑ͯͯͩ͘͞ɻ ߨٛͷਐΊํʹ͍ͭͯ 116 cd # σΟϨΫτϦҠಈ
cd .. # 1্ͭͷσΟϨΫτϦ֊ʹΔ ls # ϑΝΠϧҰཡΛදࣔ pwd # ݱࡏͷσΟϨΫτϦΛදࣔ -
1ͰઌʹɺΞϓϦέʔγϣϯηοτΞοϓΛߦͬͨํ ࡞ۀ ※ಈըͰઆ໌͕ͳ͍Ͱ͢ # masterʹ࠷৽Λ͢Δ git pull # ࠶ make
setup/conoha Λ࣮ߦ make setup/conoha ΞϓϦέʔγϣϯΛηοτΞοϓ͠Α͏ -
12:00 ·Ͱ֤ࣗͰ࡞ۀΛ͠·͠ΐ͏ɻ Θ͔Βͳ͍͜ͱ͕͋ͬͨΒɺԕྀͳ͘zoomͷνϟοτʹʲ࣭ʳΛ͚ͭͯίϝϯτ͍ͯͩ͘͠͞ɻ ͦΕҎ֎ͷίϝϯτେৎͰ͢! Δ͜ͱ ɾgit ͷΠϯετʔϧ ɾڭࡐͷμϯϩʔυ ɾΞϓϦέʔγϣϯͷηοτΞοϓ ֬ೝ
ɾΞϓϦέʔγϣϯ͕ϒϥβͰݟΕΔ͜ͱ ࡞ۀλΠϜ ΞϓϦέʔγϣϯΛηοτΞοϓ͠Α͏ ࡞ۀ 121 -
ConoHa VPSʹڭࡐΛμϯϩʔυ͠Α͏ ࡞ۀ git ΛΠϯετʔϧ͠·͢ɻ sudo yum -y install git
# git͕Πϯετʔϧ͞Ε͍ͯΔ͜ͱΛ֬ೝ͠·͢ git --version # ޭ git version 1.8.3.1 ΞϓϦέʔγϣϯΛηοτΞοϓ͠Α͏ -
ConoHa VPSʹڭࡐΛμϯϩʔυ͠Α͏ ΞϓϦέʔγϣϯΛηοτΞοϓ͠Α͏ ࡞ۀ μϯϩʔυͨ͠ڭࡐͷσΟϨΫτϦʹҠಈ͠·͢ɻ σΟϨΫτϦΛҠಈɾڭࡐΛμϯϩʔυ͠·͢ɻ cd /var/www/html git clone
https://github.com/tosite/gtb-web-application-framework.git cd /var/www/html/gtb-web-application-framework pwd # ͜ͷΑ͏ʹදࣔ͞Ε͍ͯΔ͜ͱΛ֬ೝ͍ͯͩ͘͠͞ /var/www/html/gtb-web-application-framework ͠ cd /var/www/html ͰΤϥʔ͕ͰͨΒVPSͷॳظઃఆ͕ؒҧ͍ͬͯΔՄೳੑ͕͋ΔͷͰ खΛڍ͛ͯڭ͍͑ͯͩ͘͞ -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ σʔλΛશදࣔ API TesterΛͬͯΈΑ͏ 133 Selected Method get Uri /api/comments
Parameters ͳ͠ ֬ೝ 200 ʢσʔλදࣔʹޭʣ -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ POSTͰϦΫΤετ͢Δͱࣦഊ͢Δ͔֬ೝ͠Α͏ API TesterΛͬͯΈΑ͏ 137 Selected Method post Uri /api/comments
Parameters name: ࣗ༝ content: ࣗ༝ ֬ೝ -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ POSTͰϦΫΤετ͢Δͱࣦഊ͢Δ͔֬ೝ͠Α͏ API TesterΛͬͯΈΑ͏ 138 Selected Method post Uri /api/comments
Parameters name: ࣗ༝ content: ࣗ༝ ֬ೝ 405 Τϥʔ -
routes/api.phpΛVSCodeͰ։͍ͯΈΑ͏ɻ CRUDͷCreate - ϧʔςΟϯάʹՃ͢Δ APIͷCRUDΛ࣮͠Α͏ 145 ֬ೝ <?php use Illuminate\Http\Request;
Route::middleware('api')->group(function () { Route::delete('logs', function () { exec(': > ../storage/logs/laravel.log'); }); Route::get('comments', 'CommentController@index'); Route::post('comments', 'CommentController@store'); }); -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ CRUDͷCreate - Ϩεϙϯε͕ฦͬͯ͘Δ͔֬ೝ APIͷCRUDΛ࣮͠Α͏ 146 Selected Method post Uri
/api/comments Parameters name: ࣗ༝ content: ࣗ༝ ֬ೝ -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ CRUDͷCreate - Ϩεϙϯε͕ฦͬͯ͘Δ͔֬ೝ APIͷCRUDΛ࣮͠Α͏ 147 Selected Method post Uri
/api/comments Parameters name: ࣗ༝ content: ࣗ༝ ֬ೝ 200 ʢϧʔςΟϯάʹޭʣ -
ҎԼͷΤϥʔ͕ग़ͨ߹ɺParameters͕ෆదͳՄೳੑ͕ߟ͑ΒΕ·͢ɻ ۭͰͳ͍͜ͱΛ֬ೝͯ͠࠶࣮ߦ͍ͯͩ͘͠͞ɻ CRUDͷCreate - Ϩεϙϯε͕ฦͬͯ͘Δ͔֬ೝ APIͷCRUDΛ࣮͠Α͏ 148 Selected Method post
Uri /api/comments Parameters name: ۭ content: ۭ ֬ೝ 422 Τϥʔ -
λʔϛφϧͰartisanίϚϯυΛ࣮ߦͯ͠Έ·͠ΐ͏ɻ Model{Ϟσϧ໊}.phpͱ͍͏ϑΝΠϧ໊Ͱ࡞͞Ε·͢ɻ Comment Model Λ artisan ίϚϯυͰ࡞ APIͷCRUDΛ࣮͠Α͏ 151 pwd
# ͜Ε͕දࣔ͞ΕΔ͜ͱΛ֬ೝ͍ͯͩ͘͠͞ /var/www/html/gtb-web-application php artisan make:model Comment # ޭ Model created successfully. ࡞ۀ -
Model ECγϣοϓ͔ΒͷҰཡσʔλΛऔಘ͍ͨ͠߹ͷྫ 153 MVCύλʔϯͷಛʢ෮शʣ Route DB View ᶃ ᶄ ᶅ
ᶆ ᶇ ᶈ ᶉ Controller MVCύλʔϯͷྲྀΕ -
Modelʹ$fillableΛՃͯ͠nameͱcontentΛՃ͠·͢ɻ app/Comment.phpΛVSCodeͰ։͍ͯΈ·͠ΐ͏ɻ Model ʹ $fillable ΛՃ͢Δ APIͷCRUDΛ࣮͠Α͏ 154 <?php namespace
App; use Illuminate\Database\Eloquent\Model; class Comment extends Model { protected $fillable = [ 'name', 'content', ]; } ࡞ۀ -
app/Http/Controllers/CommentController.phpΛVSCodeͰ։͍ͯΈ·͠ΐ͏ɻ CRUDͷCreate - ControllerʹstoreͷॲཧΛՃ APIͷCRUDΛ࣮͠Α͏ 155 public function store(\App\Http\Requests\Comments\Post $request)
{ $comment = Comment::create([ 'name' => $request->input('name'), 'content' => $request->input('content'), ]); return response()->json($comment, 201); } ࡞ۀ -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ CRUDͷCreate - ࠶࣮ߦ APIͷCRUDΛ࣮͠Α͏ 156 Selected Method post Uri
/api/comments Parameters name: ࣗ content: ࣗ༝ ֬ೝ 201 ʢDBʹϨίʔυՃʣ -
14:45 ·Ͱ֤ࣗͰ࡞ۀΛ͠·͠ΐ͏ɻ Θ͔Βͳ͍͜ͱ͕͋ͬͨΒɺԕྀͳ͘zoomͷνϟοτʹʲ࣭ʳΛ͚ͭͯίϝϯτ͍ͯͩ͘͠͞ɻ ͦΕҎ֎ͷίϝϯτେৎͰ͢! Δ͜ͱ ɾCommentϞσϧΛ࡞͢Δ ɾ$fillableͰΧϥϜߋ৽ͷڐՄΛઃఆ͢Δ ɾσʔλΛొ͢ΔॲཧΛՃ͢Δ ɾAPIςελʔͰ࠶ͼPOSTϦΫΤετΛૹΔ ֬ೝ
ɾεςʔλε201͕ฦͬͯ͘Δ͜ͱ ɾύϥϝʔλ͕ݟΕΔ͜ͱʢidΛ߇͓͑ͯ͘ʣ ࡞ۀλΠϜ APIͷCRUDΛ࣮͠Α͏ ࡞ۀ 159 -
routes/api.phpΛVSCodeͰ։͍ͯΈ·͠ΐ͏ɻ CRUDͷRead - ϧʔςΟϯάʹՃ͢Δ APIͷCRUDΛ࣮͠Α͏ 161 <?php use Illuminate\Http\Request; Route::middleware('api')->group(function
() { Route::delete('logs', function () { exec(': > ../storage/logs/laravel.log'); }); Route::get('comments', 'CommentController@index'); Route::post('comments', 'CommentController@store'); Route::get('comments/{comment}', 'CommentController@show'); }); ࡞ۀ -
࡞ۀ app/Http/Controllers/CommentController.phpΛVSCodeͰ։͍ͯΈ·͠ΐ͏ɻ CRUDͷRead - ControllerʹshowͷॲཧΛՃ APIͷCRUDΛ࣮͠Α͏ 162 public function show($id)
{ return Comment::findOrFail($id); } -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ {id}ʹઌ΄Ͳ߇͑ͨidΛೖྗ͠·͢ɻ CRUDͷRead - Ϩεϙϯε͕ฦͬͯ͘Δ͔֬ೝ APIͷCRUDΛ࣮͠Α͏ 163 Selected Method get
Uri /api/comments/ {id} Parameters ͳ͠ ࡞ۀ -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ {id}ʹઌ΄Ͳ߇͑ͨidΛೖྗ͠·͢ɻ CRUDͷRead - Ϩεϙϯε͕ฦͬͯ͘Δ͔֬ೝ APIͷCRUDΛ࣮͠Α͏ 164 Selected Method get
Uri /api/comments/ {id} Parameters ͳ͠ ࡞ۀ 200 Createͨ͠σʔλ͕ දࣔ͞ΕΔ -
15:10·Ͱ֤ࣗͰ࡞ۀΛ͠·͠ΐ͏ɻ Θ͔Βͳ͍͜ͱ͕͋ͬͨΒɺԕྀͳ͘zoomͷνϟοτʹʲ࣭ʳΛ͚ͭͯίϝϯτ͍ͯͩ͘͠͞ɻ ͦΕҎ֎ͷίϝϯτେৎͰ͢! Δ͜ͱ ɾࢦఆͨ͠idͷίϝϯτΛදࣔ͢ΔͨΊͷ ɹϧʔςΟϯάͱॲཧΛՃ͢Δ ɾࢦఆͨ͠idͷίϝϯτΛදࣔ͢ΔGET ɹϦΫΤετΛૹΔ ֬ೝ ɾεςʔλε200͕ฦͬͯ͘Δ͜ͱ
ɾࢦఆͨ͠idͷσʔλ͕֬ೝͰ͖Δ͜ͱ ࡞ۀλΠϜ APIͷCRUDΛ࣮͠Α͏ ࡞ۀ 166 -
routes/api.phpΛVSCodeͰ։͍ͯΈ·͠ΐ͏ɻ CRUDͷUpdate - ϧʔςΟϯάʹՃ APIͷCRUDΛ࣮͠Α͏ 170 <?php use Illuminate\Http\Request; Route::middleware('api')->group(function
() { Route::delete('logs', function () { exec(': > ../storage/logs/laravel.log'); }); Route::get('comments', 'CommentController@index'); Route::post('comments', 'CommentController@store'); Route::get('comments/{comment}', 'CommentController@show'); Route::put('comments/{comment}', 'CommentController@update'); }); ࡞ۀ -
CRUDͷUpdate - ControllerʹupdateͷॲཧΛՃ app/Http/Controllers/CommentController.phpΛVSCodeͰ։͍ͯΈ·͠ΐ͏ɻ APIͷCRUDΛ࣮͠Α͏ 171 public function update(\App\Http\Requests\Comments\Put $request,
$id) { $comment = Comment::findOrFail($id); $comment->update([ 'name' => $request->input('name') ?: $comment->name, 'content' => $request->input('content') ?: $comment->content, ]); return response()->json($comment, 200); } ࡞ۀ -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ CRUDͷUpdate - ࣮ߦ APIͷCRUDΛ࣮͠Α͏ 172 Selected Method put/patch Uri
/api/comments/ {id} Parameters name: ࣗ༝ ࡞ۀ -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ CRUDͷUpdate - ࣮ߦ APIͷCRUDΛ࣮͠Α͏ 173 Selected Method put/patch Uri
/api/comments/ {id} Parameters name: ࣗ༝ ࡞ۀ 200 name͕ߋ৽͞ΕΔ -
15:45 ·Ͱ֤ࣗͰ࡞ۀΛ͠·͠ΐ͏ɻ Θ͔Βͳ͍͜ͱ͕͋ͬͨΒɺԕྀͳ͘zoomͷνϟοτʹʲ࣭ʳΛ͚ͭͯίϝϯτ͍ͯͩ͘͠͞ɻ ͦΕҎ֎ͷίϝϯτେৎͰ͢! Δ͜ͱ ɾߋ৽ͷϧʔςΟϯάΛՃ͢Δ ɾߋ৽ͷॲཧΛՃ͢Δ ɾAPIςελʔͰࢦఆͨ͠idͷ༰Λมߋ͢Δ ϦΫΤετΛૹΔ ֬ೝ
ɾεςʔλε200͕ฦͬͯ͘Δ͜ͱ ɾมߋͷ༰͕֬ೝͰ͖Δ͜ͱ ࡞ۀλΠϜ APIͷCRUDΛ࣮͠Α͏ ࡞ۀ 175 -
routes/api.phpΛVSCodeͰ։͍ͯΈ·͠ΐ͏ɻ CRUDͷDelete - ϧʔςΟϯάʹՃ APIͷCRUDΛ࣮͠Α͏ 177 <?php use Illuminate\Http\Request; Route::middleware('api')->group(function
() { Route::delete('logs', function () { exec(': > ../storage/logs/laravel.log'); }); Route::get('comments', 'CommentController@index'); Route::post('comments', 'CommentController@store'); Route::get('comments/{comment}', 'CommentController@show'); Route::put('comments/{comment}', 'CommentController@update'); Route::delete('comments/{comment}', 'CommentController@destroy'); }); ࡞ۀ -
app/Http/Controllers/CommentController.phpΛVSCodeͰ։͍ͯΈ·͠ΐ͏ɻ CRUDͷDelete - ControllerʹdestroyͷॲཧΛՃ APIͷCRUDΛ࣮͠Α͏ 178 public function destroy($id) {
Comment::findOrFail($id)->delete(); return response()->noContent(); } ࡞ۀ -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ CRUDͷDelete - ࣮ߦ APIͷCRUDΛ࣮͠Α͏ 179 Selected Method delete Uri
/api/comments/ {id} Parameters ͳ͠ ࡞ۀ -
16:05 ·Ͱ֤ࣗͰ࡞ۀΛ͠·͠ΐ͏ɻ Θ͔Βͳ͍͜ͱ͕͋ͬͨΒɺԕྀͳ͘zoomͷνϟοτʹʲ࣭ʳΛ͚ͭͯίϝϯτ͍ͯͩ͘͠͞ɻ ͦΕҎ֎ͷίϝϯτେৎͰ͢! Δ͜ͱ ɾআͷϧʔςΟϯάΛՃ͢Δ ɾআͷॲཧΛՃ͢Δ ɾAPIςελʔͰࢦఆͨ͠idͷσʔλΛআ͢Δ ɹϦΫΤετΛૹΔ ֬ೝ
ɾεςʔλε204͕ฦͬͯ͘Δ͜ͱ ɾidΛࢦఆͯ͠GETͯ͠ݟΕͳ͍͜ͱ ࡞ۀλΠϜ APIͷCRUDΛ࣮͠Α͏ ࡞ۀ 181 -
app/Http/Controllers/CommentController.php ΛVSCodeͰ։͍ͯΈ·͠ΐ͏ɻ CRUDͷRead - ControllerʹshowͷॲཧΛՃ APIͷCRUDΛ࣮͠Α͏ 183 public function index()
{ return [ ['name' => 'tom', 'content' => 'hello'], ['name' => 'sam', 'content' => 'world'], ]; return Comment::all(); } ࡞ۀ -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ CRUDͷRead - API࣮ߦ APIͷCRUDΛ࣮͠Α͏ 184 Selected Method get Uri
/api/comments Parameters ͳ͠ ֬ೝ -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ CRUDͷRead - API࣮ߦ APIͷCRUDΛ࣮͠Α͏ 185 Selected Method get Uri
/api/comments Parameters ͳ͠ ֬ೝ 200 σʔλ͕දࣔ͞ΕΔ -
16:15 ·Ͱ֤ࣗͰ࡞ۀΛ͠·͠ΐ͏ɻ Θ͔Βͳ͍͜ͱ͕͋ͬͨΒɺԕྀͳ͘zoomͷνϟοτʹʲ࣭ʳΛ͚ͭͯίϝϯτ͍ͯͩ͘͠͞ɻ ͦΕҎ֎ͷίϝϯτେৎͰ͢! Δ͜ͱ ɾίϝϯτҰཡΛऔಘ͢ΔॲཧΛՃ͢Δ ɾAPIςελʔͰҰཡΛऔಘ͢ΔϦΫΤετΛ ɹૹΔ ֬ೝ ɾεςʔλε200͕ฦͬͯ͘Δ͜ͱ
ɾίϝϯτҰཡ͕ݟΕΔ͜ͱ ࡞ۀλΠϜ APIͷCRUDΛ࣮͠Α͏ ࡞ۀ 187 -
ORMͱObject-Relational MappingͷུশͰ͢ɻ LaravelͰEloquentͱݺΕΔORM͕ΘΕ͍ͯ·͢ɻ RailsͰActive Record͕ΘΕ͍ͯ·͢ɻ ࢼ͠ʹapp/Http/Controllers/CommentController.php ΛVSCodeͰ։͍ͯΈ·͠ΐ͏ɻ ͜͜ͰCommentΫϥε͕ORMͷׂΛՌ͍ͨͯ͠·͢ɻ ࢀߟࢿྉ:ʮEloquent:ར༻ͷ։࢝ʯhttps://readouble.com/laravel/6.x/ja/eloquent.html ORMʹ͍ͭͯ؆୯ʹհ
ORMͷΑ· 190 public function show($id) { return Comment::findOrFail($id); } -
σʔλΛऔಘ͢Δ߹ͷྫ(SELECT) ҎԼಉٛͰ͢ɻ SQLΛॻ͔ͣײతʹDBΛૢ࡞Ͱ͖Δ ORMͷΑ· 192 SELECT * FROM comments; SELECT
* FROM comments where id = 1; App\Comment::all(); App\Comment::where(‘id’, 1)->get(); SQL ORM -
σʔλΛՃ͢Δ߹ͷྫ(INSERT) ҎԼಉٛͰ͢ɻ SQLΛॻ͔ͣײతʹDBΛૢ࡞Ͱ͖Δ ORMͷΑ· 193 INSERT INTO comments VALUE (
name = ‘tosite’, content = ‘body text’, email = ‘[email protected]’ ); $params = [name => ‘tosite’, content => ‘body text’, email => ‘[email protected]’,]; (new Comments())->fill($params)->save(); SQL ORM -
app/Http/Controllers/CommentController.php ΛVSCodeͰ։͍ͯΈ·͠ΐ͏ɻ findOrFailϝιου֘͢ΔϨίʔυ͕ݟ͔ͭΒͳ͍࣌ɺࣗಈͰ404 HTTPϨεϙϯεΛฦͯ͘͠Ε·͢ɻ ͳͷͰ͜ͷϝιουΛ༻͢ΕΘ͟Θ͟໌֬ʹ404ϨεϙϯεΛฦ͢ίʔυΛॻ͘ඞཁ͋Γ·ͤΜɻ ͜ͷ߹API TesterͰଘࡏ͠ͳ͍IDΛࢦఆͯ͠ϦΫΤετΛ͢ΔͱࣗಈͰ404͕ฦ͖ͬͯ·͢ɻ findOrFail ORMͷΑ· 194
public function show($id) { return Comment::findOrFail($id); } ORM -
UserϞσϧͱCommentϞσϧ͕1ରNͷؔʹͳ͍ͬͯΔͱԾఆ͠·͢ɻ (※commentsςʔϒϧʹuser_idΛอ͍࣋ͯ͠Δ߹) ϦϨʔγϣϯΛͬͨૢ࡞ָ͕ ORMͷΑ· 196 User hasOne = 1:1 hasMany
= 1:N belongsTo = N:1 belongsToMany = N:N Comment Comment Comment User has many Comments -
UserϞσϧͱCommentϞσϧ͕1ରNͷؔʹͳ͍ͬͯΔͱԾఆ͠·͢ɻ (※commentsςʔϒϧʹuser_idΛอ͍࣋ͯ͠Δ߹) ϦϨʔγϣϯΛͬͨૢ࡞ָ͕ ORMͷΑ· 197 class User extends Model {
public function comments() { return $this->hasMany('App\Comment'); } } -
σʔλΛऔಘ͢Δ߹ͷྫ(SELECT) ҎԼಉٛͰ͢ɻ ϦϨʔγϣϯΛͬͨૢ࡞ָ͕ ORMͷΑ· 198 SELECT * FROM users LEFT
JOIN commnets ON comments.user_id = users.user_id User::comments(); SQL ORM -
※͘৭Λ͚͍ͯΔ෦ʹ੬ऑੑ͕જΜͰ͍·͢ɻ ηΩϡϦςΟରࡦ ORMͷΑ· 199 $res = pg_query( $dbconn, “select *
from users where id = ‘{$_POST[‘id’]}’ and password = ‘{$_POST[‘password’]}’”, ); Users::where(‘id’, $_POST[‘id’])->where(‘password’, $_POST[‘password’])->get(); SQL + PHP ORM -
ઌ΄ͲͷྫΛݩʹߟ͑ͯΈ·͠ΐ͏ɻ ΩʔϫʔυʮϢʔβʔ͔ΒͷೖྗΛશ໘తʹ৴͡Δͱ௧͍ʹૺ͏ʯͰ͢ɻ ͜ͷΑ͏ʹSQLΛվม͢Δ߈ܸΛʮSQLΠϯδΣΫγϣϯ߈ܸʯͱݴ͍·͢ɻ ηΩϡϦςΟରࡦ ORMͷΑ· 201 # ϩάΠϯ࣌ͷೝূͰ༻͢ΔSQLจΛ࣍ͷΑ͏ʹ࡞͍ͯͨ͠ͱ͢Δ $res =
pg_query( $dbconn, “select * from users where id = ‘{$_POST[‘id’]}’ and password = ‘{$_POST[‘password’]}”, ); # Ծʹ$_POST[‘id’]ʹʮ' or '1' = '1';-- ʯͱ͍͏͕͞Εͨ߹ɺҎԼͷΫΤϦ͕ൃߦ͞ΕΔ # ҎԼͷΫΤϦ৭ͷ෦͕ඞཱͣͯ͠͠·͏ͨΊɺશϢʔβʔͷใΛݕࡧͰ͖Δ SELECT * FROM users WHERE id = ‘’ or ‘1’ = ‘1’;-- ’ and password = ‘foo’; SQL + PHP -
ͰSQLΠϯδΣΫγϣϯΛͲͷΑ͏ʹ͙ͷ͔ʁΛݟͯΈ·͠ΐ͏ɻ େͳͷʮϓϦϖΞυεςʔτϝϯτʯΛར༻͢Δͱ͍͏͜ͱͰ͢ɻ ϓϦϖΞυεςʔτϝϯτΛ͏ϝϦοτ - σʔλϕʔεʹ४උ͞Ε͍ͯΔػೳͰɺSQLจͷΈཱͯࢧԉΛߦͬͯ͘ΕΔ - SQLจͷՄม෦Λൈ͖ग़ͯ͠ɺͦ͜ʹରͯ͠ͷઃఆΛߦ͏͜ͱ͕Ͱ͖Δ - Λઃఆ͢ΔࡍʹΤεέʔϓॲཧ͕࣮ࢪ͞ΕΔ -
ܕνΣοΫ͕ߦΘΕΔ͜ͱ͋Δ ηΩϡϦςΟରࡦ ORMͷΑ· 202 $res = pg_query( $dbconn, ‘select * from users where id = $1 and password = $2’, array($_POST[‘id’], $_POST[‘password’]) ); -
͏Ұͭͷํ๏ͱͯ͠ɺORMΛར༻͢Δͱ͍͏ํ๏͕͋Γ·͢ɺ ORMΛ͏ϝϦοτ - ORM෦తʹϓϦϖΞυεςʔτϝϯτΛར༻͍ͯ͠Δ͜ͱ͕΄ͱΜͲ - Λઃఆ͢ΔࡍʹΤεέʔϓॲཧ͕࣮ࢪ͞ΕΔ - ܕνΣοΫ͕ߦΘΕΔ͜ͱ͋Δ ηΩϡϦςΟରࡦ ORMͷΑ·
203 User::where(‘id’, ‘tosite’)->where(‘password’, ‘password1234’)->first(); -
N+1ΛҾ͖ى͜͢έʔε ORMͷΑ· 207 # ORM class Comment extends Model {
public function user() { return $this->belongsTo('App\User'); } } # Controller $comments = Comment::all(); foreach ($comments as $comment) { echo $comment->user; } -
ϖʔδΛදࣔ͢ΔͨͼʹҎԼͷΫΤϦ͕ൃߦ͞ΕΔ͜ͱʹͳΓ·͢ɻ ͜Ε $comments->user ͕࣮ߦ͞ΕΔʹSQL͕ൃߦ͞ΕΔ͜ͱʹىҼ͠·͢ɻ ͪΖΜɺORMଆͰରࡦ͢Δ͜ͱՄೳͰ͢ɻ N+1ΛҾ͖ى͜͢έʔε ORMͷΑ· 208 select *
from comments; select * from users where id = 1; select * from users where id = 2; select * from users where id = 3; -- ҎԼϨίʔυ͕ଘࡏ͢Δ͚ͩΫΤϦ͕ൃߦ͞ΕΔ $comments = Comment::with('user')->get(); foreach ($comments as $ comment) { echo $comment->user } -
- HTTPϦΫΤετͰड͚औΔೖྗ͕ࣗͷఆ௨Γʹ͘Δͱࢥ͍ࠐ·ͳ͍ - ྫ͑HTMLͷηϨΫτϘοΫεͷબࢶͱͯ͠ʮ1ʯʮ10ʯʮ50ʯΛ ४උ͍ͯͨ͠߹ʹ͜ͷ3ͭͷ͔͠དྷͳ͍ͱࢥͬͨΒେؒҧ͍ - ߈ܸऀૉʹϒϥβͰϦΫΤετͳΜ͔͠ͳ͍ - Ͳͷϒϥβ͔ΒͷΞΫηεͳͷ͔Λද͢User-Agentͱ͍͏ͷ ِՄೳ
- ૬ख͕ຊʹ Chrome Λ͍ͬͯΔ͔Θ͔Βͳ͍ ֎෦͔Βͷೖྗ৴͍͚ͯ͡ͳ͍ʢେࣄͳ͜ͱͳͷͰ2ճ͈́ʣ ValidationΛ࣮͠Α͏ 214 -
ո͍͠ͷड͚͚ͳ͍ - ֎෦͔ΒͷೖྗΛͬͯͦͷ··SQLΛΈཱͯΔ - ʮSQLΠϯδΣΫγϣϯʯ͕ى͖Δ - ֎෦͔ΒͷೖྗΛ࣮ͬͯߦ͢ΔίϚϯυΛΈཱͯΔ - ʮίϚϯυΠϯδΣΫγϣϯʯ͕ى͖Δ -
֎෦͔ΒͷೖྗΛͬͯHTMLΛग़ྗͯ͠͠·͏ - ʮΫϩεαΠτεΫϦϓςΟϯά(XSS)ʯ͕ى͖Δ ֎෦͔ΒͷೖྗΛ৴͡ΔͱͲ͏ͳΔͷ͔ʁ ValidationΛ࣮͠Α͏ 216 -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ ValidationʹҾ͔͔ͬΔΑ͏ʹAPIΛ࣮ߦ͢Δ ValidationΛ࣮͠Α͏ 218 Selected Method put/patch Uri /api/comments/ {id}
Parameters name: ࣗ content: ʢۭʣ ֬ೝ -
ҎԼͷύϥϝʔλΛೖྗޙɺSUBMITΛԡ͍ͯͩ͘͠͞ɻ ValidationʹҾ͔͔ͬΔΑ͏ʹAPIΛ࣮ߦ͢Δ ValidationΛ࣮͠Α͏ 219 Selected Method put/patch Uri /api/comments/ {id}
Parameters name: ࣗ content: ʢۭʣ ֬ೝ 422 The content field is required. -
ࠓͷValidationͷ࣮ΛΈͯΈΑ͏ app/Http/Request/Comments/Post.php ΛVSCodeͰ։͍ͯΈ·͠ΐ͏ɻ ValidationΛ࣮͠Α͏ 220 public function rules() { return
[ 'name' => 'required', // nameύϥϝʔλඞਢೖྗ 'content' => 'required', // contentύϥϝʔλඞਢೖྗ ]; } ֬ೝ -
ValidationͷυΩϡϝϯτΛݟͯϧʔϧՃ͠Α͏ min: = ࢦఆ͞ΕͨҎ্Ͱ͋Δ͜ͱΛόϦσʔτ͠·͢ɻ max: = ࢦఆ͞ΕͨҎԼͰ͋Δ͜ͱΛόϦσʔτ͠·͢ɻ ࢀߟࢿྉɿόϦσʔγϣϯʹ͍ͭͯ https://readouble.com/laravel/6.x/ja/validation.html ValidationΛ࣮͠Α͏
࡞ۀ 221 public function rules() { return [ 'name' => 'required|min:5|max:10', 'content' => 'required', ]; } -
nameʹ4จࣈ·ͨ11จࣈͷจࣈྻೖΕࣦͯഊ͢ΔͷΛ֬ೝ͍ͯͩ͘͠͞ɻ όϦσʔγϣϯΛࣦഊͤ͞Δ ValidationΛ࣮͠Α͏ 222 Selected Method put/patch Uri /api/comments/ {id}
Parameters name: ࣗ content: ʢۭʣ ֬ೝ 422 The content field is required. -
17:30 ·Ͱ֤ࣗͰ࡞ۀΛ͠·͠ΐ͏ɻ Θ͔Βͳ͍͜ͱ͕͋ͬͨΒɺԕྀͳ͘zoomͷνϟοτʹʲ࣭ʳΛ͚ͭͯίϝϯτ͍ͯͩ͘͠͞ɻ ͦΕҎ֎ͷίϝϯτେৎͰ͢! Δ͜ͱ ɾίϝϯτΛۭʹͨ͠ϦΫΤετ͕ࣦഊ͢Δ͜ ͱΛ֬ೝ͢Δ ɾόϦσʔγϣϯͷॲཧΛՃ͢Δ ɾจࣈͷόϦσʔγϣϯʹҾ͔͔ͬΔϦΫΤ ετΛૹΔ
֬ೝ ɾεςʔλε422ͰΤϥʔʹͳͬͨΒOKʂ ࡞ۀλΠϜ ValidationΛ࣮͠Α͏ ࡞ۀ 224 -
ϋϯζΦϯͰଓͰ͖ͳ͍ํ͕͍ͨͷͰɺΓ͚ͯ͠Έ·͠ΐ͏ɻ - Ͱ͖ΔʢVSCodeͷηοτΞοϓͷ͔ʣ - Remote-SSHΛҰ୴ΞϯΠϯετʔϧɾΠϯετʔϧ͠Α͏ - VSCodeΛҰ୴ΞϯΠϯετʔϧɾΠϯετʔϧ͠Α͏ - Ͱ͖ͳ͍ʢConoHaͷηοτΞοϓͷ͔ʣ -
ެ։伴Λαʔόʔʹొ͠Α͏ - ൿີ伴ΛվΊͯChromeͰμϯϩʔυ͠Α͏ʢݪҼ֬ʣ ֬ೝ : CUIͰConoHaʹsshଓͰ͖·͔͢ʁ Remote-SSHͰConoHaʹଓͰ͖ͳ͍ 227 -
.ssh/config ͷઃఆօͰ͖·ͨ͠Ͷɻ MacͷํTerminalɺWindowsͷํGit BashͰsshͰ͖Δ͔֬ೝ͠·͠ΐ͏ɻ ֬ೝ : CUIͰConoHaʹsshଓͰ͖·͔͢ʁ Remote-SSHͰConoHaʹଓͰ͖ͳ͍ 228 ࡞ۀ
# ࣮ߦ͢ΔίϚϯυ (.ssh/config ʹొͨ͠ Hostname ͕ Conoha ͷ߹) ssh Conoha ਖ਼ৗ࣌ͷը໘ -
ίϚϯυΛ࣮ߦͯ͠ެ։伴Λొ͠·͢ɻࣄલʹҎԼͷ3ͭΛ֬ೝ͠·͠ΐ͏ɻ - ൿີ伴ͷPath (.ssh/config ʹॻ͍ͯ͋ΔΑ) - ConoHaͷIP (.ssh/config ʹॻ͍ͯ͋ΔΑ) -
ConoHaͷrootύεϫʔυ ެ։伴Λαʔόʔʹొ͠Α͏ Remote-SSHͰConoHaʹଓͰ͖ͳ͍ 229 ࡞ۀ # ൿີ伴͕ར༻Ͱ͖ɺެ։伴ΛੜͰ͖Δ͔֬ೝ͢ΔίϚϯυ ssh-keygen -y -f <ൿີ伴ͷPath> -
ެ։伴ΛੜͰ͖Δ͜ͱΛ֬ೝͨ͠ΒConoHaʹొ͠·͠ΐ͏ɻ ެ։伴Λαʔόʔʹొ͠Α͏ Remote-SSHͰConoHaʹଓͰ͖ͳ͍ 230 ࡞ۀ # ࣮ߦ͢ΔίϚϯυ ssh-keygen -y -f
<ൿີ伴ͷPath> | ssh root@<ConoHaͷIP> 'cat >> .ssh/authorized_keys' # ࣮ߦͨ͠ΒrootύεϫʔυΛฉ͔ΕΔͷͰೖྗͯ͠EnterΩʔΛԡ͢ # ͳͦ͞͏Ͱ͋Εɺ࠶ͼConoHaʹsshଓͯ͠ΈΑ͏