Class: Sequel::Dataset [Sequel: The Database Toolkit for Ruby]
A dataset represents an SQL query, or more generally, an abstract set of rows in the database. Datasets can be used to create, retrieve, update and delete records. Query results are always retrieved on demand, so a dataset can be kept around and reused indefinitely (datasets never cache results): my_posts = DB[:posts].filter(:author => 'david') # no records are retrieved my_posts.all # records are
File: cheat_sheet.rdoc [Sequel: The Database Toolkit for Ruby]
Cheat Sheet Open a database require 'rubygems' require 'sequel' DB = Sequel.sqlite('my_blog.db') DB = Sequel.connect('postgres://user:password@localhost/my_db') DB = Sequel.postgres('my_db', :user => 'user', :password => 'password', :host => 'localhost') DB = Sequel.ado('mydb') Open an SQLite memory database Without a filename argument, the sqlite adapter will setup a new sqlite database in memory
Ruby Sequel DBアクセスライブラリ - yshã®æ—¥è¨˜
Objecttank@rubyã®DBアクセスライブラリをDBIã‹ã‚‰Sequelã«ç§»è¡Œä¸ã€‚Sequelã®å‚考ページhttp://sequel.rubyforge.org/http://www.slideshare.net/zhesto/ruby-off-rails-japanesehttp://xxx.mostevildanceclassics.com/page/r/SequelRubyインストール sudo gem install sequel ã¨ã‚Šã‚ãˆãšå®Ÿè¡Œsequelã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ール。railsã®script/consoleã®ã‚ˆã†ãªã‚‚ã®ã€‚ sequel mysql://user:password@localhost/dbname DBã¨ã„ã†åå‰ã®å¤‰æ•°ã«æŽ¥ç¶šã‚ªãƒ–ジェクトãŒæ ¼ç´ã•ã‚Œã‚‹ãƒ†ãƒ¼ãƒ–ルå=userãŒã‚ã£ãŸã¨ã™ã‚‹ã¨ã€ã€ã€ DB[:user].filter(:id => 10).a
1
ランã‚ング
ランã‚ング
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
{{#tags}}- {{label}}
{{/tags}}