1
2
3
4
5
6
7
8
9
10
11
12
| from sqlalchemy.orm import class_mapper
old_record = db.session.query(模型类名).filter(xxxx).first()
new_record = 模型类名()
db.session.add(new_record)
column_names = [p.key for p in class_mapper(模型类名).iterate_properties]
for item in column_names:
if item not in ['唯一索引', '字段1', '关系1']:
setattr(new_record, item, getattr(old_record, item))
db.session.commit()
|