##############################################################################
# Python From Scratch
# Author: Nilo Ney Coutinho Menezes
# Editora Novatec (c) 2010-2025 - LogiKraft 2025
# Site: https://pythonfromscratch.com
# ISBN: 978-85-7522-949-1 (Paperback), 978-85-7522-950-7 (hardcover), 978-85-7522-951-4 (ebook)
#
# File: chapter 11/exercise-11-06.py.py
##############################################################################
import sqlite3
from contextlib import closing

with sqlite3.connect("prices.db") as connection:
    with closing(connection.cursor()) as cursor:
        name = input("Enter the product name to change price: ")

        cursor.execute(
            """select * from prices
                          where name = ?""",
            (name,),
        )

        result = cursor.fetchone()
        if result:
            print("Name: {0:30s} Price: {1:6.2f}".format(*result))
            new_price = input("Enter the new price: ")
            cursor.execute(
                """update prices
                              set price = ?
                              where name = ?""",
                (new_price, name),
            )
        else:
            print("Not found.")