Module: Sequel::Dataset::Pagination

Defined in:
lib/sequel/extensions/pagination.rb

Overview

Holds methods that only relate to paginated datasets. Paginated dataset have pages starting at 1 (page 1 is offset 0, page 1 is offset page_size).

Instance Attribute Summary collapse

Instance Method Summary collapse

Instance Attribute Details

#current_pageObject

The current page of the dataset, starting at 1 and not 0.



74
75
76
# File 'lib/sequel/extensions/pagination.rb', line 74

def current_page
  @current_page
end

#page_countObject

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.



71
72
73
# File 'lib/sequel/extensions/pagination.rb', line 71

def page_count
  @page_count
end

#page_sizeObject

The number of records per page (the final page may have fewer than this number of records).



66
67
68
# File 'lib/sequel/extensions/pagination.rb', line 66

def page_size
  @page_size
end

#pagination_record_countObject

The total number of records in the dataset before pagination.



77
78
79
# File 'lib/sequel/extensions/pagination.rb', line 77

def pagination_record_count
  @pagination_record_count
end

Instance Method Details

#current_page_record_countObject

Returns the number of records in the current page



90
91
92
93
94
95
96
97
# File 'lib/sequel/extensions/pagination.rb', line 90

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

#current_page_record_rangeObject

Returns the record range for the current page



80
81
82
83
84
85
86
87
# File 'lib/sequel/extensions/pagination.rb', line 80

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

#first_page?Boolean

Returns true if the current page is the first page

Returns:

  • (Boolean)


100
101
102
# File 'lib/sequel/extensions/pagination.rb', line 100

def first_page?
  @current_page == 1
end

#last_page?Boolean

Returns true if the current page is the last page

Returns:

  • (Boolean)


105
106
107
# File 'lib/sequel/extensions/pagination.rb', line 105

def last_page?
  @current_page == @page_count
end

#next_pageObject

Returns the next page number or nil if the current page is the last page



110
111
112
# File 'lib/sequel/extensions/pagination.rb', line 110

def next_page
  current_page < page_count ? (current_page + 1) : nil
end

#page_rangeObject

Returns the page range



115
116
117
# File 'lib/sequel/extensions/pagination.rb', line 115

def page_range
  1..page_count
end

#prev_pageObject

Returns the previous page number or nil if the current page is the first



120
121
122
# File 'lib/sequel/extensions/pagination.rb', line 120

def prev_page
  current_page > 1 ? (current_page - 1) : nil
end

#set_pagination_info(page_no, page_size, record_count) ⇒ Object

Sets the pagination info for this paginated dataset, and returns self.



125
126
127
128
129
130
131
132
# File 'lib/sequel/extensions/pagination.rb', line 125

def set_pagination_info(page_no, page_size, record_count)
  @current_page = page_no
  @page_size = page_size
  @pagination_record_count = record_count
  @page_count = (record_count / page_size.to_f).ceil
  @page_count = 1 if @page_count == 0
  self
end