ruby sinatra，postgres分页结果

Question

我想分页一个数据集。

Ruby 代码是:

get '/candy' do
    @pagedata = { :cur_page => 1, :post_count => 0, :per_page => 3 }
    # set the current page to show
    @pagedata[:cur_page] = params[:page].to_i unless params[:page].nil?
    @cands = DB[:candidates] 
    #@cands = Post.by_created_at
    # set post_count
    @pagedata[:post_count] = DB[:candidates].count(:id)
    @cands = @cands.paginate(:page => @pagedata[:cur_page], :per_page => @pagedata[:per_page]) unless @cands.empty?
        erb :candy
    end

有什么问题？非常感谢所有帮助!

行:

@cands = @cands.paginate(:page => @pagedata[:cur_page], :per_page => @pagedata[:per_page]) unless @cands.empty?

产生错误:

undefined method `paginate' for Sequel::Postgres::Dataset: "SELECT * FROM "candidates"

Answer 1

您需要在创建DB 对象后添加DB.extension(:pagination)。