
第30åïŒããã¹ãã³ãŒãã®ã¬ã€ãã©ã€ã³ ãã®5ãã©ããŸã§ãã¹ããããïŒ ââ ãã¬ãŒã ã¯ãŒã¯ããä¿¡ãããåæ°
âšïž DBæ¥ç¶ã®å£ã«ã¶ã€ãããããª
æ±æ ¹æž©æ³æ¯éšã®éçºå®€ãçªã®å€ã«ã¯ãéãã«éšã«æ¿¡ããæž©æ³è¡ãåºãã£ãŠããããã£ãšããšèœã¡çããå€ã®ç©ºæ°ãšã¯å¯Ÿç §çã«ãéçºå®€ã®äžè§ã§ã¯ããããªãåžã声ãäžããªããã¢ãã¿ãŒãšæ ŒéããŠããã
ååã®é£èŒã§ããã¹ãã®é床ãããåœãã§ããããšãåŠãã ãããªã圌女ã¯ä»ãèªäœã®ãŠãŒã¶ãŒç»é²æ©èœãé«éã«æ€èšŒããããã®ãã¹ãã³ãŒããæžãããšããŠããããããããã®äœæ¥ã¯1æéåããäžæ©ãåã«é²ãã§ããªãã
ãããªïŒ ãããŒãâŠâŠãä¿ååŠçã®ãã¹ããæžããªãããããªãã®ã«ãã©ãããŠããã¹ãçšã®DBèšå®ãããŸããããªãâŠâŠããã©ã€ãããªããšããæ¥ç¶ãæåŠããããšãããšã©ãŒã°ããåºã¡ãããã§ããã
ãããªã®ã¢ãã¿ãŒã«ã¯ãã³ãŒããã®ãã®ã®ãã°ã§ã¯ãªããã€ã³ãã©èšå®ã«èµ·å ããç¡æ©è³ªãªãšã©ãŒã¡ãã»ãŒãžã䞊ãã§ããã
ãµãïŒ ãããŒãã²ãŸããŸãäœãã«åãæããããããªé¡ããŠãããâš ç»é¢ããšã©ãŒã§çã£èµ€ã£ãããããäœã«èŠæŠããŠãã®ïŒâšã
ãµãããæ·¹ãããŠã®ããŒããã£ãŒãçæã«èŠã蟌ãã§ããã
ãããªïŒ ããããµãå 茩âŠâŠããŠãŒã¶ãŒæ å ±ãDBã«ä¿åããåŠçã®ãã¹ããæžãããšããŠããã§ããã©ããã¹ãç°å¢ã®DBãç«ã¡äžãããªããŠãããã解決ããªããšããã¹ãã1ããªãé²ãŸãªããã§ããä¿åãã¿ã³ãæŒããŠãã¡ãããšããŒãã«ã«1ä»¶å¢ãããã©ããã確èªãããã ããªã®ã«âŠâŠãã
âšïž ãã¹ãã®ããã«DBãå¿ èŠãšãããåºå®èŠ³å¿µã
ãµãã¯ããããªãå¿ æ»ã«æ ŒéããŠãããDBæ¥ç¶èšå®ãã®ãã¡ã€ã«ãèŠãŠãå°ããæ¯ãåããã
ãµãïŒ ããªãã»ã©ããŒãDBããâŠâŠãã§ãããã²ãŸãããããè«ãšããŠããã®ãã¹ããæžãã®ã«ãæ¬åœã«ãæ¬ç©ã®DBããå¿ èŠãªã®ããªïŒâšã
ãããªïŒ ããã£ïŒ ã ã£ãŠå 茩ãDBä¿åã®æ©èœããã¹ããããã§ããïŒ åœç¶ãæ¬ç©ã®DBïŒãããã¯ãã¹ãçšã®DBïŒã«æ¥ç¶ããŠãå®éã«ããŒã¿ãå ¥ã£ãããšãSQLã§èŠã«è¡ããªããšããæåããŸãããã£ãŠèšããªãæ°ãããŠâŠâŠãã
ãããªã®ç®ã«ã¯ãè¿·ãããªããããã°ã©ãã³ã°ãšã¯ãå ¥åãããã®ãæçµçãªå Žæã«å±ãããšã確èªããäœæ¥ã ãDBä¿åã®ãã¹ããªããDBã確èªãããããã¯åœŒå¥³ã«ãšã£ãŠãçãããã®ãªããæ£è«ãã ã£ãã
ãµãïŒ ããããæ°æã¡ã¯ãããããã§ãããã£ãŠãå®ã¯ãåã®ããžãã¯ãã®ãã¹ããããªããŠããã ã®ãDBã®æ¥ç¶ç¢ºèªãã«ãªã£ã¡ãã£ãŠãªãïŒâšã
ãµãã¯ç©ºããŠãããã¯ã€ãããŒãã®åã«ç«ã¡ãããŒã«ãŒãæã«ããã
âšïž ã¡ãœããã®èŠçŽããšã責åãã®åé¢
ãµãïŒ ãã²ãŸãåãæžããä¿åã¡ãœããã®æ§é ãããã£ããæžãåºããŠã¿ãããâšã
ãµããããŒãã«æžããã®ã¯ãå€ãã®éçºè ãç¡æèã«æžããŠãããæšæºçãªãä¿ååŠçãã®æ§é ã ã£ãã
def register_user(self, name, email):
  # 1. ä¿åçšã®ãšã³ãã£ãã£ïŒã¢ãã«ïŒãçµã¿ç«ãŠã
  user = User(name=name, email=email)
  user.status = "ACTIVE"
  user.created_at = now()
  # 2. ãã¬ãŒã ã¯ãŒã¯ã®æ©èœã䜿ã£ãŠDBã«ä¿åãã
  user.save()  # â ããïŒ
ãµãïŒ ããã®ã¡ãœããã倧ããåããŠ2ã€ã®ãã§ãŒãºãããã§ããïŒâš ã²ãšã€ã¯ãä¿åããããã®ããŒã¿ãæ£ããæºåãããããžãã¯ãããã²ãšã€ã¯ãæºåããããŒã¿ãDBãžæµã蟌ããåŠçãâŠâŠãåŸè ã® user.save() ã£ãŠã誰ãäœã£ãã³ãŒãïŒã
ãããªïŒ ããâŠâŠããã¯ãç§ãã¡ã䜿ã£ãŠããWebãã¬ãŒã ã¯ãŒã¯ã®ã©ã€ãã©ãªã§ããã©ãã
ãµãïŒ ãããã ããããã® save() ã¡ãœããã¯ãäžçäžã®äœäžäººãäœåäžäººãšããéçºè ãæ¯æ¥äœ¿ãåããŠã24æé365æ¥ãã¹ãããç¶ããŠãããæåŒ·ã«æ¯ããã³ãŒããªãã ããâš âŠâŠãããããä»ããåã®ããŒã«ã«ç°å¢ã§ãæ¬åœã«ä¿åãããããªïŒãã£ãŠãã¹ãããŠãæéãæº¶ããå¿ èŠãæ¬åœã«ããïŒâšã
ãµãã®èšèã«ããããªã¯ãããšããã
ãµãïŒ ãåããã¹ãã§ä¿èšŒããªãããããªãã®ã¯ããsave()ãåŒã¶çŽåã®ããŒã¿ãã仿§éãã«äœãããŠãããããšããåèªèº«ã®ããžãã¯ã ããªãã ããDBã«ããããæžã蟌ãŸãããã©ããã¯ããã¬ãŒã ã¯ãŒã¯ãšDB補åã®è²¬ä»»ãåã®è²¬ä»»ãããªããããããä¿¡ãããåæ°ãæããªããšããã¹ãã¯ãã€ãŸã§çµã£ãŠã軜ããªããªããã ãïŒâšã
âšïž ãã¬ãŒã ã¯ãŒã¯ãšã®ãå¢çç·ããåŒã ââ éäžãã¹ãå Žæ
ãµãã®ææãåããããªãéãã«è£è¶³ãå ¥ãããåœŒå¥³ã®æã«ã¯ãç¥çè²ã®æž©æ³æ°Žã§æ·¹ãããè¶ãæ¡ãããŠããã
ããªïŒ ããããªã¡ããããããååèšã£ããèšèšãšãã¹ãã®ç¹ãããã®æ£äœã®äžã€ããâã
ãããªïŒ ãèšèšãšâŠâŠç¹ããâŠâŠïŒã
ããªïŒ ããããDBä¿åãã®ãã®ïŒã€ã³ãã©ïŒãšãä¿åããå å®¹ãæ±ºããããšïŒãã¡ã€ã³ããžãã¯ïŒããé ã®äžã§åãåããã®ãããããã°ããã¹ãã¯é©ãã»ã©ã·ã³ãã«ã«ãªãããâã
ããªã¯ãã¯ã€ãããŒãã®å³ã«ãäžæ¬ã®å€ªãç·ãåŒããã
ããªïŒ ãDBã«æ£ããä¿åããããã©ããã¯ããã¬ãŒã ã¯ãŒã¯ã®è²¬åãä¿åãã¹ãããŒã¿ããããžãã¹ã«ãŒã«ã«åã£ãŠæ£ããäœãããŠããããããããç§ãã¡ãåœãæžããŠæžãã¹ãããžãã¯ã®è²¬åãªã®ããâã
ãããã®å¢çç·ãåŒãããšãã§ããã°ããã¹ãã®éã«ããããæ¬ç©ã®DBãç«ã¡äžããå¿ èŠã¯ãªããªããã¢ãã¯ãã¹ã¿ãã䜿ã£ãŠãä¿åããããšã«ãããã ãã§ãèå¿ã®ããžãã¯éšåã¯ã€ã³ã¡ã¢ãªã§ãããªç§åäœã®éãã§æ€èšŒã§ããã®ã ã
ãŠã€ïŒ ããã âŠâŠã£ãâŠâŠãã¬ãŒã ã¯ãŒã¯ããä¿¡ãããããšã§âŠâŠç§ãã¡ã¯ãèªåãã¡ãæžããäžçªå€§äºãªããžãã¯ã ãã«éäžã§ãããã ããâŠâŠã£ãããã¯ãŸãã§ãä¿¡é Œã§ããããŒãããŒã«èäžãé ããŠãç®ã®åã®æµã«éäžããéšå£«ã¿ããã ããâŠâŠã£ãã
ãŠã€ã®è©©çãªè¡šçŸã«ããããªã®è¿·ãã¯å®å šã«æ¶ããŠããã èªåã§ãã¹ãŠãæ±ã蟌ã¿ãä»äººã®æžããã³ãŒãã®æ£åœæ§ãŸã§èªåã§èšŒæããããšããŠãã岿 ¢ããšãããããã®äžèªç±ãã
ãããªïŒ ãäœã§ãããã§ããããŒãã«ã®æåŸãŸã§è¿œãããã¡ããã¡ãªãã§ããããã¬ãŒã ã¯ãŒã¯ãšã®å¢çç·ãåŒãããããããã¹ãã軜ããããªããã€ãäœãä¿èšŒããŠãããããæç¢ºã«ããã³ããªãã§ããâŠâŠïŒã
ãããªã¯åã³ãšãã£ã¿ã«åãã£ãã ä»åºŠã¯DBèšå®ãã¡ã€ã«ã§ã¯ãªããããžãã¯ãæœåºãããã¹ããããã圢ã«ãªãã¡ã¯ã¿ãªã³ã°ããããã®ã³ãŒããæžãå§ããã
çªã®å€ã§ã¯ããã€ã®éã«ãéšãäžãããé²ã®éããæãããªå ãæž©æ³è¡ãç §ããå§ããŠããã å¢çç·ãåŒãããšã§æã«å ¥ãããèªç±ãããããªã®æžããã¹ãã³ãŒãã¯ããã¯ãéãéã«ç¹ããããã®ã§ã¯ãªããããžãã¯ã®æ£ãããé®®ããã«èšŒæããã軜ãããªçŸãžãšé²åããŠããã
ð ãã¹ã®ç§èµïŒèšèšã®çŸåŠãšçŸå Žã®ãªã¢ã«
ãæå³ã®ãããã¹ãã³ãŒããæžããã ããèšèã§çè§£ããã€ããã«ãªã£ãŠãããããšãã£ã¿ã«åãããšããã®ç·åŒãã¯éåžžã«é£ãããã®ã§ãã
ä»åã¯ããã¬ãŒã ã¯ãŒã¯ã®æ©èœã¯ããã¬ãŒã ã¯ãŒã¯åŽã®ãã¹ãã«ä»»ããã¹ãã ããšãã話ãããŸããããããã¯ãã¬ãŒã ã¯ãŒã¯ã«éã£ã話ã§ã¯ãããŸããããããããå€éšç°å¢ããšã®åãåãæ¹ã«éããææ³ã§ãã
äŸãã°ãPHPãPythonããã·ã§ã«ãå©ãåŠçãå®è£ ãããšããŸãã ãããéçºç°å¢ãšæ¬çªç°å¢ã§ã·ã§ã«ã®ããŒãžã§ã³ãç°ãªã£ãŠãããã©ãã§ããããïŒæ¬æ¥ãã£ãŠã¯ãªããªãããšã§ãããçŸå®ã®çŸå Žã§ã¯èµ·ããåŸã話ã§ãïŒ æ¬çªç°å¢ã§ã¯æ£ããåãã·ã§ã«ããéçºç°å¢ã§ã¯ã䌌ãŠããã埮åŠã«æåãéãããšããç¶æ³ããã®æããã¹ãã³ãŒãã¯ã©ããŸã§ãæ ä¿ãã¹ãã§ããããã
ã·ã§ã«ãå©ãããã®çµæãæ£ãããã©ãããæ€èšŒãããã¹ããæžããããªãæ°æã¡ã¯ããããŸãããããããã®ãæ£ãããã¯æ¬çªç°å¢ã§åãããªãéããæ¬åœã®æå³ã§ã¯ç¢ºå®ããŸãããéçºç°å¢ã§ã©ãã ããæ¬çªã«è¿ãåããããã代çšåãçšæããŠãã¹ããããšããã§ããããæ¬çªã§ã®æåã100%ä¿èšŒããããšã¯ãªãã®ã§ãã
ããããéçã«äŸããŠã¿ãŸãããã ã¡ãžã£ãŒãªãŒã°ã§æŽ»èºãã倧谷ç¿å¹³éžæã®ããŒã«ãæã€ããšããæçµçãªããã·ã§ã³ã ãšããŸãããã®ç·Žç¿ïŒãã¹ãïŒã®ããã«ããã€ãŠã®åææãéèè±éããã«æžŸèº«ã®ã¹ãã¬ãŒããæããŠããã£ããšããŸãããã
ä»®ã«éèããã®ããŒã«ãå®ç§ã«æãŠããšããŠããããã¯ã倧谷ç¿å¹³ã®ããŒã«ãæã€ããšããèŠä»¶ãã¯ãªã¢ããããšã«ã¯ãªããŸãããéèããã®ããŒã«ãæãŠããã©ãŒã ãã倧谷ããã®160kmè¶ ã®éçãã¹ã€ãŒããŒã«å¯Ÿå¿ã§ããä¿èšŒã¯ãªãããã§ãã
ã§ããã°ãç¡çã«ã誰ãïŒå€éšç°å¢ïŒããããŠã³ãã«ç«ãããŠããã®å Žéãã®çµæã远ããããããèªåã®ãããã£ã³ã°ãã©ãŒã ããçæ³çãªè»éãæããŠãããããšããããµããŸãããã®ãã®ããã§ãã¯ããæ¹ããé¥ãã«ææçŸ©ã ãšæããŸãããïŒ
ãã¡ãããéèè±éã®ããŒã«ãæãŠãèœåãããã°ã倧谷ç¿å¹³ã®ããŒã«ãæãŠãå¯èœæ§ã¯é«ãã§ããããããããç§ãã¡ããã¹ãã³ãŒãã§æ€èšŒãããã®ã¯ãå人ã®ãå°é ã®è¯ããããæ§èœãã§ã¯ãªããã·ã¹ãã ãšããŠã®ãæ£ãããµããŸããã§ãã
ç°å¢ã«äŸåãããçµæãã远ããããã®ã§ã¯ãªããç°å¢ãåãé¢ããç¶æ ã§ãèªåãã¡ã®ããžãã¯ããæ£ããæå³ãäŒããããŠãããããæ€èšŒããã ãã®ããµããŸãã®ãã¹ãããžã®ã·ããããããå€éšç°å¢ã«å·Šå³ãããªããçã«å ç¢ãªçŸãäœãããã®æ¥µæãªã®ã§ãã
ïŒã€ã¥ãïŒ
#ãšã³ãžã㢠#ããã°ã©ãã³ã° #ãã¹ãã³ãŒã #ãŠããããã¹ã #ãœãããŠã§ã¢éçº #èšèš #ãã¬ãŒã ã¯ãŒã¯ #ã¢ã㯠#ã¹ã¿ã #ãªãã¡ã¯ã¿ãªã³ã° #ã¯ãªãŒã³ã³ãŒã #DBãã¹ã #éçºå¹ç #æ±æ ¹æž©æ³ç§å¯çµç€Ÿ #æè¡çè² åµ #å¢çç· #é¢å¿ã®åé¢