python-sqlalchemy-如何通过避免重复而优雅地插入?

x7yiwoj4  于 2021-06-20  发布在  Mysql
关注(0)|答案(0)|浏览(404)

我试过,但运气不好:

def sqlTryInsert(result_obj):
 try:
  session.add(result_obj)
  session.flush()
  session.commit() 
 except (exc.SQLAlchemyError, exc.DBAPIError) as e:
  code, msg = e.orig
  if code == 1062:
    # send warning
    pass

我仍然得到这个错误:

sqlalchemy.exc.IntegrityError: (_mysql_exceptions.IntegrityError) (1062, 
"Duplicate entry '...' for key 'hash'") 
[SQL: 'INSERT INTO results (...) VALUES (...)'] [parameters: (...)] 
(Background on this error at: http://sqlalche.me/e/gkpj)

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题