PYTHON --工作中应用

分批将结果写入库:
start = 0 while True: tmp_list = datas_list[start:start+5000]: self.upsert_sqlserver_data(tmp_list,pre='customize',database=self.sqlserver_cust) start+=5000 if start > len(datas_list)-1: break

2、逐条入库(传参只能是列表)

 for i in datas_list:
            self.upsert_sqlserver_data([i,], pre='customize', database=self.sqlserver_cust)

  

  

  

原文地址:https://www.cnblogs.com/gina11/p/14519326.html