|
广告语:你觉得Rails现在的ActiveRecord还不够活跃、还不够DSL吗?想让它更有抱负吗?那么你需要Ambition,马上装上这颗“野心”,让数据来的更猛烈些。
使用了本产品,你将可以: User.first "SELECT * FROM users LIMIT 1"
User.select { |m| m.name != 'macgyver' } "SELECT * FROM users WHERE users.`name` <> 'macgyver'"
User.select { |u| u.email =~ /chris/ }.first "SELECT * FROM users WHERE (users.`email` REGEXP 'chris') LIMIT 1"
User.select { |u| u.karma > 20 }.sort_by(&:karma).first(5) "SELECT * FROM users WHERE (users.`karma` > 20) ORDER BY users.karma LIMIT 5"
User.select { |u| u.email =~ 'ch%' }.size "SELECT count(*) AS count_all FROM users WHERE (users.`email` LIKE 'ch%')"
User.sort_by { |u| [ u.email, -u.created_at ] } "SELECT * FROM users ORDER BY users.email, users.created_at DESC"
User.detect { |u| u.email =~ 'chris%' && u.profile.blog == 'Err' } "SELECT users.`id` AS t0_r0 ... FROM users LEFT OUTER JOIN profiles ON profiles.user_id = users.id WHERE ((users.`email` LIKE 'chris%' AND profiles.blog = 'Err')) LIMIT 1"
ORM?ROM?! >> user = User.select { |u| u.name == 'Dio' } => (Query object: call #to_sql or #to_hash to inspect...) >> user.to_sql => "SELECT * FROM users WHERE users.`name` = 'Dio'"
还担心从C中取到的数据而在V中根本没有用上而觉得浪费感情吗? class BandsController < ApplicationController def index @bands = Band.sort_by(&:name) end end
现在 @bands 不再是一个数据集合在战斗,只有当真正访问到里面的数据条目时它才会召唤db engine附身,如: <h1>Rocktastic Bands<h1> <ul> <% @bands.each do |band| %> <li><%= band %></li> <% end %> </ul>
更过份的是,你的缓存终于可以放开手脚可以大显身手了: <h1>Rocktastic Bands<h1> <% cache do %> <ul> <% @bands.each do |band| %> <li><%= band %></li> <% end %> </ul> <% end %>
还等什么,赶紧打开你的console通过gem来订购吧: http://projects.require.errtheblog.com/browser/ambition/README
更多详情请敲打我们的24小时热线URL:http://errtheblog.com/post/10722 |