SQLを組ã¿ç«‹ã¦ã‚‹ã‚‚ã® - Practice of Programming最近ã€Tengを使ã£ã¦ã„ã¾ã™ãŒã€ãã‚Œã»ã©è¤‡é›‘ã§ã‚‚ãªã„SQLを組ã¿ç«‹ã¦ã‚‹ã®ã«ã€searchメソッドã¯ä½¿ã„ã«ãã„ã¨æ€ã†æ™‚ãŒå‰²ã¨å¤šã„(group by出æ¥ãªã„ã¨ã‹ã€x = ? or y = ? ã¨ã‹æ›¸ãã«ãã„ã¨ã‹)。ãŸã¶ã‚“ã€æ–¹é‡ã¨ã—ã¦ã€ã‚·ãƒ³ãƒ—ルãªSQL以外ã¯ã€search_by_sqlã‚’ã£ã¦ã„ã†ã“ã¨ãªã®ã ã‚ã†ã¨æ€ã„ã¾ã™ã€‚ ã§ã™ãŒã€SQLã‚’æ–‡å—列ã¨ã—ã¦çµ„ã¿ç«‹ã¦ã‚‹ã®ã¯ã€å‰²ã¨ã‚ã‚“ã©ãã•ã„ã®ã§ã€SQLを組ã¿ç«‹ã¦ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’使ã£ã¦ã€search_by_sqlã«æ¸¡ã—ã¦ã„ã¾ã™ã€‚ O/Rマッパーã§ã€SQLã®ã‚¯ã‚¨ãƒªã‚’組ã¿ç«‹ã¦ã‚‹ã‚‚ã®ãŒçµ„ã¿è¾¼ã¾ã‚Œã¦ã¾ã™ãŒã€Tengã§ä½¿ã‚ã‚Œã¦ã„ã‚‹ã®ã¯ã€SQL::Makerã€DBIx::Classã ã¨ã€SQL::Abstract。Tengã®searchメソッドã§ã¯ã€SQL::Makerã®select メソッドを使ã£ã¦ã„ã¾ã™ã®ã§ã€å‡ºæ¥ã‚‹ã“ã¨ã¯ã€selectメソッドã«å‡ºæ¥ã‚‹ã“ã¨ã«é™ã‚‰ã‚Œã¾ã™
Teng
{{#tags}}- {{label}}
{{/tags}}