处理SQLAlchemy中插入的重复主键(声明式样式)

from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class MyTable(Base):
    __tablename__ = 'mytable'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    value = Column(Integer)

    def __repr__(self):
        return f'<MyTable {self.name}: {self.value}>'

# 使用声明式样式插入数据
base = Base.metadata
my_table = MyTable(name='foo', value=1)
base.insert(my_table)

base.insert_values(
    my_table,
    [
        {'name': 'foo', 'value': 1},
        {'name': 'bar', 'value': 2},
    ],
)