Python 3.6.4 (default, Jan 16 2018, 15:57:06)
[GCC 4.4.7 20120313 (Red Hat 4.4.7-18)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>>
>>> import datetime
>>> import random
>>> from peewee import SqliteDatabase, Model, IntegerField
>>>
>>> class BaseModel(Model):
... sc_id = IntegerField()
...
>>>
>>> print("db SqliteDatabase")
db SqliteDatabase
>>> test_db = SqliteDatabase(':memory:')
>>> MODELS = [BaseModel]
>>> test_db.bind(MODELS, bind_refs=False, bind_backrefs=False)
>>> test_db.connect()
True
>>> print("db connected")
db connected
>>> test_db.create_tables(MODELS)
>>>
>>> user0 = BaseModel(sc_id=1)
>>> user0.save()
1
>>> BaseModel.get()
<BaseModel: 1>
>>>
>>> users = [ BaseModel(sc_id=1),
... BaseModel(sc_id=2)]
>>>
...
... with test_db.atomic():
... BaseModel.bulk_create(users, batch_size=500)
...
Traceback (most recent call last):
File "/var/wwwps/aging_portal/peewee/peewee.py", line 3099, in execute_sql
cursor.execute(sql, params or ())
sqlite3.OperationalError: near ",": syntax error
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "<stdin>", line 4, in <module>
File "/var/wwwps/aging_portal/peewee/peewee.py", line 6326, in bulk_create
res = cls.insert_many(accum, fields=fields).execute()
File "/var/wwwps/aging_portal/peewee/peewee.py", line 1886, in inner
return method(self, database, *args, **kwargs)
File "/var/wwwps/aging_portal/peewee/peewee.py", line 1957, in execute
return self._execute(database)
File "/var/wwwps/aging_portal/peewee/peewee.py", line 2707, in _execute
return super(Insert, self)._execute(database)
File "/var/wwwps/aging_portal/peewee/peewee.py", line 2442, in _execute
cursor = database.execute(self)
File "/var/wwwps/aging_portal/peewee/peewee.py", line 3114, in execute
return self.execute_sql(sql, params, commit=commit)
File "/var/wwwps/aging_portal/peewee/peewee.py", line 3106, in execute_sql
self.commit()
File "/var/wwwps/aging_portal/peewee/peewee.py", line 2873, in __exit__
reraise(new_type, new_type(exc_value, *exc_args), traceback)
File "/var/wwwps/aging_portal/peewee/peewee.py", line 183, in reraise
raise value.with_traceback(tb)
File "/var/wwwps/aging_portal/peewee/peewee.py", line 3099, in execute_sql
cursor.execute(sql, params or ())
peewee.OperationalError: near ",": syntax error
>>> read_list = BaseModel.select()
>>> print(len(read_list))
1
>>>
>>>