daos.py 文件源码

def update(self, id, user_id, ingredient_id, coefficient):
        """Update a record in the database with new values"""
        query = text("""
        UPDATE tblUserPreference SET
            user_id=:user_id,
            ingredient_id=:ingredient_id,
            coefficient=:coefficient
        WHERE
            id=:id
        """)
        result = self.execute(query,
                              id=id,
                              user_id=user_id,
                              ingredient_id=ingredient_id,
                              coefficient=coefficient)
        db.session.commit()
        return result.rowcount > 0