spec.rb

  describe ".channel_subscribers_report" do
    let(:url){ "/users/:id" }
    before do
      User.should_receive(:select).with("users.name, users.email, replace('#{url}', ':id', users.id::text) AS url").and_call_original
    end
    it("should call select with name, email and user url") do
      User.channel_subscribers_report("/users/:id") 
    end
  end