blob: 8ded9fb94599e33c24c5a9284cd1c8593cbc512e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
from sqlplain import connect
from sqlplain.pager import SqlPaginator
def setup():
global pager
srs = connect('dbserver2')
pager = SqlPaginator(srs, ('select * from CSFBCreditDefaultSwaps', ()),
'csfb_issuer_id')
def test1():
page = pager.fetchpage(64, 100)
for row in page:
print row.csfb_issuer_id
print 'pages, rows, size:', page.npages, page.nrows, len(page)
|