create generic mixin for imlementing paginated "each()" and "each_with_replay()" methods. 

"each()" is a generator which will deliver items from paginated query

"each_with_replay()" is like "each()" and user can call "repeat_item(item)" to append it to the end of a queue. 

Moreover, it provides context with recommended blocking of advisory_lock. If there is non-blocking advisory lock and all remaining items are repeated, it means that all items are locked (i.e. long running message recovery with SchwarzIT tenant blocks data pruning lock), thus blocking lock is offered.