コード例 #1
0
 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')
コード例 #2
0
ファイル: offset_pager_test.py プロジェクト: ju1ius/clisnips
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'
コード例 #3
0
ファイル: offset_pager_test.py プロジェクト: ju1ius/clisnips
 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')
コード例 #4
0
 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')
コード例 #5
0
ファイル: offset_pager_test.py プロジェクト: ju1ius/clisnips
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'
コード例 #6
0
ファイル: offset_pager_test.py プロジェクト: ju1ius/clisnips
 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')