1

I have a model:

class Announcements(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(150), nullable=False)
    text = db.Column(db.Text(), nullable=False)
    category = db.Column(db.Integer(), nullable=False)
    subcategory = db.Column(db.Integer(), nullable=False)
    offer_type = db.Column(db.Integer(), nullable=False)
    url = db.Column(db.String(150), nullable=True)
    status = db.Column(db.Integer(), nullable=False)

    def __repr__(self):
        return '<Announcement %r>' % self.name

And public function:

def update(id):
   // UPDATE HERE

How to update note by passed id in function update() using Flask-SQLAlchemy?

I dont see any examples of updating rows in documentation

davidism
  • 121,510
  • 29
  • 395
  • 339
Oleg
  • 151
  • 2
  • 3
  • 12

1 Answers1

9

First get the item you need.

item = Announcements.query.get(id)

Then you edit that item directly:

item.name = "Newname"

Then you commit the session:

db.session.commit()
Robbie Milejczak
  • 5,664
  • 3
  • 32
  • 65