ROFISH

#ruby '2.1.0'
source 'https://rubygems.org'
gem 'rack', '~>1.5.2'
gem 'actionpack', '~> 4.1.0.beta1'
gem 'railties', '~> 4.1.0.beta1'

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

yhsiang

UPGRADE

1. Flush your new Discourse's database. This step is destructive; you must be absolutely certain that you are in the correct container, connecting to the correct database and that it contains no important data.

ssh root@hostname -p 2222

sudo -u postgres psql discourse <<END
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
ALTER SCHEMA public OWNER TO discourse;

godfat

class MigrateCookie < Struct.new(:app)
  def call env
    cookies = Rack::Utils.parse_query(env['HTTP_COOKIE'], ';,')
    case cookies['_session_id']
    when Array
      status, headers, body = app.call(env)
      headers['Set-Cookie'] =
        "#{headers['Set-Cookie']}\n#{expire_old_session}"
      [status, headers, body]
    else

tka

# 搭配 http://qiita.com/yanolab/items/1e0dd7fd27f19f697285 服用
require 'ffi'                                                                                                                           
require 'benchmark'                                                                                                                     
                                                                                                                                        
module LibGo                                                                                                                            
  extend FFI::Library                                                                                                                   
  ffi_lib './libgo.so'                                                                                                                  
  attach_function :fib, [:int], :int                                                                                                    
     

godfat

require 'sequel'

module FasterSequelTimeParser # from activerecord
  module_function
  def parse string
    string =~ /\A(\d{4})-(\d\d)-(\d\d) (\d\d):(\d\d):(\d\d)(\.\d+)?\z/
    microsec = ($7.to_r * 1_000_000).to_i
    ::Time.utc($1.to_i, $2.to_i, $3.to_i, $4.to_i,
               $5.to_i, $6.to_i, microsec)
  end

wildjcrt

Rails 開發注意要點

About Ruby Syntax

• 編輯器設定 soft tab (space=2)，以 2 格空白符號做為程式內縮距離（不分語言）。
• 函式如果只有一個參數，就不強制打()
• 函式如果有二個以上的參數，通通都要有 ()
  • (避免發生奇怪的paser bug跟保持專案一致性)
• 字串限定用雙引號包覆
• 善用 "#{str1} #{str3} " 等字串改寫技巧取代不需要的字串加法。

wildjcrt

# before


## model
class User
  after_create : call_3rd_api
  def call_3rd_api
    xxx
  end
end

wildjcrt

Debian DRBD + MySQL + HeartBeat

• 參考資料
  這篇說明的很好 http://wiselysong.blogspot.com/2009/01/heartbeatdrbdmysql-on-debian-etch.html
  這篇步驟很詳細 http://forum.icst.org.tw/phpbb/viewtopic.php?f=10&t=17893

• 環境
  作業系統 Debian Lenny
  機器一 Hostname: deb01 IP: 192.168.1.121
  機器二 Hostname: deb02 IP: 192.168.1.122

wildjcrt

javascript:(function(){ var v = new RegExp("PersonalDocuments"); if (!v.test(document.URL)) { return false; } {a=document.getElementsByClassName('rowBodyCollapsed');for(var i = 0; i<a.length; i++){Fion.deleteItem('deleteItem_'+a[i].getAttribute('asin'));};return; }})();