[CakePHP2] SQL文を貼り付ã‘ã‚‹ã¨ã€CakePHPã®ã‚³ãƒ¼ãƒ‰ã‚’生æˆã™ã‚‹ã‚µãƒ¼ãƒ“ス - cakephperã®æ—¥è¨˜(CakePHP, Laravel, PHP)infinitas-cms.org ã¨ã„ã†CakePHP製CMSを開発ã—ã¦ã„ã‚‹ @dogmatic69 ã•ã‚“ãŒã€ã™ã”ã„ã‚‚ã®ã‚’開発ã—ã¦ã¾ã—ãŸã€‚ ãªã‚“ã¨ã€SQL文をペーストã™ã‚‹ã¨ã€CakePHPã®ã‚³ãƒ¼ãƒ‰ã‚’生æˆã™ã‚‹ã‚‚ã®ã§ã™ã€‚ http://dogmatic69.com/sql-to-cakephp-find-converter コードã¯3パターン出力ã•ã‚Œã¾ã™ã€‚オプションをé¸ã¶ã¨ã€ClassRegistry::init経由ã§ã®å‘¼ã³å‡ºã—パターンã¨ã‹åˆ‡ã‚Šæ›¿ãˆå¯èƒ½ã§ã™ã€‚ findã®ã‚ªãƒ—ションã§æŒ‡å®šã™ã‚‹æ–¹æ³• find('all', $params)ã¿ãŸã„ãªãƒ‘ターン Modelã®ã‚³ãƒ¼ãƒ‰ã‚’出力。カスタムfindメソッドを生æˆã™ã‚‹ãƒ‘ターン Paginationコンãƒãƒ¼ãƒãƒ³ãƒˆã§æŒ‡å®šã™ã‚‹ãƒ‘ターン ãƒãƒ¼ãƒãƒ£ãƒ«ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãªã©ã‚‚考慮ã—ã¦å‡ºåŠ›ã™ã‚‹ã¨ã„ã†ç´ 晴らã—ã„ä»•æ§˜ï¼ ãŸã¨ãˆã°ã€ä¸‹è¨˜ã®ã‚ˆã†ãªSQLを貼り付ã‘る㨠selec
![[CakePHP2] SQL文を貼り付ã‘ã‚‹ã¨ã€CakePHPã®ã‚³ãƒ¼ãƒ‰ã‚’生æˆã™ã‚‹ã‚µãƒ¼ãƒ“ス - cakephperã®æ—¥è¨˜(CakePHP, Laravel, PHP)](https://cdn-ak-scissors.b.st-hatena.com/image/square/d2f5c893612fcdca8ce9e8e801f54392e6a80eb9/height=288;version=1;width=512/https%3A%2F%2Fogimage.blog.st-hatena.com%2F17680117127146702927%2F17680117127146706797%2F1558249239)
{{#tags}}- {{label}}
{{/tags}}