upsert shortcut for postgresql about peewee HOT 2 CLOSED

def replace(ModelClass, conflict_target, **data):
    iq = ModelClass.insert(**data)
    return iq.on_conflict(
        conflict_target=conflict_target,
        preserve=[k for k in iq._insert])

class Reg(db.Model):
    key = CharField(unique=True)
    value = TextField()
    extra = IntegerField()

replace(Reg, [Reg.key], key='k1', value='v1', extra=1).execute()
replace(Reg, [Reg.key], key='k2', value='v2', extra=2).execute()
replace(Reg, [Reg.key], key='k1', value='v1-x', extra=10).execute()
replace(Reg, [Reg.key], key='k1', value='v1-y', extra=100).execute()

for row in Reg:
    print(row.id, row.key, row.value, row.extra)

# Output:
# 2 k2 v2 2
# 1 k1 v1-y 100