DBFluteã®å°å ¥/æ§ç¯æ¯æ´ (AMP) http://www.leihauoli.com/oss (追è¨: ãã®ãµã¼ãã¹èªä½ã¯çµããã ãã§ã«ãªã³ã¯åããã¦ãã¾ã) 詳ããå 容ã¯ãã®ãã¼ã¸ã®éãã DBFlute ã¯ããããï¼å¨å¹´ãè¿ãã¾ãã -> DBFluteã¦ã¼ã¶ã®éã2011ãéå¬ | jfluteã®æ¥è¨ ãããããã«é å¼µã£ã¦ãããããã£ã¦ãã æ³åãé¥ãã«è¶ ããå¤ãã®ã¦ã¼ã¶ã®æ¹ã«ä½¿ã£ã¦ããã£ã¦ãã¾ãã ã¢ã¸ã¥ã¼ã«èªä½ã®å質ã«å¾¹åºããæ°ãã¤ãããªãããã ããã¥ã¡ã³ããæ´åããã°ã¨å¥®éãã¦åãã¾ããã ã¾ãéåã°ã§ããã¾ãããäºã¤å¼·ãæã£ããã¨ãããã¾ãã
ãã¾èªåã¯ãå ã»ã©ã®ãã¼ã¸ããæ³åãããããããã¾ãããã æ ªå¼ä¼ç¤¾ã¬ã¤ãã¦ãªãª (Lei Hau'oli) ã®ãã¼ããã¼ã¨ãã¦ã æ°äººãä¸éãç¾å ´ã¨ã³ã¸ãã¢ã®æè¡çã»æ¥åçãªæè²ãã å®éã®ç¾å ´ã®ããã¸ã§ã¯ãåæã»æ¹åæ¯æ´ãããã¦ããã£ã¦ãã¾ãã ãã®ä¸ã¤ã«ã転è·ãµã¤ãã®ããºãªã¼ã (Bizreach) ãããã¾ãã ããã°ã©ãã®ãã°ã§ ConditionBean ãå¤ã ãSQLã®ç¸è«ã åããããç¾å ´ã®åé¡ã«å¯¾å¿ããDBFluteã®æ©è½ãææ¡ãããã é±ä¸ã§DBFluteã®ãã³ãºãªã³ã®ã¯ã¼ã¯ã·ã§ãã(åå¼·ä¼)ãã£ããã (ãã³ãºãªã³ã¯ãã¯ã¼ãã³ãµã¤ããã«ã¯ãµ (Luxa) ã®æ¹ã§ã) å®ã¯ãæè¿å®è£ ããã ReplaceSchema ã® AlterCheck ãã SchemaSyncCheck ã« ColumnQuery ã®SQL颿°ãã£ã«ã¿ã ManualOrderBean ã§ç´°ããå¶å¾¡ãªã©ã¯ã ããºãªã¼ã(or ã«ã¯ãµ)ã§ã®æ¯æ´ã®ä¸ã§çã¾ããæ©è½ã§ããã ããã¦ãã°ãè¶³ããªãã¨ãããããã°é£ã§ãããã¾ç´ãã¦å³æä¾ã ããã¦DBå¨ãã«éãããWEBãã¬ã¼ã ã¯ã¼ã¯å¨ããDBè¨è¨ã éçºç°å¢ãããã¸ã§ã¯ãã®èª²é¡ç®¡çãããã¥ã¡ã³ãæ´åãªã©ã æ§ã ãªææ¡ã¨æ¯æ´ã¨å®è·µãæ¥ã æä¾ããã¦é ãã¦ãã¾ãã æ¹åã®å¹æã¯æ¸¬ããããªããã®ãã¨è©ä¾¡é ãã¦ãã¾ãã (æ¹åææ¡ãåãå ¥ãã¦é ãããããã¨ããããã¾ã) ããºãªã¼ãã¯æ¢ã«éç¨ä¸ã®ã·ã¹ãã ãªã®ã§ãæãåã£ããã¨ã¯ ãªããªãã§ããªããªããã(ãã¦ã!?)ãåå¨ãã¦ããåé¡ã¯ ããã¯ããã§ãã£ããåæãã¦ãªã«ãããã®ã¢ããã¼ãããã ãããç©ã¿éãã¦ãããã¨ã§ç¾å ´ã®ã¨ã³ã¸ãã¢ã®ã¹ãã¬ã¹ã¯ä¸ããã ã¾ãã«å ¨ä½æé©ã¨è¨ããå¹çåã享åã§ãã¦ããããªã¨ã ã·ã¹ãã éçºã®ç¾å ´ãè¯ããã®ã«ããããã¨ããä¸å¿ã§ é·ãéèãç¶ãã¦ãããã¨ãèªãå®è·µãã¦ãããã¨ã ãããã£ãèªåã®çµé¨ãä¼ããå ´ã¯ãªããªããªããã®ã§ã DBFluteèªèº«ã®æ©è½ãDBFluteã®ããã¥ã¡ã³ãã jfluteã®ããã°ãªã©ã«ãã®æããä¹ãã¦ãã¾ãããã ãã¯ãã jfluteèªèº«ãç¾å ´ã®ãã°ã«è¡ãã㨠ããã«åããã®ã¯ãªãã¨ãã¨ã¦ã宿ãã¾ããã 䏿¹ã§ãDBFluteãæå¹ã«ä½¿ã£ã¦ããã£ã¦ããªãããã ããã»ãã®åæ©è¸ã¿è¾¼ãã§ã¢ããã¼ããã¦ãããã¦ããã°ã ãã£ã¨å¹çã®è¯ãéçºãé²ãã¦ãããã¨ãã§ãã¦ããã¯ãã ã¨ããæãå ´é¢ã«ãããåºãããã¾ãã DBFluteã¯ãã¾ã ã¾ã ããã¥ã¡ã³ãæ¸ããã¨ããã¾ããã ç¾æç¹ã§ãæ¢ã«å¤ãã®ããã¥ã¡ã³ããåå¨ãã¦ãã¾ãã å¤ãã® Example ãããã¾ããML ã§ããã©ãã¼ãã¾ããã ãã ãDBFluteã¯ç¢ºå®ã«ããã¾ã¾ã§ã«ãªãããã¼ã«ã§ããã ãåã«æ¹åææ®µãæä¾ããã ãã§ãªãæ¹åã®æ¦å¿µãæä¾ãã¦ããã ã¨è¨ããåã«ãµã¤ãã«æ¸ãã¦ããã°ããã¨ãããã®ã§ããªãé¢ãã ãã³ãºãªã³ã®ã¯ã¼ã¯ã·ã§ããã®ä¸ã§ãæ©è½ã®æ¦å¿µãç´ã«ä¼ãã¦ã ãã¤ãæãåããã¦ãã®ã¡ãªããã宿ãã¦ããã£ããã å®éã«å®è£ ããããã°ã©ãã®æ¨ªã«ã¤ãã¦ãã©ãã¼ãããã ãã£ã¨æå¹å©ç¨ããããã®ãã®ç¾å ´ã«ãã£ããããç°å¢ä½ãã æé ãªã©ãæ´åãããããããã£ãæ¹åã»æ¯æ´ã§DBFluteã® åå¨ãããã«å¤§ããªãã®ã«æãã¦ããããã®ã§ã¯ãªããã¨ã (éçºè ã®DBFluteåãã©ãã©ãã¢ãããã¦ããã®ããããã¾ã) ãã¡ããããã¥ã¡ã³ãã®ãããªãæ¹åã¯é²ãã¦ãããªãããã ã¾ã ã¾ã DBFluteã®ããã£ãããªãä½¿ãæ¹ããç¾å ´ã«ããã¨æããã ãã¯ãã jfluteèªèº«ãããã°ã©ãã®ãã°ã«è¡ãã㨠ããã«åããã®ã¯ãªãã¨ãã¨ã¦ã宿ãã¾ããã ERD(ãã¼ãã«æ§é )ãDBFluteããããã£ãå®éã«DBFluteã å©ç¨ãã¦ããããã°ã©ã ãªã©ãè¦ãã°æ¹åç¹ã¯ããã«è¦ãã¦ãã¾ãã ããã¸ã§ã¯ãã®è¦ä»¶ãèãã°ãã©ã®ãããªDBè¨è¨ããªã·ã¼ã§ã ã©ã®ãããªDBFluteã®æ©è½ãå½ã¦ã¦ããã°è¯ãã®ãã å¹¾ãã§ãææ¡ã»æ¯æ´ãã§ããã§ãããã jflute èªèº«ãDBFluteã®ã³ã³ã·ã§ã«ã¸ã¥ã¨è¨ããããã§ãã
ãããããã¨ãããããã®ãAMP ãµã¼ãã¹ãã¯ã èªåã®æãããããã£ãä»äºã®ä¸ã¤ã¨è¨ããã®ã§ãã ããã°ãã¡ã¼ãªã³ã°ãªã¹ããTwitter ãªã©ã§å¹¾åº¦ã¨ãªã DBFluteã¦ã¼ã¶ããã©ãã¼ããã¦é ãã¾ãããã ãã¤ãé ã®çé ã«ããã£ã¦ããã¸ã¬ã³ãã¯ï¼ ãèªåããã®ç¾å ´ã«ãããã°ãªã...ã ã¨ã«ããç¾å ´ã®ããã°ã©ããã¢ã¼ããã¯ãã¨ç´æ¥è©±ããããã 話ãã§ããã°ãäºãã«è¯ãçµæãçããã¨ãã§ããã ããã¨ã ã¾ãã¯ãæ°è»½ã«ç¸è«ãã¦é ããã°ã¨ã éçºåã§ããã°ãæ§ã ãªé¸æè¢ã§è¯ãéçºåºç¤ã 模索ã§ããã§ããããæ¢ã«éçºä¸ãéç¨ä¸ã§ããã°ã ç¾ç¶ã®åæããå ¥ããç¶æ³ã¨è²»ç¨å¯¾å¹æã¨ã®ãã©ã³ã¹ã ã¨ããªããå¹ççãªã¢ããã¼ããèãã¦ããã§ãããã ãããã«ããå°å ¥ããããã®ã¯ãã¾ãã¯ã»ããã¼ã®éå¬ã ãã£ããããã¼ã®ã¹ãã«ã»ãããåºä¸ãããªãããã ããã§ç¾å ´ã®æ¹ã¨ã³ãã¥ãã±ã¼ã·ã§ã³ã¨ãã¤ã¤ã ãã®å¾ã©ã®ãããªå½¢å¼ã§æ¯æ´ããã¦ããã®ããè¦ãã¦ãããã æ§ã ãªé¸æè¢ããããã¨æãã¾ãã ã¾ããã¬ã¤ãã¦ãªãªã«ã¯ãç´¹ä»ãããã¼ã¸ã®å³å´ã«ããããã¼ã®éãã WEBãµã¤ãã®ããã©ã¼ãã³ã¹é¢é£ã®æ¹åã®ãµã¼ãã¹ãããã¾ãã WEBãã¶ã¤ã³ã«ã¨ã¦ãå¼·ãä¼ç¤¾ã§ãã®ã§ãå¹ åºãæ¯æ´ãå¯è½ã§ãã 質ã¨åå°ãç©ã¿ä¸ãã¦ãç·åçãªã¹ãã¼ãããå¾ãããããã«ã ã¬ã¤ãã¦ãªãªã¨ jflute ãååããã¦é ããã°ã¨ã¨æãã¾ãã // 質ã¨åå°ãããã¦å®ç´ããã¹ãã¼ããæãã | jfluteã®æ¥è¨ http://d.hatena.ne.jp/jflute/20110731/speed # # ãã®ãããªæ çµã¿ãç¨æãã¦ããããstakeuchi ããã # ããã¦ãã¨ã¦ãç´ æµã§ãããããªãã¼ã¸ããã¶ã¤ã³ã㦠# ãããã¬ã¤ãã¦ãªãªã®ãã¶ã¤ãã¼é£ã«æ·±ãæè¬è´ãã¾ãã # ãããã¨ããããã¾ãã #