wildjcrt

sql = "select *, (select count(books.id) from books where books.authorsid=authors.id) as books_count from authors "
authors = Author.find_by_sql(sql)
authors.first.books_count

wildjcrt

以下內容 copy 自 https://railstaiwan.hackpad.com/Rails-Outreach-Workshop-Taipei-01--PBrwnbjqMx3#:h=要先用隨身碟準備安裝程式

要先用隨身碟準備安裝程式

隨身碟裡面灌這些東西：

• Xcode Latest
• Xcode Command Line Tools for 10.9
• Xcode Command Line Tools for 10.8
• SublimeText 2 for 全 OS

wildjcrt

>> a = [1, 2, 3, 4, 5, 1, 2]
=> [1, 2, 3, 4, 5, 1, 2]
>> a.compact.size
=> 5
>> a.compact!.size
NoMethodError: undefined method `size' for nil:NilClass
	from (irb):14
	from /Users/wildjcrt/.rvm/rubies/ruby-2.1.3/bin/irb:11:in `<main>'

wildjcrt

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

wildjcrt

Keybase proof

I hereby claim:

• I am wildjcrt on github.
• I am wildjcrt (https://keybase.io/wildjcrt) on keybase.
• I have a public key whose fingerprint is RETU RN T HIS. PGP. GET_ FING ERPR INT( ); }

To claim this, I am signing this object:

wildjcrt

                        <%= render_table(@products,
                                        [             
                                            ["ID",       lambda { |p| p.id }],
                                            ["名稱",     lambda { |p| p.name }],
                                                ["動作",     lambda { |p| 
                                                  link_to("Show", admin_product_path(p)) + ' | ' + 
                                                  link_to("Edit", edit_admin_product_path(p)) + ' | ' +
                                                  link_to("Delete", admin_product_path(p), :confirm => "Are you sure?", :method => :delete )}]
                                        ],
                                            :class_name => "table"

wildjcrt

<%= render_table(@games,
	[	
    ["ID", lambda { |p| p.id }],
    ["遊戲名稱", lambda { |p| p.name }],
	["標籤", lambda { |p| p.tag_list.join(" | ") }],
	["動作", lambda { |p|
	  add_to_favorites_status_bar(p) + ' | ' +
	  unless current_user
		link_to("Show", game_path(p)) + ' | ' +
	  end  

wildjcrt

<%= render_table(@games,
	[	
    ["ID", lambda { |p| p.id }],
    ["遊戲名稱", lambda { |p| p.name }],
	["標籤", lambda { |p| p.tag_list.join(" | ") }],
	["動作", lambda { |p|
	  if current_user
		add_to_favorites_status_bar(p) + ' | ' +
		link_to("Show", game_path(p)) + ' | ' +
		link_to("Edit", edit_game_path(p)) + ' | ' +

wildjcrt

<%= render_table(@games,
	[	
    ["ID", lambda { |p| p.id }],
    ["遊戲名稱", lambda { |p| p.name }],
	["標籤", lambda { |p| p.tag_list.join(" | ") }],
	["動作", lambda { |p| index_table(p)}]
	],
    :class_name => "table") 
%>

wildjcrt

wget http://hackmysql.com/scripts/mysqlsla
chmod +x mysqlsla-2.03
sudo ./mysqlsla-2.03 /var/log/mysql/mysql-slow.log

# 預設會列出 top 10 的 slow quires
# 可以帶參數 --top 13 修改列出的項目數量
# 通常網路上都說從 top 1, 2, 3 的 slow quires 去修
# 是對增進效能最有幫助的！