def test_simple_query(connection):
pager = ScrollingPager(connection, 5)
pager.set_query('select rowid, * from paging_test')
pager.set_sort_columns([('rowid', 'ASC', True)])
#
pager.execute()
assert len(pager) == 4, 'Wrong number of pages.'
#
first = pager.first()
ids = [r['rowid'] for r in first]
assert ids == [1, 2, 3, 4, 5], 'Failed fetching first page.'
#
last = pager.last()
ids = [r['rowid'] for r in last]
assert ids == [16, 17, 18, 19, 20], 'Failed fetching last page.'
#
page_2 = pager.get_page(2)
ids = [r['rowid'] for r in page_2]
assert ids == [6, 7, 8, 9, 10], 'Failed fetching page 2.'
#
page_3 = pager.next()
ids = [r['rowid'] for r in page_3]
assert ids == [11, 12, 13, 14, 15], 'Failed fetching next page (3).'
#
rs = pager.previous()
assert rs == page_2, 'Failed fetching previous page (2).'
#
last = pager.last()
assert pager.next() == last, 'Calling next on last page returns last page'
#
first = pager.first()
assert pager.previous(
) == first, 'Calling previous on first page returns first page'
def testComplexQuery(self):
pager = ScrollingPager(self.connection, 5)
params = {'term': 'foo*'}
pager.set_query(
'''
SELECT i.docid, t.rowid, t.* from paging_test t
JOIN paging_test_idx i ON i.docid = t.rowid
WHERE paging_test_idx MATCH :term
''', params)
pager.set_count_query(
'''
SELECT docid FROM paging_test_idx
WHERE paging_test_idx MATCH :term
''', params)
pager.set_sort_columns([('ranking', 'DESC'), ('rowid', 'ASC', True)])
#
pager.execute()
self.assertEqual(pager._total_size, 12, 'Wrong number of rows.')
self.assertEqual(len(pager), 3, 'Wrong number of pages.')
#
page_1_ids = [5, 10, 15, 20, 1]
page_2_ids = [6, 11, 16, 4, 9]
page_3_ids = [14, 19]
#
first = pager.first()
ids = [r['rowid'] for r in first]
self.assertEqual(ids, page_1_ids, 'Failed fetching first page.')
#
page_2 = pager.next()
ids = [r['rowid'] for r in page_2]
self.assertEqual(ids, page_2_ids, 'Failed fetching next page (2).')
#
page_3 = pager.next()
ids = [r['rowid'] for r in page_3]
self.assertEqual(ids, page_3_ids, 'Failed fetching next page (3).')
#
page_2 = pager.previous()
ids = [r['rowid'] for r in page_2]
self.assertEqual(ids, page_2_ids, 'Failed fetching previous page (2).')
#
page_1 = pager.previous()
ids = [r['rowid'] for r in page_1]
self.assertEqual(ids, page_1_ids, 'Failed fetching previous page (1).')
#
last = pager.last()
ids = [r['rowid'] for r in last]
self.assertEqual(ids, page_3_ids, 'Failed fetching last page.')
#
page_2 = pager.get_page(2)
ids = [r['rowid'] for r in page_2]
self.assertEqual(ids, page_2_ids, 'Failed fetching page 2.')
#
last = pager.last()
self.assertEqual(pager.next(), last,
'Calling next on last page returns last page')
first = pager.first()
self.assertEqual(pager.previous(), first,
'Calling previous on first page returns first page')
def testSimpleQuery(self):
pager = ScrollingPager(self.connection, 5)
pager.set_query('select rowid, * from paging_test')
pager.set_sort_columns([('rowid', 'ASC', True)])
#
pager.execute()
self.assertEqual(len(pager), 4, 'Wrong number of pages.')
#
first = pager.first()
ids = [r['rowid'] for r in first]
self.assertEqual(ids, [1, 2, 3, 4, 5],
'Failed fetching first page.')
#
last = pager.last()
ids = [r['rowid'] for r in last]
self.assertEqual(ids, [16, 17, 18, 19, 20],
'Failed fetching last page.')
#
page_2 = pager.get_page(2)
ids = [r['rowid'] for r in page_2]
self.assertEqual(ids, [6, 7, 8, 9, 10],
'Failed fetching page 2.')
#
page_3 = pager.next()
ids = [r['rowid'] for r in page_3]
self.assertEqual(ids, [11, 12, 13, 14, 15],
'Failed fetching next page (3).')
#
rs = pager.previous()
self.assertEqual(rs, page_2,
'Failed fetching previous page (2).')
#
last = pager.last()
self.assertEqual(pager.next(), last,
'Calling next on last page returns last page')
#
first = pager.first()
self.assertEqual(pager.previous(), first,
'Calling previous on first page returns first page')
def testSimpleQuery(self):
pager = ScrollingPager(self.connection, 5)
pager.set_query('select rowid, * from paging_test')
pager.set_sort_columns([('rowid', 'ASC', True)])
#
pager.execute()
self.assertEqual(len(pager), 4, 'Wrong number of pages.')
#
first = pager.first()
ids = [r['rowid'] for r in first]
self.assertEqual(ids, [1, 2, 3, 4, 5], 'Failed fetching first page.')
#
last = pager.last()
ids = [r['rowid'] for r in last]
self.assertEqual(ids, [16, 17, 18, 19, 20],
'Failed fetching last page.')
#
page_2 = pager.get_page(2)
ids = [r['rowid'] for r in page_2]
self.assertEqual(ids, [6, 7, 8, 9, 10], 'Failed fetching page 2.')
#
page_3 = pager.next()
ids = [r['rowid'] for r in page_3]
self.assertEqual(ids, [11, 12, 13, 14, 15],
'Failed fetching next page (3).')
#
rs = pager.previous()
self.assertEqual(rs, page_2, 'Failed fetching previous page (2).')
#
last = pager.last()
self.assertEqual(pager.next(), last,
'Calling next on last page returns last page')
#
first = pager.first()
self.assertEqual(pager.previous(), first,
'Calling previous on first page returns first page')
def testComplexQuery(self):
pager = ScrollingPager(self.connection, 5)
params = {'term': 'foo*'}
pager.set_query('''
SELECT i.docid, t.rowid, t.* from paging_test t
JOIN paging_test_idx i ON i.docid = t.rowid
WHERE paging_test_idx MATCH :term
''', params)
pager.set_count_query('''
SELECT docid FROM paging_test_idx
WHERE paging_test_idx MATCH :term
''', params)
pager.set_sort_columns([('ranking', 'DESC'), ('rowid', 'ASC', True)])
#
pager.execute()
self.assertEqual(pager._total_size, 12, 'Wrong number of rows.')
self.assertEqual(len(pager), 3, 'Wrong number of pages.')
#
page_1_ids = [5, 10, 15, 20, 1]
page_2_ids = [6, 11, 16, 4, 9]
page_3_ids = [14, 19]
#
first = pager.first()
ids = [r['rowid'] for r in first]
self.assertEqual(ids, page_1_ids, 'Failed fetching first page.')
#
page_2 = pager.next()
ids = [r['rowid'] for r in page_2]
self.assertEqual(ids, page_2_ids,
'Failed fetching next page (2).')
#
page_3 = pager.next()
ids = [r['rowid'] for r in page_3]
self.assertEqual(ids, page_3_ids,
'Failed fetching next page (3).')
#
page_2 = pager.previous()
ids = [r['rowid'] for r in page_2]
self.assertEqual(ids, page_2_ids,
'Failed fetching previous page (2).')
#
page_1 = pager.previous()
ids = [r['rowid'] for r in page_1]
self.assertEqual(ids, page_1_ids,
'Failed fetching previous page (1).')
#
last = pager.last()
ids = [r['rowid'] for r in last]
self.assertEqual(ids, page_3_ids,
'Failed fetching last page.')
#
page_2 = pager.get_page(2)
ids = [r['rowid'] for r in page_2]
self.assertEqual(ids, page_2_ids,
'Failed fetching page 2.')
#
last = pager.last()
self.assertEqual(pager.next(), last,
'Calling next on last page returns last page')
first = pager.first()
self.assertEqual(pager.previous(), first,
'Calling previous on first page returns first page')