git倉庫輸出
git archive --format=tar --prefix=actasfavor/ HEAD | (cd /home/holin/work/ tar xf -)
輸出到/home/holin/work/actasfavor/目錄下

Posted by holin At May 16, 2008 16:42
加載plugins中的controller和model

# Include hook code here
require 'act_as_favor'
# make plugin controller, model, helper available to app
config.load_paths += %W(#{ActAsFavor::PLUGIN_CONTROLLER_PATH} #{ActAsFavor::PLUGIN_HELPER_PATH} #{ActAsFavor::PLUGIN_MODELS_PATH})
Rails::Initializer.run(:set_load_path, config)
# require the controller
require 'favors_controller'
# require models
require 'favor'

Posted by holin At May 15, 2008 15:36
使用最頻繁的前5個命令
history | awk {'print $2'} | sort | uniq -c | sort -k1 -rn| head -n5

Posted by holin At May 15, 2008 10:40
按數組元素的某屬性排序
@users.sort!{|a, b| a.last => b.last }

Posted by holin At May 11, 2008 14:35
按日期備份數據庫
mysqldump db_name -uroot > "/root/db_backup/kaoshi_web_`date +"%Y-%m-%d"`.sql"

Posted by holin At May 08, 2008 12:05
用memcached手動cache數據

sql = "SELECT * FROM blogs LIMIT 100"
Blog.class
k = MD5.new(sql)
@blogs = Cache.get k
if @blogs.blank?
@blogs = Blog.find_by_sql(sql)
Cache.put k, @blogs, 60*30 #expire after 30min
end
memcache-client 1.5.0:
get(key, expiry = 0)
put(key, value, expiry = 0)

Posted by devon At May 04, 2008 20:39
shuffle an array

class Array
def shuffle
sort_by { rand }
end
def shuffle!
self.replace shuffle
end
end

Posted by holin At May 04, 2008 15:39
讓所有的ajax請求都不render :layout

def render(*args)
args.first[:layout] = false if request.xhr? and args.first[:layout].nil?
super
end

Posted by devon At May 03, 2008 10:53
Find with Hash

Event.find(
:all,
:conditions => [ "title like :search or description like :search",
{:search => "%Tiki%"}]
)

Posted by devon At May 03, 2008 10:49
執行sql語句腳本

mysql -uroot -p123END
use dbame;
delete from results;
delete from examings;
quit
END

Posted by holin At May 01, 2008 12:14
SQL Transaction in Rails

def fetch_value
sql = ActiveRecord::Base.connection();
sql.execute "SET autocommit=0";
sql.begin_db_transaction
id, value =
sql.execute("SELECT id, value FROM sometable WHERE used=0 LIMIT 1 FOR UPDATE").fetch_row;
sql.update "UPDATE sometable SET used=1 WHERE id=#{id}";
sql.commit_db_transaction
value;
end

Posted by holin At April 30, 2008 09:37
顯示 Flash 消息的動態效果

% if flash[:warning] or flash[:notice] %>
div id="notice" % if flash[:warning] %>class="warning"% end %>>
%= flash[:warning] || flash[:notice] %>
/div>
script type="text/javascript">
setTimeout("new Effect.Fade('notice');", 15000)
/script>
% end %>
15000 毫秒后自動 notice Div 自動消失。

Posted by devon At April 29, 2008 13:02
刪除環境中的常量

Object.send(:remove_const, :A)
>> Math
=> Math
>> Object.send(:remove_const, :Math)
=> Math
>> Math
NameError: uninitialized constant Math

Posted by devon At April 28, 2008 18:24
手動加上 authenticity_token
div style="margin:0;padding:0">input name="authenticity_token" type="hidden" value="%= form_authenticity_token %>" />/div>

Posted by devon At April 28, 2008 14:24
Rails group_by

% @articles.group_by(:day).each do |day, articles| %>
div id='day' style="padding: 10px 0;">
h2>%= day.to_date.strftime('%y年%m月%d日') %>/h2>
%= render :partial => 'article', :collection => articles %>
/div>
% end %>
articles 按天數分組

Posted by devon At April 25, 2008 22:32
讀寫文件

# Open and read from a text file
# Note that since a block is given, file will
# automatically be closed when the block terminates
File.open('p014constructs.rb', 'r') do |f1|
while line = f1.gets
puts line
end
end
# Create a new file and write to it
File.open('test.rb', 'w') do |f2|
# use "\n" for two lines of text
f2.puts "Created by Satish\nThank God!"
end

Posted by holin At April 17, 2008 02:10
遍歷目錄
Dir.glob(File.join('app/controllers', "**", "*_controller.rb")) { |filename| puts filename }

Posted by holin At April 16, 2008 15:28
字符串到 model
1
2
>> 'tag_course'.camelize.constantize.find(:first)
=> #TagCourse id: 7, tag_id: 83, course_id: 2>
*camelize(lower_case_and_underscored_word, first_letter_in_uppercase = true)*
By default, camelize converts strings to UpperCamelCase. If the argument to camelize is set to ":lower" then camelize produces lowerCamelCase.
*constantize(camel_cased_word)*
Constantize tries to find a declared constant with the name specified in the string. It raises a NameError when the name is not in CamelCase or is not initialized.

Posted by devon At April 07, 2008 17:32
調用Proc
1
2
3
a = Proc.new { |i| puts i }
a['haha']
a.call('hehe')

Posted by holin At March 28, 2008 23:10
Rails中Host靜態文件
1
2
config.action_controller.asset_host = "http://assets.example.com"
config.action_controller.asset_host = "http://assets-%d.example.com"
The Rails image_path and similar helper methods will then use that host to reference files in the public directory.
The second line will distribute asset requests across assets-0.example.com,assets-1.example.com, assets-2.example.com, and assets-3.example.com.

Posted by devon At March 26, 2008 18:18
打包gems到項目目錄中

$ mkdir vendor/gems
$ cd vendor/gems
$ gem unpack hpricot
Unpacked gem: 'hpricot-0.4'
config.load_paths += Dir["#{RAILS_ROOT}/vendor/gems/**"].map do |dir|
File.directory?(lib = "#{dir}/lib") ? lib : dir
end

Posted by devon At March 26, 2008 18:12
在當前上下文中執行文件中的代碼

instance_eval(File.read('param.txt'))
# such as
@father = 'Father'
instance_eval("puts @father")
#Produces:
#Father

Posted by holin At March 20, 2008 01:13
將當前文件所在目錄加入require路徑

$LOAD_PATH File.expand_path(File.dirname(__FILE__))
# or
$: File.expand_path(File.dirname(__FILE__))
# this one puts current path before the other path.
$:.unshift( File.expand_path(File.dirname(__FILE__)) )
*__ FILE __* 當前文件路徑

Posted by holin At March 19, 2008 01:40
多字段模糊搜索

conditions = []
[:name, :school, :province, :city].each { |attr| conditions Profile.send(:sanitize_sql, ["#{attr} LIKE ?", "%#{params[:q]}%"]) if params[:q] }
conditions = conditions.any? ? conditions.collect { |c| "(#{c})" }.join(' OR ') : nil
在profile表里，按name, school, province, city模糊搜索

Posted by devon At March 17, 2008 17:25
nginx 啟動腳本


#! /bin/sh
# chkconfig: - 58 74
# description: nginx is the Nginx daemon.
# Description: Startup script for nginx webserver on Debian. Place in /etc/init.d and
# run 'sudo update-rc.d nginx defaults', or use the appropriate command on your
# distro.
#
# Author: Ryan Norbauer
# Modified: Geoffrey Grosenbach http://topfunky.com
# Modified: David Krmpotic http://davidhq.com
set -e
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
DESC="nginx daemon"
NAME=nginx
DAEMON=/usr/local/nginx/sbin/$NAME
CONFIGFILE=/usr/local/nginx/conf/nginx.conf
DAEMON=/usr/local/nginx/sbin/$NAME
CONFIGFILE=/usr/local/nginx/conf/nginx.conf
PIDFILE=/usr/local/nginx/logs/$NAME.pid
SCRIPTNAME=/etc/init.d/$NAME
# Gracefully exit if the package has been removed.
test -x $DAEMON || exit 0
d_start() {
$DAEMON -c $CONFIGFILE || echo -en "\n already running"
}
d_stop() {
kill -QUIT `cat $PIDFILE` || echo -en "\n not running"
}
d_reload() {
kill -HUP `cat $PIDFILE` || echo -en "\n can't reload"
}
case "$1" in
start)
echo -n "Starting $DESC: $NAME"
d_start
echo "."

stop)
echo -n "Stopping $DESC: $NAME"
d_stop
echo "."

reload)
echo -n "Reloading $DESC configuration..."
d_reload
echo "."

restart)
echo -n "Restarting $DESC: $NAME"
d_stop
# One second might not be time enough for a daemon to stop,
# if this happens, d_start will fail (and dpkg will break if
# the package is being upgraded). Change the timeout if needed
# be, or change d_stop to have start-stop-daemon use --retry.
# Notice that using --retry slows down the shutdown process
# somewhat.
sleep 1
d_start
echo "."

*)
echo "Usage: $SCRIPTNAME {start|stop|restart|reload}" >2
exit 3

esac
exit 0
將文件寫入到 /etc/init.d/nginx
sudo chmod +x /etc/init.d/nginx
測試是否可正確運行
sudo /etc/init.d/nginx start
設置自動啟動
sudo /sbin/chkconfig --level 345 nginx on

Posted by devon At March 16, 2008 12:26
link_to_remote 取靜態頁面
1
2
%= link_to_remote "update post", :update => 'post', :method => 'get', :url => '/post_1.html' %>
div id='post'>/div>
將 url 改為靜態面頁的地址即可。

Posted by devon At March 16, 2008 11:07
in_place_editor for rails2.0

module InPlaceMacrosHelper
# Makes an HTML element specified by the DOM ID +field_id+ become an in-place
# editor of a property.
#
# A form is automatically created and displayed when the user clicks the element,
# something like this:
# form id="myElement-in-place-edit-form" target="specified url">
# input name="value" text="The content of myElement"/>
# input type="submit" value="ok"/>
# a onclick="javascript to cancel the editing">cancel/a>
# /form>
#
# The form is serialized and sent to the server using an AJAX call, the action on
# the server should process the value and return the updated value in the body of
# the reponse. The element will automatically be updated with the changed value
# (as returned from the server).
#
# Required +options+ are:
# tt>:url/tt>:: Specifies the url where the updated value should
# be sent after the user presses "ok".
#
# Addtional +options+ are:
# tt>:rows/tt>:: Number of rows (more than 1 will use a TEXTAREA)
# tt>:cols/tt>:: Number of characters the text input should span (works for both INPUT and TEXTAREA)
# tt>:size/tt>:: Synonym for :cols when using a single line text input.
# tt>:cancel_text/tt>:: The text on the cancel link. (default: "cancel")
# tt>:save_text/tt>:: The text on the save link. (default: "ok")
# tt>:loading_text/tt>:: The text to display while the data is being loaded from the server (default: "Loading...")
# tt>:saving_text/tt>:: The text to display when submitting to the server (default: "Saving...")
# tt>:external_control/tt>:: The id of an external control used to enter edit mode.
# tt>:load_text_url/tt>:: URL where initial value of editor (content) is retrieved.
# tt>:options/tt>:: Pass through options to the AJAX call (see prototype's Ajax.Updater)
# tt>:with/tt>:: JavaScript snippet that should return what is to be sent
# in the AJAX call, +form+ is an implicit parameter
# tt>:script/tt>:: Instructs the in-place editor to evaluate the remote JavaScript response (default: false)
# tt>:click_to_edit_text/tt>::The text shown during mouseover the editable text (default: "Click to edit")
def in_place_editor(field_id, options = {})
function = "new Ajax.InPlaceEditor("
function "'#{field_id}', "
function "'#{url_for(options[:url])}'"
js_options = {}
if protect_against_forgery?
options[:with] ||= "Form.serialize(form)"
options[:with] += " + 'authenticity_token=' + encodeURIComponent('#{form_authenticity_token}')"
end
js_options['cancelText'] = %('#{options[:cancel_text]}') if options[:cancel_text]
js_options['okText'] = %('#{options[:save_text]}') if options[:save_text]
js_options['loadingText'] = %('#{options[:loading_text]}') if options[:loading_text]
js_options['savingText'] = %('#{options[:saving_text]}') if options[:saving_text]
js_options['rows'] = options[:rows] if options[:rows]
js_options['cols'] = options[:cols] if options[:cols]
js_options['size'] = options[:size] if options[:size]
js_options['externalControl'] = "'#{options[:external_control]}'" if options[:external_control]
js_options['loadTextURL'] = "'#{url_for(options[:load_text_url])}'" if options[:load_text_url]
js_options['ajaxOptions'] = options[:options] if options[:options]
# js_options['evalScripts'] = options[:script] if options[:script]
js_options['htmlResponse'] = !options[:script] if options[:script]
js_options['callback'] = "function(form) { return #{options[:with]} }" if options[:with]
js_options['clickToEditText'] = %('#{options[:click_to_edit_text]}') if options[:click_to_edit_text]
js_options['textBetweenControls'] = %('#{options[:text_between_controls]}') if options[:text_between_controls]
function (', ' + options_for_javascript(js_options)) unless js_options.empty?
function ')'
javascript_tag(function)
end
# Renders the value of the specified object and method with in-place editing capabilities.
def in_place_editor_field(object, method, tag_options = {}, in_place_editor_options = {})
tag = ::ActionView::Helpers::InstanceTag.new(object, method, self)
tag_options = {:tag => "span", :id => "#{object}_#{method}_#{tag.object.id}_in_place_editor", :class => "in_place_editor_field"}.merge!(tag_options)
in_place_editor_options[:url] = in_place_editor_options[:url] || url_for({ :action => "set_#{object}_#{method}", :id => tag.object.id })
tag.to_content_tag(tag_options.delete(:tag), tag_options) +
in_place_editor(tag_options[:id], in_place_editor_options)
end
end
解決在rails2.0以上版本使用in_place_editor時出現的 ActionController::InvalidAuthenticityToken 錯誤。

Posted by devon At March 15, 2008 16:20
capture in view

% @greeting = capture do %>
Welcome to my shiny new web page! The date and time is
%= Time.now %>
% end %>
html>
head>title>%= @greeting %>/title>/head>
body>
b>%= @greeting %>/b>
/body>/html>
The capture method allows you to extract part of a template into a variable. You can then use this variable anywhere in your templates or layout.

Posted by devon At March 13, 2008 14:06
在 before_filter 中使用不同的layout
before_filter Proc.new {|controller| layout 'iframe' unless controller.request.env["HTTP_REFERER"] =~ /localhost/ }
如果不是從localhost這個站點來訪問的，則使用 iframe 的 layout

Posted by devon At March 11, 2008 17:38
Rails中獲取 HTTP_REFERER
request.env["HTTP_REFERER"]
可以取到的參數包括：
SERVER_NAME: localhost
PATH_INFO: /forum/forums
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en) AppleWebKit/522.11 (KHTML, like Gecko) Version/3.0.2 Safari/522.12
HTTP_ACCEPT_ENCODING: gzip, deflate
SCRIPT_NAME: /
SERVER_PROTOCOL: HTTP/1.1
HTTP_HOST: localhost:3000
HTTP_CACHE_CONTROL: max-age=0
HTTP_ACCEPT_LANGUAGE: en
REMOTE_ADDR: 127.0.0.1
SERVER_SOFTWARE: Mongrel 1.1.3
REQUEST_PATH: /forum/forums
HTTP_REFERER: http://localhost:3000/
HTTP_COOKIE: _matchsession=BAh7BzoMY3NyZl9pZCIlNWJiNzg4NDUzOWQzNWFhZTQ4MGRkNTUwYzc0MDc5%250AZGYiCmZsYXNoSUM6J0FjdGlvbkNvbnRyb2xsZXI6OkZsYXNoOjpGbGFzaEhh%250Ac2h7AAY6CkB1c2VkewA%253D268e6091590591d959128f3b17b62ff46244a0a3; _slemail=temp%40email.com; _slhash=9dfd86431742273e3e96e06a1c20541d69f74dc9; _haha_session=BAh7BiIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo%250ASGFzaHsABjoKQHVzZWR7AA%253D%253D--96565e41694dc839bd244af40b5d5121a923c8e3
HTTP_VERSION: HTTP/1.1
REQUEST_URI: /forum/forums
SERVER_PORT: "3000"
GATEWAY_INTERFACE: CGI/1.2
HTTP_ACCEPT: text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_CONNECTION: keep-alive
REQUEST_METHOD: GET