Python批量插入数据库后，如何处理列表剩余元素？

Ah, classic batch processing oversight! Your current code works great for full 1000-row chunks, but it leaves behind any remaining rows that don't hit that 1000-count threshold. The fix is simple—just add a quick check after your loop runs to insert whatever's left in the package list.

Here's the updated code:

allRows = db.getAllRows() #12345条元素
package = []
for idx, pr in enumerate(allRows):
    package.append(pr)
    if (idx + 1) % 1000 == 0:
        db.inserPackage(package)
        package = []
# Insert any remaining rows that didn't fill a full 1000-row package
if package:
    db.inserPackage(package)

Why this works: #

• The loop handles all complete 1000-row batches as before.
• After the loop finishes, if package isn't empty (meaning there are leftover rows like your 345 example), we call inserPackage one last time to push those remaining records into the target table.

This approach keeps your original logic intact while ensuring no data gets left behind, regardless of whether the total number of rows is a perfect multiple of your batch size.

内容的提问来源于stack exchange，提问作者Pablo Pardo