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()