Sequelã¨æˆ¯ã‚Œã¦åˆ†ã‹ã£ãŸã“ã¨ã‚’メモ書ã - Qiitarequire 'sequel' require 'logger' opts = { # hostãªã©DBæŽ¥ç¶šæƒ…å ± loggers: [Logger.new('/tmp/sql.log')] } dbh = Sequel.connect(opts) dbh[:sample_data___st].select( :st__id, :st__data ).where( st__id: 10 ).all # é…列形å¼ã§è©²å½“ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’全件å–å¾— ã¨ã€ã“ã‚“ãªé¢¨ã«ã™ã‚‹ã“ã¨ã§loggersã‚ーã§æŒ‡å®šã—ãŸå ´æ‰€ã«SQLãŒå‡ºåŠ›ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ã”覧ã®ã¨ãŠã‚Šloggersã«ã¯é…列を渡ã—ã¦ã„ã‚‹ã®ã§è¤‡æ•°ã®ãƒã‚°ã«åãã“ã¨ãŒå¯èƒ½ã¨ãªã£ã¦ã„ã¾ã™ã€‚ 出力çµæžœã¨ã—ã¦ã¯ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ (0.019228s) SELECT `st`.`id`, `st`.`data` FROM `sample_data` AS `st`
4.46.0.txt
Sequel: The Database Toolkit for Ruby
ãŠæ‰‹è»½ O/R Mapper `Sequel` - Qiita
{{#tags}}- {{label}}
{{/tags}}