find_by_sql 小结

#  管理员有多少个

@member_count = Member.count(:conditions => ["authority = ?", "admin"])

# データ抽出「projects」Ruby Communityg9~wS
mI
      project = Project.find(:first,:conditions => ["project_code = ? ",params[:login][:project_code]]

# SQL作成（一覧）
k lU%^T5RGh0      sql =      "SELECT id, info_name, member_name, updated_on "
n~j%QF G/O0      sql.concat("FROM (SELECT * FROM infos WHERE project_id = ?) infos ")Ruby Community;L9^*wHP!w*G5K"C
      sql.concat("WHERE 1 = 1 ")

# セッションの確認
(D1KR/I4jx8R0      if (session[:project] == nil)
1YzxK3~&_7VH0        raise "session error"Ruby Community/fM Am,L2VT
      end

# 権限の確認
;MV^o g6g*Q+w0      if (session[:member][:authority].to_s == "guest")Ruby CommunityJ/ZM4Gr&H
        raise "authority error"Ruby Community,{&q9rU
d(zO
      end