peewee.OperationalError: too many SQL variables

使用peewee+sqlite批量插入数据报错

peewee.OperationalError: too many SQL variables

  

 

  
1
 

sqlite 每次插入有数量限制，不能插入太多，资料显示999，不过我设置为500就报错了

peewee提供了一个方式，分次插入，两种方式等价

from peewee import chunked

# Insert rows 100 at a time.
with db.atomic(): for idx in range(0, len(data_source), 100): MyModel.insert_many(data_source[idx:idx+100]).execute() # Insert rows 100 at a time.
with db.atomic(): for batch in chunked(data_source, 100): MyModel.insert_many(batch).execute()

  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
 

参考：

1. How to increase SQLITE_MAX_VARIABLE_NUMBER at compilation-time?
2. http://docs.peewee-orm.com/en/latest/peewee/querying.html#bulk-inserts

文章来源: pengshiyu.blog.csdn.net，作者：彭世瑜，版权归原作者所有，如需转载，请联系作者。

原文链接：pengshiyu.blog.csdn.net/article/details/84936705