Rails 3 常用代码

validates

validates :code, :uniqueness => true, :presence => true
validates :price, :numericality => true
validates :status, :inclusion => {:in => STATUSES}
validates :rate, :presence => true, :numericality => {:less_than => 1, :greater_than => 0}

validate :valid_attribute
def valid_attribute
  self.errors.add(:category, 'message') if ****
end

scope

scope :investor, where(:investor => true).order("CONVERT( `name` USING gbk ) ASC")

find

Order.where(["code LIKE ?", "#{quick}%"]).last

test

record = Order.new
record.valid?
record.errors[:name]

view

<%= raw text -%>

controller

respond_to do |format|
  format.html # index.html.erb
  format.xml  { render :xml => @posts }
end

excecute sql

sql = 'Update * Set column = REPLACE(column, 'src', 'dest') WHERE *
ActiveRecord::Base.connection.execute(sql)

date search

where(["DATE(analyse_time) = DATE(?)", params[:date].to_datetime.to_time_in_current_zone])