# frozen-string-literal: true # # The pagination extension adds the Sequel::Dataset#paginate and #each_page methods, # which return paginated (limited and offset) datasets with the following methods # added that make creating a paginated display easier: # # * +page_size+ # * +page_count+ # * +page_range+ # * +current_page+ # * +next_page+ # * +prev_page+ # * +first_page?+ # * +last_page?+ # * +pagination_record_count+ # * +current_page_record_count+ # * +current_page_record_range+ # # This extension uses Object#extend at runtime, which can hurt performance. # # You can load this extension into specific datasets: # # ds = DB[:table] # ds = ds.extension(:pagination) # # Or you can load it into all of a database's datasets, which # is probably the desired behavior if you are using this extension: # # DB.extension(:pagination) # # Related modules: Sequel::DatasetPagination, Sequel::Dataset::Pagination # module Sequel module DatasetPagination # Returns a paginated dataset. The returned dataset is limited to # the page size at the correct offset, and extended with the Pagination # module. If a record count is not provided, does a count of total # number of records for this dataset. def paginate(page_no, page_size, record_count=nil) raise(Error, "You cannot paginate a dataset that already has a limit") if @opts[:limit] record_count ||= count page_count = (record_count / page_size.to_f).ceil page_count = 1 if page_count == 0 limit(page_size, (page_no - 1) * page_size). with_extend(Dataset::Pagination). clone(:page_size=>page_size, :current_page=>page_no, :pagination_record_count=>record_count, :page_count=>page_count) end # Yields a paginated dataset for each page and returns the receiver. Does # a count to find the total number of records for this dataset. Returns # an enumerator if no block is given. def each_page(page_size) raise(Error, "You cannot paginate a dataset that already has a limit") if @opts[:limit] return to_enum(:each_page, page_size) unless defined?(yield) record_count = count total_pages = (record_count / page_size.to_f).ceil (1..total_pages).each{|page_no| yield paginate(page_no, page_size, record_count)} self end end class Dataset # Holds methods that only relate to paginated datasets. Paginated dataset # have pages starting at 1 (page 1 is offset 0, page 2 is offset 1 * page_size). module Pagination # The number of records per page (the final page may have fewer than # this number of records). def page_size @opts[:page_size] end # The number of pages in the dataset before pagination, of which # this paginated dataset is one. Empty datasets are considered # to have a single page. def page_count @opts[:page_count] end # The current page of the dataset, starting at 1 and not 0. def current_page @opts[:current_page] end # The total number of records in the dataset before pagination. def pagination_record_count @opts[:pagination_record_count] end # Returns the record range for the current page def current_page_record_range return (0..0) if current_page > page_count a = 1 + (current_page - 1) * page_size b = a + page_size - 1 b = pagination_record_count if b > pagination_record_count a..b end # Returns the number of records in the current page def current_page_record_count return 0 if current_page > page_count a = 1 + (current_page - 1) * page_size b = a + page_size - 1 b = pagination_record_count if b > pagination_record_count b - a + 1 end # Returns true if the current page is the first page def first_page? current_page == 1 end # Returns true if the current page is the last page def last_page? current_page == page_count end # Returns the next page number or nil if the current page is the last page def next_page current_page < page_count ? (current_page + 1) : nil end # Returns the page range def page_range 1..page_count end # Returns the previous page number or nil if the current page is the first def prev_page current_page > 1 ? (current_page - 1) : nil end end end Dataset.register_extension(:pagination, DatasetPagination) end