我正在尝试使用bulk_save_objects
或bulk_insert_mappings
将字典列表插入表中。有什么方法可以获取每个条目带有主键的对象列表吗?
try:
cycle_object_list = []
for cycle in cycle_list:
period = Period()
for k,v in cycle.items():
setattr(period,k,v)
cycle_object_list.append(period)
db.session.bulk_save_objects(cycle_object_list)
db.session.commit()
print(cycle_object_list)
except Exception:
db.session.rollback()
raise
finally:
db.session.close()
我期望像[Period.49,Period.50,Period.51]
但是实际结果是[Period.None,Period.None,Period.None]