def testSimpleQuery(self):
pager = OffsetPager(self.connection, 5)
pager.set_query('select rowid, * from paging_test')
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 = OffsetPager(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.execute()
self.assertEqual(len(pager), 2, 'Wrong number of pages.')
#
first = pager.first()
ids = [r['rowid'] for r in first]
self.assertEqual(ids, [1, 5, 6, 10, 11],
'Failed fetching first page.')
#
last = pager.next()
ids = [r['rowid'] for r in last]
self.assertEqual(ids, [15, 16, 20],
'Failed fetching next page (2).')
#
first = pager.previous()
ids = [r['rowid'] for r in first]
self.assertEqual(ids, [1, 5, 6, 10, 11],
'Failed fetching previous page (1).')
#
last = pager.last()
ids = [r['rowid'] for r in last]
self.assertEqual(ids, [15, 16, 20],
'Failed fetching last page.')
#
page_2 = pager.get_page(2)
ids = [r['rowid'] for r in page_2]
self.assertEqual(ids, [15, 16, 20],
'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 = OffsetPager(self.connection, 5)
pager.set_query('select rowid, * from paging_test')
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 = OffsetPager(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.execute()
self.assertEqual(len(pager), 2, 'Wrong number of pages.')
#
first = pager.first()
ids = [r['rowid'] for r in first]
self.assertEqual(ids, [1, 5, 6, 10, 11], 'Failed fetching first page.')
#
last = pager.next()
ids = [r['rowid'] for r in last]
self.assertEqual(ids, [15, 16, 20], 'Failed fetching next page (2).')
#
first = pager.previous()
ids = [r['rowid'] for r in first]
self.assertEqual(ids, [1, 5, 6, 10, 11],
'Failed fetching previous page (1).')
#
last = pager.last()
ids = [r['rowid'] for r in last]
self.assertEqual(ids, [15, 16, 20], 'Failed fetching last page.')
#
page_2 = pager.get_page(2)
ids = [r['rowid'] for r in page_2]
self.assertEqual(ids, [15, 16, 20], '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 test_simple_query(connection):
pager = OffsetPager(connection, 5)
pager.set_query('select rowid, * from paging_test')
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 test_complex_query(connection):
pager = OffsetPager(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.execute()
assert len(pager) == 2, 'Wrong number of pages.'
#
first = pager.first()
ids = [r['rowid'] for r in first]
assert ids == [1, 5, 6, 10, 11], 'Failed fetching first page.'
#
last = pager.next()
ids = [r['rowid'] for r in last]
assert ids == [15, 16, 20], 'Failed fetching next page (2).'
#
first = pager.previous()
ids = [r['rowid'] for r in first]
assert ids == [1, 5, 6, 10, 11], 'Failed fetching previous page (1).'
#
last = pager.last()
ids = [r['rowid'] for r in last]
assert ids == [15, 16, 20], 'Failed fetching last page.'
#
page_2 = pager.get_page(2)
ids = [r['rowid'] for r in page_2]
assert ids == [15, 16, 20], 'Failed fetching 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'