Sequel ã§ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ç®¡ç† - basyura's blog
ç›´æ„Ÿçš„ã« Users.create ãŒç‹¬ç«‹ã—ã¦ã‚‹ã‚ˆã†ã«è¦‹ãˆã¦ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ç®¡ç†ã•ã‚Œãªã„よã†ã«æ„Ÿã˜ã‚‹ã‚“ã ã‘ã©ã€ ç´ ç›´ã« transaction を使ãˆã°ã„ã„。 require 'rubygems' require 'sequel' # DB オープン DB = Sequel.sqlite("transaction.db") # ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç”Ÿæˆ unless DB.table_exists? :users DB.create_table :users do primary_key :id text :screen_name, :unique => true text :description end end # モデル定義 class Users < Sequel::Model ; end # テーブルã‹ã‚‰ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’削除 Users.delete # ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿½åŠ Users.create
merbメモ| Sequelã§ã‚¢ã‚½ã‚·ã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã¤ã‹ã†
Sequelã§ã¯has_manyã¨ã‹belongs_toã¯ã‚¨ã‚¤ãƒªã‚¢ã‚¹ã§ã€å®Ÿéš›ã«ã¯one_to_many,many_to_one,many_to_manyã®3ã¤ã®ãƒ¡ã‚½ãƒƒãƒ‰ã ã‘ãŒå˜åœ¨ã—ã¾ã™ã€‚has_one相当ã¯ã‚ã‚Šã¾ã›ã‚“。 関係ã®å®šç¾© ã ã„ãŸã„ã“ã‚“ãªæ„Ÿã˜ã€‚ class Article < Sequel::Model has_many :comments #複数ã®ã‚³ãƒ¡ãƒ³ãƒˆã‚’æŒã¤ã®ã§è¤‡æ•°å½¢ belongs_to :category #ã²ã¨ã¤ã®ã‚«ãƒ†ã‚´ãƒªã«æ‰€å±žã™ã‚‹ã®ã§å˜æ•°å½¢ many_to_many :tags #複数ã®ã‚¿ã‚°ã¨ãã£ã¤ãã®ã§è¤‡æ•°å½¢ end class Comment < Sequel::Model belongs_to :article end class Category < Sequel::Model has_many :articles end class Tag < Sequ
ã¯ã¦ãªãƒ–ãƒã‚° | 無料ブãƒã‚°ã‚’作æˆã—よã†
æ€ã„ã¯è¨€è‘‰ã«ã€‚ ã¯ã¦ãªãƒ–ãƒã‚°ã¯ã€ã‚ãªãŸã®æ€ã„や考ãˆã‚’残ã—ãŸã‚Šã€ ã•ã¾ã–ã¾ãªäººãŒç¶´ã£ãŸå¤šæ§˜ãªä¾¡å€¤è¦³ã«è§¦ã‚ŒãŸã‚Šã§ãã‚‹å ´æ‰€ã§ã™ã€‚
ãªã‚“ã‹ã°ã‚“ã–ã„ | Ramaze ver. 2008.06（ã¨Sequelã¨Erubis）使ã£ã¦ã¿ãŸ
ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã¨ã„ãˆã°æŽ²ç¤ºæ¿ã ã¨æ€ã†ã®ã§æŽ²ç¤ºæ¿ã‚’ã¤ãã£ã¦ã¿ãŸã€‚ インストール gemã§ã„ã‚ã„ã‚入れる。aptã§SQLite3ã¨ã‹ã‚‚ã„ã‚Œã¨ã。 # sudo gem install ramaze sequel erubis thin # ramaze -v Ramaze Version 2008.06, on ruby 1.8.6 (2007-09-24) [i486-linux] プãƒã‚¸ã‚§ã‚¯ãƒˆä½œæˆ # ramaze --create bbs # cd bbs Model å‰ã‹ã‚‰æ°—ã«ãªã£ã¦ãŸSequelを使ã†ã€‚Merbã‚„Railsã¿ãŸã„ã«database.ymlã¨ã‹ãªã„ã®ã§ç”Ÿã§æ‰±ã†ã€‚ # vim model/post.rb require "sequel" DB=Sequel.sqlite "sqlite.db" class Post Time.now) if columns.include
File: README.rdoc [Sequel: The Database Toolkit for Ruby]
Sequel is a lightweight database access toolkit for Ruby. Sequel provides thread safety, connection pooling and a concise DSL for constructing database queries and table schemas. Sequel also includes a lightweight but comprehensive ORM layer for mapping records to Ruby objects and handling associated records. Sequel supports advanced database features such as prepared statements, bound variables,
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
第9回　Sinatraã¨Sequel・Hamlã§æŽ²ç¤ºæ¿ã‚¢ãƒ—リを作る | gihyo.jp
ã¯ã˜ã‚㫠第7回ã¯Rails以外ã®Webフレームワークã®ç°¡å˜ãªç´¹ä»‹ã¨ã€Sinatraã§Hello Worldアプリケーションを動ã‹ã™ã¨ã“ã‚ã¾ã§ã‚’解説ã—ã¾ã—ãŸã€‚今回ã¯Sinatraã§å®Ÿéš›ã®ã‚¢ãƒ—リケーションを作りã€Sequelã¨Hamlã¨ã„ã†2ã¤ã®ãƒ©ã‚¤ãƒ–ラリを紹介ã—ã¾ã™ã€‚ Sinatraã®ç‰¹å¾´ã¯ã€CGIスクリプトã®ã‚ˆã†ã«ãƒ•ã‚¡ã‚¤ãƒ«ä¸€ã¤ã‹ã‚‰ã‚¢ãƒ—リケーションãŒæ›¸ã‘る気軽ã•ã§ã™ã€‚CGIスクリプトã¨ã„ãˆã°ã€ä»£è¡¨çš„ãªã‚‚ã®ã¯ä½•ã¨è¨€ã£ã¦ã‚‚掲示æ¿ï¼ˆBBS）ã§ã™ã€‚ãã“ã§ã€ä»Šå›žã¯Sinatraã§æŽ²ç¤ºæ¿ã‚¢ãƒ—リを作ã£ã¦ã¿ã¾ã—ãŸã€‚ソースコードãŒå°‘ã—é•·ã‚ãªã®ã§ã€githubã«ã¦å…¨æ–‡ã‚’公開ã—ã¦ã„ã¾ã™ã€‚é©å®œå‚ç…§ã—ãªãŒã‚‰èªã¿é€²ã‚ã¦ä¸‹ã•ã„。ファイル構æˆã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ start.rb アプリケーションã®æœ¬ä½“。 model/comment.rb 掲示æ¿ã®æ›¸ãè¾¼ã¿ã‚’表ã™ãƒ¢ãƒ‡ãƒ«ã®å®šç¾©ã€‚ view/index.haml トッ
Sequel: The Database Toolkit for Ruby - Documentation
General Info, Guides, Examples, and Tutorials README Cheat Sheet Dataset Filtering Advanced Associations Prepared Statements/Bound Variables Master/Slave Databases and Sharding Schema Modification Full API RDoc, Main Classes/Modules: Sequel Sequel::Database Sequel::Dataset Sequel::Model Sequel::Model::Associations Sequel::Model::Associations::EagerLoading Change Log Release Notes License External
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Module: Sequel::Plugins::Timestamps [Sequel: The Database Toolkit for Ruby]
GitHub - jeremyevans/fixture_dependencies: Sequel/ActiveRecord fixture loader that handles dependency graphs
http://merblog.tt25.org/
{{#tags}}- {{label}}
{{/tags}}