sqlクエリーの結果にリストデータを追加し、ページングを実現
830 ワード
"""
sql ,
"""
a = [1,2,3,4,5,6,7,8] # SQL
b = [9,10,11,12,13,14,15,16] # x
total = len(a) # sql
page = 4 #
page_size = 5 #
page_total = page * page_size #
def interestcode():
result = a
#
# ,
if page_total > total:
#
#
if page_total - total < page_size:
# sql
result = a + b[0:page_total - total]
else:
#
# ,
nums = page_total-total-page_size
print(page_total-total, 3333)
print(nums, 11111)
print(nums+page_size, 2222)
#
result = b[nums:nums+page_size]
else:
result = a
print(result)
interestcode()