H22 - Lesson 11

update.py

def update(post):
    connection = get_db()
    sql = connection.cursor()
    query = """
        UPDATE
            BlogPosts
        SET
            Title = ?,
            Content = ?,
            Author = ?
        WHERE
            PostId = ?
    """
    sql.execute(
        query, 
        [
            post["title"], post["content"], post["author"], post["post_id"],
        ],
    )
    connection.commit()