CRUDæäœ - CRUDãšã¯ïŒ
Webå¶äœã«æ¬ ãããªãCRUDæäœãåŠã¶ãããŒã¿ããŒã¹ã®ããŒã¿ã®äœæãèªã¿èŸŒã¿ãæŽæ°ãåé€ããå®è·µçãªäŸãšãã³ãã§åŠã³ãŸãã

CRUD æäœã¯ã Web éçºã«ããã æãåºæ¬çãªæŠå¿µã® 1 ã€ã§ããã·ã³ãã«ãªãŠã§ãã¢ããªã±ãŒã·ã§ã³ãæ§ç¯ããå Žåã§ããè€éãªäŒæ¥ã·ã¹ãã ãæ§ç¯ããå Žåã§ãã ã®æäœãçè§£ããããšã¯ãããŒã¿ãæ±ãäžã§äžå¯æ¬ ã§ãããã®èšäºã§ã¯ã ãäœãæå³ããã®ãããŸãããŒã¿ããŒã¹ã§ããŒã¿ã管çããããã«ã©ã®ããã«äœ¿çšãããã®ããæ¢ããŸãããŸãã ã®æäœã®å®äŸãã ãèªåã®ãããžã§ã¯ãã«å°å ¥ããããã®ãã³ãããã¹ããã©ã¯ãã£ã¹ã玹ä»ããŸãããŠã§ãéçºã®åå¿è ã§ããçµéšè±å¯ãªããã§ãããã®èšäºãèªãã°ãä¿¡é Œæ§ãšæ¡åŒµæ§ã®é«ããŠã§ãã¢ããªã±ãŒã·ã§ã³ã®æ§ç¯ã«ããã ã®æäœã®åœ¹å²ãæ·±ãçè§£ããããšãã§ããŸããCRUDCRUDCRUDCRUDCRUD
CRUD ãšã¯ïŒ
CRUDCreateãReadãUpdateãDeleteã®é æåããšã£ããã®ã§ã ãœãããŠã§ã¢éçº ã«ãããããŒã¿ç®¡çã»æäœã«äžå¯æ¬ ãª4ã€ã®æäœã衚ããŠããŸãããããã®æäœã¯ãããŒã¿ããŒã¹ãããŒã¿ã¹ãã¬ãŒãžã·ã¹ãã ãšçžäºäœçšããã»ãšãã©ã®ã¢ããªã±ãŒã·ã§ã³ã®ããã¯ããŒã³ã圢æããŠããŸããäŸãã°ããŠãŒã¶ãŒããªã³ã©ã€ã³ã¹ãã¢ã«ååã远å ãã é»ååååŒã¢ããªã±ãŒã·ã§ã³ãèã㊠ã¿ãŸããããäœæãæäœã¯ãŠãŒã¶ãŒãæ°ããååã远å ããããšãå¯èœã«ãããèªã¿åããæäœã¯è¡šç€ºããããã«ååæ å ±ãååŸããã
åºäž»ãååã®è©³çްãäŸ¡æ ŒãæŽæ°ãããšããæŽæ°ããªãã¬ãŒã·ã§ã³ãç»å ŽããŸããæåŸã«ãååã®åšåº«ããªããªã£ãããåé€ããå Žåã¯ããåé€ããªãã¬ãŒã·ã§ã³ã䜿çšããŸãããããã®CRUD æäœãå®è£ ããããšã§ããœãããŠã§ã¢éçºè ã¯å æ¬çãã€çŽæçãªãŠãŒã¶ãŒãšã¯ã¹ããªãšã³ã¹ãæäŸããåºç€ããŒã¿ãšã·ãŒã ã¬ã¹ã«å¯Ÿè©±ã§ããããã«ãªããŸããCRUD ãªãã¬ãŒã·ã§ã³ã®å®è£ ã¯ã SQLããŒã¿ããŒã¹ãNoSQLããŒã¿ããŒã¹ã RESTful APIãªã©ã䜿çšããæè¡ã¹ã¿ãã¯ã«ãã£ãŠç°ãªãããšãå€ãã
ã¡ãªããCRUD
ãœãããŠã§ã¢éçºã«ãããCRUD ã®éçšã®ã¡ãªããã¯æ°å€ããã¢ããªã±ãŒã·ã§ã³ã®å¹çæ§ãä¿å®æ§ããŠãŒã¶ãŒãšã¯ã¹ããªãšã³ã¹ã«å€§ããå¯äžããŠããŸããäž»ãªå©ç¹ã¯ä»¥äžã®éãã§ãã
-
æšæºåïŒCRUD ãªãã¬ãŒã·ã§ã³ã¯ãããŒã¿ã¹ãã¬ãŒãžã·ã¹ãã ãšå¯Ÿè©±ããããã®å ±éã®ãã¬ãŒã ã¯ãŒã¯ã確ç«ããéçºè ãç°ãªãã¢ããªã±ãŒã·ã§ã³ããã©ãããã©ãŒã ãçè§£ããäœæ¥ããããšã容æã«ããã
-
éçºããã»ã¹ã®ç°¡çŽ åãCRUD ã¢ãã«ã«æºæ ããããšã§ãéçºè ã¯ã¢ããªã±ãŒã·ã§ã³ã®äœæããã»ã¹ãåçåããããšãã§ããããŒã¿æäœã®ããã«å®è£ ãã¹ãæäœã®ã»ãããæç¢ºã«ãªããŸããããã«ãããäžè²«æ§ã®ããå¹ççãªéçºãå¯èœã«ãªããŸãã
-
ä¿å®æ§ã® åäžãCRUDããŒã¹ã®ã¢ããªã±ãŒã·ã§ã³ã¯ãããŒã¿ç®¡çã«é¢ããæšæºçãªã¢ãããŒãã«åŸã£ãŠãããããäžè¬çã«ä¿å®ã容æã§ãããã®ãããéçºè ã¯å¿ èŠã«å¿ããŠããã©ãã«ã·ã¥ãŒãã£ã³ã°ãã¢ããªã±ãŒã·ã§ã³ã®ã¢ããããŒããç°¡åã«è¡ãããšãã§ããŸãã
-
ãŠãŒã¶ãŒãšã¯ã¹ããªãšã³ã¹ã® åäžãCRUD ã®æäœãå®è£ ããããšã§ããŠãŒã¶ãŒã¯ã¢ããªã±ãŒã·ã§ã³å ã§ããŒã¿ã®äœæãèªã¿åããæŽæ°ãåé€ãªã©ã®éèŠãªã¿ã¹ã¯ãã·ãŒã ã¬ã¹ã«å®è¡ã§ããããã«ãªããŸãããã®çµæãçŽæçã§æºè¶³åºŠã®é«ããŠãŒã¶ãŒãšã¯ã¹ããªãšã³ã¹ãå®çŸããŸãã
-
ã¢ãžã¥ãŒã«æ§ãšæè»æ§ãCRUDããŒã¹ã®ã¢ããªã±ãŒã·ã§ã³ã§é¢å¿äºãåé¢ããããšã§ãã¢ãžã¥ãŒã«æ§ãšæè»æ§ãä¿é²ãããŸããã€ãŸããéçºè ã¯ãã·ã¹ãã å šäœã«åœ±é¿ãäžããããšãªããç¹å®ã®ã¢ããªã±ãŒã·ã§ã³éšåãç°¡åã«å€æŽãããæ¡åŒµãããããããšãã§ããŸãã
-
ã¹ã±ãŒã©ããªãã£ãCRUD ã¢ãã«ã§ã¯ãããŒã¿ããŠãŒã¶ãŒã®éèŠã®å¢å ã«å¯Ÿå¿ããããã«ãã¢ããªã±ãŒã·ã§ã³ãããç°¡åã«æ¡åŒµããããšãã§ããŸããããŒã¿ç®¡çã«å¯Ÿããæšæºåãããã¢ãããŒãã«ãããéçºè ã¯ããã©ãŒãã³ã¹ãæé©åããã¢ããªã±ãŒã·ã§ã³ãå¢å ããäœæ¥è² è·ã«å¯Ÿå¿ã§ããããã«ããããšãã§ããŸãã
-
ããŸããŸãªãã¯ãããžãŒãšã®äºæ æ§ïŒCRUD ã®æäœã¯ããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ãNoSQL ããŒã¿ããŒã¹ãRESTful APIãGraphQL ãªã©ãããŸããŸãªãã¯ãããžãŒã§é©çšå¯èœã§ãããã®æ±çšæ§ã«ãããéçºè ã¯CRUDããŒã¹ã®ã·ã¹ãã ãæ§ã ãªæè¡ã¹ã¿ãã¯ã«æ¡çšã»çµ±åããããšã容æã«ãªããŸãã
CREATE ãªãã¬ãŒã·ã§ã³ãšã¯ãã©ã®ãããªãã®ã§ããïŒ
CRUD ã®4ã€ã®æäœã®ãã¡ãæåã®æäœã§ããCREATE æäœã¯ãããŒã¿ããŒã¹ã APIãªã©ã® ããŒã¿ä¿åã·ã¹ãã ã«æ°ããããŒã¿é ç®ããªããžã§ã¯ãã远å ããŸãããœãããŠã§ã¢éçºã§ã¯ãCREATE ãªãã¬ãŒã·ã§ã³ã«ããããŠãŒã¶ãŒã¯ã¢ããªã±ãŒã·ã§ã³å ã§æ°ããã¬ã³ãŒãããªãœãŒã¹ãçæããããšãã§ããŸããäŸãã°ããŠãŒã¶ãŒããœãŒã·ã£ã«ã¡ãã£ã¢ãã©ãããã©ãŒã ã«ãµã€ã³ã¢ãããããšããCREATE æäœã¯ããŠãŒã¶ãŒåãé»åã¡ãŒã«ããã¹ã¯ãŒããªã©ã®ãŠãŒã¶ãŒã®æ å ±ãããŒã¿ããŒã¹ã«ä¿åããŸãããã®ããã»ã¹ã§ã¯éåžžããŠãŒã¶ãŒããã®å ¥åãåãåããããŒã¿ãæ€èšŒããæ°ããããŒã¿ã¢ãã«ã€ã³ã¹ã¿ã³ã¹ïŒäŸãã°ããŠãŒã¶ãŒãªããžã§ã¯ãïŒãæ§ç¯ããã
æ°ããã€ã³ã¹ã¿ã³ã¹ãæºåããããšãCREATE ãªãã¬ãŒã·ã§ã³ã¯ããããããŒã¿èšæ¶ã·ã¹ãã ã«æ¿å ¥ããå°æ¥ã®æ€çŽ¢ãšå€æŽã®ããã«äžæã®èå¥åãå²ãåœãŠããCREATE ãªãã¬ãŒã·ã§ã³ã®å®è£ ã¯ããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã§ã® SQL ãINSERTãã³ãã³ãã®å®è¡ããRESTful API ãžã® HTTP ãPOSTããªã¯ãšã¹ããªã©ã䜿çšããæè¡ã¹ã¿ãã¯ã«ãã£ãŠç°ãªããŸããæ°ããããŒã¿ãä¿åããã¡ã«ããºã ãæäŸããããšã§ãCREATE æäœã¯ããŠãŒã¶ãŒã®å ¥åã«åºã¥ããŠç¶ç¶çã«é²åãããã€ãããã¯ã§ã€ã³ã¿ã©ã¯ãã£ããªã¢ããªã±ãŒã·ã§ã³ãéçºããããšãå¯èœã«ããŸãã
READ ãªãã¬ãŒã·ã§ã³ãšã¯äœã§ããããŸãã©ã®ããã«æ©èœããã®ã§ããïŒ
CRUD ãã©ãã€ã ã«ããã2çªç®ã®èŠçŽ ã§ããREAD ãªãã¬ãŒã·ã§ã³ã¯ãããŒã¿ããŒã¹ãAPIãªã©ã®ã¹ãã¬ãŒãžã·ã¹ãã ããããŒã¿ãååŸã衚瀺ããããã«äžå¯æ¬ ã§ãããœãããŠã§ã¢éçºã§ã¯ãREAD ã®æäœã«ããããŠãŒã¶ãŒãã¢ããªã±ãŒã·ã§ã³å ã«ä¿åãããŠããæ å ±ã«ã¢ã¯ã»ã¹ãã衚瀺ããããšãã§ããŸããäŸãã°ããªã³ã©ã€ã³ã¹ãã¢ãé²èЧããå ŽåãREAD æäœã¯ãååãäŸ¡æ Œã説æãªã©ã®åå詳现ãããŒã¿ããŒã¹ããååŸãããŠãŒã¶ãŒãé²èŠ§ã»æäœã§ããããã«è¡šç€ºããããã®ããã»ã¹ã§ã¯éåžžãç¹å®ã®ãã©ã¡ãŒã¿ããã£ã«ã¿ã䜿çšããŠããŒã¿ã¹ãã¬ãŒãžã·ã¹ãã ã«åãåãããè¡ããç®çã®ããŒã¿ãæ¢ããŸãã
ããŒã¿ãååŸããåŸã¯ãã¢ããªã±ãŒã·ã§ã³ã®ã€ã³ã¿ãŒãã§ã€ã¹å ã§ãŠãŒã¶ãŒãã¬ã³ããªãŒãªè¡šç€ºãã§ãããããå€æãæžåŒèšå®ãè¡ãããããšãå€ããREAD ãªãã¬ãŒã·ã§ã³ã®å®è£ ã¯ããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã§ã® SQL "SELECT" ã³ãã³ãã®å®è¡ããRESTful API ãžã® HTTP "GET" ãªã¯ãšã¹ããªã©ã䜿çšããæè¡ã¹ã¿ãã¯ã«ãã£ãŠç°ãªããŸããREAD ãªãã¬ãŒã·ã§ã³ã䜿çšãããšãéçºè ã¯ãä¿åãããããŒã¿ã«ã¢ã¯ã»ã¹ããŠè¡šç€ºããã¡ã«ããºã ãæäŸããããšã«ãã£ãŠãããŸããŸãªãŠãŒã¶ãŒã®ããŒãºã奜ã¿ã«å¯Ÿå¿ãããè±ãã§æ å ±éã®å€ãé åçãªã¢ããªã±ãŒã·ã§ã³ãäœæã§ããŸãã
UPDATE ãªãã¬ãŒã·ã§ã³ãšã¯ãã©ã®ãããªãã®ã§ããïŒ
CRUD ãã¬ãŒã ã¯ãŒã¯ã®3çªç®ã®ã³ã³ããŒãã³ãã§ããUPDATE ãªãã¬ãŒã·ã§ã³ã¯ãããŒã¿ããŒã¹ã API ãªã©ã®ã¹ãã¬ãŒãžã·ã¹ãã å ã®æ¢åã®ããŒã¿ã倿Žãã圹å²ãæ ã£ãŠããŸãããœãããŠã§ã¢éçºã§ã¯ãUPDATE ãªãã¬ãŒã·ã§ã³ã«ããããŠãŒã¶ãŒã¯ã¢ããªã±ãŒã·ã§ã³å ã§ä»¥åã«ä¿åãããæ å ±ã倿Žããããšãã§ããŸããããšãã°ããŠãŒã¶ãŒããœãŒã·ã£ã«ã»ã¡ãã£ã¢ã»ãã©ãããã©ãŒã ã§ãããã£ãŒã«ç»åãæŽæ°ããå ŽåãUPDATE æäœã«ãããããŒã¿ããŒã¹å ã®å€ãç»åãæ°ããç»åã«çœ®ãæããŸãããã®ããã»ã¹ã§ã¯ãéåžžã倿Žããç¹å®ã®ã¬ã³ãŒããŸãã¯ãªãœãŒã¹ãç¹å®ããæ°ããããŒã¿ãæ€èšŒãã倿ŽãããŒã¿ã¹ãã¬ãŒãžã·ã¹ãã ã«é©çšããŸãã
UPDATE ãªãã¬ãŒã·ã§ã³ã¯ãã¬ã³ãŒãã®å 容ã倿ŽããŠãããã®ã¬ã³ãŒãã®äžæãªèå¥åãä¿æããããšã§ãããŒã¿ã®æŽåæ§ãšäžè²«æ§ã確ä¿ããŸããUPDATE ãªãã¬ãŒã·ã§ã³ã®å®è£ ã¯ããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã§ã®SQL "UPDATE" ã³ãã³ãã®å®è¡ããRESTful APIãžã®HTTP "PUT" ãŸã㯠"PATCH" ãªã¯ãšã¹ããªã©ã䜿çšããæè¡ã¹ã¿ãã¯ã«ãã£ãŠç°ãªããä¿åãããããŒã¿ã倿Žããã¡ã«ããºã ãæäŸããããšã§ãUPDATE ãªãã¬ãŒã·ã§ã³ã¯ãéçºè ããŠãŒã¶ãŒãšã®ããåããèŠä»¶ã®å€åã«å¿ããŠé²åã§ãããé©å¿æ§ãšå¿çæ§ã«åªããã¢ããªã±ãŒã·ã§ã³ãäœæã§ããããã«ããŸãã
DELETE ãªãã¬ãŒã·ã§ã³ãšã¯äœã§ããããŸãã©ã®ããã«æ©èœããã®ã§ããïŒ
DELETE ãªãã¬ãŒã·ã§ã³ã¯ãCRUD ãã¬ãŒã ã¯ãŒã¯ã®æåŸã®åŽé¢ã§ãããŒã¿ããŒã¹ã API ãªã©ã®ã¹ãã¬ãŒãžã·ã¹ãã ããããŒã¿ãåé€ãã圹å²ãæ ã£ãŠããŸãããœãããŠã§ã¢éçºã§ã¯ãDELETE ãªãã¬ãŒã·ã§ã³ã«ããããŠãŒã¶ãŒã¯ã¢ããªã±ãŒã·ã§ã³å ã®ç¹å®ã®ã¬ã³ãŒãããªãœãŒã¹ãæ°žä¹ ã«åé€ããããšãã§ããŸããããšãã°ããŠãŒã¶ãŒãããã°ãã©ãããã©ãŒã ããæçš¿ãåé€ããå ŽåãDELETE æäœã¯ãããŒã¿ããŒã¹ããé¢é£ããããŒã¿ãåé€ããããã®ããã»ã¹ã§ã¯éåžžãäžæã®èå¥åã䜿çšããŠåé€ããã¬ã³ãŒããŸãã¯ãªãœãŒã¹ãèŠã€ããããŒã¿èšæ¶ã·ã¹ãã ããåé€ããã³ãã³ããçºè¡ããŸãã
åé€ããã»ã¹ã§ã¯ããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã®å€éšããŒå¶çŽãRESTful APIã®äŸåãªãœãŒã¹ãªã©ãé¢é£ããããŒã¿ãé©åã«åŠçããŠãããŒã¿ã®æŽåæ§ãšäžè²«æ§ãç¶æããããšã極ããŠéèŠã§ãããDELETE æäœã®å®è£ ã¯ããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã§ã® SQL "DELETE" ã³ãã³ãã®å®è¡ããRESTful API ãžã® HTTP "DELETE" ãªã¯ãšã¹ããªã©ã䜿çšããæè¡ã¹ã¿ãã¯ã«äŸåããŸããä¿åãããããŒã¿ãåé€ããã¡ã«ããºã ãæäŸããããšã§ãDELETE æäœã¯ããŠãŒã¶ãŒã®ããŒãºã«é©å¿ããããŒã¿ä¿æããªã·ãŒã«æºæ ããã¹ãã¬ãŒãžãªãœãŒã¹ãæé©åã§ãããæè»ã§ç®¡çããããã¢ããªã±ãŒã·ã§ã³ãéçºããããšãå¯èœã«ããŸãã
ãŸãšã
çµè«ãšããŠãCRUD ãã¬ãŒã ã¯ãŒã¯ïŒCreate, Read, Update, Delete æäœã§æ§æïŒã¯ããœãããŠã§ã¢éçºã«ãããå¹ççãªããŒã¿ç®¡çã»æäœã®ç€ãšãªããã®ã§ãããCRUD ã®ã¢ãã«ã«åŸãããšã§ãéçºè ã¯çŽæçã§ã¹ã±ãŒã©ãã«ããã€ä¿å®æ§ã®é«ãã¢ããªã±ãŒã·ã§ã³ãèšèšã§ããã·ãŒã ã¬ã¹ãªãŠãŒã¶ãŒãšã¯ã¹ããªãšã³ã¹ãæäŸããããšãã§ããŸãããããã®æäœã¯ã倿§ãªæè¡ã¹ã¿ãã¯ã«å¯Ÿå¿ããçŸä»£ã®éçºææ³ã«ãããäºææ§ãšæ±çšæ§ãä¿èšŒããŸããããŒã¿é§ååã¢ããªã±ãŒã·ã§ã³ãžã®äŸå床ãé«ãŸãäžããœãããŠã§ã¢éçºè ã«ãšã£ãŠCRUD ãªãã¬ãŒã·ã§ã³ãçè§£ãã䜿ãããªãããšãããäžå±€å¿ èŠãšãªã£ãŠããŸããCRUD ãã©ãã€ã ãæ¡çšããããšã§ã éçº ããã»ã¹ãåçåãããã€ãããŒã·ã§ã³ãžã®éãéãããŸããéçºè ã¯ããŠãŒã¶ãŒãåã°ãããŠããŒã¯ãªæ©èœãç¹åŸŽãäœãäžããããšã«éäžããé²åãç¶ããããžã¿ã«ç°å¢ã®äžã§åªäœã«ç«ã€ããšãã§ããã®ã§ãã


