I want to insert or modify a piece of data in the row corresponding to the id, but I don’t know how to do it
To add, delete, check and modify, just go to the document.
model = Model.query.get(id)
or model = Model.query.filter_by(id=id).first()
model.name = 'new name'
db.session.add(model)
db.session.commit()
If you insert data by specifying the ID, it is unlikely if it is the primary key, but it can be updated. And if it is not the primary key, then 2 operations can be achieved. The code is similar to the following:
Add as:
model = Model(name='new names')
db.session.add(model)
db.session.commit()
Then update to:
model.name = 'new name'
db.session.add(model)
db.session.commit()