- src/ Azureã«é 眮ãããµã³ãã«Webã¢ã㪠2016幎åå€å±ã§è¡ã£ããã³ãºãªã³ã§äœæãããã®ã§ã
- src/php/basic/ PHPåäœç¢ºèªçšWebã¢ããª(HelloPHPãšåºãã ãã§ã)
- src/php/todo/ PHPç TODOã¢ã㪠cookieã«ããŒã¿ãä¿åããç
- src/php/todo-mysql/ PHPç TODOã¢ã㪠DBã«ããŒã¿ãä¿åããç
- src/node/basic Node.jsåäœç¢ºèªWebã¢ããª(Hello Nodeãšåºãã ãã§ã)
- src/node/chat Node.jsç ãã£ããã¢ããª
- WebAppsã«ã€ããŠ
- WebAppsãäœæããã
- PHPçã®Webã¢ããªãé 眮ããŠã¿ãã -OneDrve/DropBox/FTP/Githubçµç±ã§ãããã€-
- ã¯ã©ãŒã¿ãŒã»ç®¡çã³ã³ãœãŒã«ã»WebãµãŒããŒã®èšå®å€æŽ æéãããã°ä»¥äžãè¡ããŸã
- Node.jsçã®Webã¢ããªãé 眮ããŠã¿ãã -WebSocketã®èšå®-
- PHPãšDBã䜿ãWebã¢ããªãé 眮ããŠã¿ãã -MySQLãšé£æº-
ãã³ãºãªã³ãå§ããåã«ãã®ãªããžããªãã¯ããŒã³ïŒããããªãæ¹ã¯å³äžã®ãClone or DownloadããããDownloadZipããã¯ãªãã¯ããŠäžèº«ãè§£çããŠä¿åïŒããŠãã ããã
Microsoft瀟ãæäŸããã¯ã©ãŠã(ãµãŒãã¹ããããã¯ãŒã¯çµç±ã§å©çšãã圢)ãµãŒãã¹
ä»®æ³ãã·ã³ããããã¯ãŒã¯ã®ã€ã³ãã©ãæ©æ¢°åŠç¿ãã©ãããã©ãŒã ãã¹ãã¬ãŒãžãµãŒãã¹ãªã©æ§ã ãªãµãŒãã¹ãæäŸ
éçºè ãšããŠèŠãã¯ã©ãŠã(Azureã«éãã)
- ã€ã³ãã©ããã©ãããã©ãŒã ãå©çš
- ãµãŒãã®æ§ç¯ã»ç®¡çãªã©ã®é¢åãªéšåã¯ãã¹ãŠãä»»ã
âéçºã«å°å¿µ
Azureã¯äžçåå°ã«ããŒã¿ã»ã³ã¿ãŒãæã£ãŠãã(ããŒã¿ã»ã³ã¿ãŒãããå°åããªãŒãžã§ã³ãšãã)
æ¥æ¬ã¯æ±ïŒæ±äº¬ãåŒçïŒãšè¥¿ïŒå€§éªïŒ
ãªãŒãžã§ã³ããšã«äœ¿ããæ©èœãæéãªã©ãç°ãªã
é ããªãŒãžã§ã³ã ãšé
å»¶ã倧ããã®ã§è¿ãæ¹ããã
ãµãŒãã¹ããšã«èª²éãããããåºæ¬äœ¿ã£ãæéã ã
MicrosoftImagineçµç±ã§ç»é²ããå Žåã¯ç¡æã§äœ¿ããæ©èœã®ã¿ã¢ã¯ã»ã¹å¯èœ
å¶éãè¶ ããŠäœ¿ã£ãŠãããšãã課éãããããšã¯ãªãã®ã§å®å¿
(ãã ãæ®éã«ã¢ã«ãŠã³ããç»é²ããŠã¯ã¬ãžããã«ãŒããšé£æºãããŠãå¶éããããªãå Žåã¯å¯Ÿè±¡å€)
Webãµã€ããç°¡åã«å
¬éããæ©èœ
Webãµã€ããå
¬éããã®ã«åã
â»çŸåšããã¯ãšã³ããWindowsçãLinuxçããããŸãããLinuxçã¯ãã¬ãã¥ãŒãªã®ã§
ããã§ã¯ããã¯ãšã³ããWindowsçã察象ã«ããŸããã
以äžã®æ§ãªããšããããå Žåã¯ä»®æ³ãã·ã³çãæ€èš
- ç¹å®ã®ããŒãã§åŸ æ©ããã
- ãµããŒãããŠããªãèšèªã§äœããã
- ããã°ã©ã ãã€ã³ã¹ãã«ããŠåããããã»ã©ã€ãã©ãªãã·ã¹ãã ã«å ¥ããå¿ èŠããã
- åãèšèªã¯.NET/Node.js/PHP/Java/Python
- WindowsServerãšIISã§æ§ç¯ãããŠãã
- WebãµãŒãã®èšå®ã¯.htaccessã§ã¯ãªãweb.configãé
眮
cakePHPãªã©ããã®ãŸãŸçœ®ããšåããªã - ã³ãã³ããèµ°ããããããéã¯PowesShell(orCMD)
- ãã°ããã¢ã¯ã»ã¹ããªããšãµãŒããŒãèœã¡ãããã®åŸååã¢ã¯ã»ã¹æã¯ã¬ã¹ãã³ã¹ãè¿ã£ãŠãããŸã§ãã°ããæéããããã
ãªããçŸåšLinuxã€ã³ã¹ã¿ã³ã¹ããã¬ãã¥ãŒã§å ¬éãããŠããŸãïŒRuby察å¿)
Dockeräžã§åãã®ã§ã«ã¹ã¿ãã€ãºããã³ã³ããäžã§åããããšãå¯èœ
â»ãã ã4/15çŸåšã§ãã¬ãã¥ãŒãªã®ã§ãã®å ã©ããªããããããªãã§ãã
| ãã©ã³å | æé¡ | ã¢ããªæ° | CPU | ã¡ã¢ãª | ã¹ãã¬ãŒãž | 垯åå¶é |
|---|---|---|---|---|---|---|
| ç¡æ | 0 | 10 | å ±æ 60å/æ¥ | 1G | 1G | 165MB/æ¥ |
| å ±æ | \1.57/æ | 100 | å ±æ 240å/æ¥ | 0.5G | 1G | ç¡ã(転ééããšã«èª²é) |
| Basic B1 | \9.03/æ | ç¡å¶é | 1ã³ã¢ | 1.75G | 10G | ç¡ã(転ééããšã«èª²é) |
| Standard S1 | \12.04/æ | ç¡å¶é | 1ã³ã¢ | 1.75G | 50G | ç¡ã(転ééããšã«èª²é) |
| Standard S3 | \48.15/æ | ç¡å¶é | 4ã³ã¢ | 7G | 50G | ç¡ã(転ééããšã«èª²é) |
ã¢ããªæ°ïŒ1ãµãŒããŒäžã§å®è¡ã§ããWebãµã€ããªã©ã®æ°
CPUïŒ60å/æ¥ã¯1æ¥ãããCPUæéã60åãŸã§å©çšã§ãã
â»ç¡æãå
±æãã©ã³ã¯ãµãŒããŒåäœã§ãªãã¢ããªåäœã§ãªãœãŒã¹å¶éã»èª²é
Basic,Standard,PremiumãšäžããŠãããšæ§ã
ãªæ©èœãå©çšå¯èœã«ãªã
ãã©ã³ã¯ä»»æã®ã¿ã€ãã³ã°ã§å€æŽå¯èœïŒå€æŽäžæ°åçšåºŠããŠã³ã¿ã€ã ãçºçããïŒ
âæåã¯ç¡æãã©ã³ã§ãå¿
èŠã«å¿ããŠèª²éããããšãå¯èœ
Azureã®ããŒã¿ã«ãµã€ã(http://portal.azure.com/)ãžã¢ã¯ã»ã¹ããŸã
ã¢ã¯ã»ã¹ãããšä»¥äžã®ç»é¢ã«ãªããŸãã

ä»åã¯Webãµã€ãããã¹ãã£ã³ã°ããWebAppãäœæããã®ã§ãæ°èŠããããWeb+ã¢ãã€ã«ãããWebAppããéžæããŸãã
WebAppã远å ããç»é¢ã衚瀺ãããŸãã

- ã¢ããªå
ä»»æã§ããURLã«ãªããŸãã®ã§ä»äººãšè¢«ããªãååã«ããŠãã ããã
ãã§ã«ååšããå Žåã¯
ã衚瀺ãããŸã - ãµãã¹ã¯ãªãã·ã§ã³
é¢é£ä»ããAzureã®ã¢ã«ãŠã³ãã§ããMicrosoft Imaginãããã¯DreamSparkãéžã°ããŠããããšã確èªããŠãã ããã - ãªãœãŒã¹ã°ã«ãŒã
æ°èŠäœæãéžæããä»»æã®ååãã€ããŠãã ããã - App Serviceãã©ã³/å Žæ
AppServiceããã¹ãã£ã³ã°ãããµãŒããŒã®å Žæãšæéãã©ã³ãéžæããŸãã
ãæ°èŠäœæããéžæããŠãå ŽæãããJapan Eastãã«ããããšãããããããŸãã
(äŸ¡æ Œã¬ãã«ã¯F1 Freeã®ã¿éžæã§ããŸãããªããæ°èŠäœæããå Žåã¯AppServiceãã©ã³åã«ä»»æã®ååãã€ããŠãã ããã)

ãªãœãŒã¹ã°ã«ãŒãã¯Azureã®ä»®æ³ãã·ã³ãWebAppããããã¯ãŒã¯ãªã©ã®ãªãœãŒã¹ããŸãšããŠç®¡çããæ©èœã§ãã
ã°ã«ãŒãåããããšã§ãŸãšããŠæ¶ãããããããšãåºæ¥ãŸãã

å
容ã確èªããŠãäœæããã¿ã³ãæŒããŸãã
äœææã«ãããã·ã¥ããŒãã«ãã³çãããããéžæãããšæåã«ã¢ã¯ã»ã¹ããããŒãžã«å³ã®ããã«ãã³çããããŸãã
é²æç¶æ³ã¯ãéç¥ããã¿ã³ãããããšã§ç¢ºèªã§ããŸãã

ãããã€ãå®äºããŸãããšåºãã°å®äºã§ãã

远å ããWebAppã«ã¢ã¯ã»ã¹ããŠã¿ãŸãããã
ãAppServiceããéžæã远å ããWebAppãã¯ãªãã¯ããŸãã
ãã³çãããæ¹ã¯ããã·ã¥ããŒãã®ãã³çãããããã®ãã¯ãªãã¯ããŸãã
ãæŠèŠãã«è¡šç€ºãããURLãã¯ãªãã¯ãããããåç
§ããã¯ãªãã¯ããããšã§ããã©ã«ãã®ããŒãžã«ã¢ã¯ã»ã¹ã§ããŸãã

å³ã®ãããªããŒãžã衚瀺ãããã°å®äºã§ãã

Azureã§ã¯æ§ã ãªæ¹æ³ã§Webã¢ããªããããã€åºæ¥ãŸããã以äž3çš®é¡ã«å€§å¥ã§ããŸãã
-
å€éšã®ãµãŒãã¹ã«ãœãŒã¹ã³ãŒãã眮ããæåã§ãããã€ããå Žå(DropBox/OneDrive/å€éšãªããžããªç)

-
å€éšã®ãµãŒãã¹ã«ãœãŒã¹ã³ãŒãã眮ãããœãŒã¹ã³ãŒããæŽæ°ããã¿ã€ãã³ã°ã§èªåçã«ãããã€ããå ŽåïŒç¶ç¶çãªããã〠Github/BitbucketçïŒ

-
Azure WebAppsã«çŽæ¥ãããã€ããå Žå(FTP/å éšãªããžããª)

ããããã€ã¡ã³ããã®ããããã€ãªãã·ã§ã³ããéžæããŸãã

ããœãŒã¹ã®éžæããã¯ãªãã¯ããŸãã

ãœãŒã¹ã³ãŒãã®åæå
ãéžæããç»é¢ã衚瀺ãããŸãã

ãããããœãŒã¹ã³ãŒããã©ãããåæãããã«ãã£ãŠæé ãå¥ããŸãã
DropBox/OneDriveçµç±ã§ãããã€ããæ¹ã¯ãã¡ã
å€éšãªããžããªçµç±ã§ãããã€ããæ¹ã¯ãã¡ã
Githubãå©çšããŠãããã€ããæ¹ã¯ãã¡ã
åºæ¬çãªæäœã¯ã»ãŒåããªã®ã§ããã§ã¯DropBoxãäŸã«èª¬æããŸãã
ããœãŒã¹ã®éžæããããDropBoxããéžæã
ãå±éå
ããããæ¿èªããéžæãããæ¿èªããããã¯ãªãã¯

DropBoxã®ãã°ã€ã³ããŒãžã衚瀺ãããã®ã§ãã°ã€ã³ããã
ãã°ã€ã³å®äºåŸç¶è¡ããã«ã¯OKãã¯ãªãã¯ããŠãã ãããšè¡šç€ºãããããOKããã¯ãªãã¯ã

å
容ã確èªããŠãOKããã¯ãªãã¯ããŸãã

ãã©ã«ããŒã®éžæã¯DropBoxäžã§çæããããœãŒã¹ã³ãŒãã眮ããã©ã«ããŒãéžæããŸãã
ïŒDropBoxã®å Žåã¯ã¢ããª/Azure/以äžã«ãªããŸããïŒ
ãããã€ã®ããŒã«ããã¯ã®æå¹åã«ãã§ãã¯ãå
¥ãããšããœãŒã¹ã³ãŒããä»»æã®ãããã€ããã¿ã€ãã³ã°ã«æ»ãããšãåºæ¥ãŸãã
ãã®ã¿ã€ãã³ã°ã§Dropboxã®ã¢ããª/Azure/ãã©ã«ããŒã®éžæã§æå®ãããã©ã«ããŒåãäœæãããŠãããšæãã®ã§ãã¡ããéããŠãã ããã
éãããã©ã«ããŒã«ã¯ããŒã³ã»ããŠã³ããŒããããã®ãªããžããªã®src/php/todoã®äžèº«ããã¹ãŠã³ããŒããŠãã ããã

Azureã®ããŒã¿ã«ã«æ»ãããããã€ãªãã·ã§ã³ãã®ãåæããã¯ãªãã¯ã

Dropboxãªããžããªã®ã³ã³ãã³ããååŸãããããã€ããŸããïŒãšèãããã®ã§ãã¯ãããéžæããŠãã ããã

ãã°ããåŸ
ã£ãŠSynchronized n change(s) from Dropboxãšè¡šç€ºãããã°ãããã€å®äºã§ãã

以éãœãŒã¹ã³ãŒããæŽæ°ãããµãŒããŒã«ãããã€ããéã¯ãã®æé ãç¹°ãè¿ãã°OKã§ãã
詊ãã«WebAppã«ã¢ã¯ã»ã¹ããŠã¿ãŸãããã

ãã®ããã«Todoã¢ããªã衚瀺ãããã°å®äºã§ãã
ã奜ã¿ã§src/php/basic以äžã®ãã®ãã³ããŒããŠãããã€ããŠãOKã§ãã
ãã®ãŸãŸæ¬¡ã®ç« ã«é²ã¿ãŸããã
ããœãŒã¹ã®éžæããããå€éšãªããžããªããéžæã
ãªããžããªã®URLã«ãœãŒã¹ã³ãŒããé 眮ãããªããžããªã®URLãåå²ã«ãã©ã³ãåãå ¥åããŸãã
ä»åããã¡ãã§ã¯
URLïŒ https://github.com/mspjp/20170426tsukubaHandson-deploy.git
ãã©ã³ãïŒ master
ãçšæããŠããŸãã
å 容ã確èªããŠãOKããã¿ã³ãæŒããŠãã ããã
Azureã®ããŒã¿ã«ã«æ»ãããããã€ãªãã·ã§ã³ãã®ãåæããã¯ãªãã¯ã

External ãªããžããªã®ã³ã³ãã³ããååŸãããããã€ããŸããïŒãšèãããã®ã§ãã¯ãããéžæããŠãã ããã

ãã°ããåŸ
ã£ãŠã³ãããåã衚瀺ãããã°ãããã€å®äºã§ãã

以éãœãŒã¹ã³ãŒããæŽæ°ã»ãªããžããªã«pushåŸããµãŒããŒã«ãããã€ããéã¯ãã®æé ãç¹°ãè¿ãã°OKã§ãã
詊ãã«WebAppã«ã¢ã¯ã»ã¹ããŠã¿ãŸãããã

ãã®ããã«ãã¹ãçšããŒãžã衚瀺ãããã°å®äºã§ãã
å€éšãªããžããªã§è©Šãã«ãããæ¹ãå€ãå Žåã¯ãã®ããšãã¡ãã§ããŒãžãæŽæ°ããŠå床ãããã€ããŠããããšããã®ãå«ãããããããŸããã
ãã®ãŸãŸæ¬¡ã®ç« ã«é²ã¿ãŸããã
ãã¡ãã¯ä»åã®ãã³ãºãªã³ã§ã¯æ±ããŸããããä»åŸAzure WebAppsãå©çšãããéã«åèã«ããŠãã ããã
ãªããGithubãšé£æºãããæ¹åŒãäžçªããããã§ãã
ããœãŒã¹ã®éžæããããGithubããéžæã
ãå±éå
ããããæ¿èªããéžæãããæ¿èªããããã¯ãªãã¯

Githubã«ãã°ã€ã³ããŸãã

å
容ã確èªããAuthorize Applicationããã¯ãªãã¯ããŸãã

Azureã®ããŒã¿ã«ã«æ»ããã°ã€ã³å®äºåŸç¶è¡ããã«ã¯OKãã¯ãªãã¯ããŠãã ãããšè¡šç€ºãããããOKããã¯ãªãã¯ã

åæå
ã®ãªããžããªã»ãã©ã³ããªã©ãæå®ããŸãã

ãããã€ãªãã·ã§ã³å
ã§ææ°ã®ã³ãããã衚瀺ãããŠããã°æåã§ãã

以éGithubã®è©²åœãããã©ã³ããæŽæ°ãããã³ã«èªåçã«ãããã€ãããŸãã
ãã¡ãã¯ä»åã®ãã³ãºãªã³ã§ã¯æ±ããŸããããä»åŸAzure WebAppsãå©çšãããéã«åèã«ããŠãã ããã
ãŸããFTPã®ãŠãŒã¶ãŒãšãã¹ã¯ãŒããç»é²ããŸãã
ããããã€è³æ Œæ
å ±ããã¯ãªãã¯ããFTP/ãããã€ãŠãŒã¶ãŒåããšããã¹ã¯ãŒãããç»é²ããŸãã

å
¥ååŸãä¿åããæŒããŠãã ããã
ã€ãã«ãæŠèŠãããFTP(S)ãã¹ãåã確èªããFTPã¯ã©ã€ã¢ã³ãããšã¯ã¹ãããŒã©ãŒãªã©ã§ã¢ã¯ã»ã¹ããŸãã

ã¢ã¯ã»ã¹æã«IDãšãã¹ã¯ãŒããèŠæ±ãããã®ã§ãæŠèŠãã®ãFTP/ããã〠ãŠãŒã¶ãŒåããIDã«ããã¹ã¯ãŒãã¯ããããã€è³æ Œæ å ±ãã§æå®ãããã®ãå ¥é²ããŠãã ããã
WebAppsã®ããŒã ãã©ã«ããŒã«ã¢ã¯ã»ã¹ã§ããŸãã

Webã«å
¬éãããããŒã¿ãŒã¯site/wwwroot/以äžã«ãªããŸãã®ã§ãã¡ãã«Webã¢ããªãHTMLãã¡ã€ã«ãªã©ãã³ããŒããŠãã ããã
ãã¡ãã®é ç®ã¯è§£èª¬ã®ã¿ã§ã
ç¡æãã©ã³ãªã©ãªãœãŒã¹å¶éãããå Žåã¯ããšã©ãã ãå©çšãããšãµã€ããæ¢ãŸããã確èªããæ©èœããããŸãã
ãApp Serviceãã©ã³ãã®ãã¯ã©ãŒã¿ããéžæãããšäžèЧã§è¡šç€ºãããŸãã

ãªãããªãœãŒã¹å¶éãããã£ãå Žåã¯Webãµã€ãã¢ã¯ã»ã¹æã«403ã衚瀺ãããŸãã

ãªãœãŒã¹å¶éãªã©ã§WebAppsãæ¢ãŸã£ãå Žåã¯ç®¡çã³ã³ãœãŒã«ãªã©ãå©çšã§ããªããªããŸãã
(WebAppsã®ãµãŒããŒäžã§åããŠããAPIãµãŒããŒãæ¢ããããŠããŸããã)
WebãµãŒããŒã®ç®¡ççšã«ã³ã³ãœãŒã«ãå©çšã§ããŸãã
ãéçºããŒã«ãã®ãã³ã³ãœãŒã«ãããå©çšã§ããŸãã

â»ãã¡ãã®ã³ã³ãœãŒã«ã¯ãµã³ãããã¯ã¹äžã§åããŠããŸãã
ãŸããã³ãã³ãããã³ããã»PowerShellãå©çšãããå Žåã¯ãéçºããŒã«ãã®ãé«åºŠãªããŒã«ããããç§»åããéžæãKuduã«ç§»åããŸãã

Kuduã®ã¡ãã¥ãŒãããDebug ConsoleãããCMDããããã¯ãPowerShellããéžæããŸãã

äžéšã«ã«ã¬ã³ããã£ã¬ã¯ããªã®ãã¡ã€ã«äžèЧããäžéšã«ã³ãã³ãããã³ãããããã¯PowerShellã®ã³ã³ãœãŒã«ã衚瀺ãããŸãã

Kuduã¯WebAppsã®ãããã€ãšã³ãžã³ã§ãããã€åŠçã®ã»ãããã¯ããããã°ããŒã«ãªã©ãæäŸããŠããŸãã
WebãµãŒããŒã®PHPã®ããŒãžã§ã³ãç°å¢å€æ°ããã£ã¬ã¯ããªã®ã«ãŒãã£ã³ã°ãªã©ã®å€æŽã¯ãèšå®ãã®ãã¢ããªã±ãŒã·ã§ã³èšå®ãã§å€æŽã§ããŸãã

äŸãã°
index.html
/hoge
ãšãããã©ã«ããŒæ§æã§ãããã€ãããšãã«ããã¹ãå/fooãžã¢ã¯ã»ã¹ãããšhoge以äžã«ã¢ã¯ã»ã¹ãããããšãã¯ãä»®æ³ã¢ããªã±ãŒã·ã§ã³ãšãã£ã¬ã¯ããªãŒãã以äžã®ããã«ããŸãã

ãç²ãæ§ã§ãããããã§ãã³ãºãªã³ã¯çµäºã§ãã
æéã«äœè£ãããå Žåãæ©ãçµãã£ãæ¹ãå®¶ã§ç¶ãããã£ãŠã¿ããæ¹ã¯åŒãç¶ãã詊ããã ããã
ãã®ç« ã§ã¯Node.jsã§äœæãããWebSocketãå©çšããWebã¢ããªãAzureäžã«é 眮ããŸãã
2ç« ã®å 容ãåèã«ã¯ããŒã³ã»ããŠã³ããŒããããã®ãªããžããªã®src/node/chat以äžã®äžèº«ãAzureã«ãããã€ããŸãã
ãã®ãã£ããã¢ããªã¯Websocket(socket.io)ãå©çšããŠããããããèšå®ãã®ãã¢ããªã±ãŒã·ã§ã³èšå®ããããWebSocketsããããªã³ãã«ããŸãã
ã€ã¥ããŠãä¿åããã¯ãªãã¯ããŠå€æŽããèšå®ãåæ ãããŸãã
â»çŸåšã ãšäœæ ããªãã§ãsocket.ioã䜿ããŸãããå ¬åŒã®ãã¥ãŒããªã¢ã«ã§ã¯ãªã³ã«ããããšãèšèŒãããŠããŸãã

WebAppsã«ã¢ã¯ã»ã¹ãããšæ¬¡ã®ãããªãã£ããã¢ããªã衚瀺ãããŸãã
è€æ°ã®ç«¯æ«ããã¢ã¯ã»ã¹ããŠçžäºã«æžã蟌ããšæžã蟌ã¿å
容ãåæ ãããŸãã
ãã®ç« ã§ã¯ããŒã¿ããŒã¹ïŒMySQLïŒãå©çšããWebã¢ããªãAzureã«ãããã€ããŸãã
ã¯ããã«ã2ç« ã®å
容ãåèã«ã¯ããŒã³ã»ããŠã³ããŒããããã®ãªããžããªã®src/php/todo-mysql以äžã®äžèº«ãAzureã«ãããã€ããŸãã
ãã®æç¹ã§ToDoã¢ããªã®submitãæŒããŠãäœãèµ·ããªãïŒå
éšã§ãšã©ãŒã«ãªã£ãŠããŸãïŒãšæããŸãã
ïŒããã¯DBãµãŒããŒããŸã åãããŠããªãã®ã§DBã®èªã¿æžããè¡ãapi.phpå
ã§ãšã©ãŒãèµ·ãããŠããããã§ããïŒ
次ã«MySQLãµãŒããŒãçšæããŸãã
Azure WebAppsã«ã¯çµã¿èŸŒã¿ã®MySQLãµãŒããŒãããã®ã§ãããå©çšããŸãã
ä»åå©çšããçµã¿èŸŒã¿ã®MySQLãµãŒããŒïŒMySQL In AppïŒã¯ãã¹ãçšãšããŠèšèšããããã®ã§ãã
æ¬çªç°å¢ã§ã¯å¥ã§DBãµãŒããŒãç«ãŠãããšãããããããŸãã
(ãªããMySQL In Appã¯WebAppsã®ãµãŒããŒã§åãããMySQLã®åŠçæéãCPUæéã«ã«ãŠã³ããããŸãããŸããå€éšããã¯æ¥ç¶ã§ããŸããã)
Azureã®ããŒã¿ã«ã«æ»ããèšå®ãã®ãMySQL In AppããããMySQL In Appããããªã³ãã«ããŠãä¿åããæŒããŠãã ããã

ä¿åãéžæåŸäžéšã®ã管çããæŒããšphpMyAdmin(MySQLã®ç®¡çããŒã«)ãžã¢ã¯ã»ã¹ã§ããŸãã

ãªããmysqlãµãŒããŒã皌åããŠããªããšãã°ã€ã³ããŒãžãžç§»åããããããããã€ããWebãµã€ãã«1åã¢ã¯ã»ã¹ãMySQLãµãŒããŒãèµ·åãããŠãã ããã
PHPMyAdminã«ã¢ã¯ã»ã¹ãããšä»¥äžã®ãããªããŒãžã«é·ç§»ã§ããŸãã

Webã¢ããªããMySQLãµãŒããŒã«æ¥ç¶ããããã«å¿
èŠãªæ
å ±ã¯ç°å¢å€æ°ãšããŠæž¡ãããŸãã
ïŒç°å¢å€æ°åã¯ãèšå®ãã®ãMySQL In Appããã確èªã§ããŸãã)

MySQL In Appã¯ã€ã³ã¹ã¿ã³ã¹èµ·åæã«ããŒãçªå·ãªã©ãå€ããå¯èœæ§ãããããç°å¢å€æ°ãããµãŒããŒã®ããŒãçªå·ããŠãŒã¶ãŒåãªã©ãååŸããããšãããããããŸãã
ãªããç°å¢å€æ°ã®äžèº«ã¯ä»¥äžã®ãããªãã©ãŒãããã§ãã
Database=localdb;Data Source=127.0.0.1:56682;User Id=azure;Password=HD_$6#vW_P@ssW0rd
ä»åæäŸããphpãã¡ã€ã«(src/php/todo-mysql/api.php)ã§ã¯ç°å¢å€æ°ããããŒã¿ããŒã¹åãããŒãçªå·ãªã©ãååŸããããã«å®è£
ããŠããŸãã
ãããããã°ã確èªãã ããã
ç¶ããŠãµã³ãã«ã¢ããªçšã®ããŒãã«ãäœæããŸãã
å床phpMyAdminã«ã¢ã¯ã»ã¹ãå·ŠåŽããlocaldbãéžæããSQLãéžæããŸãã

(å©çšããããŒã¿ããŒã¹åã¯äœãããšãåºæ¥ãŸããããã©ã«ãã§localdbãšèšããã®ãäœæãããŠããã®ã§ããã䜿ããŸãã)
ã¯ãšãªãå ¥åããããã¯ã¹ã«ä»¥äžã®SQLã貌ãä»ãããGOããã¿ã³ãæŒããŸãã
CREATE TABLE todo (id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, name TEXT CHARACTER SET utf8 COLLATE utf8_general_ci, date DATE);ãšã©ãŒãåºãªããã°æåã§ãã
æåŸã«ãããã€ããWebãµã€ãã«ã¢ã¯ã»ã¹ãäœãæžã蟌ãã§ã¿ãŸãããã
è€æ°ã®ç«¯æ«ããã¢ã¯ã»ã¹ãããšcookieçãšç°ãªãã¿ã¹ã¯ãå
±æãããŠãããšæããŸãã
以äžã§Azure WebAppsã®ãã³ãºãªã³ã¯ãã¹ãŠçµäºã§ãã
ããããšãããããŸããã
Microsoft Student Partners






