27、RESTful Web服务：构建、客户端与最佳实践

RESTful Web服务：构建、客户端与最佳实践

1. 启动Rails服务器与SQL查询逻辑

在开始使用Web服务前，需要在控制台窗口启动Rails服务器，命令如下：

$ script/server

在服务的实现中，存在一段SQL查询逻辑，用于统计书签数量。其代码如下：

if tag
  tag_from = ", tags, taggings"
  tag_where = "AND taggings.taggable_type = 'Bookmark'" +
    " AND bookmarks.id = taggings.taggable_id" +
    " AND taggings.tag_id = tags.id AND tags.name = ?"
end
# Unless a user is viewing their own calendar, only count public
# bookmarks.
public_where = viewed_by_owner ? "" : "AND public='1'"
sql = ["SELECT date(timestamp) AS date, count(bookmarks.id) AS count" +
       " FROM bookmarks#{tag_from} " +
       " WHERE user_id=? #{tag_where} #{public_where} " +
       " GROUP BY date(timestam