python学习-SQLalchemy 判断主键是否重复
报错:mysql.connector.errors.IntegrityError: 1062 (23000): Duplicate entry ‘key1-key2-key3’ for key ‘PRIMARY’
解决方法1:在添加数据前,先做简单的查询
res=session.query(table).filter(table.PRIMARY1=='a',table.PRIMARY2=='b', table.PRIMARY3=='c').first()
if not res:
#执行封装好的session操作,session_maker为封装好的有关session的commit,rollback,close相关操作
with session_maker() as session:
session.add(data1)
else:
print('该主键已存在')