ã«ã²ã‚Šãšã‚€::ã—ã‚“ã·ã‚‹ - DBI ã§å®Ÿéš›ã«ç™ºè¡Œã•ã‚Œã‚‹ã‚¯ã‚¨ãƒªãƒ¼ã‚’å–å¾—ã™ã‚‹ DBIx::QueryLog を書ã„ãŸå£ç¯€ãŒå¤‰ã‚ã£ã¦ã€æ—©é€Ÿé¢¨é‚ªã‚’ã²ã„ã¦ã„ã¾ã™ã€‚ ã•ã¦ã€ã‚‚ã†ç§‹ã‚’通り越ã—ã¦å†¬ã®æ§˜ç›¸ã‚’呈ã—ã¦ããŸæ˜¨ä»Šã§ã¯ã‚ã‚Šã¾ã™ãŒã€DBI ã§ã¯ã€æ™®é€šã¯ãƒ—レースホルダを使ㄠmy $stmt = 'SELECT * FROM user WHERE user_id = ?'; my @bind = ($user_id); $dbh->do($stmt, undef, @bind); ã¨ã‹æ›¸ãã¨æ€ã„ã¾ã™ã€‚ ã“ã®ã¨ãã«ã€å®Ÿéš›ã«ãƒã‚¤ãƒ³ãƒ‰ã•ã‚ŒãŸå¾Œã® SQL ã‚’ã¿ãŸã„ãªãƒ¼ã£ã¦è¡å‹•ã«é§†ã‚‰ã‚Œã‚‹ã¨æ€ã„ã¾ã™ãŒ*1ã€ã©ã†é ‘å¼µã£ã¦ãƒ‰ã‚ュメントをèªã‚“ã§ã‚‚ã‚ã‹ã‚Šã¾ã›ã‚“ã。 ã“ã†ã„ã†ã¨ãã¯ä»•æ–¹ãªã„ã®ã§ã€$stmt 㨠@bind を両方ãƒã‚°ã«å‡ºã—ã¦ãŠèŒ¶ã‚’æ¿ã—ã¦ã„ã¾ã—ãŸã€‚ $self->log->_dump($stmt, @bind); # => SELECT * FROM user WHERE user_id = ?, [1234] ã§ã‚‚ã“ã‚Œã£
{{#tags}}- {{label}}
{{/tags}}